ibatis mysql insert후 sequence 값 가져오기

 

ibatis임.

 

File : sql.xml

 

<insert id="daoDAO.insertData " parameterClass="HashMap">

/* daoDAO. insertData */

<![CDATA[

    INSERT INTO TABLE (REG_ID, LOG_ID, IP, REG_DT)

    VALUES ( #reg_id#, #log_id#, #ip#, NOW())

]]>

<selectKey keyProperty="seq" resultClass="int">

    SELECT LAST_INSERT_ID()

</selectKey>

</insert>

 

 

File : daoDAO.java

public void insertData (Map map){

        insert("daoDAO.insertData", map);

    }

 

 

 

File : service.java

void insertData (Map map) throws Exception;

 

 

 

File : serviceImpl.java

public void insertData (Map map) throws Exception{

        daoDAO.insertData(map);

    }

 

 

 

File : controller.java

Map map = new HashMap();

 

map.put("insertId","abc");

map.put("seq",0);

tmpService.insertData(map);

 

//시퀀스가 파라미터 map 에 담겨 나온다.

System.out.println(map.get("seq"));