• mybatis入门

    目录

    一、mybatis简介

    二、mybatis环境搭建

    1.导入pom依赖

    2.导入框架的配置文件

    三、基于ssm逆向工程的使用

    四、mybatis增删改查测试

    mybatis的测试：

    一、mybatis简介

    MyBatis是一款优秀的（ORM）持久层框架，即对象映射关系框架，是一款关于数据库层面的框架。它支持自定义 SQL、存储过程以及高级映射。

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

    MyBatis 可以通过简单的XML或注解来配置和映射原始类型、接口和Java POJO (Plain Old Java Objects，普通老式Java对象) 为数据库中的记录。

    二、mybatis环境搭建

    1.导入pom依赖

    2.  
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.   <modelVersion>4.0.0modelVersion>
    6.  
    7.   <groupId>org.examplegroupId>
    8.   <artifactId>mybatis01artifactId>
    9.   <version>1.0-SNAPSHOTversion>
    10.   <packaging>warpackaging>
    11.  
    12.   <name>mybatis01 Maven Webappname>
    13.   
    14.   <url>http://www.example.comurl>
    15.  
    16.   <properties>
    17.     <maven.compiler.source>1.8maven.compiler.source>
    18.     <maven.compiler.target>1.8maven.compiler.target>
    19.   properties>
    20.  
    21.   <dependencies>
    22.     
    23.     <dependency>
    24.       <groupId>junitgroupId>
    25.       <artifactId>junitartifactId>
    26.       <version>4.12version>
    27.       <scope>testscope>
    28.     dependency>
    29.  
    30.     
    31.     <dependency>
    32.       <groupId>javax.servletgroupId>
    33.       <artifactId>javax.servlet-apiartifactId>
    34.       <version>4.0.0version>
    35.       <scope>providedscope>
    36.     dependency>
    37.  
    38.     
    39.     <dependency>
    40.       <groupId>org.mybatisgroupId>
    41.       <artifactId>mybatisartifactId>
    42.       <version>3.4.5version>
    43.     dependency>
    44.  
    45.     
    46.     <dependency>
    47.       <groupId>mysqlgroupId>
    48.       <artifactId>mysql-connector-javaartifactId>
    49.       <version>5.1.44version>
    50.     dependency>
    51.  
    52.     
    53.     
    54.     
    55.     
    56.     <dependency>
    57.       <groupId>org.apache.logging.log4jgroupId>
    58.       <artifactId>log4j-coreartifactId>
    59.       <version>2.9.1version>
    60.     dependency>
    61.     <dependency>
    62.       <groupId>org.apache.logging.log4jgroupId>
    63.       <artifactId>log4j-apiartifactId>
    64.       <version>2.9.1version>
    65.     dependency>
    66.     
    67.     <dependency>
    68.       <groupId>org.apache.logging.log4jgroupId>
    69.       <artifactId>log4j-webartifactId>
    70.       <version>2.9.1version>
    71.     dependency>
    72.   dependencies>
    73.  
    74.  
    75.   <build>
    76.     <finalName>mybatis01finalName>
    77.     <resources>
    78.       
    79.       <resource>
    80.         <directory>src/main/javadirectory>
    81.         <includes>
    82.           <include>**/*.xmlinclude>
    83.         includes>
    84.       resource>
    85.       
    86.       <resource>
    87.         <directory>src/main/resourcesdirectory>
    88.         <includes>
    89.           <include>jdbc.propertiesinclude>
    90.           <include>*.xmlinclude>
    91.         includes>
    92.       resource>
    93.     resources>
    94.  
    95.     <pluginManagement>
    96.       <plugins>
    97.         <plugin>
    98.           <groupId>org.mybatis.generatorgroupId>
    99.           <artifactId>mybatis-generator-maven-pluginartifactId>
    100.           <version>1.3.2version>
    101.           <dependencies>
    102.             
    103.             <dependency>
    104.               <groupId>mysqlgroupId>
    105.               <artifactId>mysql-connector-javaartifactId>
    106.               <version>5.1.44version>
    107.             dependency>
    108.           dependencies>
    109.           <configuration>
    110.             <overwrite>trueoverwrite>
    111.           configuration>
    112.         plugin>
    113.  
    114.         <plugin>
    115.           <artifactId>maven-clean-pluginartifactId>
    116.           <version>3.1.0version>
    117.         plugin>
    118.         
    119.         <plugin>
    120.           <artifactId>maven-resources-pluginartifactId>
    121.           <version>3.0.2version>
    122.         plugin>
    123.         <plugin>
    124.           <artifactId>maven-compiler-pluginartifactId>
    125.           <version>3.8.0version>
    126.         plugin>
    127.         <plugin>
    128.           <artifactId>maven-surefire-pluginartifactId>
    129.           <version>2.22.1version>
    130.         plugin>
    131.         <plugin>
    132.           <artifactId>maven-war-pluginartifactId>
    133.           <version>3.2.2version>
    134.         plugin>
    135.         <plugin>
    136.           <artifactId>maven-install-pluginartifactId>
    137.           <version>2.5.2version>
    138.         plugin>
    139.         <plugin>
    140.           <artifactId>maven-deploy-pluginartifactId>
    141.           <version>2.8.2version>
    142.         plugin>
    143.       plugins>
    144.     pluginManagement>
    145.   build>
    146. project>

    jdbc.properties 

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    3. jdbc.username=root
    4. jdbc.password=123456

    web.xml

    1. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    2.  
    3.  
    4.  
    5.      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    6.  
    7.  
    8.  
    9.      xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
    10.  
    11.  
    12.  
    13.      version="3.1">web-app>

     

    2.导入框架的配置文件

    安装以下插件

    Free mybatis plugin

    Mybatis generator

    mybatis tools

    maven helper mybatis.cfg.xml

    2. configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    3. <configuration>
    4.     
    5.     <properties resource="jdbc.properties"/>
    6.  
    7.     <settings>
    8.         <setting name="logImpl" value="LOG4J2"/>
    9.     settings>
    10.  
    11.     
    12.     <typeAliases>
    13.         
    14.     typeAliases>
    15.  
    16.  
    17.     
    18.     <environments default="development">
    19.         <environment id="development">
    20.             
    21.             <transactionManager type="jdbc"/>
    22.  
    23.             
    24.             
    25.             
    26.             
    27.             <dataSource type="POOLED">
    28.                 <property name="driver"
    29.                           value="${jdbc.driver}"/>
    30.                 <property name="url"
    31.                           value="${jdbc.url}"/>
    32.                 <property name="username" value="${jdbc.username}"/>
    33.                 <property name="password" value="${jdbc.password}"/>
    34.             dataSource>
    35.         environment>
    36.     environments>
    37.  
    38.     <mappers>
    39.         <mapper resource="com/javaxl/mapper/BookMapper.xml"/>
    40.     mappers>
    41. configuration>

    三、基于ssm逆向工程的使用

    mybatis generator插件的使用

    安装Mybatis generator插件

     点击setting

    找到Plugins，搜索下载即可 

    配置generatorConfig.xml

    修改5.1.44的jar的路径
    修改实体类生成地址
    修改SQL对应的配置文件的生成地址
    修改dao层代码生成地址
    指定需要生成增删改查代码对应的表 

    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.     <classPathEntry location="F:\\Maven\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    10.  
    11.     
    12.     <context id="infoGuardian">
    13.         
    14.         <commentGenerator>
    15.             <property name="suppressAllComments" value="true"/>
    16.             <property name="suppressDate" value="true"/> 
    17.         commentGenerator>
    18.  
    19.         
    20.         <jdbcConnection driverClass="${jdbc.driver}"
    21.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    22.  
    23.         
    24.         <javaTypeResolver>
    25.             
    26.             <property name="forceBigDecimals" value="false"/>
    27.         javaTypeResolver>
    28.  
    29.         
    30.         
    31.         
    32.         <javaModelGenerator targetPackage="com.maomao.model"
    33.                             targetProject="src/main/java">
    34.             
    35.             <property name="enableSubPackages" value="false"/>
    36.             
    37.             <property name="constructorBased" value="true"/>
    38.             
    39.             <property name="trimStrings" value="false"/>
    40.             
    41.             <property name="immutable" value="false"/>
    42.         javaModelGenerator>
    43.  
    44.         
    45.         <sqlMapGenerator targetPackage="com.maomao.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.mm.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             <property name="enableSubPackages" value="false"/>
    59.         javaClientGenerator>
    60.  
    61.         
    62.         
    63.         
    64.         
    65.         
    66.         
    67.         
    68.         
    69.         
    70.         
    71.         
    72.         
    73.         
    74.  
    75.         <table schema="" tableName="t_mvc_Book" domainObjectName="Book"
    76.                enableCountByExample="false" enableDeleteByExample="false"
    77.                enableSelectByExample="false" enableUpdateByExample="false">
    78.             
    79.             
    80.             
    81.             
    82.         table>
    83.  
    84.         <table schema="" tableName="t_oa_permission" domainObjectName="Permission"
    85.                enableCountByExample="false" enableDeleteByExample="false"
    86.                enableSelectByExample="false" enableUpdateByExample="false">
    87.         table>
    88.  
    89.     context>
    90. generatorConfiguration>

     配置maven运行generator命令

    点击+，选中Maven

     

    选择项目

     

     在pom文件中使用配置好的命令

     

    四、mybatis增删改查测试

    SessionUtil.java

    1. package com.zking.util;
    2.  
    3. import org.apache.ibatis.session.SqlSession;
    4. import org.apache.ibatis.session.SqlSessionFactory;
    5. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    6.  
    7.  
    8. public class SessionUtil {
    9.     private static SqlSessionFactory sessionFactory;
    10.     private static ThreadLocal threadLocal = new ThreadLocal();
    11.     static {
    12.         sessionFactory = new SqlSessionFactoryBuilder().build(SessionUtil.class.getResourceAsStream("/mybatis.cfg.xml"));
    13.     }
    14.  
    15.     public static SqlSession openSession() {
    16.         SqlSession session = threadLocal.get();
    17.         if (null == session) {
    18.             session = sessionFactory.openSession();
    19.             threadLocal.set(session);
    20.         }
    21.         return session;
    22.     }
    23.  
    24.     public static void main(String[] args) {
    25.         SqlSession session = openSession();
    26.         System.out.println(session.getConnection());
    27.         session.close();
    28. //        System.out.println(session.getConnection());
    29.     }
    30. }

     BookBiz.java

    1. package com.zking.biz;
    2.  
    3. import com.zking.model.Book;
    4.  
    5.  
    6. public interface BookBiz {
    7.  
    8.     int deleteByPrimaryKey(Integer bid);
    9.  
    10.  
    11.     Book selectByPrimaryKey(Integer bid);
    12.  
    13.  
    14. }

    BookBizImpl.java

    1. package com.zking.biz.impl;
    2.  
    3. import com.zking.model.Book;
    4. import com.zking.mapper.BookMapper;
    5. import com.zking.biz.BookBiz;
    6.  
    7.  
    8. public class BookBizImpl implements BookBiz {
    9.     private BookMapper bookMapper;
    10.  
    11.     //alt+insert  快速提供set/get/toString/构造方法
    12.     //alt+enter  快速构建实现类，填充代码的前半部分  Ctrl+1
    13.     public BookMapper getBookMapper() {
    14.         return bookMapper;
    15.     }
    16.  
    17.     public void setBookMapper(BookMapper bookMapper) {
    18.         this.bookMapper = bookMapper;
    19.     }
    20.  
    21.     @Override
    22.     public int deleteByPrimaryKey(Integer bid) {
    23.         return bookMapper.deleteByPrimaryKey(bid);
    24.     }
    25.  
    26.     @Override
    27.     public Book selectByPrimaryKey(Integer bid) {
    28.         return bookMapper.selectByPrimaryKey(bid);
    29.     }
    30. }

     log4j2.xml

    2.  
    4. <Configuration status="WARN" monitorInterval="30">
    5.     <Properties>
    6.         
    7.         <Property name="LOG_HOME">/root/workspace/lucenedemo/logsProperty>
    8.         <property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/errorproperty>
    9.         <property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warnproperty>
    10.         <property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%nproperty>
    11.     Properties>
    12.  
    13.     <Appenders>
    14.         
    15.         <Console name="Console" target="SYSTEM_OUT">
    16.             
    17.             <ThresholdFilter level="trace" onMatch="ACCEPT"
    18.                              onMismatch="DENY" />
    19.             
    20.             
    21.             <PatternLayout pattern="${PATTERN}" />
    22.         Console>
    23.  
    24.         
    25.         
    26.         <File name="log" fileName="logs/test.log" append="false">
    27.             <PatternLayout
    28.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    29.         File>
    30.         
    31.         <RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
    32.                      filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
    33.             
    34.             <ThresholdFilter level="info" onMatch="ACCEPT"
    35.                              onMismatch="DENY" />
    36.             <PatternLayout
    37.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    38.             <Policies>
    39.                 
    40.                 
    41.                 
    42.                 <TimeBasedTriggeringPolicy interval="1"
    43.                                            modulate="true" />
    44.                 
    45.                 
    46.             Policies>
    47.         RollingFile>
    48.  
    49.         <RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
    50.                      filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
    51.             <ThresholdFilter level="warn" onMatch="ACCEPT"
    52.                              onMismatch="DENY" />
    53.             <PatternLayout
    54.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    55.             <Policies>
    56.                 <TimeBasedTriggeringPolicy />
    57.                 <SizeBasedTriggeringPolicy size="2 kB" />
    58.             Policies>
    59.             
    60.             <DefaultRolloverStrategy max="20" />
    61.         RollingFile>
    62.  
    63.         <RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
    64.                      filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
    65.             <ThresholdFilter level="error" onMatch="ACCEPT"
    66.                              onMismatch="DENY" />
    67.             <PatternLayout
    68.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    69.             <Policies>
    70.                 
    71.                 <TimeBasedTriggeringPolicy interval="1"
    72.                                            modulate="true" />
    73.                 
    74.             Policies>
    75.         RollingFile>
    76.  
    77.     Appenders>
    78.  
    79.     
    80.     <Loggers>
    81.         
    82.         <logger name="org.springframework" level="INFO">logger>
    83.         <logger name="org.mybatis" level="INFO">logger>
    84.  
    85.         
    86.         <logger name="org.springframework" level="ERROR" />
    87.         <logger name="org.hibernate" level="ERROR" />
    88.         <logger name="org.apache.struts2" level="ERROR" />
    89.         <logger name="com.opensymphony.xwork2" level="ERROR" />
    90.         <logger name="org.jboss" level="ERROR" />
    91.  
    92.  
    93.         
    94.         <root level="all">
    95.             <appender-ref ref="Console" />
    96.             <appender-ref ref="RollingFileInfo" />
    97.             <appender-ref ref="RollingFileWarn" />
    98.             <appender-ref ref="RollingFileError" />
    99.         root>
    100.  
    101.     Loggers>
    102.  
    103. Configuration>

    BookBizImplTest.java

    1. package com.zking.biz.impl;
    2.  
    3. import com.zking.mapper.BookMapper;
    4. import com.zking.util.SessionUtil;
    5. import org.apache.ibatis.session.SqlSession;
    6. import org.junit.After;
    7. import org.junit.Before;
    8. import org.junit.Test;
    9.  
    10. public class BookBizImplTest {
    11.     private BookBizImpl bookBiz;
    12.     private SqlSession sqlSession;
    13.  
    14.     @Before
    15.     public void setUp() throws Exception {
    16.         System.out.println("初始化方法...");
    17.         BookBizImpl bookBiz = new BookBizImpl();
    18. //        从工具类中获取session对象
    19.         sqlSession = SessionUtil.openSession();
    20. //        从session对象中获取mapper对象
    21.         BookMapper mapper = sqlSession.getMapper(BookMapper.class);
    22.          bookBiz.setBookMapper(mapper);
    23.          this.bookBiz=bookBiz;
    24.  
    25.     }
    26.  
    27.     @After
    28.     public void tearDown() throws Exception {
    29.         System.out.println("方法测试结束...");
    30.         sqlSession.commit();
    31.         sqlSession.close();
    32.     }
    33.  
    34.     @Test
    35.     public void deleteByPrimaryKey() {
    36.        bookBiz.deleteByPrimaryKey(bid:44);
    37.     }
    38.  
    39.     @Test
    40.     public void selectByPrimaryKey() {
    41.         System.out.println("测试的业务方法...");
    42. //        System.out.println(bookBiz.getBookMapper());
    43.         System.out.println( bookBiz.selectByPrimaryKey(44));
    44.  
    45.  
    46.     }
    47. }

    mybatis的测试：

    1、日志框架的集成的作用：排查定位问题

    2、对于ORM(hibernate/Mybatis/JPA/MP)框架，都需要注意事务问题

     

  • 相关阅读:
    十个比较有用的linux命令
    【HarmonyOS】遇见的问题汇总
    HTML1:html基础
    python数据分析—删除value=0的行
    woocommerce对接paypal如何进行沙盒测试？
    Docker通过Dockerfile创建Redis、Nginx--详细过程
    从浅入深掌握并发执行框架Executor
    Schema_CN28_XRR0追溯运行/反算
    温控仪的工作原理
    Java+SpringBoot+Vue+MySQL：美食推荐系统的技术革新
  • 原文地址：https://blog.csdn.net/qq_44247968/article/details/126276974