MyBatis学习入门之简单实现查询

 

 

1、导入jar包

2、创建resources文件夹用来放资源配置

database.properties:

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

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">
<!-- 通过这个配置文件完成mybatis与数据库的连接 -->
<configuration>
	<!-- 引入 database.properties 文件-->
	<properties resource="database.properties"/>
	<!-- 配置mybatis的log实现为LOG4J -->
	<settings>
		<setting name="logImpl" value="LOG4J" />
	</settings>
	<environments default="development">
		<environment id="development">
			<!--配置事务管理，采用JDBC的事务管理  -->
			<transactionManager type="JDBC"></transactionManager>
			<!-- POOLED:mybatis自带的数据源，JNDI:基于tomcat的数据源 -->
			<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>	
	<!-- 将mapper文件加入到配置文件中 -->
	<mappers>
		<mapper resource="cn/smbms/dao/user/UserMapper.xml"></mapper>
	</mappers>
</configuration>

3、创建数据库对应的实体类：

变量命名规则与数据库保持一致

4、创建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">
<mapper namespace="cn.smbms.dao.user.UserMapper">
	<!-- 查询用户表记录数 -->
	<select id="count" resultType="int">
		select count(1) as count from smbms_user
	</select>	
</mapper>

5、创建测试类log4j进行测试

（1）创建 存放test类的source folder 

（2）右键创建JUnit类

（3）MapperTest.java及运行结果：

package cn.smbms.dao.user;
import static org.junit.Assert.*;
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.apache.log4j.Logger;
import org.junit.Test;
public class UserMapperTest {
	private Logger logger=Logger.getLogger(UserMapperTest.class);
	@Test
	public void test() {
		String resource="mybatis-config.xml";
		int count=0;
		SqlSession sqlSession = null;	
		try {
			//获取mybatis-config.xml输入流
			InputStream is=Resources.getResourceAsStream(resource);
			//创建sqlSessionFactory对象，完成配置文件的读取
			SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
			//创建sqlSession
			sqlSession=factory.openSession();
			//调用mapper文件来对数据进行操作,必须将mapper文件引入到mybatis-config.xml文件中
			count=sqlSession.selectOne("cn.smbms.dao.user.UserMapper.count");
			logger.debug("UserMapperTest count----->" +count);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			sqlSession.close();
		}
	}

}