Mybatis环境搭建

0.目录结构，并导入lib的jar包

2.创建test数据库，创建mytest表

DROP TABLE IF EXISTS `mytest`;
CREATE TABLE `mytest` (
  `ID` varchar(255) NOT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mytest
-- ----------------------------
INSERT INTO `mytest` VALUES ('1', '阿达');

3.创建一个User类，与mytest表对应

public class User {
    private String id;
    private String name;
    
    public User() {
        
    }
    public User(String id, String name) {
        super();
        this.id = id;
        this.name = name;
    }
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
      
}

4.创建一个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>
  <!-- <settings>
    <setting name="useGeneratedKeys" value="false"/>
    <setting name="useColumnLabel" value="true"/>
  </settings>

  <typeAliases>
    <typeAlias alias="UserAlias" type="org.apache.ibatis.submitted.complex_property.User"/>
  </typeAliases> -->

  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC">
        <property name="" value=""/>
      </transactionManager>
      <dataSource type="UNPOOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>

    <mappers>
    <mapper resource="com\Config\User.xml"/>
  </mappers>  

</configuration>

5.创建一个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">
    
<!-- namespace：填类名或者是接口名 -->
<mapper namespace="User">
<!-- type="包名.Meassge" -->
  <resultMap type="com.cjh.bean.User" id="MeassageResult">
    <id column="ID" jdbcType="VARCHAR" property="id"/>
    <result column="Name" jdbcType="VARCHAR" property="name"/>
  </resultMap>

  <select id="query"  parameterType="String" resultMap="MeassageResult">
   select * from myTest where id = #{id}
  </select>
 
</mapper>

6.创建一个Main

public class Main {
    
    private static SqlSessionFactory sqlSessionFactory;
    private static Reader reader;

    static {
        try {
            reader = Resources.getResourceAsReader("com/Config/MybatisConfig.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static SqlSessionFactory getSession() {
        return sqlSessionFactory;
    }
    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        SqlSession session = sqlSessionFactory.openSession();
        try {
            User user = (User) session.selectOne(
                    "User.query", "1");
            if(user!=null){
                String userInfo = "名字："+user.getName()+", id："+user.getId();
                System.out.println(userInfo);
            }
        } finally {
            session.close();
        }
    }
}

7.运行Main类