Mybatis基础配置

项目目录结构

待更新代码的解释。。。。

User.java

package com.mybatis.domain;

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 + "]";
	}
	
	
}

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.mybatis.mapping.userMapper">
	<!-- 根据id查询得到一个user对象 -->
	<select id="getUser" parameterType="int"
		resultType="com.mybatis.domain.User">
		select * from users where id = #{id}
	</select>
	<!-- 创建用户 -->
	<insert id="addUser" parameterType="com.mybatis.domain.User">
		insert into users (name,age) values(#{name},#{age})
	</insert>
	<!-- 删除用户 -->
	<delete id="deleteUser" parameterType="int">
		delete from users where id = #{id}
	</delete>
	<!-- 修改用户 -->
	<update id="updateUser" parameterType="com.mybatis.domain.User">
		update users set name = #{name} ,age = #{age} where id = #{id}
	</update>
	<!-- 查询全部用户 -->
	<select id="getAllUsers" resultType="com.mybatis.domain.User">
		select * from users;
	</select>
</mapper>

MybatisUtils.java

package com.mybatis.utils;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.mybatis.test.Test;

public class MybatisUtils {

	
	private static SqlSessionFactory sqlSessionFactory;
	
	private static String resource = "conf.xml";
	
	
	static {
		InputStream reader = Test.class.getClassLoader().getResourceAsStream(resource);
		sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
	}
	
	public static SqlSession getSqlSession() {
		return sqlSessionFactory.openSession();
	}
	public static SqlSession getSqlSession(boolean isAutoCommit) {
		return sqlSessionFactory.openSession(isAutoCommit);
	}
}

Test.java

package com.mybatis.test;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.mybatis.domain.User;

public class Test {

	
	public static void main(String[] args) {
		String resource = "conf.xml";
		
		InputStream reader = Test.class.getClassLoader().getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession session = sqlSessionFactory.openSession();
		
		String statement = "com.mybatis.mapping.userMapper.getUser";
		User user = session.selectOne(statement,1);
		System.out.println(user);
	}
}

TestCRUDByXmlMapper.java

package com.mybatis.test;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.mybatis.domain.User;
import com.mybatis.utils.MybatisUtils;

public class TestCRUDByXmlMapper {

	@Test
	public void testadd() {
		SqlSession session = MybatisUtils.getSqlSession(true);

		String statement = "com.mybatis.mapping.userMapper.addUser";
		User user = new User();
		user.setName("用户孤傲苍狼");
		user.setAge(20);
		int result = session.insert(statement, user);
//		session.commit();
		session.close();
		System.out.println(result);
	}
	
	@Test
	public void testupdate() {
		SqlSession session = MybatisUtils.getSqlSession(true);

		String statement = "com.mybatis.mapping.userMapper.updateUser";
		User user = new User();
		user.setId(4);
		user.setName("孤傲苍狼_exp");
		user.setAge(22);
		int result = session.insert(statement, user);
//		session.commit();
		session.close();
		System.out.println(result);
	}
	
	@Test
	public void testdelete() {
		SqlSession session = MybatisUtils.getSqlSession(true);

		String statement = "com.mybatis.mapping.userMapper.deleteUser";
		int result = session.insert(statement, 4);
//		session.commit();
		session.close();
		System.out.println(result);
	}
	
	@Test
	public void testGetAll() {
		SqlSession session = MybatisUtils.getSqlSession(true);

		String statement = "com.mybatis.mapping.userMapper.getAllUsers";
		List<User> users = session.selectList(statement);
//		session.commit();
		session.close();
		System.out.println(users);
	}
}

conf.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="db.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="${name}"/>
					<property name="password" value="${password}"/>
				</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="com/mybatis/mapping/userMapper.xml"/>
	</mappers>
</configuration>

db.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis
name=root
password=