maven 构建springmvc+mybatis项目

一、首先maven构建出web项目

二、pom.xml当中添加mybatis以及spring等的依赖

	<modelVersion>4.0.0</modelVersion>
	<groupId>springmvcMaven</groupId>
	<artifactId>springmvcMaven</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>springmvcMaven Maven Webapp</name>
	<url>http://maven.apache.org</url>



	<properties>
		<!-- spring版本号 -->
		<spring.version>4.1.2.RELEASE</spring.version>
		<!-- mybatis版本号 -->
		<mybatis.version>3.3.0</mybatis.version>
		<!-- log4j日志文件管理包版本 -->
		<slf4j.version>1.7.7</slf4j.version>
		<log4j.version>1.2.17</log4j.version>
	</properties>



	<dependencies>


		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<dependency>
			<groupId>taglibs</groupId>
			<artifactId>standard</artifactId>
			<version>1.1.2</version>
		</dependency>

		<!-- spring核心包 -->
		<!-- springframe start -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		
<!-- 		添加上连接池 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>
		<dependency>
			<groupId>commons-pool</groupId>
			<artifactId>commons-pool</artifactId>
			<version>1.6</version>
		</dependency>
		<!-- aspect -->
			<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.6.12</version>
		</dependency>
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>1.6.2</version>
		</dependency>
		
		
		<!-- springframe end -->

		<!-- http://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>


		<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>
		<!-- mybatis/spring包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- mysql驱动包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.29</version>
		</dependency>
		<!-- junit测试包 -->


		<!-- http://mvnrepository.com/artifact/c3p0/c3p0 -->
		<dependency>
			<groupId>c3p0</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.1.2</version>
		</dependency>


		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>




	</dependencies>

三、web.xml当中添加spring配置

	<display-name>Archetype Created Web Application</display-name>


	<!-- Spring监听器 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<!-- 防止Spring内存溢出监听器 -->
	<listener>
		<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
	</listener>
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:spring-*.xml</param-value>
	</context-param>
	<servlet>
		<servlet-name>springmvc</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
<!-- 			<param-value>classpath:spring-mvc.xml</param-value> -->
			<param-value></param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>springmvc</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>

四、spring-*.xml中添加配置文件  其中配置mybatis  添加数据库支持

spring-persist.xml

<!-- 自动扫描 -->
	<context:component-scan base-package="com.ccsu.springmvc.*" />
	<!-- 引入配置文件 -->
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:jdbc.properties" />
	</bean>

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc_uriver}" />
        <property name="url" value="${jdbc_url}" />
        <property name="username" value="${jdbc_username}" />
        <property name="password" value="${jdbc_password}" />  
        <property name="initialSize" value="${initialSize}"/>   
      	<property name="maxActive" value="${maxActive}"/>   
       	<property name="maxIdle" value="${maxIdle}"/>   
       	<property name="minIdle" value="${minIdle}"/>         
     	<property name="maxWait" value="${maxWait}" />        
     	
     
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
     <property name="dataSource" ref="dataSource"></property>
     <!-- 
     <property name="configLocation" value="classpath:mybatis.xml"></property>
     <property name="typeAliasesPackage" value="com.ccsu.*.dao" />
      -->
     <property name="mapperLocations" value="classpath:com/ccsu/springmvc/mapping/*.xml" />
    </bean>

 
 <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.ccsu.springmvc.dao" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
	</bean>
    
     

	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		 <property name="dataSource" ref="dataSource" />
	</bean>
	
   	 <aop:config>
	     <aop:advisor pointcut="execution(* com.ccsu.springmvc.service..*.*(..))" advice-ref="txAdvice"/>  
	 </aop:config>
	 <tx:advice id="txAdvice" transaction-manager="transactionManager">  
	     <tx:attributes>  
	         <tx:method name="get*" read-only="true"/>  
	         <tx:method name="query*" read-only="true"/>  
	         <tx:method name="find*" read-only="true"/>  
	         <tx:method name="select*" read-only="true"/> 
	         <tx:method name="queryShopOrderCount"  read-only="false"/>
	         <tx:method name="*"  propagation="REQUIRED" rollback-for="java.lang.Exception"/>
	    </tx:attributes>  
	 </tx:advice>  
	<tx:annotation-driven transaction-manager="transactionManager" />

spring-mvc.xml

  <context:component-scan base-package="com.ccsu" />  
   
    <bean class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping" />  
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />  
       
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">  
        <property name="prefix" value="/WEB-INF/views/" />  
        <property name="suffix" value=".jsp" />  
    </bean>  

文件配置好以后@Controler @Service   @Mapping等构建出web路径

最后mybatis需要注意的几点

mapper.xml中的namespace="com.ccsu.springmvc.dao.StudentDao"与对应的接口类对应

<select id="getStudentByName" resultMap="BaseResultMap"
parameterType="java.lang.String">
SELECT
<include refid="Base_Column_List" />
FROM student t WHERE name = #{name }
</select>

操作id与getStudentByName于对应的方法对应

spring中配置mybatis时候 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
     <property name="dataSource" ref="dataSource"></property>
     <!-- 
     <property name="configLocation" value="classpath:mybatis.xml"></property>
     <property name="typeAliasesPackage" value="com.ccsu.*.dao" />
      -->
     <property name="mapperLocations" value="classpath:com/ccsu/springmvc/mapping/*.xml" />
    </bean>

要指定对应mapper的位置

实例代码