MyBatis框架（2019-09-23）

百度百科：https://baike.baidu.com/item/MyBatis/2824918?fr=aladdin

1.創(chuàng)建數(shù)據(jù)庫

image.png

2.創(chuàng)建數(shù)據(jù)庫order表-執(zhí)行語句

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '下單用戶id',
  `number` varchar(32) NOT NULL COMMENT '訂單號(hào)',
  `createtime` date NOT NULL COMMENT '創(chuàng)建訂單時(shí)間',
  `note` varchar(100) DEFAULT NULL COMMENT '備注',
  PRIMARY KEY (`id`),
  KEY `FK_orders_1` (`user_id`),
  CONSTRAINT `FK_order_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

3.order表插入數(shù)據(jù)-執(zhí)行語句

INSERT INTO `order` VALUES ('3', '1', '1000010', '2015-02-04 13:22:35', null);
INSERT INTO `order` VALUES ('4', '1', '1000011', '2015-02-03 13:22:41', null);
INSERT INTO `order` VALUES ('5', '10', '1000012', '2015-02-12 16:13:23', null);

4.創(chuàng)建數(shù)據(jù)庫user表-執(zhí)行語句

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用戶名稱',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `sex` char(1) DEFAULT NULL COMMENT '性別',
  `address` varchar(256) DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

5.user表插入數(shù)據(jù)-執(zhí)行語句

INSERT INTO `user` VALUES ('1', '王五', null, '2', null);
INSERT INTO `user` VALUES ('10', '張三', '2014-07-10', '1', '北京市');
INSERT INTO `user` VALUES ('16', '張小明', null, '1', '河南鄭州');
INSERT INTO `user` VALUES ('22', '陳小明', null, '1', '河南鄭州');
INSERT INTO `user` VALUES ('24', '張三豐', null, '1', '河南鄭州');
INSERT INTO `user` VALUES ('25', '陳小明', null, '1', '河南鄭州');
INSERT INTO `user` VALUES ('26', '王五', null, null, null);

6.數(shù)據(jù)庫表執(zhí)行結(jié)果

7.Eclipse中創(chuàng)建Maven工程

image.png

8.添加compiler包

image.png

9.編輯pom.xml配置文件

image.png

10.創(chuàng)建model層User類

image.png

User類

package com.neuedu.mybatis1.model;

import java.util.Date;

public class User {
        private int id;
        private String username;
        private Date birthday;
        private String sex;
        private String address;
        public int getId() {
            return id;
        }
        public void setId(int id) {
            this.id = id;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public Date getBirthday() {
            return birthday;
        }
        public void setBirthday(Date birthday) {
            this.birthday = birthday;
        }
        public String getSex() {
            return sex;
        }
        public void setSex(String sex) {
            this.sex = sex;
        }
        public String getAddress() {
            return address;
        }
        public void setAddress(String address) {
            this.address = address;
        }
        @Override
        public String toString() {
            return "User [id=" + id + ", username=" + username + ", birthday=" + birthday + ", sex=" + sex
                    + ", address=" + address + "]";
        }       
}

11.增加mysql包

image.png

12.創(chuàng)建SqlMapConfig.xml文件

image.png

13.導(dǎo)入MyBatis包

image.png

14.編輯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(環(huán)境)-->
<configuration>
    <environments default="development">
    <!-- 運(yùn)行環(huán)境 -->
    <environment id="development">
    <!-- 事務(wù)管理器 -->
    <transactionManager type="JDBC" />
    <!-- 數(shù)據(jù)庫連接池 dataSource(數(shù)據(jù)源)  property(屬性) -->
    <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>
    <!-- 加載映射文件 -->
    <mappers>
        <!-- 加載User表的增刪改查等處理方法 -->
        <mapper resource="config/UserMapper.xml"/>
    </mappers>
</configuration>

15.創(chuàng)建config文件夾

config文件夾

16.創(chuàng)建log4j.properties日志文件

日志文件

17.編輯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
日志文件

18.在config文件夾內(nèi)創(chuàng)建UserMapper.xml文件

創(chuàng)建UserMapper.xml文件

19.編輯UserMapper.xml文件（重點(diǎn)）

  • 查詢方法
  • 增加方法
  • 刪除方法
  • 更新方法
<?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="user">
    <!-- parameterType:入?yún)㈩愋?-->
    <select id="getById" parameterType="int" resultType="com.neuedu.mybatis1.model.User">
        <!-- #{}:相當(dāng)于占位符? -->
        select * from user where id = #{id}
    </select>
    
    <!-- 根據(jù)用戶名做模糊查詢 -->
    <!-- resultType:集合中元素的類型 -->
    <select id="getByUserName" parameterType="String" resultType="com.neuedu.mybatis1.model.User">
        <!-- username參數(shù)的格式:%變量% -->
        <!-- select * from user where username like #{username} -->
        <!-- 拼接字符串${}，值必須是value -->
        select * from user where username like '%${value}%'
    </select>
    <!-- 插入 
    useGeneratedKeys="true"需要返回主鍵
    keyProperty="id"要把主鍵對(duì)應(yīng)的java對(duì)象的哪個(gè)屬性上(id)
    適用于主鍵自動(dòng)生成，比如mysql，主鍵自增
    -->
    <insert id="save" parameterType="com.neuedu.mybatis1.model.User"
    useGeneratedKeys="true" keyProperty="id">
        <!-- pojo對(duì)象的屬性值  #{屬性名} -->
        insert into user values(null,#{username},#{birthday},#{sex},#{address})
    </insert>
    
    <!-- 第二種方法，較為常用，因?yàn)閙ysql中的id大多數(shù)為自動(dòng)增長 -->
    <insert id="save2" parameterType="com.neuedu.mybatis1.model.User">
        <!-- order什么時(shí)候去執(zhí)行 ，兩種情況先執(zhí)行和后執(zhí)行-->
        <selectKey keyProperty="id" order="AFTER" resultType="int">
        <!-- 查詢主鍵 -->
            select max(id) from user
        </selectKey>
        
        insert into user values(null,#{username},#{birthday},#{sex},#{address})
    </insert>
    
    <!-- 刪除語句 -->
    <delete id="delete" parameterType="int">
        delete from user where id = #{id}
    </delete>
    <!-- 修改語句 -->
    <update id="update" parameterType="com.neuedu.mybatis1.model.User">
        update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id = #{id}
    </update>       
</mapper>

20.創(chuàng)建junit包

創(chuàng)建junit包

22.新建SessionFactoryUtil類

image.png

23.編輯SessionFactoryUtil文件

  • 重點(diǎn):單例模式
package com.neuedu.mybatis1.utils;

import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class SessionFactoryUtil {
    //SqlSessionFactory是一個(gè)單例模式
    //取得一個(gè)單例的SqlSessionFactory
    public static SqlSessionFactory sf = null;
    //靜態(tài)代碼塊---加載類的時(shí)候執(zhí)行的靜態(tài)代碼塊
    static{
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        InputStream is = null;
        try {
            is = Resources.getResourceAsStream("sqlMapConfig.xml");
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        sf = builder.build(is);
    }
    public static SqlSessionFactory getSqlSessionFactory(){
        return sf;  
    }   
}

24.創(chuàng)建junit類型的文件UTest

image.png

25.編輯UTest文件

  • 重點(diǎn)：方法名上方必須加@Test
  • 創(chuàng)建SessionFactoryUtil文件之后，使用單例模式，在UTest里可以直接調(diào)用
  • SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
  • SqlSession sqlSession = factory.openSession();
  • 注意最后需要進(jìn)行提交事務(wù)和關(guān)閉
  • sqlSession.commit(); 提交事務(wù)
  • sqlSession.close();關(guān)閉
package test;
import java.io.IOException;
import java.util.Date;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;

import com.neuedu.mybatis1.model.User;
import com.neuedu.mybatis1.utils.SessionFactoryUtil;

public class UTest {

    @Test
    //保存測試用例：根據(jù)用戶ID查詢
    public void testGetById() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
            //從工廠中創(chuàng)建連接
            SqlSession sqlSession = factory.openSession();
            User user = sqlSession.selectOne("user.getById",1);
            System.out.println(user);
            sqlSession.close();

}
    @Test
    public void testGetByUserName() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        //從工廠中創(chuàng)建連接
        SqlSession sqlSession = factory.openSession();
        List<User> list = sqlSession.selectList("user.getByUserName","小");
        //關(guān)閉連接資源(放到連接池中)
        for(User u:list)
        System.out.println(u);
        sqlSession.close();
}
    
    @Test
    public void testsave() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        //從工廠中創(chuàng)建連接
        SqlSession sqlSession = factory.openSession();
        User user = new User();
        user.setUsername("小王");
        user.setBirthday(new Date());
        user.setSex("男");
        user.setAddress("遼寧鐵嶺");
        sqlSession.insert("user.save",user);
        //提交事務(wù)，默認(rèn)是不提交       
        sqlSession.commit();
        System.out.println(user);
        sqlSession.close();
}
    
    @Test
    public void testsave2() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        //從工廠中創(chuàng)建連接
        SqlSession sqlSession = factory.openSession();
        User user = new User();
        user.setUsername("小王");
        user.setBirthday(new Date());
        user.setSex("男");
        user.setAddress("遼寧鐵嶺");
        sqlSession.insert("user.save2",user);       
        //提交事務(wù)，默認(rèn)是不提交
        sqlSession.commit();
        System.out.println(user);
        sqlSession.close();
}
    @Test
    public void testdelete() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        SqlSession sqlSession = factory.openSession();
        sqlSession.delete("user.delete",43);
        sqlSession.commit();
        sqlSession.close();
}
    @Test
    public void testupdate() throws IOException {
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        //從工廠中創(chuàng)建連接
        SqlSession sqlSession = factory.openSession();
        User user = sqlSession.selectOne("user.getById",24);
        user.setUsername("小李");
        user.setBirthday(new Date());
        user.setSex("男");
        user.setAddress("遼寧沈陽");
        sqlSession.update("user.update",user);      
        //提交事務(wù)，默認(rèn)是不提交
        sqlSession.commit();
        sqlSession.close();
}
}

26.創(chuàng)建OrderMapper.xml文件，編輯OrderMapper.xml文件。創(chuàng)建OTest文件，編輯OTest文件。在SqlMapConfig.xml添加xml文件路徑(原理同User)

  • 注意：因?yàn)镺rder是在數(shù)據(jù)庫中是關(guān)鍵字(Order by)，所以在進(jìn)行查詢數(shù)據(jù)庫中的order表時(shí)，應(yīng)該將order加上單引號(hào)，注意是鍵盤Tab鍵的上方的單引號(hào)
  • OrderMapper.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="or">
    
    <!-- 根據(jù)id查詢用戶信息 -->
    <select id="select" parameterType="int" resultType="com.neuedu.mybatis1.model.Order">
        select * from `order` where id = #{id}
    </select>
    
    <!-- 根據(jù)user_id查詢用戶信息集合 -->
    <select id="selectList" parameterType="int" resultType="com.neuedu.mybatis1.model.Order">
        select * from `order` where user_id = #{user_id}
    </select>

    <!-- 插入 -->
    <insert id="insert" parameterType="com.neuedu.mybatis1.model.Order">
        <selectKey keyProperty="id" order="AFTER" resultType="int">
            select max(id) from `order`
        </selectKey>    
        insert into `order` values(null,#{user_id},#{number},#{createtime},#{note})
    </insert>
    
    <!-- 刪除語句 -->
    <delete id="delete" parameterType="int">
        delete from `order` where id = #{id}
    </delete>
    <!-- 修改語句 -->
    <update id="update" parameterType="com.neuedu.mybatis1.model.Order">
        update `order` set user_id=#{user_id},number=#{number},createtime=#{createtime},note=#{note} where id = #{id}
    </update>       
</mapper>
  • OTest
package test;

import java.io.IOException;
import java.util.Date;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;
import com.neuedu.mybatis1.model.Order;
import com.neuedu.mybatis1.utils.SessionFactoryUtil;

public class OTest {
    
    //增
    @Test
    public void insert() throws IOException{
        //1.調(diào)用uil
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        //2.創(chuàng)建連接
        SqlSession sqlSession = factory.openSession();      
        //3.創(chuàng)建對(duì)象
        Order order = new Order();      
        //4.放入值
        order.setUser_id(10);
        order.setNumber("101101");
        order.setCreatetime(new Date());
        order.setNote("2544");
        //5.調(diào)用方法
        sqlSession.insert("or.insert",order);
        //6.提交
        sqlSession.commit();
        //7.關(guān)閉
        sqlSession.close();
    }
    
    //刪
    @Test
    public void delete() throws IOException{
    SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
    SqlSession sqlSession = factory.openSession();
    sqlSession.delete("or.delete",3);
    sqlSession.commit();
    sqlSession.close(); 
    }
    
    //改
    @Test
    public void update() throws IOException{
    SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
    SqlSession sqlSession = factory.openSession();
    Order order = sqlSession.selectOne("or.select",4);
    order.setUser_id(26);
    order.setNumber("10145401");
    order.setCreatetime(new Date());
    order.setNote("2554");
    //5.調(diào)用方法
    sqlSession.update("or.update",order);
    //6.提交
    sqlSession.commit();
    //7.關(guān)閉
    sqlSession.close();
    }
    
    //查
    @Test
    public void select() throws IOException{
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        SqlSession sqlSession = factory.openSession();
        Order order = sqlSession.selectOne("or.select",4);
        System.out.println(order);
        sqlSession.close(); 
        }
    
    @Test
    //根據(jù)user_id查集合
    public void selectList() throws IOException{
        SqlSessionFactory factory = SessionFactoryUtil.getSqlSessionFactory();
        SqlSession sqlSession = factory.openSession();
        List<Order> list = sqlSession.selectList("or.selectList",10);
        for(Order o:list){
        System.out.println(o);
        }
        sqlSession.close(); 
        }
    }
  • 在SqlMapConfig.xml新增xml文件路徑
</environments>
    <!-- 加載映射文件 -->
    <mappers>
        <!-- 加載User表的增刪改查等處理方法 -->
        <mapper resource="config/UserMapper.xml"/>
        <mapper resource="config/OrderMapper.xml"/>
    </mappers>
</configuration>
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時(shí)請(qǐng)結(jié)合常識(shí)與多方信息審慎甄別。
平臺(tái)聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡書系信息發(fā)布平臺(tái)，僅提供信息存儲(chǔ)服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容