Mybatis学习笔记【一】

1.全局配置文件（sqlMapConfig.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>
        <!-- 环境 -->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.cj.jdbc.Driver" />
                                <!-- 有些版本的url对应的value=jdbc:mysql://localhost:3306/yc?characterEncoding=utf8 -->
                                <!-- 平常用的&在xml中要使用它的转义字符&amp; -->
				<property name="url" value="jdbc:mysql://localhost:3306/yc?characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC" />
				<property name="username" value="root" />
				<property name="password" value="a" />
			</dataSource>
		</environment>
	</environments>
</configuration>

2.POJO(User.java)

package cn.itcast.mybatis.po;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable {
	/**
	 * 成员变量最好和数据库的表的列一一对应
	 */
	private static final long serialVersionUID = 1L;
	private Integer id;
	private String name;
	private String sex;
	private Date birthday;
	private String address;


	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", sex=" + sex
				+ ", birthday=" + birthday + ", address=" + address + "]";
	}
}

3.配置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">
<!-- 写Sql语句   -->
<mapper namespace="UserMapper">
	<!-- 通过ID查询一个用户 -->
        <!-- 类似于方法调用，id起方法名的作用，paramaterType是入参类型，resultType是返回值类型 -->
	<select id="SelectById" parameterType="Integer" resultType="cn.itcast.mybatis.po.User">
		select * from user where id = #{id}
	</select>
        <!-- 通过用户名模糊查询 -->
	<select id="SelectByUserName" parameterType="String" resultType="cn.itcast.mybatis.po.User">
		select * from user where name like '%${value}%'
	</select>
	<insert id="insertUser" parameterType="cn.itcast.mybatis.po.User">
                <!-- 在插入数据后返回它的id,如果是MYSQL，order取AFTER,Oracle则是BEFORE -->
		<selectKey keyProperty="id" resultType="Integer" order="AFTER">
			select LAST_INSERT_ID()
		</selectKey>
		insert into user (name,sex,birthday,address)
		value(#{name},#{sex},#{birthday},#{address})
	</insert>
	<update id="UpdateById" parameterType="cn.itcast.mybatis.po.User">
		update user set name=#{name},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}
	</update>
	<delete id="DeleteById" parameterType="Integer">
		delete from user where id=#{id}
	</delete>
</mapper>

4.修改全局配置文件

<!--在environment标签后,configuration标签前-->
<!-- Mapper的位置  Mapper.xml 写Sql语句的文件的位置 -->
<mappers>
 	<mapper resource="sqlMap/UserMapper.xml"/> 
</mappers>

5.测试类

package cn.itcast.mybatis.po;

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.junit.Test;

public class MybatisJUnitTest {

	@Test
	public void test() throws IOException {
		String resource="sqlMapConfig.xml";
                //读取全局配置文件
		InputStream in=Resources.getResourceAsStream(resource);
                //构建SqlSessionFactory
		SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(in);
                //打开SqlSession会话
		SqlSession session=sqlSessionFactory.openSession();
                /*
                //插入记录
		User user=new User();
		user.setAddress("成都市");
		user.setUsername("李雷");
		user.setBirthday(new Date());
		user.setSex("男");
		user.setId(1);
		session.insert("insertUser", user);//执行mapper文件中id为insertUser的sql语句
		session.commit();//提交事务
		System.out.println(user.getId());
		*/
		/*
                //更新记录
		User user=new User();
		user.setAddress("成都市");
		user.setUsername("李雷");
		user.setBirthday(new Date());
		user.setSex("男");
		user.setId(1);
		session.update("UpdateById", user);
		session.commit();
		*/
                //删除记录
		session.delete("DeleteById", 1);
		session.commit();
		session.close();
	}

}