自己的Mybatis搭建

MyBatis3搭建

第一步：建java工程，引jar包

  Mybatis-3.0.5.jar  mysql-connector-java-5.0.8-bin.jar

第二步：在src目录下新建conf.xml(MyBatis的总配置文件)，添加如下内容

<?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">

       <environment id="development">

           <transactionManager type="JDBC" />

           <!-- 配置数据库连接信息-->

           <dataSource type="POOLED">

                <propertyname="driver" value="com.mysql.jdbc.Driver" />

                <propertyname="url" value="jdbc:mysql://localhost:3306/talkdb" />

                <property name="username"value="root" />

                <propertyname="password" value="admin123" />

           </dataSource>

       </environment>

   </environments>

   

   <mappers>

       <!-- 注册userMapper.xml文件，

       userMapper.xml位于com.test.dao这个包下，所以resource写成com/test/dao/userMapper.xml-->

       <mapper resource="com/test/dao/userMapper.xml"/>

   </mappers>

   

</configuration>

第三步：新建com.test.bean包下的User类

package com.test.bean;

 

public class User {

   private String id;

   private String username;

    privateString password;

   public String getId() {

       return id;

    }

   public void setId(String id) {

       this.id = id;

    }

   public String getUsername() {

       return username;

    }

   public void setUsername(String username) {

        this.username = username;

    }

   public String getPassword() {

       return password;

    }

   public void setPassword(String password) {

       this.password = password;

    }

   

   @Override

   public String toString() {

       return "User [id=" + id + ", username=" + username +", password=" + password + "]";

    }

   

}

第四步：新建com.test.dao下的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">

<mappernamespace="com.test.dao.userMapper"

   <!--

       根据id查询得到一个user对象

    -->

   <select id="getUser"parameterType="java.lang.String"

       resultType="com.test.bean.User">

       select * from tt_talk_user where id=#{id}

   </select>

</mapper>

第五步：新建com.test.testMybatis包下Test01.java文件，内容如下

package com.test.testMybatis;

 

import java.io.InputStream;

 

importorg.apache.ibatis.session.SqlSession;

importorg.apache.ibatis.session.SqlSessionFactory;

importorg.apache.ibatis.session.SqlSessionFactoryBuilder;

 

import com.test.bean.User;

 

public class Test01 {

   /**

    * <p>Description: MyBatis搭建测试</p>

    * @param args 参数

    */

   public static void main(String[] args) {

       

       String resource = "conf.xml";

       

       InputStream is =Test01.class.getClassLoader().getResourceAsStream(resource);

       

       SqlSessionFactory sessionFactory = newSqlSessionFactoryBuilder().build(is);

          

       SqlSession session = sessionFactory.openSession();

       

       String statement = "com.test.dao.userMapper.getUser";//映射sql的标识字符串

        User user = (User)session.selectOne(statement, "12345678123456781234567812345678");

       System.out.println(user);

    }

}

第六步：运行Test01.java文件，得到对象，此时，MyBatis测试完毕