Mybatis创建过程

mybatis搭建过程：
1、导入jar

log4j.jar
mybatis-3.4.1.jar
mysql-connector-java-5.1.37-bin.jar
2、创建mybatis的核心（全局）配置文件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="jdbc.properties"></properties>
 <environments default="development">
 <environment id="development">
 <transactionManager type="JDBC"/>
 <dataSource type="POOLED">
 <property name="driver" value="${jdbc.driver}"/>
 <property name="url" value="${jdbc.url}"/>
 <property name="username" value="${jdbc.username}"/>
 <property name="password" value="${jdbc.password}"/>
 </dataSource>
 </environment>
 </environments>
 <mappers>
 <mapper resource="UserMapper.xml"/>
 </mappers>
 </configuration>
3、创建映射文件XxxMapper.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="com.atguigu.mapper.UserMapper">
 <select id="getuid" resultType="com.atguigu.bean.User">
 select uid,userName,password,age,sex from user where uid = #{id}
 </select>
</mapper>
4、创建mapper接口，实现两个绑定:

public interface  UserMapper {
User  getuid(String id);
}
    (1)接口全限定名要和映射文件的namespace保持一致
    (2)接口中方法名和SQL语句的id保持一致
5、获取mybatis操作数据库的会话对象SqlSession，通过getMapper()获取接口的动态代理实现类
6、测试

InputStream rs = Resources.getResourceAsStream("mybatis-config.xml");
    SqlSessionFactory build = new SqlSessionFactoryBuilder().build(rs);
    SqlSession openSession = build.openSession();
    UserMapper mapper = openSession.getMapper(UserMapper.class);
    User getuid = mapper.getuid("1");
    System.out.println(getuid);

转载于:https://my.oschina.net/u/4151492/blog/3064926