MyBatis开发环境搭建

mybatis,前身ibatis，是一个orm框架

1.mybatis-config.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="db.properties"></properties>
  <environments default="development">
    <environment id="users">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${db.driver}"/>
        <property name="url" value="${db.url}"/>
        <property name="username" value="${db.username}"/>
        <property name="password" value="${db.password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="javastudy/userMapper.xml"/>
  </mappers>
</configuration>

db.properties

db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost/users
db.username=root
db.password=

2.userMapper.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="javastudy.userMapper">
    <select id="selectUser" resultType="javastudy.User">
        select * from User where id = #{id}
    </select>
</mapper>

3.MybatisUtils

public class MabatisUtils {
	public static SqlSession openSession() throws IOException
	{
            String resource = "mybatis-cfg.xml";
            InputStream in = Resources.getResourceAsStream(resource);
            SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in,"users");
            return sessionFactory.openSession();
	}
}

4 junit测试

public class test {

	@Test
	public void testSelect() throws IOException {
		SqlSession session=MabatisUtils.openSession();
		String statment="javastudy.userMapper.selectUser";
		User user=session.selectOne(statment, 2);
		System.out.println(user);
		session.close();
		
	}

}