首页 > 代码库 > mybatis+springMVC

mybatis+springMVC

!!!springMVC  Mybatis dbcp  log4j

1、导入jar包

技术分享 

技术分享

2、spring-servlet.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"    xmlns:p="http://www.springframework.org/schema/p"    xmlns:mvc="http://www.springframework.org/schema/mvc"    xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd           http://www.springframework.org/schema/context           http://www.springframework.org/schema/context/spring-context-2.5.xsd           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd        http://www.springframework.org/schema/mvc         http://www.springframework.org/schema/mvc/spring-mvc.xsd">    <!-- 使spring扫描包下的所有类,让标注spring注解的类生效 -->    <context:component-scan base-package="com.duanzishou">        <!-- 扫描所有的controller 但是不扫描service-->          <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" />          <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service" />     </context:component-scan>    <mvc:annotation-driven></mvc:annotation-driven>    <!-- 对转向页面的路径解析。prefix:前缀, suffix:后缀 -->    <bean        class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/view/" />        <property name="suffix" value=".jsp" />    </bean>    <!-- JSON支持 -->    <bean id="messageAdapter"        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">        <property name="messageConverters">            <list>                <!-- Support JSON -->                <bean                    class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" />            </list>        </property>    </bean>    <mvc:resources mapping="/resources/**" location="/resources/" />    <mvc:resources mapping="/js/**" location="/js/" />    <mvc:resources mapping="/images/**" location="/images/" />    <mvc:resources mapping="/css/**" location="/css/" />    <mvc:resources mapping="/common/**" location="/common/" />    <mvc:resources mapping="/bootstrap/**" location="/bootstrap/" />    <mvc:resources mapping="/lib/**" location="/lib/" />    <mvc:resources mapping="/twitter-bootstrap/**" location="/twitter-bootstrap/" />    <mvc:resources mapping="/upload/**" location="/upload/" />    <bean id="exceptionMessageAdapter"        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerExceptionResolver">        <property name="messageConverters">            <list>                <!-- Support JSON -->                <bean                    class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" />            </list>        </property>    </bean>    <!-- 文件上传支持 -->    <bean id="multipartResolver"        class="org.springframework.web.multipart.commons.CommonsMultipartResolver"        p:maxUploadSize="34564356345456"         p:defaultEncoding="utf-8">        <!-- <property name="defaultEncoding" value="http://www.mamicode.com/utf-8"></property> -->    </bean></beans> 

 

  3、applicationContext-mybatis.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:aop="http://www.springframework.org/schema/aop"    xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx"    xmlns:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="                   http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd                   http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd                   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">    <!-- Properties文件读取配置,base的properties -->    <context:property-placeholder location="classpath:jdbc.properties" />    <!-- JNDI获取数据源(使用dbcp连接池) -->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"        destroy-method="close" scope="singleton">        <property name="driverClassName" value="${driverClassName}" />        <property name="url" value="${url}" />        <property name="username" value="${uname}" />        <property name="password" value="${password}" />        <!-- 初始化连接大小 -->        <property name="initialSize" value="${initialSize}"></property>        <!-- 连接池最大数量 -->        <property name="maxActive" value="${maxActive}"></property>        <!-- 连接池最大空闲 -->        <property name="maxIdle" value="${maxIdle}"></property>        <!-- 连接池最小空闲 -->        <property name="minIdle" value="${minIdle}"></property>        <!-- 获取连接最大等待时间 -->        <property name="maxWait" value="${maxWait}"></property>    </bean>    <!-- enable transaction demarcation with annotations -->    <tx:annotation-driven />    <!-- 定义 SqlSessionFactory -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"        scope="singleton">        <property name="dataSource" ref="dataSource" />        <property name="configLocation" value="classpath:mybatis-config.xml" />    </bean>    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->    <bean id="transactionManager"        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean>    <!-- 配置事务通知属性 -->    <tx:advice id="txAdvice" transaction-manager="transactionManager">        <!-- 定义事务传播属性 -->        <tx:attributes>            <tx:method name="insert*" propagation="REQUIRED" />            <tx:method name="update*" propagation="REQUIRED" />            <tx:method name="edit*" propagation="REQUIRED" />            <tx:method name="save*" propagation="REQUIRED" />            <tx:method name="add*" propagation="REQUIRED" />            <tx:method name="new*" propagation="REQUIRED" />            <tx:method name="set*" propagation="REQUIRED" />            <tx:method name="remove*" propagation="REQUIRED" />            <tx:method name="delete*" propagation="REQUIRED" />            <tx:method name="change*" propagation="REQUIRED" />            <tx:method name="get*" propagation="REQUIRED" read-only="true" />            <tx:method name="query*" propagation="REQUIRED" read-only="true" />            <tx:method name="find*" propagation="REQUIRED" read-only="true" />            <tx:method name="load*" propagation="REQUIRED" read-only="true" />            <tx:method name="*" propagation="REQUIRED" read-only="true" />            <tx:method name="*" rollback-for="CustomException" />        </tx:attributes>    </tx:advice>    <!-- 应用普通类获取bean <bean id="appContext" class="com.soanl.util.tool.ApplicationUtil"/> -->    <!-- 配置事务切面 -->    <aop:config>        <aop:pointcut id="serviceOperation"            expression="execution(* com.duanzishou.service..*.*(..))" />        <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceOperation" />    </aop:config>    <!-- scan for mappers and let them be autowired MapperScannerConfigurer         Mybatis-Spring 会自动为我们注册Mapper对应的MapperFactoryBean对象 -->    <!-- Mapper接口所在包名,Spring会自动查找其下的Mapper -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="org.project.dao" />    </bean>        <!-- 自动扫描组件,这里要把controler下面的 controller去除,他们是在springmvc的配置文件中配置的,如果不去除会影响事务管理的。  -->    <context:component-scan base-package="com.duanzishou.*">        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />     </context:component-scan></beans>  

 4、web.xml整合SpringMVC和Mybatis

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">  <display-name></display-name>  <context-param>    <param-name>contextConfigLocation</param-name>    <param-value>classpath:applicationContext-*.xml</param-value>  </context-param>  <listener>    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>   <!-- 初始化 DispatcherServlet时,该框架在 web应用程序WEB-INF目录中寻找一个名为[servlet-名称]-servlet.xml的文件,              并在那里定义相关的Beans,重写在全局中定义的任何Beans -->  <servlet>    <servlet-name>spring</servlet-name>    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>    <init-param>      <param-name>contextConfigLocation</param-name>      <param-value>classpath:spring-servlet.xml</param-value>    </init-param>    <load-on-startup>1</load-on-startup>  </servlet>  <servlet-mapping>    <servlet-name>spring</servlet-name>    <!-- 所有的的请求,都会被DispatcherServlet处理 -->      <url-pattern>/</url-pattern>  </servlet-mapping>  <context-param>    <param-name>log4jConfigLocation</param-name>    <param-value>classpath:log4j.properties</param-value>  </context-param>    <!-- 日志监听 -->    <listener>    <listener-class>            org.springframework.web.util.Log4jConfigListener        </listener-class>  </listener>   <!-- 配置字符集 -->    <filter>    <filter-name>characterEncodingFilter</filter-name>    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>    <init-param>      <param-name>encoding</param-name>      <param-value>UTF-8</param-value>    </init-param>    <init-param>      <param-name>forceEncoding</param-name>      <param-value>true</param-value>    </init-param>  </filter>  <filter-mapping>    <filter-name>characterEncodingFilter</filter-name>    <url-pattern>/</url-pattern>  </filter-mapping>  <welcome-file-list>    <welcome-file>index.jsp</welcome-file>  </welcome-file-list></web-app>

5、log4j.properties

log4j.rootLogger=debug,CONSOLE,file#log4j.rootLogger=ERROR,ROLLING_FILElog4j.logger.org.project=errorlog4j.logger.org.apache.ibatis=debuglog4j.logger.org.mybatis.spring=debuglog4j.logger.java.sql.Connection=debuglog4j.logger.java.sql.Statement=debuglog4j.logger.java.sql.PreparedStatement=debuglog4j.logger.java.sql.ResultSet=debug####################################################################################### Console Appender  \u65e5\u5fd7\u5728\u63a7\u5236\u8f93\u51fa\u914d\u7f6e######################################################################################log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppenderlog4j.appender.Threshold=debuglog4j.appender.CONSOLE.Target=System.outlog4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayoutlog4j.appender.CONSOLE.layout.ConversionPattern= - (%r ms) - [%p] %d %c - %m%n####################################################################################### Rolling File  \u6587\u4ef6\u5927\u5c0f\u5230\u8fbe\u6307\u5b9a\u5c3a\u5bf8\u7684\u65f6\u5019\u4ea7\u751f\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6#######################################################################################log4j.appender.ROLLING_FILE=org.apache.log4j.RollingFileAppender#log4j.appender.ROLLING_FILE.Threshold=INFO#log4j.appender.ROLLING_FILE.File=${baojia.root}/logs/log.log#log4j.appender.ROLLING_FILE.Append=true#log4j.appender.ROLLING_FILE.MaxFileSize=5000KB#log4j.appender.ROLLING_FILE.MaxBackupIndex=100#log4j.appender.ROLLING_FILE.layout=org.apache.log4j.PatternLayout#log4j.appender.ROLLING_FILE.layout.ConversionPattern=%d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n####################################################################################### DailyRolling File  \u6bcf\u5929\u4ea7\u751f\u4e00\u4e2a\u65e5\u5fd7\u6587\u4ef6\uff0c\u6587\u4ef6\u540d\u683c\u5f0f:log2009-09-11######################################################################################log4j.appender.file=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.file.DatePattern=yyyy-MM-ddlog4j.appender.file.File=${springMVCProject.root}/logs/log.loglog4j.appender.file.Append=truelog4j.appender.file.Threshold=debuglog4j.appender.file.layout=org.apache.log4j.PatternLayoutlog4j.appender.file.layout.ConversionPattern= - (%r ms) - %d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n#DWR \u65e5\u5fd7#log4j.logger.org.directwebremoting = ERROR#\u663e\u793aHibernate\u5360\u4f4d\u7b26\u7ed1\u5b9a\u503c\u53ca\u8fd4\u56de\u503c#log4j.logger.org.hibernate.type=DEBUG,CONSOLE #log4j.logger.org.springframework.transaction=DEBUG#log4j.logger.org.hibernate=DEBUG#log4j.logger.org.acegisecurity=DEBUG#log4j.logger.org.apache.myfaces=TRACE#log4j.logger.org.quartz=DEBUG#log4j.logger.com.opensymphony=INFO  #log4j.logger.org.apache.struts2=DEBUG  log4j.logger.com.opensymphony.xwork2=debug

6、jdbc.properties

driverClassName=com.mysql.jdbc.Driverurl=jdbc:mysql://127.0.0.1:3306/waduanzi?useUnicode=true&characterEncoding=utf-8uname=rootpassword=123456minIdle=10maxIdle=50initialSize=5maxActive=100maxWait=100removeAbandonedTimeout=180removeAbandoned=true

 

mybatis+springMVC