MyBatis和Spring整合

我就是我 2022-04-24 15:34 147阅读 0赞

## 创建maven项目 ##

创建一个java项目即可

## 引入相关依赖 ##

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<groupId>com.dpb</groupId>
    	<artifactId>mybatis11-SS</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<properties>
    		<spirng.version>4.3.3.RELEASE</spirng.version>
    	</properties>
    	<dependencies>
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-context</artifactId>
    			<version>${spirng.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-orm</artifactId>
    			<version>${spirng.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.4.6</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.27</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-api</artifactId>
    			<version>1.7.25</version>
    		</dependency>
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-log4j12</artifactId>
    			<version>1.7.25</version>
    		</dependency>
    		<dependency>
    			<groupId>log4j</groupId>
    			<artifactId>log4j</artifactId>
    			<version>1.2.17</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.mchange</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.5.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>3.8.1</version>
    		</dependency>
    	</dependencies>
    </project>

## 创建对应的配置文件 ##

mybatis的全局配置文件

<?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>
      <settings>
      	
      	<setting name="lazyLoadingEnabled" value="true"/>
      	<setting name="aggressiveLazyLoading" value="false"/>
      </settings>
    </configuration>

## spring的配置文件 ##

## db.properties文件 ##

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/pms?characterEncoding=utf-8
    names=root
    password=123456

## log4j.properties文件 ##

log4j.rootCategory=DEBUG, stdout , R
     
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=[QC] %p [%t] %C.%M(%L) | %m%n
     
    log4j.appender.R=org.apache.log4j.DailyRollingFileAppender
    log4j.appender.R.File=C:\\tools\\logs\\dpb.log
    log4j.appender.R.layout=org.apache.log4j.PatternLayout
    log4j.appender.R.layout.ConversionPattern=%d-[TS] %p %t %c - %m%n

## 业务测试 ##

## javabean和mapper接口映射文件 ##

## 逆向工程生成 ##

## 逆向工程文件 ##

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
      PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
      "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
       
      <classPathEntry location="C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\5.1.27\mysql-connector-java-5.1.27.jar" />
    
      <context id="DB2Tables" targetRuntime="MyBatis3">
      
    		<commentGenerator>
    			<property name="suppressAllComments" value="true" />
    		</commentGenerator>
      	 
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"  
            connectionURL="jdbc:mysql://localhost:3306/pms"  
            userId="root"  
            password="123456">  
        </jdbcConnection>   
        
    	
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    	 
        <javaModelGenerator targetPackage="com.sxt.bean" targetProject="mybatis-11-spring\src\main\java">
        	 
          <property name="enableSubPackages" value="false" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
     	
        <sqlMapGenerator targetPackage="com.sxt.dao"  targetProject="mybatis-11-spring\src\main\java">
          <property name="enableSubPackages" value="false" />
        </sqlMapGenerator>
     	 
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.sxt.dao"  targetProject="mybatis-11-spring\src\main\java">
          <property name="enableSubPackages" value="false" />
        </javaClientGenerator>
        
         <table  tableName="t_user" domainObjectName="User" >
        </table> 
        
      </context>
    </generatorConfiguration>

## service及其实现类 ##

package com.sxt.service;
    
    import java.util.List;
    
    import com.sxt.bean.User;
    
    public interface UserService {
    	public List<User> query();
    }

## service实现类定义查询以a开头的name ##

package com.sxt.service.impl;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import com.sxt.bean.User;
    import com.sxt.bean.UserExample;
    import com.sxt.bean.UserExample.Criteria;
    import com.sxt.dao.UserMapper;
    import com.sxt.service.UserService;
    @Service
    public class UserServiceImpl implements UserService{
    	@Resource
    	private UserMapper dao;
    	@Override
    	public List<User> query() {
    		UserExample example = new UserExample();
    		Criteria criteria = example.createCriteria();
    		criteria.andUsernameLike("a%");
    		return dao.selectByExample(example );
    	}
    
    }

## 测试方法 ##

package com.sxt.test;
    
    import java.util.List;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import com.sxt.bean.User;
    import com.sxt.service.UserService;
    
    public class UserTest {
    	public static void main(String[] args) {
    		ApplicationContext context = new ClassPathXmlApplicationContext("application.xml");
    		UserService bean = context.getBean(UserService.class);
    		List<User> query = bean.query();
    		System.out.println(query);
    		}
    }

![在这里插入图片描述][20190429150434646.png]

## 项目结构目录 ##

![在这里插入图片描述][20190429150559195.png]  
注意如果接口映射文件和接口文件不在同一个包下可以如下配置:

<bean class="org.mybatis.spring.SqlSessionFactoryBean"> 
     
    	<property name="configLocation" value="classpath:mybatisconf.xml"/>
    
      <property name="dataSource" ref="dateSource"/>
    
        <property name="typeAliasesPackage" value="com.sxt.model"/>
     
         <property name="mapperLocations" value="classpath:mapper/*.xml"/>
       </bean>

[20190429150434646.png]: /images/20220212/770f455a720344a1abca4ab68380f4bc.png
[20190429150559195.png]: /images/20220212/2a4466e31aad45688cef216a39f3cf13.png