idea创建mybatis项目

今天初步学习了mybatis，废话不多说，下面是我用idea搭建第一个mybatis的过程：

项目总体结构如下

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

  <modelVersion>4.0.0</modelVersion>
  <packaging>war</packaging>

  <name>com.xzf.mybatis</name>
  <groupId>com.xzf.mybatis</groupId>
  <artifactId>com.xzf.mybatis</artifactId>
  <version>1.0-SNAPSHOT</version>



  <dependencies>
      <!--junit依赖包-->
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.3</version>
        <scope>test</scope>
      </dependency>


      <!--配置mybatis需要的依赖包-->
      <dependency>
        <groupId>asm</groupId>
        <artifactId>asm</artifactId>
        <version>3.3.1</version>
      </dependency>

      <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>2.2.2</version>
      </dependency>

      <dependency>
        <groupId>commons-logging</groupId>
        <artifactId>commons-logging</artifactId>
        <version>1.1.1</version>
      </dependency>
      <dependency>
        <groupId>org.javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>3.17.1-GA</version>
      </dependency>
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
      </dependency>
      <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.7</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.5</version>
      </dependency>

      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.5</version>
        <scope>test</scope>
      </dependency>
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.3.0</version>
      </dependency>
      <!-- lombok插件导包-->
      <dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <version>1.16.10</version>
          <scope>provided</scope>
      </dependency>

  </dependencies>
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>
</project>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTDConfig 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--Lazy加载-->
    <settings>
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>
    <!--别名-->
    <typeAliases>
        <typeAlias type="com.xzf.pojo.User" alias="User"></typeAlias>
    </typeAliases>
    <!--对事物的管理和连接池的配置-->
    <environments default="development">
        <environment id="development">
            <!--配置JDBC事务控制，由mybatis进行管理-->
            <transactionManager type="JDBC"></transactionManager>
            <!--配置数据源，采用mybatis连接池-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
                <property name="username" value="root" />
                <property name="password" value="123456" />
            </dataSource>

        </environment>
    </environments>

    <!--mapping文件路径配置-->
    <mappers>
        <mapper resource="mapper/User.xml"></mapper>
    </mappers>
</configuration>

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="test">
    <select id="findById" parameterType="int" resultType="com.xzf.pojo.User">
        SELECT * FROM User WHERE id=#{id}
    </select>
</mapper>

User.class

package com.xzf.pojo;

import lombok.Getter;
import lombok.Setter;

/**
 * 描述
 *
 * @author xzf
 * @date 2019/4/8 21:46
 **/
@Setter
@Getter
public class User {
    private int id;
    private String name;
    private int age;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

UserTest

package com.xzf.test;

import com.xzf.pojo.User;
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 java.io.InputStream;

/**
 * 描述
 *
 * @author xzf
 * @date 2019/4/8 22:51
 **/
public class UserTest {
    public static void main(String[] args)throws Exception{
        //读取配置文件
        String resource="mybaits-config.xml";
        InputStream inputStream= Resources.getResourceAsStream(resource);

        //创建SqlSesstionFactory
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);

        //创建SqlSession
        SqlSession sqlSession=sqlSessionFactory.openSession();
        //调用sqlSession的方法，第一个参数为statement即所调用的配置文件的具体方法，第二个为传入参数
        User user=sqlSession.selectOne("test.findById",2);
        System.out.println(user);
        //提交事务
        sqlSession.commit();
        //关闭资源
        sqlSession.close();
    }
}

数据库设计也简单，就三个字段

运行结果为User{id=2, name='hh', age=19}