Mybatis入门

搭建mybatis框架环境

1、创建maven工程

2、导入相关pom依赖

  1 <?xml version="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.0</modelVersion>
  6 
  7   <groupId>com.MavenMybatis</groupId>
  8   <artifactId>Mybatis_1</artifactId>
  9   <version>1.0-SNAPSHOT</version>
 10   <packaging>war</packaging>
 11 
 12   <name>Mybatis_1 Maven Webapp</name>
 13   <!-- FIXME change it to the project's website -->
 14   <url>http://www.example.com</url>
 15 
 16   <properties>
 17     <maven.compiler.source>1.8</maven.compiler.source>
 18     <maven.compiler.target>1.8</maven.compiler.target>
 19   </properties>
 20 
 21 
 22   <dependencies>
 23     <!-- ********************** junit单元测试依赖 ********************** -->
 24     <dependency>
 25       <groupId>junit</groupId>
 26       <artifactId>junit</artifactId>
 27       <version>4.12</version>
 28       <scope>test</scope>
 29     </dependency>
 30 
 31     <!-- ********************** Java Servlet API  ********************** -->
 32     <dependency>
 33       <groupId>javax.servlet</groupId>
 34       <artifactId>javax.servlet-api</artifactId>
 35       <version>4.0.0</version>
 36       <scope>provided</scope>
 37     </dependency>
 38 
 39     <!-- ********************** Mybatis依赖 ********************** -->
 40     <dependency>
 41       <groupId>org.mybatis</groupId>
 42       <artifactId>mybatis</artifactId>
 43       <version>3.4.5</version>
 44     </dependency>
 45 
 46     <!-- ********************** Mysql JDBC驱动 ********************** -->
 47     <dependency>
 48       <groupId>mysql</groupId>
 49       <artifactId>mysql-connector-java</artifactId>
 50       <version>5.1.44</version>
 51     </dependency>
 52 
 53     <!-- **********************  日志配置  ********************** -->
 54     <!--记得修改mybatis.cfg.xml添加如下内容-->
 55     <!--<setting name="logImpl" value="LOG4J2"/>-->
 56     <!--核心log4j2jar包-->
 57     <dependency>
 58       <groupId>org.apache.logging.log4j</groupId>
 59       <artifactId>log4j-core</artifactId>
 60       <version>2.9.1</version>
 61     </dependency>
 62     <dependency>
 63       <groupId>org.apache.logging.log4j</groupId>
 64       <artifactId>log4j-api</artifactId>
 65       <version>2.9.1</version>
 66     </dependency>
 67     <!--web工程需要包含log4j-web，非web工程不需要-->
 68     <dependency>
 69       <groupId>org.apache.logging.log4j</groupId>
 70       <artifactId>log4j-web</artifactId>
 71       <version>2.9.1</version>
 72     </dependency>
 73   </dependencies>
 74 
 75   <build>
 76     <finalName>Mybatis_1</finalName>
 77     <resources>
 78       <!--解决mybatis-generator-maven-plugin运行时没有将XxxMapper.xml文件放入target文件夹的问题-->
 79       <resource>
 80         <directory>src/main/java</directory>
 81         <includes>
 82           <include>**/*.xml</include>
 83         </includes>
 84       </resource>
 85       <!--解决mybatis-generator-maven-plugin运行时没有将jdbc.properites文件放入target文件夹的问题-->
 86       <resource>
 87         <directory>src/main/resources</directory>
 88         <includes>
 89           <include>jdbc.properties</include>
 90           <include>*.xml</include>
 91         </includes>
 92       </resource>
 93     </resources>
 94 
 95     <plugins>
 96       <plugin>
 97         <groupId>org.mybatis.generator</groupId>
 98         <artifactId>mybatis-generator-maven-plugin</artifactId>
 99         <version>1.3.2</version>
100         <dependencies>
101           <!--使用Mybatis-generator插件不能使用太高版本的mysql驱动 -->
102           <dependency>
103             <groupId>mysql</groupId>
104             <artifactId>mysql-connector-java</artifactId>
105             <version>5.1.44</version>
106           </dependency>
107         </dependencies>
108         <configuration>
109           <overwrite>true</overwrite>
110         </configuration>
111       </plugin>
112     </plugins>
113   </build>
114 </project>

Jdbc.properties

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

Web.xml

1 <web-app xmlns="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"></web-app>

3、Mybatis相关插件安装

Free mybatis plugin

Mybatis generator

mybatis tools

maven helper 

4、Mybatis.cfg.xml配置

Mybatis.cfg.xml

 1 <?xml version="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.javaxl.model.Book" alias="Book"/>-->
14     </typeAliases>
15 
16 
17     <!-- 配置mybatis运行环境 -->
18     <environments default="development">
19         <environment id="development">
20             <!-- type="JDBC" 代表使用JDBC的提交和回滚来管理事务 -->
21             <transactionManager type="jdbc"/>
22 
23             <!-- mybatis提供了3种数据源类型，分别是：POOLED,UNPOOLED,JNDI -->
24             <!-- POOLED 表示支持JDBC数据源连接池 -->
25             <!-- UNPOOLED 表示不支持数据源连接池 -->
26             <!-- JNDI 表示支持外部数据源连接池 -->
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/Mybatis/mapper/BookMapper.xml"/>
40     </mappers>
41 </configuration>

基于ssm逆向工程的使用

1、配置generatorConfig.xml

更改<!--指定数据库jdbc驱动jar包的位置-->

 1 <?xml version="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     <!--指定数据库jdbc驱动jar包的位置-->
 9     <classPathEntry location="D:\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     <!-- 一个数据库一个context -->
12     <context id="infoGuardian">
13         <!-- 注释 -->
14         <commentGenerator>
15             <property name="suppressAllComments" value="true"/><!-- 是否取消注释 -->
16             <property name="suppressDate" value="true"/> <!-- 是否生成注释代时间戳 -->
17         </commentGenerator>
18 
19         <!-- jdbc连接 -->
20         <jdbcConnection driverClass="${jdbc.driver}"
21                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
22 
23         <!-- 类型转换 -->
24         <javaTypeResolver>
25             <!-- 是否使用bigDecimal， false可自动转化以下类型（Long, Integer, Short, etc.） -->
26             <property name="forceBigDecimals" value="false"/>
27         </javaTypeResolver>
28 
29         <!-- 01 指定javaBean生成的位置 -->
30         <!-- targetPackage：指定生成的model生成所在的包名 -->
31         <!-- targetProject：指定在该项目下所在的路径  -->
32         <javaModelGenerator targetPackage="com.Mybatis.model"
33                             targetProject="src/main/java">
34             <!-- 是否允许子包，即targetPackage.schemaName.tableName -->
35             <property name="enableSubPackages" value="false"/>
36             <!-- 是否对model添加构造函数 -->
37             <property name="constructorBased" value="true"/>
38             <!-- 是否针对string类型的字段在set的时候进行trim调用 -->
39             <property name="trimStrings" value="false"/>
40             <!-- 建立的Model对象是否 不可改变  即生成的Model对象不会有 setter方法，只有构造方法 -->
41             <property name="immutable" value="false"/>
42         </javaModelGenerator>
43 
44         <!-- 02 指定sql映射文件生成的位置 -->
45         <sqlMapGenerator targetPackage="com.Mybatis.mapper"
46                          targetProject="src/main/java">
47             <!-- 是否允许子包，即targetPackage.schemaName.tableName -->
48             <property name="enableSubPackages" value="false"/>
49         </sqlMapGenerator>
50 
51         <!-- 03 生成XxxMapper接口 -->
52         <!-- type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象 -->
53         <!-- type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象 -->
54         <!-- type="XMLMAPPER",生成SQLMap XML文件和独立的Mapper接口 -->
55         <javaClientGenerator targetPackage="com.Mybatis.mapper"
56                              targetProject="src/main/java" type="XMLMAPPER">
57             <!-- 是否在当前路径下新加一层schema,false路径com.oop.eksp.user.model， true:com.oop.eksp.user.model.[schemaName] -->
58             <property name="enableSubPackages" value="false"/>
59         </javaClientGenerator>
60 
61         <!-- 配置表信息 -->
62         <!-- schema即为数据库名 -->
63         <!-- tableName为对应的数据库表 -->
64         <!-- domainObjectName是要生成的实体类 -->
65         <!-- enable*ByExample是否生成 example类 -->
66         <!--<table schema="" tableName="t_book" domainObjectName="Book"-->
67         <!--enableCountByExample="false" enableDeleteByExample="false"-->
68         <!--enableSelectByExample="false" enableUpdateByExample="false">-->
69         <!--&lt;!&ndash; 忽略列，不生成bean 字段 &ndash;&gt;-->
70         <!--&lt;!&ndash; <ignoreColumn column="FRED" /> &ndash;&gt;-->
71         <!--&lt;!&ndash; 指定列的java数据类型 &ndash;&gt;-->
72         <!--&lt;!&ndash; <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" /> &ndash;&gt;-->
73         <!--</table>-->
74 
75         <table schema="" tableName="t_mvc_Book" domainObjectName="Book"
76                enableCountByExample="false" enableDeleteByExample="false"
77                enableSelectByExample="false" enableUpdateByExample="false">
78             <!-- 忽略列，不生成bean 字段 -->
79             <!-- <ignoreColumn column="FRED" /> -->
80             <!-- 指定列的java数据类型 -->
81             <!-- <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" /> -->
82         </table>
83 
84     </context>
85 </generatorConfiguration>

配置maven运行generator命令

Mybatis增删改查案例

SessionUtil
 1 package com.Mybatis.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<SqlSession> threadLocal = new ThreadLocal<SqlSession>();
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 }
BookService 
 1 package com.Mybatis.service;
 2 
 3 import com.Mybatis.model.Book;
 4 
 5 public interface BookService {
 6 
 7     int deleteByPrimaryKey(Integer bid);
 8 
 9     int insert(Book record);
10 
11 
12     int insertSelective(Book record);
13 }


新建BookService，将BookMapper复制到BookService，选中类名BookService，Alt+回车生成实现类BookServiceImpl




BookServiceImpl




 1 package com.Mybatis.service.impl;
 2 
 3 import com.Mybatis.mapper.BookMapper;
 4 import com.Mybatis.model.Book;
 5 import com.Mybatis.service.BookService;
 6 
 7 public class BookServiceImpl implements BookService {
 8     public BookMapper getBookMapper() {
 9         return bookMapper;
10     }
11 
12     public void setBookMapper(BookMapper bookMapper) {
13         this.bookMapper = bookMapper;
14     }
15 
16     private BookMapper bookMapper;
17 
18 
19 
20 
21 
22     @Override
23     public int deleteByPrimaryKey(Integer bid) {
24         return bookMapper.deleteByPrimaryKey(bid);
25     }
26 
27     @Override
28     public int insert(Book record) {
29         return bookMapper.insert(record);
30     }
31 
32     @Override
33     public int insertSelective(Book record) {
34         return bookMapper.insertSelective(record);
35     }
36 }




测试


BookServiceTest




 1 package com.Mybatis.service;
 2 
 3 
 4 import com.Mybatis.mapper.BookMapper;
 5 import com.Mybatis.model.Book;
 6 import com.Mybatis.service.impl.BookServiceImpl;
 7 import com.Mybatis.util.SessionUtil;
 8 import org.apache.ibatis.session.SqlSession;
 9 import org.junit.After;
10 import org.junit.Before;
11 import org.junit.Test;
12 
13 public class BookServiceTest {
14 
15     private BookService bookService;
16     private SqlSession sqlSession;
17     @Before
18     public  void  setUp(){
19         BookServiceImpl bookService = new BookServiceImpl();
20         sqlSession = SessionUtil.openSession();
21         BookMapper mapper = sqlSession.getMapper(BookMapper.class);
22         bookService.setBookMapper(mapper);
23         this.bookService = bookService;
24     }
25 
26     @Test
27     public void deleteByPrimaryKey() {
28 
29     }
30 
31     @Test
32     public void insert() {
33         Book book = new Book();
34         book.setBid(1);
35         book.setBname("Mybatis插入");
36         book.setPrice(22);
37         bookService.insert(book);
38     }
39 
40     @Test
41     public void insertSelective() {
42     }
43 
44     @After
45     public void tearDown() throws Exception{
46         sqlSession.commit();
47         sqlSession.close();
48     }
49 }




新增








        

	      

	    

	  

	  

	    
      
        【推广】
        免费学中医，健康全家人
      
	  

    

    

          原文地址：https://www.cnblogs.com/xcn123/p/11691921.html