spring+springmvc+mybatis+oracle整合开发核心配置代码

时间：2022-03-25 14:52:20

1.web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

    <!-- 核心springmvc核心控制器 -->
    <servlet>
<servlet-name>DispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>DispatcherServlet</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>

<!-- POST编码过滤器 -->
<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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>

2.mybatis.xml 

<?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>

  <!-- <environments default="oracle_developer">
     <environment id="mysql_developer">
        <transactionManager type="jdbc"></transactionManager>
        <dataSource type="pooled">
          <property name="driver" value="com.mysql.jdbc.Driver"></property>
          <property name="url" value="jdbc:mysql://localhost:3306/mybatis"></property>
          <property name="username" value="root"></property>
          <property name="password" value="123456"></property>  
        </dataSource>
     </environment>

     <environment id="oracle_developer">
        <transactionManager type="jdbc"></transactionManager>
        <dataSource type="pooled">
          <property name="driver" value="oracle.jdbc.driver.OracleDriver"></property>
          <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:mldn"></property>
          <property name="username" value="scott"></property>
          <property name="password" value="tiger"></property>  
        </dataSource>
     </environment>
  </environments>
     -->
    <mappers>
         <mapper resource="cn/itcast/entity/EmpMapper.xml"/>
    </mappers>

</configuration>

3.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:p="http://www.springframework.org/schema/p"
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:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
     http://www.springframework.org/schema/beans/spring-beans.xsd
      http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop.xsd
         http://www.springframework.org/schema/tx
      http://www.springframework.org/schema/tx/spring-tx.xsd
      http://www.springframework.org/schema/mvc
         http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
      ">

<!-- 配置C3P0连接池,目的：管理数据库连接 -->
<bean id="comboPooledDataSourceID" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="jdbcUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:mldn"></property>
<property name="user" value="scott"></property>
<property name="password" value="tiger"></property>
</bean>

 <!-- 配置SqlSessionFactoryBean，目的：加载mybaits配置文件和映射文件，即替代原Mybatis工具类的作用 -->
 <bean id="sqlSessionFactoryBeanID" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="configLocation" value="classpath:mybatis.xml"/>
    <property name="dataSource" ref="comboPooledDataSourceID"/>
 </bean>

 <!-- 配置Mybatis的事务管理器，即因为Mybatis底层用的是JDBC事务管事器，所以在这里依然配置JDBC事务管理器 -->
 <bean id="dataSourceTransactionManagerID" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <property name="dataSource" ref="comboPooledDataSourceID"/>
     </bean>

 <!-- 配置事务通知，即让哪些方法需要事务支持 -->
 <tx:advice id="tx" transaction-manager="dataSourceTransactionManagerID">
     <tx:attributes>
         <tx:method name="*" propagation="REQUIRED"></tx:method>
     </tx:attributes>
 </tx:advice>

 <!-- 配置事务切面，即让哪些包下的类需要事务 -->
 <aop:config>
    <aop:pointcut id="pointcut" expression="execution(* cn.itcast.dao.*.*(..))"></aop:pointcut>
    <aop:advisor advice-ref="tx" pointcut-ref="pointcut"></aop:advisor>
 </aop:config>

 <!-- 注册EmpDao -->
 <bean id="empDaoID" class="cn.itcast.dao.EmpDao">
     <property name="sqlSessionFactory" ref="sqlSessionFactoryBeanID"></property>
 </bean>

 <!-- 注册EmpService -->
 <bean id="empServiceID" class="cn.itcast.service.EmpService">
     <property name="empDao" ref="empDaoID"></property>
 </bean>

 <!-- 注册EmpAction -->
 <context:component-scan base-package="cn.itcast.action"></context:component-scan>

  <!-- 通知springioc容器这些注解的作用 -->
  <context:annotation-config/>

  <!-- 视图解析器 -->
  <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
      <property name="prefix" value="/jsp/"/>
      <property name="suffix" value=".jsp"/>
  </bean>
</beans>

4.EmpAction 

package cn.itcast.action;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.itcast.entity.Emp;
import cn.itcast.service.EmpService;
//单例，控制器

@Controller
@RequestMapping(value="/emp")
public class EmpAction {

private EmpService empService;
@Resource(name="empServiceID")
public void setEmpService(EmpService empService) {
this.empService = empService;
}
//注册员工
@RequestMapping(value="/register")
public String register(Emp emp) throws Exception{
//调用业务层
empService.register(emp);
return "success";
}

}
5.register.jsp 

<%@ page language="java" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head> 
    <title>员工注册</title>
  <body>
     <form action="${pageContext.request.contextPath }/emp/register.action" method="post">
        <table border="2" align="center">
          <tr>
             <th>编号</th>
             <td><input type="text" name="id"/></td>
          </tr>
          <tr>
<th>姓名</th>
<td><input type="text" name="name"></td>
</tr>
<tr>
<th>薪水</th>
<td><input type="text" name="sal"></td>
</tr>
<tr>
<th>性别</th>
<td>
<input type="radio" name="sex" value="男"/>男
<input type="radio" name="sex" value="女" checked/>女
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="注册"/>
</td>
</tr> 
        </table>
     </form>
  </body>
</html>


标签：

相关文章