从零开始学习搭建mybatis框架

第一步：创建一个JavaProject项目，导入所需的mybatis的jar包

1、上图所示jar包（百度云盘）：https://pan.baidu.com/s/1i-L_3UrVT5hOrCjdwkg8ig

2、maven方式添加jar包

<dependencies>
     <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.3.0</version>
    </dependency>
    <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.25</version>
     </dependency>
</dependencies>

第二步：创建resource文件夹，编写全局配置文件mybatis-config.xml文件等

 database.properties 配置文件

driver=com.mysql.jdbc.Driver
#在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
url=jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&characterEncoding=utf-8
user=root
password=root

log4j.properties 配置文件

log4j.rootLogger=DEBUG,CONSOLE,file
#log4j.rootLogger=ERROR,ROLLING_FILE
log4j.logger.cn.smbms.dao=debug
log4j.logger.com.ibatis=debug 
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug 
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug 
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug 
log4j.logger.java.sql.Connection=debug 
log4j.logger.java.sql.Statement=debug 
log4j.logger.java.sql.PreparedStatement=debug 
log4j.logger.java.sql.ResultSet=debug 
log4j.logger.org.tuckey.web.filters.urlrewrite.UrlRewriteFilter=debug

######################################################################################
# Console Appender  \u65e5\u5fd7\u5728\u63a7\u5236\u8f93\u51fa\u914d\u7f6e
######################################################################################
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.Threshold=error
log4j.appender.CONSOLE.Target=System.out
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern= [%p] %d %c - %m%n


######################################################################################
# DailyRolling File  \u6bcf\u5929\u4ea7\u751f\u4e00\u4e2a\u65e5\u5fd7\u6587\u4ef6\uff0c\u6587\u4ef6\u540d\u683c\u5f0f:log2009-09-11
######################################################################################
log4j.appender.file=org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.DatePattern=yyyy-MM-dd
log4j.appender.file.File=log.log
log4j.appender.file.Append=true
log4j.appender.file.Threshold=error
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n


log4j.logger.com.opensymphony.xwork2=error  

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="database.properties"/>
	
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${user}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
       <!-- 此处填写UserMaper.xml文件的url路径，注意不要把 "/" 写成  "."
    <mapper resource="com/bdqn/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

本示例配置文件（百度云盘）：https://pan.baidu.com/s/1KNQORuOjxHiWesOotXwJ4A 

第三步：创建pojo类，如（User类）

package com.bdqn.pojo;

import java.util.Date;

public class User {
	private Integer id; //id 
	private String userCode; //用户编码
	private String userName; //用户名称
	private String userPassword; //用户密码
	private Integer age;//年龄
	private String userRoleName;    //用户角色名称
	
	public String getUserRoleName() {
		return userRoleName;
	}
	public void setUserRoleName(String userRoleName) {
		this.userRoleName = userRoleName;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUserCode() {
		return userCode;
	}
	public void setUserCode(String userCode) {
		this.userCode = userCode;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserPassword() {
		return userPassword;
	}
	public void setUserPassword(String userPassword) {
		this.userPassword = userPassword;
	}
}

第四步：创建mapper文件（如  ①UserMapper接口,  ②UserMapper.xml）

 1、UserMapper.java

package com.bdqn.mapper;

public interface UserMapper {
	
	/**
	 * 查询用户总人数
	 * @return
	 */
	public  int CountUser();

}

2、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">
<mapper namespace="com.bdqn.mapper.UserMapper">

  <select id="CountUser" resultType="int">
   	SELECT COUNT(1) FROM `smbms_user`
  </select>
  
</mapper>

 第五步：创建测试类：UserTest

1️⃣ 采用getMapper方式 （常用）

package com.bdqn.test;

import java.io.IOException;
import java.io.InputStream;
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 com.bdqn.mapper.UserMapper;

public class UserTest {
	
	@Test
	public void eg1(){
		SqlSession sqlSession=null;
		try {
			String resource="mybatis-config.xml";
			InputStream is=Resources.getResourceAsStream(resource);
			SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(is);
			sqlSession=factory.openSession();
			int count=sqlSession.getMapper(UserMapper.class).CountUser();
			System.out.println("用户总人数为："+count);
		} catch (IOException e) {
			e.printStackTrace();
		} finally{
			sqlSession.close();
		}
	}

}

 2️⃣ 采用selectOne方式（基本不用）

注意：

采用这种方式就不再需要( UserMapper.java)这个接口，直接使用 UserMapper.xml中的namespace + id，其他地方不变。

package com.bdqn;

import java.io.IOException;
import java.io.InputStream;

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;

public class UserTest {

	@Test
	public void eg1(){
		SqlSession sqlSession=null;
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			sqlSession=sqlSessionFactory.openSession();
			int result=sqlSession.selectOne("com.bdqn.mapper.UserMapper.CountUser");
			System.out.println("用户总人数："+result);
		} catch (IOException e) {
			e.printStackTrace();
		} finally{
			sqlSession.close();
		}
	}
}

 mybatis的帮助文档：http://www.mybatis.org/mybatis-3/zh/getting-started.html

到这搭建mybatis框架就全部结束了。