IDEA 创建一个Mybatis Maven项目的方法步骤(图文)

<dependencies>

   <dependency>

    <groupid>org.mybatis</groupid>

    <artifactid>mybatis</artifactid>

    <version> 3.3 . 0 </version>

   </dependency>

   <!-- mysql驱动包

     这个驱动包要根据自己mysql版本来配置不然就会出bug-->

   <dependency>

    <groupid>mysql</groupid>

    <artifactid>mysql-connector-java</artifactid>

    <version> 8.0 . 11 </version>

   </dependency>

   <!-- junit测试包 -->

   <dependency>

    <groupid>junit</groupid>

    <artifactid>junit</artifactid>

    <version> 4.11 </version>

    <scope>test</scope>

   </dependency>

  </dependencies>

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

   <!--配置mysql的环境-->

   <environment id= "mysql" >

    <!--配置事务的类型-->

    <transactionmanager type= "jdbc" ></transactionmanager>

    <!--配置连接池-->

    <datasource type= "pooled" >

     <property name= "driver" value= "com.mysql.jdbc.driver" />

     <property name= "url" value= "jdbc:mysql://localhost:3306/testuser?servertimezone=asia/shanghai" />

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

     <property name= "password" value= "li4918458" />

    </datasource>

   </environment>

  </environments>

  <!-- mapping文件路径配置 -->

  <mappers>

   <mapper resource= "mapper/usermapper.xml" />

  </mappers>

</configuration>

<?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= "pojo.user" >

  <!--id = "接口中的方法名"

  　　parametertype= "传入的参数类型"

  　　resulttype = "返回实体类对象，使用包.类名" -->

  <select id= "findbyid" parametertype= "int" resulttype= "pojo.user" > select * from user where id = #{id}

  </select>

  </mapper>

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 org.junit.test;

import pojo.user;

import java.io.ioexception;

import java.io.inputstream;

import java.io.reader;

public class test {

@test

public void testsearchbyid() throws ioexception {

  //1.读取配置文件

  inputstream in = resources.getresourceasstream( "mybatis-config.xml" );

  //2.创建sqlsessionfactory工厂

  sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(in);

  //3.使用工厂生产sqlsession对象

  sqlsession session = sqlsessionfactory.opensession();

  //4.执行sql语句

  user user = session.selectone( "test.finduserbyid" , 1 );

  //5. 打印结果

  system.out.println(user);

  //6.释放资源

  session.close();

  in.close();

}

  //根据用户名模糊查询用户列表

  @test

  public void testfinduserbyusername() throws ioexception {

   //定义读取文件名

   string resources = "mybatis-config.xml" ;

   //创建流

   reader reader= null ;

   try {

    //读取mybatis-config.xml文件到reader对象中

    reader= resources.getresourceasreader(resources);

   } catch (ioexception e) {

    e.printstacktrace();

   }

   //初始化mybatis,创建sqlsessionfactory类的实例

   sqlsessionfactory sqlmapper= new sqlsessionfactorybuilder().build(reader);

   //创建session实例

   sqlsession session=sqlmapper.opensession();

   //传入参数查询，返回结果

   user user=session.selectone( "findbyid" , 1 );

   //输出结果

   system.out.println(user.getname());

   //关闭session

   session.close();

  }

}