Spring-mvc整合mybatis-oracle11g-druid数据源

Bertha 。 2022-08-10 00:36 19阅读 0赞

今天做了个小练习，spring-mvc整合mybatis。使用的表是，oracle自带的emp表。

项目内容：  
对emp表的增删改查

项目所使用的框架版本  
Spring 3.1  
mybatis 3.2  
oracle 11g  
druid 1.0.15

废话不多话,上图解释。

![这里写图片描述][20151105091931435]

先展示各个配置文件的内容  
web.xml文件内容

<?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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
        <display-name>EmpMgr</display-name>
        <welcome-file-list>
            <welcome-file>index.html</welcome-file>
            <welcome-file>index.htm</welcome-file>
            <welcome-file>index.jsp</welcome-file>
            <welcome-file>default.html</welcome-file>
            <welcome-file>default.htm</welcome-file>
            <welcome-file>default.jsp</welcome-file>
        </welcome-file-list>
    
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:app*.xml</param-value>
        </context-param>
    
        
        <servlet>
            <servlet-name>mvc</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>mvc</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
        
        <servlet>
            <servlet-name>DruidStatView</servlet-name>
            <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
        </servlet>
        <servlet-mapping>
            <servlet-name>DruidStatView</servlet-name>
            <url-pattern>/druid/*</url-pattern>
        </servlet-mapping>
    
        
        <filter>
            <filter-name>encode</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>
        </filter>
        <filter-mapping>
            <filter-name>encode</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
    </web-app>

generatorConfig.xml 。至于如何使用mybatis逆向工程，请访问本博客专栏[mybatis如何实现逆向工程][mybatis]

<?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="context1" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <commentGenerator>
                <property name="suppressDate" value="true" />
            </commentGenerator>
            <jdbcConnection driverClass="oracle.jdbc.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="scott" password="tiger" />
    
            <javaModelGenerator targetPackage="com.mvc.zxf.emp.entity" targetProject="EmpMgr/src" />
            <sqlMapGenerator targetPackage="com.mvc.zxf.emp.dao" targetProject="EmpMgr/src" />
            <javaClientGenerator targetPackage="com.mvc.zxf.emp.dao" targetProject="EmpMgr/src" type="XMLMAPPER" />
            <table tableName="emp">
                <generatedKey column="empno" sqlStatement="select SEQ_EMP.nextval from dual" />
            </table>
        </context>
    </generatorConfiguration>

mvc-servlet.xml spring mvc 配置

mybatis-config.xml 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="logImpl" value="LOG4J" />
        </settings>
        
        <typeAliases>
            <package name="com.mvc-mybatis.zxf.emp.entity" />
        </typeAliases>
    </configuration>

log4j.properties 日志记录文件

# Global logging configuration
    #log4j.rootLogger=ERROR, stdout, E
    log4j.rootLogger=info, stdout, E
    # JDBC and MyBatis logging configuration...
    log4j.logger.com.ibatis=debug
    log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug
    log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug
    log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug
    log4j.logger.java.sql.Connection=debug
    log4j.logger.java.sql.Statement=debug
    log4j.logger.java.sql.PreparedStatement=debug,stdout
    
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
    
    # Save error message to file...
    log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
    log4j.appender.E.File = ../logs/slsdw_error_
    log4j.appender.E.DatePattern=yyyy-MM-dd'.log'
    log4j.appender.E.Append = true
    log4j.appender.E.Threshold = ERROR
    log4j.appender.E.layout = org.apache.log4j.PatternLayout
    log4j.appender.E.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

jdbc.properties 驱动属性配置

driverClassName=oracle.jdbc.driver.OracleDriver
    jdbc_url=jdbc:oracle:thin:@localhost:1521:orcl
    jdbc_username=scott
    jdbc_password=tiger

applicationContext.xml spring 配置文件

<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mybatis="http://mybatis.org/schema/mybatis-spring" xsi:schemaLocation=" http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd ">
        
        <bean id="config" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="location" value="classpath:jdbc.properties"></property>
        </bean>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            
            <property name="url" value="${jdbc_url}" />
            <property name="username" value="${jdbc_username}" />
            <property name="password" value="${jdbc_password}" />
    
            
            <property name="initialSize" value="10" />
            <property name="minIdle" value="10" />
            <property name="maxActive" value="20" />
    
            
            <property name="maxWait" value="60000" />
    
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
    
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
    
            <property name="validationQuery" value="SELECT 'x' FROM DUAL" />
            <property name="testWhileIdle" value="true" />
            <property name="testOnBorrow" value="false" />
            <property name="testOnReturn" value="false" />
    
            
            <property name="poolPreparedStatements" value="true" />
            <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />
    
            
            <property name="filters" value="stat" />
        </bean>
    
        
        <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            <property name="configLocation" value="classpath:mybatis-config.xml" />
        </bean>
        
    
        <mybatis:scan base-package="com.mvc.zxf.emp.dao" />
        
        <context:component-scan base-package="com.mvc.zxf.emp.biz" />
    
        
        <bean id="txMgr" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
        
        <tx:advice transaction-manager="txMgr" id="txAdvice">
            <tx:attributes>
                <tx:method name="add*" propagation="REQUIRED" />
                <tx:method name="create*" propagation="REQUIRED" />
                <tx:method name="remove*" propagation="REQUIRED" />
                <tx:method name="delete*" propagation="REQUIRED" />
                <tx:method name="modify*" propagation="REQUIRED" />
                <tx:method name="update*" propagation="REQUIRED" />
                <tx:method name="find*" propagation="REQUIRED" read-only="true" />
                <tx:method name="search*" propagation="REQUIRED" read-only="true" />
                <tx:method name="get*" propagation="REQUIRED" read-only="true" />
                <tx:method name="*" propagation="REQUIRED" />
            </tx:attributes>
        </tx:advice>
        <aop:config>
            <aop:pointcut expression="execution(* *..biz..*.*(..))" id="txSrvMethod" />
            <aop:advisor advice-ref="txAdvice" pointcut-ref="txSrvMethod" />
        </aop:config>
    
    </beans>

实现的效果如下图：  
![运行结果][20151105092830736]

项目资源分享  
链接：[http://pan.baidu.com/s/1c0pyogw][http_pan.baidu.com_s_1c0pyogw] 密码：zdg9

如有问题，请留言交流，谢谢。

[20151105091931435]: /images/20220731/19d3f01f98b84450bea811c9911b2d95.png
[mybatis]: http://blog.csdn.net/u013410747/article/details/48881497
[20151105092830736]: /images/20220731/d58278a6762b4e12b489a6f698d2a2f8.png
[http_pan.baidu.com_s_1c0pyogw]: http://pan.baidu.com/s/1c0pyogw