JavaSevlet_MVC

jdbc.properties

#key=value

#db 4 information

oracle.jdbc=oracle.jdbc.driver.OracleDriver

oracle.url=jdbc:oracle:thin:@localhost:1521:xe

oracle.userid=scott

oracle.passwd=tiger

 

mysql.jdbc=com.mysql.jdbc.Driver

mysql.url=jdbc:mysql:localhost:3306\orcl

mysql.userid=scott

mysql.passwd=tiger

 

Configuratoin

 

<?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>

 

<properties resource = "jdbc.properties"/>

 

<typeAliases>

<typeAlias type="DTO" alias="DTO"/>

</typeAliases>

 

<environments default="development">

<environment id="development">

<transactionManager type="JDBC"/>

 

<dataSource type="POOLED">

<property name="driver" value="${oracle.jdbc}"/>

<property name="url" value="${oracle.url}"/>

<property name="username" value="${oracle.userid}"/>

<property name="password" value="${oracle.passwd}"/>

 

</dataSource>

</environment>

</environments>

 

<mappers>

<mapper resource="DeptMapper.xml"/>

</mappers>

</configuration>

 

SqlSessionFactory

 

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Factory {
static SqlSessionFactory sqlSessionFactory= null;
static {
String resource = "Configuration.xml";  //수정이 필요한 유일한 부분 
InputStream inputStream= null;
try {
inputStream = Resources.getResourceAsStream(resource);
System.out.println("configuration.xml 로딩 성공 ");
} catch (IOException e) {
e.printStackTrace();
}
 sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}

public static SqlSession getSqlSession() {//
SqlSession session = sqlSessionFactory.openSession();
return session;
}

}

 

DTO

 

public class DTO {

 

int deptno;

String dname;

String loc;

public DTO() {

super();

// TODO Auto-generated constructor stub

}

public DTO(int deptno, String dname, String loc) {

super();

this.deptno = deptno;

this.dname = dname;

this.loc = loc;

}

public int getDeptno() {

return deptno;

}

public void setDeptno(int deptno) {

this.deptno = deptno;

}

public String getDname() {

return dname;

}

public void setDname(String dname) {

this.dname = dname;

}

public String getLoc() {

return loc;

}

public void setLoc(String loc) {

this.loc = loc;

}

 

 

 

 

}

 

Main

 

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="DeptMapper">

 

<select id="selectAll" resultType="DTO">

select * from dept

</select>

 

</mapper>

 

Service

 

import java.util.List;

import org.apache.ibatis.session.SqlSession;

public class Service {

DAO dao;

public Service() {
super();
dao = new DAO();
}

public List<DTO> selectAll() {
List<DTO> list = null;
SqlSession session = Factory.getSqlSession();
try {
list = dao.selectAll(session);
} finally {
session.close();
}
return list;
}
}

 

DAO

 

import java.util.List;

import org.apache.ibatis.session.SqlSession;

public class DAO {

public List<DTO> selectAll(SqlSession session) {
List<DTO> list = session.selectList("DeptMapper.selectAll");
return list;
}

}

 

Mapper

 

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="DeptMapper">

 

<select id="selectAll" resultType="DTO">

select * from dept

</select>

 

</mapper>