持久层框架MyBatis学习(2)-入门案例

一，环境搭建

1.创建java工程
2.jar包 ：mybatis核心包，mybatis扩展包，junit

3.添加mybatis核心配置文件 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>
	<!-- 和spring整合后 environments配置将废除-->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理-->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池-->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>
</configuration>

4.添加一个log4j.properties

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

5.创建一个pojo

public class User implements Serializable {
	private int id;
	private String username;// 用户姓名
	private String sex;// 性别
	private Date birthday;// 生日
	private String address;// 地址
//get/set方法。。。
}

6.创建一个映射文件

<?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="test">
</mapper>

7.把映射文件加载到 sqlMapConfig.xml

<mappers>
		<mapper resource="user.xml"/>
</mappers>

二，入门案例

1.根据id查询用户

1).映射文件里配置

<select id="findUserById" parameterType="int" resultType="com.djc.mybatis.po.User" >
	 select * from user where id = #{id}
</select>

1. id：statementId 唯一
2. parameterType：参数类型
3. resultType：返回值类型
4. #{id}：占位符，如果传入的是字符串，预编译的时候会自动带上单引号

2).测试

	@Test
	public void testFindUserById() throws Exception {
		//1.获取sqlSessionFactory对象
		SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
		SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
		//2.获取sqlSession
		SqlSession sqlSession = sqlSessionFactory.openSession();
		//3.使用sqlSession的方法		(statementId, 指定的输入映射参数)
		User user = sqlSession.selectOne("findUserById", 10);
		System.out.println(user);
		//4.关闭sqlSession
		sqlSession.close();
	}

2.根据用户名模糊查询

1).映射文件里配置

<select id="findUserByUsername" parameterType="string" resultType="com.djc.mybatis.po.User">
	select * from user where username like '%${value}%'
</select>

5. $ {id}：连接符 ：如果传入的是基础数据类型 大括号中只能写value 即${value},如果传入的是pojo或者map类型，大括号中只能写属性名或key名 ${username}

2).测试

	@Test
	public void testFindUserByUsername() throws Exception {
		SqlSessionFactoryBuilder builder =  new SqlSessionFactoryBuilder();
		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
		SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		List<User> list = sqlSession.selectList("findUserByUsername", "张");
		System.out.println(list);
		sqlSession.close();
	}

3.插入用户并返回id

1).映射文件里配置

<insert id="insertUser" parameterType="com.djc.mybatis.po.User" >
	<selectKey resultType="int" keyProperty="id" order="AFTER">
		<!-- 返回当前事务最后产生的id -->
		select LAST_INSERT_ID()
	</selectKey>
	insert into user(username,birthday,sex,address) value(#{username},#{birthday},#{sex},#{address})
</insert>

1. keyProperty：返回id给到的属性
2. order:提交事务前还是后 枚举 只有AFTER和BEFORE

2).测试

	@Test
	public void testInsertUser() throws Exception {
		SqlSessionFactoryBuilder builder =  new SqlSessionFactoryBuilder();
		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
		SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		User user = new User();
		user.setAddress("天津");
		user.setBirthday(new Date());
		user.setSex("0");
		user.setUsername("cc");
		sqlSession.insert("insertUser", user);
		//需要提交事务
		sqlSession.commit();
		System.out.println(user);
		sqlSession.close();
	}

4.修改用户

1).映射文件里配置

<update id="updateUser" parameterType="com.djc.mybatis.po.User">
	update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id=#{id}
</update>

2).测试

	@Test
	public void testUpdateUser() throws Exception {
		SqlSessionFactoryBuilder builder =  new SqlSessionFactoryBuilder();
		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
		SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		User user = new User();
		user.setAddress("天津");
		user.setBirthday(new Date());
		user.setSex("0");
		user.setUsername("aa");
		user.setId(27);
		sqlSession.insert("updateUser", user);
		sqlSession.commit();
		System.out.println(user);
		sqlSession.close();
	}

5.删除用户

1).映射文件里配置

<delete id="deleteUser" parameterType="int">
	delete from user where id=#{id}
</delete>

2).测试

	@Test
	public void testDeleteUser() throws Exception {
		SqlSessionFactoryBuilder builder =  new SqlSessionFactoryBuilder();
		InputStream inputStream = Resources.getResourceAsStream("sqlMapConfig.xml");
		SqlSessionFactory sqlSessionFactory = builder.build(inputStream);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		sqlSession.insert("deleteUser", 26);
		sqlSession.commit();
		sqlSession.close();
	}

三，hibernate和mybatis区别

1. 应用场景：hibernate一般用于传统项目（银行项目），mybatis一般应用于互联网项目
2. 学习成本：hibernate高度封装学习耗时长，mybatis是半封装核心是封装SQL语句改动比较灵活