基于maven的SpringMVC，Spring，MyBatis的全注解配置

墨蓝 2022-08-07 14:57 111阅读 0赞

## 首先创建maven项目 ##

1.maven添加各种依赖包

<dependency>
    			<groupId>c3p0</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.1.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.2.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.2.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-jdbc</artifactId>
    			<version>4.1.6.RELEASE</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>cglib</groupId>
    			<artifactId>cglib</artifactId>
    			<version>2.2</version>
    		</dependency>
    	
    		<dependency>
    			<groupId> mysql</groupId>
    			<artifactId> mysql-connector-java</artifactId>
    			<version> 5.0.5</version>
    		</dependency>
    	
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-context</artifactId>
    			<version>4.1.6.RELEASE</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-webmvc</artifactId>
    			<version>4.1.6.RELEASE</version>
    		</dependency>

2.配置spring.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans  
         http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  
         http://www.springframework.org/schema/context  
         http://www.springframework.org/schema/context/spring-context-4.0.xsd  
         http://www.springframework.org/schema/mvc  
         http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
    
    	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
    		destroy-method="close">
    
    	
    	<property name="driverClass" value="com.mysql.jdbc.Driver" />
    	
    	<property name="jdbcUrl" value="url" />
    	
    	<property name="user" value="user" />
    	
    	<property name="password" value="pass" />
    	
    	<property name="initialPoolSize" value="5" />
    	
    	<property name="minPoolSize" value="5" />
    	
    	<property name="maxPoolSize" value="20" />
    	
    	<property name="maxStatements" value="100" />
    	
    	<property name="maxIdleTime" value="3600" />
    	
    	<property name="acquireIncrement" value="2" />
    	
    	<property name="acquireRetryAttempts" value="10" />
    	
    	<property name="acquireRetryDelay" value="600" />
    	
    	<property name="testConnectionOnCheckin" value="true" />
    	
    	<property name="idleConnectionTestPeriod" value="1200" />
    	
    	<property name="checkoutTimeout" value="10000" />
    
    	</bean>
    
    	
    
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="configLocation" value="classpath:configuration.xml" />
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.ray.model.mapper" />
        </bean>
        
    
    
    	<mvc:annotation-driven />
    	
    	<context:component-scan base-package="com.ray.services" />
    	
    	<bean
    		class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />
    	
    	<bean
    		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		<property name="prefix" value="/WEB-INF/" />
    		<property name="suffix" value=".jsp" />
    	</bean>
    </beans>

3.配置web.xml

<servlet>
    	<servlet-name>springmvc</servlet-name>
    	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    	<init-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>/WEB-INF/spring.xml</param-value>
    	</init-param>
    	<load-on-startup>1</load-on-startup>
    	</servlet>
    
    
    	<servlet-mapping>
    		<servlet-name>springmvc</servlet-name>
    		<url-pattern>*.do</url-pattern>
    	</servlet-mapping>

4.配置mybatis自动生成实体（运行maven install的时候）

首先配置pom.xml

<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<entity.target.dir>src/main/java/</entity.target.dir>
    		<dao.resources.dir>src/main/resources/</dao.resources.dir>
    	</properties>
    	
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<version>1.3.2</version>
    				<dependencies>
    					
    					<dependency>
    						<groupId> mysql</groupId>
    						<artifactId> mysql-connector-java</artifactId>
    						<version> 5.0.5</version>
    					</dependency>
    					<dependency>
    						<groupId>org.mybatis</groupId>
    						<artifactId>mybatis-spring</artifactId>
    						<version>1.2.2</version>
    					</dependency>
    					
    					<dependency>
    						<groupId>org.mybatis</groupId>
    						<artifactId>mybatis</artifactId>
    						<version>3.2.4</version>
    					</dependency>
    	
    		</dependencies>
    		<executions>
    			<execution>
    				<id>Generate MyBatis Artifacts</id>
    				<phase>package</phase>
    				<goals>
    					<goal>generate</goal>
    				</goals>
    			</execution>
    		</executions>
    		<configuration>
    			<verbose>false</verbose>
    			<overwrite>false</overwrite>
    			<configurationFile>
    				src/main/resources/mybatis-generator.xml</configurationFile>
    		</configuration>
    		</plugin>
    		<plugin>
    			<artifactId>maven-compiler-plugin</artifactId>
    			<configuration>
    				<encoding>UTF-8</encoding>
    				<source>1.5</source>
    				<target>1.5</target>
    			</configuration>
    		</plugin>
    		</plugins>
    	
    		</build>

配置mybatis-generator.xml

<?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>
    
    	<context id="DB2Tables" targetRuntime="MyBatis3" defaultModelType="flat">
    		<plugin type="org.mybatis.generator.plugins.RenameExampleClassPlugin">
    			<property name="searchString" value="[e|E]xample$" />
    			<property name="replaceString" value="Criteria" />
    		</plugin>
    
    	<commentGenerator>
    		<property name="suppressDate" value="true" />
    	</commentGenerator>
    
    	<jdbcConnection driverClass="com.mysql.jdbc.Driver"
    		connectionURL="jdbc:mysql://127.0.0.1/ray" userId="ray"
    		password="123456">
    	</jdbcConnection>
    
    	<javaTypeResolver>
    		<property name="forceBigDecimals" value="false" />
    	</javaTypeResolver>
    
    	
    	<javaModelGenerator targetPackage="com.ray.model"
    		targetProject="${entity.target.dir}">
    		<property name="enableSubPackages" value="true" />
    		<property name="trimStrings" value="true" />
    	</javaModelGenerator>
    
    
    
    	
    	<sqlMapGenerator  targetPackage="com.ray.model.mapper"
    		targetProject="${dao.resources.dir}">
    		<property name="enableSubPackages" value="true" />
    	</sqlMapGenerator>
    
    	
    	<javaClientGenerator type="ANNOTATEDMAPPER"
    		targetPackage="com.ray.model.mapper" implementationPackage="com.ray.model.mapper.impl"
    		targetProject="${entity.target.dir}">
    		<property name="enableSubPackages" value="true" />
    	</javaClientGenerator>
    
    	<table tableName="user" domainObjectName="User">
    	</table>
    
    	</context>
    </generatorConfiguration>

5.mybatis配置configuration.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration      
        PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"      
        "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
    <configuration>
    	<settings>
    		
    		<setting name="cacheEnabled" value="true" />
    		
    		<setting name="lazyLoadingEnabled" value="true" />
    		
    		<setting name="aggressiveLazyLoading" value="false" />
    		
    		<setting name="multipleResultSetsEnabled" value="true" />
    		
    		<setting name="useColumnLabel" value="true" />
    		
    		<setting name="useGeneratedKeys" value="true" />
    		
    		<setting name="autoMappingBehavior" value="FULL" />
    		
    		<setting name="defaultExecutorType" value="BATCH" />
    		
    		<setting name="defaultStatementTimeout" value="25000" />
    	</settings>
    	
    	<typeAliases>
    		<typeAlias alias="User"
    			type="com.ray.model.User" />
    	</typeAliases>
    	
    	
    </configuration>

6.使用

package com.ray.services;
    
    import java.io.IOException;
    import java.io.PrintWriter;
    
    import javax.servlet.http.HttpServletResponse;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import com.ray.model.mapper.UserMapper;
    
    @Controller
    public class Test {
    
    	@Autowired
    	private UserMapper mapper;
    	
    	/**
    	 * 测试有多少条数据
    	 * @param response
    	 */
    	@RequestMapping("/getcount.do")
    	public void count(HttpServletResponse response){
    		PrintWriter pw = null;
    		try {
    			
    			pw = response.getWriter();
    			pw.write("count:"+mapper.countByExample(null));
    			
    		} catch (IOException e) {
    			e.printStackTrace();
    		}finally{
    			if(pw != null){
    				pw.close();
    			}
    		}
    	}
    
    	public UserMapper getMapper() {
    		return mapper;
    	}
    
    	public void setMapper(UserMapper mapper) {
    		this.mapper = mapper;
    	}
    	
    	
    }

虽然也需要用xml文档来进行配置，但是感觉用注解还是方便了好多，具体代码https://git.oschina.net/raywang2014/JavaEE.git（这个项目配置了最基本的环境，但是项目是分模块的）