一,环境搭建
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>
- id:statementId 唯一
- parameterType:参数类型
- resultType:返回值类型
- #{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>
- $ {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>
- keyProperty:返回id给到的属性
- 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区别
- 应用场景:hibernate一般用于传统项目(银行项目),mybatis一般应用于互联网项目
- 学习成本:hibernate高度封装学习耗时长,mybatis是半封装核心是封装SQL语句改动比较灵活