一、MyBatis簡介
MyBatis是支持普通SQL查詢，存儲過程和高級映射的優秀持久層框架。
MyBatis消除了幾乎所有的JDBC代碼和參數的手工設置以及對結果集的檢索封裝。
MyBatis可以使用簡單的XML或注解用于配置和原始映射，將接口和Java的POJO（Plain Old Java Objects，普通的Java對象）映射成數據庫中的記錄.
JDBC -> dbutils(自動封裝) -> MyBatis -> Hibernate
mybatis是將sql寫在xml中，然后去訪問數據庫。
二、MyBatis快速入門
2.1.新建java項目
添加mybatis和mysql的驅動jar：mybatis-3.1.1.jar,mysql-connector-java-5.1.7-bin.jar
2.2.新建表
|
1
2
3
4
5
|
create database mybatis;use mybatis;create table users(id int primary key auto_increment, name varchar(20), age int);insert into users (name,age) values('Tom',12);insert into users (name, age) values('Jack',11); |
2.3.添加mybatis的配置文件conf.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<?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.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/mybatis" /><property name="username" value="root" /><property name="password" value="root" /></dataSource></environment></environments></configuration> |
2.4.定義表對應的實體類
|
1
2
3
4
5
6
|
public class User {private int id;private String name;private int age;//get,set方法} |
2.5.定義操作users表的sql映射文件userMapper.xml
|
1
2
3
4
5
6
7
8
|
<?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.atguigu.mybatis_test.test1.userMapper"><select id="getUser" parameterType="int"resultType="com.atguigu.mybatis_test.test1.User">select * from users where id=#{id}</select></mapper> |
2.6.在conf.xml文件中注冊userMapper.xml文件
|
1
2
3
|
<mappers><mapper resource="com/atguigu/mybatis_test/test1/userMapper.xml"/></mappers> |
2.7.編寫測試代碼：執行定義的select語句
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
public class Test {public static void main(String[] args) throws IOException {String resource = "conf.xml";//加載mybatis的配置文件（它也加載關聯的映射文件）Reader reader = Resources.getResourceAsReader(resource);//構建sqlSession的工廠SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);//創建能執行映射文件中sql的sqlSessionSqlSession session = sessionFactory.openSession();//映射sql的標識字符串String statement = "com.atguigu.mybatis.bean.userMapper"+".selectUser";//執行查詢返回一個唯一user對象的sqlUser user = session.selectOne(statement, 1);System.out.println(user);}} |
三、操作users表的CRUD
3.1.xml的實現
3.1.1.定義sql映射xml文件：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<insert id="insertUser" parameterType="com.atguigu.ibatis.bean.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.atguigu.ibatis.bean.User">update users set name=#{name},age=#{age} where id=#{id}</update><select id="selectUser" parameterType="int" resultType="com.atguigu.ibatis.bean.User">select * from users where id=#{id}</select><select id="selectAllUsers" resultType="com.atguigu.ibatis.bean.User">select * from users</select> |
3.1.2.在config.xml中注冊這個映射文件
|
1
|
<mapper resource=" com/atguigu/ibatis/bean/userMapper.xml"/> |
3.1.3.在dao中調用
|
1
2
3
4
5
|
public User getUserById(int id) {SqlSession session = sessionFactory.openSession();User user = session.selectOne(URI+".selectUser", id);return user;} |
3.2.注解的實現
3.2.1.定義sql映射的接口
|
1
2
3
4
5
6
7
8
9
10
11
12
|
public interface UserMapper {@Insert("insert into users(name, age) values(#{name}, #{age})")public int insertUser(User user);@Delete("delete from users where id=#{id}")public int deleteUserById(int id);@Update("update users set name=#{name},age=#{age} where id=#{id}")public int updateUser(User user);@Select("select * from users where id=#{id}")public User getUserById(int id);@Select("select * from users")public List<User> getAllUser();} |
3.2.2.在config中注冊這個映射接口
|
1
|
<mapper class="com.atguigu.ibatis.crud.ano.UserMapper"/> |
3.2.3.在dao中調用
|
1
2
3
4
5
6
|
public User getUserById(int id) {SqlSession session = sessionFactory.openSession();UserMapper mapper = session.getMapper(UserMapper.class);User user = mapper.getUserById(id);return user;} |
四、幾個可以優化的地方
4.1.連接數據庫的配置可以單獨放在一個properties文件中。
|
1
2
3
4
5
6
|
## db.properties<br><properties resource="db.properties"/><property name="driver" value="${driver}" /><property name="url" value="${url}" /><property name="username" value="${username}" /><property name="password" value="${password}" /> |
4.2.為實體類定義別名,簡化sql映射xml文件中的引用
|
1
2
3
|
<typeAliases><typeAlias type="com.atguigu.ibatis.bean.User" alias="_User"/></typeAliases> |
4.3.可以在src下加入log4j的配置文件,打印日志信息
1. 添加jar:
log4j-1.2.16.jar
2.1. log4j.properties(方式一)
|
1
2
3
4
5
6
7
8
9
10
11
|
log4j.properties，log4j.rootLogger=DEBUG, Console#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.java.sql.ResultSet=INFOlog4j.logger.org.apache=INFOlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG |
2.2. log4j.xml(方式二)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"><appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern"value="%-5p %d{MM-dd HH:mm:ss,SSS} %m (%F:%L) \n" /></layout></appender><logger name="java.sql"><level value="debug" /></logger><logger name="org.apache.ibatis"><level value="debug" /></logger><root><level value="debug" /><appender-ref ref="STDOUT" /></root></log4j:configuration> |
五、解決字段名與實體類屬性名不相同的沖突
5.1.準備表和字段
|
1
2
3
4
5
6
7
8
|
CREATE TABLE orders(order_id INT PRIMARY KEY AUTO_INCREMENT,order_no VARCHAR(20),order_price FLOAT);INSERT INTO orders(order_no, order_price) VALUES('aaaa', 23);INSERT INTO orders(order_no, order_price) VALUES('bbbb', 33);INSERT INTO orders(order_no, order_price) VALUES('cccc', 22); |
5.2.定義實體類
|
1
2
3
4
5
|
public class Order {private int id;private String orderNo;private float price;} |
5.3.實現getOrderById(id)的查詢：
方式一: 通過在sql語句中定義別名
|
1
2
3
|
<select id="selectOrder" parameterType="int" resultType="_Order">select order_id id, order_no orderNo,order_price price from orders where order_id=#{id}</select> |
方式二: 通過<resultMap>
|
1
2
3
4
5
6
7
8
|
<select id="selectOrderResultMap" parameterType="int" resultMap="orderResultMap">select * from orders where order_id=#{id}</select><resultMap type="_Order" id="orderResultMap"><id property="id" column="order_id"/><result property="orderNo" column="order_no"/><result property="price" column="order_price"/></resultMap> |
六、實現關聯表查詢
6.1.一對一關聯
6.1.1.提出需求
根據班級id查詢班級信息(帶老師的信息)
6.1.2.創建表和數據
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
CREATE TABLE teacher(t_id INT PRIMARY KEY AUTO_INCREMENT,t_name VARCHAR(20));CREATE TABLE class(c_id INT PRIMARY KEY AUTO_INCREMENT,c_name VARCHAR(20),teacher_id INT);ALTER TABLE class ADD CONSTRAINT fk_teacher_id FOREIGN KEY (teacher_id) REFERENCES teacher(t_id); INSERT INTO teacher(t_name) VALUES('LS1');INSERT INTO teacher(t_name) VALUES('LS2');INSERT INTO class(c_name, teacher_id) VALUES('bj_a', 1);INSERT INTO class(c_name, teacher_id) VALUES('bj_b', 2); |
6.1.3.定義實體類：
|
1
2
3
4
5
6
7
8
9
|
public class Teacher {private int id;private String name;}public class Classes {private int id;private String name;private Teacher teacher;} |
6.1.4.定義sql映射文件ClassMapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
<!--方式一: 嵌套結果: 使用嵌套結果映射來處理重復的聯合結果的子集SELECT * FROM class c, teacher t,student s WHERE c.teacher_id=t.t_id AND c.C_id=s.class_id AND c.c_id=1--><select id="getClass3" parameterType="int" resultMap="ClassResultMap3">select * from class c, teacher t,student s where c.teacher_id=t.t_id and c.C_id=s.class_id and c.c_id=#{id}</select><resultMap type="_Classes" id="ClassResultMap3"><id property="id" column="c_id"/><result property="name" column="c_name"/><association property="teacher" column="teacher_id" javaType="_Teacher"><id property="id" column="t_id"/><result property="name" column="t_name"/></association><!-- ofType指定students集合中的對象類型 --><collection property="students" ofType="_Student"><id property="id" column="s_id"/><result property="name" column="s_name"/></collection></resultMap><!--方式二：嵌套查詢：通過執行另外一個SQL映射語句來返回預期的復雜類型SELECT * FROM class WHERE c_id=1;SELECT * FROM teacher WHERE t_id=1 //1 是上一個查詢得到的teacher_id的值SELECT * FROM student WHERE class_id=1 //1是第一個查詢得到的c_id字段的值--><select id="getClass4" parameterType="int" resultMap="ClassResultMap4">select * from class where c_id=#{id}</select><resultMap type="_Classes" id="ClassResultMap4"><id property="id" column="c_id"/><result property="name" column="c_name"/><association property="teacher" column="teacher_id" javaType="_Teacher" select="getTeacher2"></association><collection property="students" ofType="_Student" column="c_id" select="getStudent"></collection></resultMap><select id="getTeacher2" parameterType="int" resultType="_Teacher">SELECT t_id id, t_name name FROM teacher WHERE t_id=#{id}</select><select id="getStudent" parameterType="int" resultType="_Student">SELECT s_id id, s_name name FROM student WHERE class_id=#{id}</select> |
6.1.5.測試
|
1
2
3
4
5
6
7
8
9
10
11
12
|
@Testpublic void testOO() {SqlSession sqlSession = factory.openSession();Classes c = sqlSession.selectOne("com.atguigu.day03_mybatis.test5.OOMapper.getClass", 1);System.out.println(c);}@Testpublic void testOO2() {SqlSession sqlSession = factory.openSession();Classes c = sqlSession.selectOne("com.atguigu.day03_mybatis.test5.OOMapper.getClass2", 1);System.out.println(c);} |
6.2.一對多關聯
6.2.1.提出需求
根據classId查詢對應的班級信息,包括學生,老師
6.2.2.創建表和數據：
|
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TABLE student(s_id INT PRIMARY KEY AUTO_INCREMENT,s_name VARCHAR(20),class_id INT);INSERT INTO student(s_name, class_id) VALUES('xs_A', 1);INSERT INTO student(s_name, class_id) VALUES('xs_B', 1);INSERT INTO student(s_name, class_id) VALUES('xs_C', 1);INSERT INTO student(s_name, class_id) VALUES('xs_D', 2);INSERT INTO student(s_name, class_id) VALUES('xs_E', 2);INSERT INTO student(s_name, class_id) VALUES('xs_F', 2); |
6.2.3.定義實體類
|
1
2
3
4
5
6
7
8
9
10
|
public class Student {private int id;private String name;}public class Classes {private int id;private String name;private Teacher teacher;private List<Student> students;} |
6.2.4.定義sql映射文件ClassMapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
<!--方式一: 嵌套結果: 使用嵌套結果映射來處理重復的聯合結果的子集SELECT * FROM class c, teacher t,student s WHERE c.teacher_id=t.t_id AND c.C_id=s.class_id AND c.c_id=1--><select id="getClass3" parameterType="int" resultMap="ClassResultMap3">select * from class c, teacher t,student s where c.teacher_id=t.t_id and c.C_id=s.class_id and c.c_id=#{id}</select><resultMap type="_Classes" id="ClassResultMap3"><id property="id" column="c_id"/><result property="name" column="c_name"/><association property="teacher" column="teacher_id" javaType="_Teacher"><id property="id" column="t_id"/><result property="name" column="t_name"/></association><!-- ofType指定students集合中的對象類型 --><collection property="students" ofType="_Student"><id property="id" column="s_id"/><result property="name" column="s_name"/></collection></resultMap><!--方式二：嵌套查詢：通過執行另外一個SQL映射語句來返回預期的復雜類型SELECT * FROM class WHERE c_id=1;SELECT * FROM teacher WHERE t_id=1 //1 是上一個查詢得到的teacher_id的值SELECT * FROM student WHERE class_id=1 //1是第一個查詢得到的c_id字段的值--><select id="getClass4" parameterType="int" resultMap="ClassResultMap4">select * from class where c_id=#{id}</select><resultMap type="_Classes" id="ClassResultMap4"><id property="id" column="c_id"/><result property="name" column="c_name"/><association property="teacher" column="teacher_id" javaType="_Teacher" select="getTeacher2"></association><collection property="students" ofType="_Student" column="c_id" select="getStudent"></collection></resultMap><select id="getTeacher2" parameterType="int" resultType="_Teacher">SELECT t_id id, t_name name FROM teacher WHERE t_id=#{id}</select><select id="getStudent" parameterType="int" resultType="_Student">SELECT s_id id, s_name name FROM student WHERE class_id=#{id}</select> |
6.2.5.測試
|
1
2
3
4
5
6
7
8
9
10
11
12
|
@Testpublic void testOM() {SqlSession sqlSession = factory.openSession();Classes c = sqlSession.selectOne("com.atguigu.day03_mybatis.test5.OOMapper.getClass3", 1);System.out.println(c);}@Testpublic void testOM2() {SqlSession sqlSession = factory.openSession();Classes c = sqlSession.selectOne("com.atguigu.day03_mybatis.test5.OOMapper.getClass4", 1);System.out.println(c);} |
七、動態sql與模糊查詢
7.1.需求
實現多條件查詢用戶(姓名模糊匹配, 年齡在指定的最小值到最大值之間)。
7.2.準備數據庫和表
|
1
2
3
4
5
6
7
8
9
10
11
12
|
create table d_user( id int primary key auto_increment, name varchar(10),age int(3));insert into d_user(name,age) values('Tom',12); insert into d_user(name,age) values('Bob',13); insert into d_user(name,age) values('Jack',18);7.3.ConditionUser(查詢條件實體類)private String name;private int minAge;private int maxAge; |
7.4.User表實體類
|
1
2
3
|
private int id;private String name;private int age; |
7.5.userMapper.xml(映射文件)
|
1
2
3
4
5
6
7
8
9
|
<?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.atguigu.day03_mybatis.test6.userMapper"><select id="getUser" parameterType="com.atguigu.day03_mybatis.test6.ConditionUser" resultType="com.atguigu.day03_mybatis.test6.User">select * from d_user where age>=#{minAge} and age<=#{maxAge}<if test='name!="%null%"'>and name like #{name}</if></select></mapper> |
7.6.UserTest(測試)
|
1
2
3
4
5
6
7
8
9
10
|
public class UserTest {public static void main(String[] args) throws IOException {Reader reader = Resources.getResourceAsReader("conf.xml");SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);SqlSession sqlSession = sessionFactory.openSession();String statement = "com.atguigu.day03_mybatis.test6.userMapper.getUser";List<User> list = sqlSession.selectList(statement, new ConditionUser("%a%", 1, 12));System.out.println(list);}} |
MyBatis中可用的動態SQL標簽
八、調用存儲過程
8.1.提出需求
查詢得到男性或女性的數量, 如果傳入的是0就女性否則是男性
8.2.準備數據庫表和存儲過程:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
create table p_user( id int primary key auto_increment, name varchar(10),sex char(2));insert into p_user(name,sex) values('A',"男"); insert into p_user(name,sex) values('B',"女"); insert into p_user(name,sex) values('C',"男"); #創建存儲過程(查詢得到男性或女性的數量, 如果傳入的是0就女性否則是男性)DELIMITER $CREATE PROCEDURE mybatis.ges_user_count(IN sex_id INT, OUT user_count INT)BEGIN IF sex_id=0 THENSELECT COUNT(*) FROM mybatis.p_user WHERE p_user.sex='女' INTO user_count;ELSESELECT COUNT(*) FROM mybatis.p_user WHERE p_user.sex='男' INTO user_count;END IF;END$#調用存儲過程DELIMITER ;SET @user_count = 0;CALL mybatis.ges_user_count(1, @user_count);SELECT @user_count; |
8.3.創建表的實體類
|
1
2
3
4
5
|
public class User {private String id;private String name;private String sex;} |
8.4.userMapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
<mapper namespace="com.atguigu.mybatis.test7.userMapper"><!--查詢得到男性或女性的數量, 如果傳入的是0就女性否則是男性CALL mybatis.get_user_count(1, @user_count);--><select id="getCount" statementType="CALLABLE" parameterMap="getCountMap">call mybatis.get_user_count(?,?)</select><parameterMap type="java.util.Map" id="getCountMap"><parameter property="sex_id" mode="IN" jdbcType="INTEGER"/><parameter property="user_count" mode="OUT" jdbcType="INTEGER"/></parameterMap></mapper> |
8.5.測試
|
1
2
3
4
5
|
Map<String, Integer> paramMap = new HashMap<>();paramMap.put("sex_id", 0);session.selectOne(statement, paramMap);Integer userCount = paramMap.get("user_count");System.out.println(userCount); |
九、MyBatis緩存
9.1.理解mybatis緩存
正如大多數持久層框架一樣，MyBatis 同樣提供了一級緩存和二級緩存的支持
1.一級緩存: 基于PerpetualCache 的 HashMap本地緩存，其存儲作用域為 Session，當 Session flush 或 close 之后，該Session中的所有 Cache 就將清空。
2. 二級緩存與一級緩存其機制相同，默認也是采用 PerpetualCache，HashMap存儲，不同在于其存儲作用域為 Mapper(Namespace)，并且可自定義存儲源，如 Ehcache。
3. 對于緩存數據更新機制，當某一個作用域(一級緩存Session/二級緩存Namespaces)的進行了 C/U/D 操作后，默認該作用域下所有 select 中的緩存將被clear。
9.2.mybatis一級緩存
9.2.1.根據任務查詢
根據id查詢對應的用戶記錄對象。
9.2.2.準備數據庫表和數據
|
1
2
3
4
5
6
7
|
CREATE TABLE c_user(id INT PRIMARY KEY AUTO_INCREMENT,NAME VARCHAR(20),age INT);INSERT INTO c_user(NAME, age) VALUES('Tom', 12);INSERT INTO c_user(NAME, age) VALUES('Jack', 11); |
9.2.3.創建表的實體類
|
1
2
3
4
|
public class User implements Serializable{private int id;private String name;private int age; |
9.2.4.userMapper.xml
|
1
2
3
4
5
6
7
8
9
10
11
|
<?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.atguigu.mybatis.test8.userMapper"><select id="getUser" parameterType="int" resultType="_CUser">select * from c_user where id=#{id}</select><update id="updateUser" parameterType="_CUser">update c_user setname=#{name}, age=#{age} where id=#{id}</update></mapper> |
9.2.5.測試
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
/** 一級緩存: 也就Session級的緩存(默認開啟)*/@Testpublic void testCache1() {SqlSession session = MybatisUtils.getSession();String statement = "com.atguigu.mybatis.test8.userMapper.getUser";User user = session.selectOne(statement, 1);System.out.println(user);/** 一級緩存默認就會被使用*//*user = session.selectOne(statement, 1);System.out.println(user);*//*1. 必須是同一個Session,如果session對象已經close()過了就不可能用了*//*session = MybatisUtils.getSession();user = session.selectOne(statement, 1);System.out.println(user);*//*2. 查詢條件是一樣的*//*user = session.selectOne(statement, 2);System.out.println(user);*//*3. 沒有執行過session.clearCache()清理緩存*//*session.clearCache();user = session.selectOne(statement, 2);System.out.println(user);*//*4. 沒有執行過增刪改的操作(這些操作都會清理緩存)*//*session.update("com.atguigu.mybatis.test8.userMapper.updateUser",new User(2, "user", 23));user = session.selectOne(statement, 2);System.out.println(user);*/} |
9.3.MyBatis二級緩存
9.3.1.添加一個<cache>在userMapper.xml中
|
1
2
|
<mapper namespace="com.atguigu.mybatis.test8.userMapper"><cache/> |
9.3.2.測試
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
/** 測試二級緩存*/@Testpublic void testCache2() {String statement = "com.atguigu.mybatis.test8.userMapper.getUser";SqlSession session = MybatisUtils.getSession();User user = session.selectOne(statement, 1);session.commit();System.out.println("user="+user);SqlSession session2 = MybatisUtils.getSession();user = session2.selectOne(statement, 1);session.commit();System.out.println("user2="+user);} |
9.3.3.補充說明
1. 映射語句文件中的所有select語句將會被緩存。
2. 映射語句文件中的所有insert，update和delete語句會刷新緩存。
3. 緩存會使用Least Recently Used（LRU，最近最少使用的）算法來收回。
4. 緩存會根據指定的時間間隔來刷新。
5. 緩存會存儲1024個對象
|
1
2
3
4
5
|
<cacheeviction="FIFO" //回收策略為先進先出flushInterval="60000" //自動刷新時間60ssize="512" //最多緩存512個引用對象readOnly="true"/> //只讀 |
十、Spring集成MyBatis
10.1.添加jar
【mybatis】
mybatis-3.2.0.jar
mybatis-spring-1.1.1.jar
log4j-1.2.17.jar
【spring】
spring-aop-3.2.0.RELEASE.jar
spring-beans-3.2.0.RELEASE.jar
spring-context-3.2.0.RELEASE.jar
spring-core-3.2.0.RELEASE.jar
spring-expression-3.2.0.RELEASE.jar
spring-jdbc-3.2.0.RELEASE.jar
spring-test-3.2.4.RELEASE.jar
spring-tx-3.2.0.RELEASE.jar
aopalliance-1.0.jar
cglib-nodep-2.2.3.jar
commons-logging-1.1.1.jar
【MYSQL驅動包】
mysql-connector-java-5.0.4-bin.jar
10.2.數據庫表
|
1
2
3
4
5
6
|
CREATE TABLE s_user(user_id INT AUTO_INCREMENT PRIMARY KEY,user_name VARCHAR(30),user_birthday DATE,user_salary DOUBLE) |
10.3.實體類：User
|
1
2
3
4
5
6
7
|
public class User {private int id;private String name;private Date birthday;private double salary;//set,get方法} |
10.4.DAO接口: UserMapper (XXXMapper)
|
1
2
3
4
5
6
7
|
public interface UserMapper {void save(User user);void update(User user);void delete(int id);User findById(int id);List<User> findAll();} |
10.5.SQL映射文件: userMapper.xml(與接口忽略大小寫同名)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<?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.atguigu.mybatis.test9.UserMapper"><resultMap type="User" id="userResult"><result column="user_id" property="id"/><result column="user_name" property="name"/><result column="user_birthday" property="birthday"/><result column="user_salary" property="salary"/></resultMap><!-- 取得插入數據后的id --><insert id="save" keyColumn="user_id" keyProperty="id" useGeneratedKeys="true">insert into s_user(user_name,user_birthday,user_salary)values(#{name},#{birthday},#{salary})</insert><update id="update">update s_userset user_name = #{name},user_birthday = #{birthday},user_salary = #{salary}where user_id = #{id}</update><delete id="delete">delete from s_userwhere user_id = #{id}</delete><select id="findById" resultMap="userResult">select *from s_userwhere user_id = #{id}</select><select id="findAll" resultMap="userResult">select *from s_user</select></mapper> |
10.6.spring的配置文件: beans.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.2.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.2.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.2.xsd"><!-- 1. 數據源 : DriverManagerDataSource --><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver"/><property name="url" value="jdbc:mysql://localhost:3306/mybatis"/><property name="username" value="root"/><property name="password" value="root"/></bean><!--2. mybatis的SqlSession的工廠: SqlSessionFactoryBeandataSource / typeAliasesPackage--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><property name="typeAliasesPackage" value="com.atuigu.spring_mybatis2.domain"/></bean><!--3. mybatis自動掃描加載Sql映射文件 : MapperScannerConfigurersqlSessionFactory / basePackage--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.atuigu.spring_mybatis2.mapper"/><property name="sqlSessionFactory" ref="sqlSessionFactory"/></bean><!-- 4. 事務管理 : DataSourceTransactionManager --><bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><!-- 5. 使用聲明式事務 --><tx:annotation-driven transaction-manager="txManager" /></beans> |
10.7.mybatis的配置文件: mybatis-config.xml
|
1
2
3
4
5
6
7
8
9
10
11
|
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><!-- Spring整合myBatis后，這個配置文件基本可以不要了--><!-- 設置外部配置文件 --><!-- 設置類別名 --><!-- 設置數據庫連接環境 --><!-- 映射文件 --></configuration> |
10.8.測試
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
@RunWith(SpringJUnit4ClassRunner.class) //使用Springtest測試框架@ContextConfiguration("/beans.xml") //加載配置public class SMTest {@Autowired //注入private UserMapper userMapper;@Testpublic void save() {User user = new User();user.setBirthday(new Date());user.setName("marry");user.setSalary(300);userMapper.save(user);System.out.println(user.getId());}@Testpublic void update() {User user = userMapper.findById(2);user.setSalary(2000);userMapper.update(user);}@Testpublic void delete() {userMapper.delete(3);}@Testpublic void findById() {User user = userMapper.findById(1);System.out.println(user);}@Testpublic void findAll() {List<User> users = userMapper.findAll();System.out.println(users);}} |
以上所述是小編給大家介紹的MyBatis快速入門(簡明淺析易懂)，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對服務器之家網站的支持！
原文鏈接：http://www.cnblogs.com/ablejava/archive/2016/11/08/6036563.html
