Mybatis Data Insert/Update

insert 문

• EmpRepository.java 단

1 2 3 4 5 6 7 8 9 10 11 12

public void insEmp(Emp ins){         SqlSession sqlsess = getSqlSessionFactory().openSession();                  try{             //조건 검색해서 처리할 내용 //insert로 처리             sqlsess.insert(NAMESPACE+".insertEmp" ,ins );             sqlsess.commit();//커밋         }finally{             //자원 해제 처리 에러가나던 어쩌던             sqlsess.close();         }     } Colored by Color Scripter

cs

• EmpMapper.xml 단

1 2 3 4

select가 아닌 insert로 처리 <insert id="insertEmp" parameterType="emp">         INSERT INTO EMP_S VALUES(emp_sjh.nextVal, #{ename}, #{job},          #{mgr}, sysdate, #{sal}, #{comm}, #{deptno} ) </insert> Colored by Color Scripter

cs

Update 문

• Repository

1 2 3 4 5 6

1 2 3 4 5 6 7 public void uptEmp(Emp upt){        SqlSession sqlsess = getSqlSessionFactory().openSession();         //역시 update로 처리         try{             sqlsess.update(NAMESPACE+".uptEmp",upt);         }finally{             sqlsess.commit();             sqlsess.close();         }     } Colored by Color Scripter cs Colored by Color Scripter

cs

• Mapper

1 2 3 4 5 6 7 8 9 10 11 12

<update id="uptEmp" parameterType="emp">       UPDATE EMP_S set            empno = #{empno}           <!--이런식으로 ename이 존재할때만 upt해주고               아닐시 넘길수 있음            -->           <if test = "ename !=null">               ,ename=#{ename}                   </if>       ,job=#{job},sal=#{sal}        where empno=#{empno}   </update>

cs