[Mybatis3] SimpleProject(Mybatis3+mysql)

SimpleProject(Mybatis3+mysql)

1. mybatis.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> <environments default="development"> <!-- 1 --> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost/test" /> <property name="username" value="root" /> <property name="password" value="1111" /> </dataSource> </environment> </environments> <!-- 2 --> <mappers> <mapper resource="sample/dao/PetMapper.xml" /> </mappers> </configuration>

1). 데이터 베이스의 접속 정보를 설정

2). 매핑 파일의 경로를 지정

 

2. petMapper.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"> <!-- 1 --> <mapper namespace="sample.dao.petMapper"> <!-- 2 --> <select id="selectPet" parameterType="int" resultMap="petResultMap"> SELECT * FROM PET WHERE PET_ID = #{petId} </select> <!-- 3 --> <resultMap id="petResultMap" type="sample.domain.Pet"> <id property = "petId" column = "PET_ID"/> <result property = "petName" column="PET_NAME"/> </resultMap> </mapper>  

2) SQL 기술

3) 가져온 결과 OR 매핑

3. Main.java

package sample; import java.io.IOException; import java.io.Reader; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import sample.domain.Pet; public class PetMain { public static void main(String[] args) throws IOException{ //1 String resource = "META-INF/mybatis.xml"; Reader reader = Resources.getResourceAsReader(resource); SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader); SqlSession session = sqlMapper.openSession(); //2 Pet pet = session.selectOne("sample.dao.petMapper.selectPet",1); session.close(); System.out.println(pet.getPetId()); System.out.println(pet.getPetName()); } }  

1) Mybatis 설정 파일을 SqlSessionFactoryBuilder로 읽어온다

- SqlSessionFactory를 생성

- SqlSession 가져옴

2) Sql 실행

- 네임스페이스 + SQL ID

- 1은 SQL의 파라미터값 지정

fullSource - https://github.com/KyleJeong/Mybatis3