• MyBatis入门

    目录

            一，MyBatis简介

    二，MyBatis环境搭建

    三，Mybatis generator插件使用步骤

    四，基于ssm逆向工程的使用

    五，案例

    一，MyBatis简介

            是一款半自动的ORM持久层框架，具有较高的SQL灵活性，支持高级映射（一对一，一对多），动态SQL,延迟加载和缓存等特性，即对象映射关系框架；
    是一款关于数据库层面的框架，数据库无关性较低

    二，MyBatis环境搭建

           2.1 创建maven工程

            点击当前项目右键new一个module 

     左侧选择Maven 勾选上方的框，在下方随意点击一行输入webapp再用ctrl+下快捷键找到该行

     命名：

     点击加号输入内容，注意不要输错

     出现该字符提示即表示创建成功

     2.2 配置相关的pom依赖

    1. "1.0" encoding="UTF-8"?>
    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>pro_maven_01artifactId>
    9.   <version>1.0-SNAPSHOTversion>
    10.   <packaging>warpackaging>
    11.  
    12.   <name>pro_maven_01 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.   <build>
    75.     <resources>
    76.       
    77.       <resource>
    78.         <directory>src/main/javadirectory>
    79.         <includes>
    80.           <include>**/*.xmlinclude>
    81.         includes>
    82.       resource>
    83.       
    84.       <resource>
    85.         <directory>src/main/resourcesdirectory>
    86.         <includes>
    87.           <include>jdbc.propertiesinclude>
    88.           <include>*.xmlinclude>
    89.         includes>
    90.       resource>
    91.     resources>
    92.  
    93.     <finalName>pro_maven_01finalName>
    94.     <pluginManagement>
    95.       <plugins>
    96.         <plugin>
    97.           <groupId>org.mybatis.generatorgroupId>
    98.           <artifactId>mybatis-generator-maven-pluginartifactId>
    99.           <version>1.3.2version>
    100.           <dependencies>
    101.             
    102.             <dependency>
    103.               <groupId>mysqlgroupId>
    104.               <artifactId>mysql-connector-javaartifactId>
    105.               <version>5.1.44version>
    106.             dependency>
    107.           dependencies>
    108.           <configuration>
    109.             <overwrite>trueoverwrite>
    110.           configuration>
    111.         plugin>
    112.         <plugin>
    113.           <artifactId>maven-clean-pluginartifactId>
    114.           <version>3.1.0version>
    115.         plugin>
    116.         
    117.         <plugin>
    118.           <artifactId>maven-resources-pluginartifactId>
    119.           <version>3.0.2version>
    120.         plugin>
    121.         <plugin>
    122.           <artifactId>maven-compiler-pluginartifactId>
    123.           <version>3.8.0version>
    124.         plugin>
    125.         <plugin>
    126.           <artifactId>maven-surefire-pluginartifactId>
    127.           <version>2.22.1version>
    128.         plugin>
    129.         <plugin>
    130.           <artifactId>maven-war-pluginartifactId>
    131.           <version>3.2.2version>
    132.         plugin>
    133.         <plugin>
    134.           <artifactId>maven-install-pluginartifactId>
    135.           <version>2.5.2version>
    136.         plugin>
    137.         <plugin>
    138.           <artifactId>maven-deploy-pluginartifactId>
    139.           <version>2.8.2version>
    140.         plugin>
    141.       plugins>
    142.     pluginManagement>
    143.   build>
    144. project>

     更改web.xml

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

     作为一个数据库层面的框架，必定少不了连接数据库

       jdbc.properties文件:

    三，Mybatis generator插件使用步骤

    1.先将该图中的插件下载好，Plugins-->Marketplace 文本框中搜索关键字

     2.配置mybatis的配置文件

    1. "1.0" encoding="UTF-8"?>
    2. DOCTYPE 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.         <typeAlias type="com.zhw.model.Book" alias="Book"/>
    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/zhw/mapper/BookMapper.xml"/>
    40.     mappers>
    41. configuration>

    四，基于ssm逆向工程的使用

      1.安装插件

       上图中的mybatis generator 就是的

       2、配置xml

    1. "1.0" encoding="UTF-8" ?>
    2. DOCTYPE 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="D:\\Software\\apache-maven-3.5.0-bin\\apache-maven-3.5.0-bin\\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.zhw.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.zhw.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.zhw.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.             
    88.             
    89.             
    90.             
    91.         table>
    92.  
    93.  
    94.     context>
    95. generatorConfiguration>

      3、配置maven运行generator命令 

     

    选择需要生成的数据库中的表名：

     配置完成后，点击运行生成dao方法和实体类

     ​​​​​​​

     

     五，案例

     SessionUtil

    1. package com.ljj.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.  * @author ljj
    9.  * @create  2022-08-10 22:10
    10.  */
    11. public class SessionUtil {
    12.     private static SqlSessionFactory sessionFactory;
    13.     private static ThreadLocal threadLocal = new ThreadLocal();
    14.     static {
    15.         sessionFactory = new SqlSessionFactoryBuilder().build(SessionUtil.class.getResourceAsStream("/mybatis.cfg.xml"));
    16.     }
    17.  
    18.     public static SqlSession openSession() {
    19.         SqlSession session = threadLocal.get();
    20.         if (null == session) {
    21.             session = sessionFactory.openSession();
    22.             threadLocal.set(session);
    23.         }
    24.         return session;
    25.     }
    26.  
    27.     public static void main(String[] args) {
    28.         SqlSession session = openSession();
    29.         System.out.println(session.getConnection());
    30.         session.close();
    31. //        System.out.println(session.getConnection());
    32.     }
    33. }

    BookBiz 

    1. package com.ljj.service;
    2.  
    3. import com.ljj.model.Book;
    4.  
    5. /**
    6.  * @author ljj
    7.  * @create  2022-08-10 23:12
    8.  */
    9. public interface BookBiz {
    10.     int deleteByPrimaryKey(Integer bid);
    11.  
    12.     Book selectByPrimaryKey(Integer bid);
    13. }

    log4j.xml

    1. "1.0" encoding="UTF-8"?>
    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>

  • 相关阅读:
    【JavaScript总结】js基础知识点
    Java向上向下转型
    Android拖放startDragAndDrop拖拽Glide灵活加载堆叠圆角图，Kotlin（6）
    【MQTT】Javascript通过WebSocket连接MQTT
    vue 简介 （MVVM介绍，超详细）
    基于JAVA景区售票系统设计与实现 开题报告
    [山东科技大学OJ]2414 Problem G: 倒排字符串
    低代码平台
    SQLSERVER 查询阻塞SQL以及锁
    Java EE——网络层IP协议的格式与内容解析
  • 原文地址：https://blog.csdn.net/weixin_64313980/article/details/126277171