MyBatis的环境配置

 

一、拓展包

二、配置文件

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">
		<!-- <property name="username" value="sa"></property> -->
	</properties>
	<!-- mybatis配置文件 -->
	<settings>
		<setting name="cacheEnabled" value="false"/>
		<setting name="autoMappingBehavior" value="PARTIAL"/>
	</settings>
	<!-- 别名的配置 -->
	<typeAliases>
		<!-- <typeAlias type="com.xit.pojo.User" alias="user"/> -->
		<package name="com.xit.pojo"/>
	</typeAliases>
	
  	<!-- 配置运行环境 -->
  <environments default="default">
    <environment id="default">
    	<!-- 配置事务管理器 -->
    	<!-- 由JDBC管理事务 -->
      <transactionManager type="JDBC"/>
      <!-- 配置数据源：连接池 -->
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <!-- 引入Mapper映射文件 -->
  <mappers>
  	<mapper resource="com/xit/pojo/UserMapper.xml"/>
  	<!-- URL方式 -->
  	<!-- <mapper url="file:///C:/eclipse-workspace/mybatis-01/src/com/xit/pojo/UserMapper.xml"/> -->
  </mappers>
</configuration>

database.properties

username=root
password=123
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/smbms?useUnicode=true&characterEncoding=utf-8

两个文件互相配合?

log4j.properties 日志文件，没有的话也可以运行  但是会有报错

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

三、Mapper和Dao

Mapper主要是书写了Sql语句

<?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">
  <!-- namespace:1.用于区分不同的mapper 2.用于绑定接口  -->
  <mapper namespace="com.xit.dao.UserDAO">
<!-- <mapper namespace="com.xit.pojo.UserMapper">  -->
	<select id="selectCount" resultType="int">
		select count(*) from smbms_user
	</select>
	<select id="selectList" resultType="user">
		select * from smbms_user
	</select>
	<select id="selectByUserNameAndRole" parameterType="User" resultType="user">
		<!--  </>select * from smbms_user where smbms_user.userName like concat('%',#{userName},'%') and smbms_user.userRole = #{userRole}-->
		select * from smbms_user  where smbms_user.userName like '%${userName}%' and smbms_user.userRole = #{userRole}
	</select>
	<!-- mapper 传入参数 -->
	<select id="selectByUserNameAndRoleMap" parameterType="map" resultType="user">
		select * from smbms_user  where smbms_user.userName like '%${uname}%' and smbms_user.userRole = #{urole}
	</select>
	<select id="selectByPrimary" parameterType="long" resultType="user">
		select * from smbms_user where id=#{id};
	</select>
</mapper>

Dao是一个借口主要写了是为实现方法体的方法 ：

1、方法名与Mapper中select标签的id值一样

2、方法中的形参类型与parameterType中类型一致

3、方法中返回值与resultType类型一样

package com.xit.dao;

import java.util.List;
import java.util.Map;

import com.xit.pojo.User;

public interface UserDAO {
	public Integer selectCount();
	public List<User> selectList();
	public List<User> selectByUserNameAndRole(User user);
	public List<User> selectByUserNameAndRoleMap(Map map);
	public User selectByPrimary(long id);
}

四、防止重复实例化的单例模式

实例化工厂类

MyBatisUtils

package com.xit.common;

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;

public class MyBatisUtils {
	private static SqlSessionFactory factory;
	static {		
		 InputStream is;
		try {
			//1 读取mybatis-config.xml核心配置文件
			is = Resources.getResourceAsStream("mybatis-config.xml");
			 //2 创建SqlSessionFactoryBuilder对象
			 SqlSessionFactoryBuilder sfb = new SqlSessionFactoryBuilder();
			 //3 调用sfb对象的build()方法创建SqlSessionFactory对象
			 factory = sfb.build(is);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static SqlSession getSession() {
		return factory.openSession();
	}
	public static void closeSession(SqlSession session) {
		if(session!=null) {
			session.close();
		}
	}
}

 根据id查找用户

	@Test
	void testselectByPrimary() {
		SqlSession session = MyBatisUtils.getSession();
		UserDAO userDAO = session.getMapper(UserDAO.class);
		User user = userDAO.selectByPrimary(13L);
		System.out.println(user.getUserName());
	}