Day53 MyBatis

<typeAliases>

   <package name="model"/> 패키지를 등록하면 해당 패키지의 모든 클래스들이 클래스명 첫글자 소문자로 한 이름을 alias로 등록됨

</typeAliases>

public interface IDeptDao { @Insert("insert into dept values ( #{deptno}, #{dname}, #{dloc} )") public void insertDept(Dept dept); @Update("update dept set dname=#{dname}, dloc=#{dloc} where deptno=#{deptno}") public void updateDept(Dept dept); @Delete("delete from dept where deptno =#{deptno}") public void deleteDept(int deptno); @Select("select * from dept where deptno = #{deptno}") public Dept selectOne(int deptno); @Select("select * from dept") public List<Dept> selectAll(); }

public class DeptDao implements IDeptDao{  private SqlSessionFactory sqlSessionFactory;    public DeptDao() {       InputStream is = null;       try {          is = Resources.getResourceAsStream("configuration.xml");          sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);       } catch (IOException e) {          // TODO Auto-generated catch block          e.printStackTrace();       } finally {          try {             if (is != null)                is.close();          } catch (IOException e) {             // TODO Auto-generated catch block             e.printStackTrace();          }       }    }    public void insertDept(Dept dept){    SqlSession session = sqlSessionFactory.openSession();    try{    session.getMapper(IDeptDao.class).insertDept(dept);    }    finally{    session.close();    }    }    public List<Dept> selectAll(){    SqlSession session = sqlSessionFactory.openSession();    try{    return session.getMapper(IDeptDao.class).selectAll();    }    finally{    session.close();    }     }    @Override    public void updateDept(Dept dept) {    SqlSession session = sqlSessionFactory.openSession();    try{    session.getMapper(IDeptDao.class).updateDept(dept);    }    finally{    session.close();    }        }    @Override    public void deleteDept(int deptno) {    SqlSession session = sqlSessionFactory.openSession();    try{    session.getMapper(IDeptDao.class).deleteDept(deptno);    }    finally{    session.close();    }        }    @Override    public Dept selectOne(int deptno) {    SqlSession session = sqlSessionFactory.openSession();    try{    return session.getMapper(IDeptDao.class).selectOne(deptno);    }    finally{    session.close();    }    } }

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration   PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="managed"> </transactionManager> <dataSource type="UNPOOLED"> <property value="com.mysql.jdbc.Driver" name="driver" /> <property value="jdbc:mysql://localhost/lkb" name="url" /> <property value="root" name="username" /> <property value="mysql" name="password" /> </dataSource> </environment> </environments> <mappers> <mapper class="dao.IDeptDao"/> </mappers> </configuration>