栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

什么是MyBatis框架 第一节

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

什么是MyBatis框架 第一节

1.简绍Mybatis框架

什么是框架:框架就是别人搭建好的某些功能,你只需要引用该框架并加入自己的业务代码。

好处: 提高我们的开发效率。

mybatis的介绍:

MyBatis 是一款优秀的持久层Dao框架,它支持定制化 SQL、存储过程以及高级映射。

MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。

MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息,将接口和 Java 的 POJOs(Java实体类)映射成数据库中的记录。

MyBatis会将输入参数,输出结果进行映射。

2.我们为什么要用MyBatis框架

可以简化jdbc的操作以及占位符赋值以及查询结果集的封装。

3.使用MyBatis 3.1.引入MyBatis和Mysql的jar包


    org.mybatis
    mybatis
    3.4.6



    mysql
    mysql-connector-java
    8.0.28
3.2.创建MyBatis的配置文件

        

    
    
        
        
        
        
    
    
        
            
            
            
                
                
                
                
            
        
    
3.3.创建数据库和表
CREATE TABLE `t_student`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生表的主键列',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `t_student` VALUES (1, '张三', 18, '北京');
INSERT INTO `t_student` VALUES (2, '李四', 19, '北京');
INSERT INTO `t_student` VALUES (4, '钱七', 19, '北京');
INSERT INTO `t_student` VALUES (5, '关羽', 25, '南京');
INSERT INTO `t_student` VALUES (6, '张飞', 25, '南京');
INSERT INTO `t_student` VALUES (7, '赵云', 28, '南京');
INSERT INTO `t_student` VALUES (8, '项羽', 19, '南京');
INSERT INTO `t_student` VALUES (9, '刘备', 30, '上海');
INSERT INTO `t_student` VALUES (10, '曹操', 40, '许昌');
INSERT INTO `t_student` VALUES (11, '夏侯', 36, '许昌');
INSERT INTO `t_student` VALUES (12, '诸葛亮', 38, '上海');
INSERT INTO `t_student` VALUES (13, '周瑜', 78, '江东');
INSERT INTO `t_student` VALUES (14, '小乔', 56, '江东');
INSERT INTO `t_student` VALUES (15, '孙尚香', 59, '江东');
3.4.创建实体类 跟添加lombok
@Data //set和get方法以及toString方法
@NoArgsConstructor //无参构造方法
@AllArgsConstructor //所有参数的构造方法
public class User {
    private int userid;
    private String username;
    private String realname;
}
3.5.创建MyBatis和数据库的映射文件 并实现 增删改查 应用

作用:映射实体和表之间的映射关系。



        
        
        
        
        
                select * from t_student
        
        
3.6.注意:一定要把映射文件注册到配置文件上 mybatis.xml 上

mybatis.xml


        

    
    
        
        
        
        
    
    
        
            
            
            
                
                
                
                
            
        
    
    
    
        
    

3.7.测试 增删改查 mybatis
package com.test;
import com.wzl.entity.Student;
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;
import java.io.FileReader;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
public class Test01 {
    @Test
    public void testFindById() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = session.selectOne("qy151.student001.findById",6);
        System.out.println(student);
        session.close();
    }
    @Test
    public void testAdd() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = new Student();
        student.setName("数码宝贝");
        student.setAge(15);
        student.setAddress("天津");
        int row = session.insert("qy151.student001.add",student);
        System.out.println(row);
        session.commit();
        session.close();
    }
    @Test
    public void testDelete() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        int dele = session.delete("qy151.student001.delete",85);
        System.out.println(dele);
        session.commit();
        session.close();
    }
    @Test
    public void testUpdate() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = new Student(83,"小明",18,"北京");
        int upda = session.update("qy151.student001.update",student);
        System.out.println(upda);
        session.commit();
        session.close();
    }
    @Test
    public void testFindAll() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        List students = session.selectList("qy151.student001.findAll");
        System.out.println(students);
        session.commit();
        session.close();
    }
}

4.LomBok插件

它可以帮你生成实体类的get和set方法 而且可以帮你生成构造方法。重写toString方法

(1) idea安装lombok插件---

 (2) 工程中引入lombok依赖


        
            org.projectlombok
            lombok
            1.18.24
        

(3)在实体类上添加lombok注解

@Data //set和get方法以及toString方法
@NoArgsConstructor //无参构造方法
@AllArgsConstructor //所有参数的构造方法
public class User {
    private int userid;
    private String username;
    private String realname;
}
5. 使用mybatis完成crud
package com.test;
import com.wzl.entity.Student;
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;
import java.io.FileReader;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
public class Test01 {
    @Test
    public void testFindById() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = session.selectOne("qy151.student001.findById",6);
        System.out.println(student);
        session.close();
    }
    @Test
    public void testAdd() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = new Student();
        student.setName("数码宝贝");
        student.setAge(15);
        student.setAddress("天津");
        int row = session.insert("qy151.student001.add",student);
        System.out.println(row);
        session.commit();
        session.close();
    }
    @Test
    public void testDelete() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        int dele = session.delete("qy151.student001.delete",85);
        System.out.println(dele);
        session.commit();
        session.close();
    }
    @Test
    public void testUpdate() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        Student student = new Student(83,"小明",18,"北京");
        int upda = session.update("qy151.student001.update",student);
        System.out.println(upda);
        session.commit();
        session.close();
    }
    @Test
    public void testFindAll() throws IOException {
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession();
        List students = session.selectList("qy151.student001.findAll");
        System.out.println(students);
        session.commit();
        session.close();
    }
}

6.mybatis一些优化

        mybatis.xml配置文件




    
    
        
    
    
        
            
            
            
                
                
                
                
            
        
    
    
        
    

 7.添加sql日志

        (1)添加日志的jar.



    4.0.0
    com.wzl
    mybatis-02
    1.0-SNAPSHOT
    
        8
        8
    
    
    
        
            org.mybatis
            mybatis
            3.4.6
        
        
        
            mysql
            mysql-connector-java
            8.0.28
        
        
        
            org.projectlombok
            lombok
            1.18.24
        
        
        
            junit
            junit
            4.12
        
        
        
            log4j
            log4j
            1.2.17
        
        
            org.projectlombok
            lombok
            RELEASE
            compile
        
    

(2) 添加日志的文件配置--log4j.properties必须

log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

详细日志:

#将等级为DEBUG的日志信息输出到console和file这两个目的地,console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file

#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n

#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=D:/qy151/log/qy151.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n

#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/957458.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号