MyBatis(1)配置

1.首先导入三个jar包
①JDBC驱动包
②log4j包
③mybatis包
2.创建Source Folder(名字为resources)
3.在resources中创建
db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/smbms
username=root
password=root

log4j.properties

log4j.rootLogger=debug,CONSOLE,file
#log4j.rootLogger=ERROR,ROLLING_FILE

log4j.logger.cn.easybuy=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

######################################################################################
# Console Appender  \u65e5\u5fd7\u5728\u63a7\u5236\u8f93\u51fa\u914d\u7f6e
######################################################################################
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.Threshold=debug
#log4j.appender.CONSOLE.DatePattern=yyyy-MM-dd
log4j.appender.CONSOLE.Target=System.out
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern= - (%r ms) - %d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n

######################################################################################
# Rolling File  \u6587\u4ef6\u5927\u5c0f\u5230\u8fbe\u6307\u5b9a\u5c3a\u5bf8\u7684\u65f6\u5019\u4ea7\u751f\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6
######################################################################################
#log4j.appender.ROLLING_FILE=org.apache.log4j.RollingFileAppender
#log4j.appender.ROLLING_FILE.Threshold=INFO
#log4j.appender.ROLLING_FILE.File=${baojia.root}/logs/log.log
#log4j.appender.ROLLING_FILE.Append=true
#log4j.appender.ROLLING_FILE.MaxFileSize=5000KB
#log4j.appender.ROLLING_FILE.MaxBackupIndex=100
#log4j.appender.ROLLING_FILE.layout=org.apache.log4j.PatternLayout
#log4j.appender.ROLLING_FILE.layout.ConversionPattern=%d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %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=l.log
log4j.appender.file.Append=true
log4j.appender.file.Threshold=debug
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern= - (%r ms) - %d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n

核心配置文件(mybatic-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>
	<!-- 引入bd.properties配置文件 -->
	<properties resource="db.properties"/>
	<!-- log4j -->
	<settings>
		<setting name="logImpl" value="LOG4J"/>
	</settings>
	<environments default="development">
		<environment id="development">
			<!-- jdbc -->
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="${driver}"></property>
				<property name="url" value="${url}"></property>
				<property name="username" value="${username}"></property>
				<property name="password" value="${password}"></property>
			</dataSource>
		</environment>
	</environments>
	<!-- 将mapper文件加入到配置文件中(重要)(cn/m/dao1/是包名  UserMapper.xml是mapper的名字) -->
	<mappers>
		<mapper resource="cn/m/dao1/UserMapper.xml"/>
	</mappers>
</configuration>

4.创建实体类

5.创建mapper.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">
<!-- namespace是dao接口的路径 -->
<mapper namespace="cn.m.dao1.UserMapper">
		<!-- c查询用户表记录数 resultType是返回的数据类型 -->
		<select id="count" resultType="cn.m.dao1.User">
			select * from smbms_user
		</select>
</mapper>

创建测试类

package cn.m.dao1.user;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

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.apache.log4j.Logger;
import org.junit.Test;

import cn.m.dao1.User;

public class UserMapperTest {
	private Logger logger=Logger.getLogger(UserMapperTest.class);
	@Test
	public void test() {
		int count=0;
		List<User> alist=new ArrayList<User>();
		SqlSession sqlsession=null;
		try {
			//1 获取mybatis-config.xml输入流
			InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
			//2 创建sqlsessionfactory 完成对配置文件的读取
			SqlSessionFactory ssf=new SqlSessionFactoryBuilder().build(is);
			//3 创建sqlSession 
			sqlsession=ssf.openSession();
			//4 调用mapper文件对数据进行操作,必须将mapper文件引入到mybatis.config.xml文件中 （cn.m.dao1.UserMapper是mapper里的mapper节点的namespace count是子节点的id）
			alist=sqlsession.selectList("cn.m.dao1.UserMapper.count");//selectList()是查询list的方法 count是mapper里的id
			for (User user : alist) {
				System.out.println(user.getId());
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			//关闭sqlsession
			sqlsession.close();
		}
		
	}

}