重新整理Mybatis-01

写在前面：受限于自身编程语言水平，文中可能存在错误之处，博客本意只为自查，不建议作为学习之用

1、整体的项目结构

2、导包不在赘述

3，简单的数据库表

3、先建立一个基础类

package com.xiaohu.pojo;

/**
 * 基础类
 * @author PC
 *
 */

public class User {
	private int id;
	private String name;
	private int age;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public User(int id, String name, int age) {
		super();
		this.id = id;
		this.name = name;
		this.age = age;
	}

	public User() {
		super();
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}

}

4，配置文件

<?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>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
				<property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=Test" />
				<property name="username" value="sa" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
</configuration>

5，映射文件

<?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唯一标识（包名+文件名） -->
<mapper namespace="com.xiaohu.pojo.UserMapper"> 
	<select id="selectUser" parameterType="int" resultType="com.xiaohu.pojo.User"> 
		select * from users where id = #{id} 
	</select> 
</mapper>

6，引用映射文件

<?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>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
				<property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=Test" />
				<property name="username" value="sa" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
	<!-- 配置文件中把要加载的映射文件加载进来 -->
	<mappers>
			<!-- 加载文件所以使用斜杠表明路径 -->
			<mapper resource="com/xiaohu/pojo/UserMapper.xml"/>
	</mappers>
</configuration>

7，测试

package com.xiaohu.pojo;

import java.io.IOException;
import java.io.Reader;

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 UserTest {
	public static void main(String[] args) throws IOException {
		// 配置文件名
		String resource = "config.xml";
		// 使用流加载配置文件
		Reader reader = Resources.getResourceAsReader(resource);
		// 建立会话工厂
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		// 打开会话
		SqlSession sqlSession = sqlSessionFactory.openSession();
		// statement作为参数唯一的指向com.xiaohu.pojo包下的UserMapper中id为selectUser
		// 也就是说namespace为com.xiaohu.pojo.UserMapper中的selectUser
		String statement = "com.xiaohu.pojo.UserMapper.selectUser";
		User user = sqlSession.selectOne(statement, 1);
		System.out.println(user);
	}
}