Spring：使用JdbcTemplate的简单实例-基于XML文件配置

 

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

    <welcome-file-list>

       <welcome-file>index.jsp</welcome-file>

    </welcome-file-list>

    <servlet>

       <servlet-name>Dispatcher</servlet-name>

       <servlet-class>

           org.springframework.web.servlet.DispatcherServlet

       </servlet-class>

       <init-param>

           <param-name>contextConfigLocation</param-name>

           <param-value>/WEB-INF/applicationContext.xml</param-value>

       </init-param>

    </servlet>

    <servlet-mapping>

       <servlet-name>Dispatcher</servlet-name>

       <url-pattern>*.do</url-pattern>

    </servlet-mapping>

    <filter>

       <filter-name>encodingFilter</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>encodingFilter</filter-name>

       <url-pattern>/*</url-pattern>

    </filter-mapping>

 

 

 

 

</web-app>

 

2. applicationContext.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"

    xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <bean id="viewResolver"

       class="org.springframework.web.servlet.view.InternalResourceViewResolver">

       <property name="viewClass">

           <value>org.springframework.web.servlet.view.JstlView</value>

       </property>

       <property name="prefix">

           <value>/</value>

       </property>

       <property name="suffix">

           <value>.jsp</value>

       </property>

    </bean>

   

    <bean id="dataSource"

       class="org.apache.commons.dbcp.BasicDataSource">

       <property name="driverClassName"

           value="oracle.jdbc.driver.OracleDriver">

       </property>

       <property name="url"

           value="">

       </property>

       <property name="username" value=""></property>

       <property name="password" value=""></property>

    </bean>

 

    <bean id="paramMethodResolver"

       class="org.springframework.web.servlet.mvc.multiaction.ParameterMethodNameResolver">

       <property name="paramName">

           <value>action</value>

       </property>

       <property name="defaultMethodName">

           <value>view</value>

       </property>

    </bean>

 

    <bean id="urlHandlerMapping"

       class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">

       <property name="mappings">

           <props>

              <prop key="login.do">LoginController</prop>

           </props>

       </property>

    </bean>

 

    <bean id="loginDao" class="com.lz.dao.LoginDao">

       <property name="dataSource">

           <ref bean="dataSource" />

       </property>

    </bean>

 

    <bean id="LoginController" class="com.lz.web.LoginController">

       <property name="formView" value="index" />

       <property name="successView" value="index" />

       <property name="loginDao">

           <ref bean="loginDao" />

       </property>

       <property name="methodNameResolver">

           <ref bean="paramMethodResolver" />

       </property>

    </bean>

 

    <bean id="transactionManager"

       class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

       <property name="dataSource">

           <ref local="dataSource" />

       </property>

    </bean>

 

    <bean id="loginDaoTransaction"

       class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">

       <property name="transactionManager">

           <ref local="transactionManager" />

       </property>

       <property name="target">

           <ref local="loginDao" />

       </property>

       <property name="transactionAttributes">

           <props>

              <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>

              <prop key="*">PROPAGATION_REQUIRED</prop>

           </props>

       </property>

    </bean>

</beans>

 

3. LoginDao.java

package com.lz.dao;

 

import org.springframework.jdbc.core.support.JdbcDaoSupport;

 

public class LoginDao extends JdbcDaoSupport {

    public int save(Long id, String a) {

       String sql = "insert into a values(?,?)";

       return getJdbcTemplate().update(sql, new Object[] { id, a });

    }

}

 

4. LoginController.java

package com.lz.web;

 

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

 

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.mvc.multiaction.MultiActionController;

 

import com.lz.dao.LoginDao;

 

public class LoginController extends MultiActionController {

    private String formView;

    private String successView;

    private LoginDao loginDao;

 

    public ModelAndView view(HttpServletRequest request,

           HttpServletResponse response) throws Exception {

       return new ModelAndView(formView);

    }

 

    public ModelAndView save(HttpServletRequest request,

           HttpServletResponse response) throws Exception {

       loginDao.save(0l, "C");

       return new ModelAndView(successView);

    }

 

    public void setFormView(String formView) {

       this.formView = formView;

    }

 

    public void setSuccessView(String successView) {

       this.successView = successView;

    }

 

    public void setLoginDao(LoginDao loginDao) {

       this.loginDao = loginDao;

    }

}

 

5. index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

    <head>

       <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

       <title>Insert title here</title>

    </head>

 

    <body>

       <a href="login.do?action=save">save</a>

    </body>

</html>