设置mybatis 配置文件:Configuration.xml, 在src_user目录下建立此文件,内容如下:<?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>
<typeAliases>
<typeAlias alias="User" type="com.yihaomen.mybatis.model.User"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis" />
<property name="username" value="root"/>
<property name="password" value="password"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/yihaomen/mybatis/model/User.xml"/>
</mappers>
</configuration>
实体DTO类
package com.yihaomen.mybatis.model;
public class User {
      private int id;
      private String userName;
      private String userAge;
      private String userAddress;
      public int getId() {
            return id;
      }
      public void setId(int id) {
            this.id = id;
      }
      public String getUserName() {
            return userName;
      }
      public void setUserName(String userName) {
            this.userName = userName;
      }
      public String getUserAge() {
            return userAge;
      }
      public void setUserAge(String userAge) {
            this.userAge = userAge;
      }
      public String getUserAddress() {
            return userAddress;
      }
      public void setUserAddress(String userAddress) {
            this.userAddress = userAddress;
      }
}
建立这个User 的映射文件 User.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.yihaomen.mybatis.models.UserMapper">
<select id="selectUserByID" parameterType="int" resultType="User">
select * from `user` where id = #{id}
</select>
</mapper>
测试类:
package com.yihaomen.test;
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 com.yihaomen.mybatis.model.User;
public class Test {
      private static SqlSessionFactory sqlSessionFactory;
      private static Reader reader;
      static{
            try{
                  reader = Resources.getResourceAsReader("Configuration.xml");
                  sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
            }catch(Exception e){
            e.printStackTrace();
      }
}
public static SqlSessionFactory getSession(){
      return sqlSessionFactory;
}
public static void main(String[] args) {
      SqlSession session = sqlSessionFactory.openSession();
      try {
            User user = (User) session.selectOne("com.yihaomen.mybatis.models.UserMapper.selectUserByID", 1);
            System.out.println(user.getUserAddress());
            System.out.println(user.getUserName());
      } finally {
      session.close();
}
}
}