[Java] MyBatis 사용하기
2. 프로퍼티 파일 작성
db.properties
driver=org.postgresql.Driver
url=jdbc:postgresql://ip/dbname
username=user
password=pw
3. 설정파일
! > 공백, 공라인이 있으면 에러 발생
MyBatisConfig.xml
<?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="mybatis/db.properties" />
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mybatis/employee.xml" />
</mappers>
</configuration>
4. sql 작성
employee.xml
<?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="Test">
<select id="getEmployee" resultType="app.data.model.Employee">
SELECT * FROM Employee WHERE id = #{id}
</select>
<select id="getAllEmployees" resultType="app.data.model.Employee">
SELECT * FROM "Employee"
</select>
</mapper>
5. bean 클래스 생성
Employee.java
package app.data.model;
public class Employee{
private String no;
private String userId;
private String name;
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getNo() {
return no;
}
public void setNo(String no) {
this.no = no;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
5. 실행
package test;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import db.SqlMapClient;
import app.data.model.*;
public class Test{
public static void main(String[] args){
SqlSession session = SqlMapClient.getSqlSession();
Employee employee = session.selectOne("Test.getEmployee", "1112");
System.out.println("name : " + employee.getName());
List<Employee> list = session.selectList("Test.getAllEmployees");
for(int i=0; i<list.size(); i++){
System.out.println(list.get(i).getName());
}
session.close();
}
}