Mybatis基本配置

1、需要的依赖包

<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis</artifactId>
	<version>3.4.2</version>
</dependency>
<!--DBCP数据源-->
<dependency>
	<groupId>commons-dbcp</groupId>
	<artifactId>commons-dbcp</artifactId>
	<version>1.4</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.38</version>
</dependency>
<dependency>
	<groupId>log4j</groupId>
	<artifactId>log4j</artifactId>
	<version>1.2.17</version>
</dependency>

2、配置数据库连接文件jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://127.0.0.1\:3306/tg_volunteers?useUnicode\=true&characterEncoding\=utf-8
jdbc.username=root
jdbc.password=123456

3、DBCP数据源适配器

package com.l4j.mybatis.util;

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;

/**
 * Created by Li on 2017/3/11.
 */
public class DBCPDataSourceFactory extends UnpooledDataSourceFactory {

    public DBCPDataSourceFactory(){
        this.dataSource = new BasicDataSource();
    }
}

4、配置mybatis-config.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>

    <!--加载数据库连接配置文件-->
    <properties resource="jdbc.properties" />

    <!--配置Mybatis运行行为-->
    <settings>
        <setting name="useGeneratedKeys" value="true"/>
        <setting name="logImpl" value="LOG4J"/>
    </settings>

    <!--environments 环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="com.l4j.mybatis.util.DBCPDataSourceFactory">
                <property name="driverClassName" value="${jdbc.driverClassName}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--xml映射文件配置-->
    <mappers>
        <mapper resource="mappers/UserMapper.xml"/>
    </mappers>
</configuration>

4.1 log4j日志配置

log4j.rootLogger=ERROR, stdout
log4j.logger.UserMapper=DEBUG
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss}|%-40.40logger{0}|%msg%n

5、创建SqlSession工具类

Mybatis应用是以SqlsesionFactory为核心的。SqlsesionFactory实例通过SqlSessionFactoryBuilder创建。SqlSessionFactoryBuilder仅用于创建SqlSesionFactory，sqlSessiFactory的生命周期应该存在整个应用。SqlSession 的实例不是线程安全的，因此是不能被共享的，所以它的最佳的作用域是请求或方法作用域。

import java.io.InputStream;

/**
 * Created by Li on 2017/3/9.
 */
public class SQLSessionFactory{

    private static String RESOURCE="mybatis-config.xml";

    private static final SqlSessionFactory SSF =  SQLSessionFactory.getSessionFactory();

    public static SqlSessionFactory getSessionFactory(){

        SqlSessionFactory sqlSessionFactory = null;
        InputStream inputStream;

        try {
            inputStream = Resources.getResourceAsStream(RESOURCE);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }catch(IOException e){
            e.printStackTrace();
        }
        return sqlSessionFactory;
    }

    public static SqlSession getSqlSession(){
        return SSF.openSession();
    }
}

6、创建UserBean

package com.l4j.mybatis.domain;

/**
 * Created by Li on 2017/3/11.
 */
public class User {
    private int userId;
    private String userName;
    private String password;
    private int userRole;
    private String email;
    private String registeDate;
    private int userStatus;

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    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;
    }

    public int getUserRole() {
        return userRole;
    }

    public void setUserRole(int userRole) {
        this.userRole = userRole;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getRegisteDate() {
        return registeDate;
    }

    public void setRegisteDate(String registeDate) {
        this.registeDate = registeDate;
    }

    public int getUserStatus() {
        return userStatus;
    }

    public void setUserStatus(int userStatus) {
        this.userStatus = userStatus;
    }
    @Override
    public String toString() {
        return "User{" +
                "userId=" + userId +
                ", userName='" + userName + '\'' +
                ", password='" + password + '\'' +
                ", userRole=" + userRole +
                ", email='" + email + '\'' +
                ", registeDate='" + registeDate + '\'' +
                ", userStatus=" + userStatus +
                '}';
    }
}

7、配置UserMapper.xml

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="UserMapper">


    <select id="getAllUser" resultType="com.l4j.mybatis.domain.User">
        select user_name as userName
        ,user_password as password
        from user;
    </select>

</mapper>

7.1 映射注解

对于简单的SQL语句，使用映射注解的方式看上去更加优雅，安全性和开发效率也更高，开发中可以结合使用映射注解和xml映射的方式，示例如下：

public interface UserMapper {
  @Select("SELECT * FROM user")
  List<User> selectUser();
}

UserMapper mapper = session.getMapper(UserMapper.class);
List<User> userList = mapper.selectUser();

8、测试

package test;

import com.l4j.mybatis.domain.User;
import com.l4j.mybatis.util.SQLSessionFactory;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

/**
 * Created by Li on 2017/3/11.
 */
public class Test {

    public static void main(String[] args) {
        SqlSession sqlSession = SQLSessionFactory.getSqlSession();

        SqlSession sqlSession = ac.getBean("sqlSession",SqlSession.class);

        List<User> userList= sqlSession.selectList("UserMapper.getAllUser");

        System.out.println(userList.size());
        for(User u : userList)
            System.out.println(u);
    }
}

结果：

2017-03-12 09:57:34|dbcLogger.debug(BaseJdbcLogger.java:181)ogger{0}|==>  Preparing: select user_name as userName ,user_password as password from user; sg
2017-03-12 09:57:34|dbcLogger.debug(BaseJdbcLogger.java:181)ogger{0}|==> Parameters: sg
2017-03-12 09:57:34|dbcLogger.debug(BaseJdbcLogger.java:181)ogger{0}|<==      Total: 3sg
3
User{userId=0, userName='113', password='123', userRole=0, email='null', registeDate='null', userStatus=0}
User{userId=0, userName='1212', password='123', userRole=0, email='null', registeDate='null', userStatus=0}
User{userId=0, userName='1111', password='123', userRole=0, email='null', registeDate='null', userStatus=0}