Spring MVC系列：（6）添加用戶的小案例

1、添加數據庫表

使用sqlplus打開數據庫

sqlplus scott/tiger

創建emps數據表

create table emps(
	id varchar(32) not null,
	username varchar(20) not null,
	salary number(6,2),
	hiredate date
);

2、添加jar包

項目需要的jar包有spring-core、spring-web、spring-webmvc、oracle數據庫驅動、c3p0數據庫連接池、dbutils。

3、配置

添加jar包之后，要進行配置：

（1）將springmvc加入到web項目中，需要配置web.xml、springmvc.xml文件

（2）使用c3p0，需要配置c3p0-config.xml文件

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" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>emp</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <!-- 注冊springmvc框架核心控制器 -->
  <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:springmvc.xml</param-value>
      </init-param>
  </servlet>
  <servlet-mapping>
  	<servlet-name>springmvc</servlet-name>
  	<url-pattern>*.action</url-pattern>
  </servlet-mapping>
  
  <!-- 編碼過濾器 -->
  <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>

springmvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    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.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">

	<import resource="com/rk/config/spring-emp.xml"/>
</beans>

c3p0-config.xml

<c3p0-config>
    <default-config>
        <property name="jdbcUrl">jdbc:oracle:thin:@127.0.0.1:1521:orcl</property>
        <property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
        <property name="user">scott</property>
        <property name="password">tiger</property>
		<property name="acquireIncrement">2</property>
		<property name="initialPoolSize">5</property>
		<property name="minPoolSize">1</property>
		<property name="maxPoolSize">5</property>
        <property name="maxIdleTime">1000</property>
    </default-config>
</c3p0-config>

4、工具類編寫

SecurityUtils用來提供UUID，而JDBCUtils用來獲取DataSource。

SecurityUtils.java

package com.rk.utils;

import java.util.UUID;

public class SecurityUtils {
	public static String getUUID()
    {
        return UUID.randomUUID().toString().replaceAll("-", "");
    }
}

JDBCUtils.java

package com.rk.utils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class JDBCUtils {
	/**
	 * 去src目錄下加載c3p0-config.xml配置文件
	 */
	private static ComboPooledDataSource dataSource = new ComboPooledDataSource();
	/**
	 * 獲取數據源
	 */	
	public static ComboPooledDataSource getDataSource() {
		return dataSource;
	}
}

5、從entity到action

Employee.java

package com.rk.entity;

import java.util.Date;

public class Employee {
	private String id;
	private String username;
	private Double salary;
	private Date hiredate;
	public Employee(){}
	
	public Employee(String id, String username, Double salary, Date hiredate) {
		this.id = id;
		this.username = username;
		this.salary = salary;
		this.hiredate = hiredate;
	}


	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public Double getSalary() {
		return salary;
	}
	public void setSalary(Double salary) {
		this.salary = salary;
	}
	public Date getHiredate() {
		return hiredate;
	}
	public void setHiredate(Date hiredate) {
		this.hiredate = hiredate;
	}
	
}

EmpDao.java

package com.rk.dao;

import java.sql.Timestamp;
import java.util.Date;

import org.apache.commons.dbutils.QueryRunner;
import org.junit.Test;

import com.rk.entity.Employee;
import com.rk.utils.JDBCUtils;
import com.rk.utils.SecurityUtils;

public class EmpDao {
	public void add(Employee emp) throws Exception{
		QueryRunner queryRunner = new QueryRunner(JDBCUtils.getDataSource());
		String sql = "insert into emps(id,username,salary,hiredate) values(?,?,?,?)";
		Object[] params = {SecurityUtils.getUUID(),emp.getUsername(),emp.getSalary(),new Timestamp(emp.getHiredate().getTime())};
		queryRunner.update(sql,params);
	}
	
	@Test
	public void run() throws Exception{
		Employee emp = new Employee();
		emp.setUsername("小明");
		emp.setSalary(88.88);
		emp.setHiredate(new Date());
		add(emp);
	}
}

EmpService.java

package com.rk.service;

import com.rk.dao.EmpDao;
import com.rk.entity.Employee;

public class EmpService {
	private EmpDao empDao;
	public void setEmpDao(EmpDao empDao) {
		this.empDao = empDao;
	}
	
	public void register(Employee emp) throws Exception{
		empDao.add(emp);
	}
}

EmpAction.java

package com.rk.action;

import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.validation.BindException;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractCommandController;

import com.rk.entity.Employee;
import com.rk.service.EmpService;

@SuppressWarnings("deprecation")
public class EmpAction extends AbstractCommandController {
	//業務層
	private EmpService empService;
	public void setEmpService(EmpService empService) {
		this.empService = empService;
	}
	//將表單參數封裝到Employee實體中
	public EmpAction(){
		this.setCommandClass(Employee.class);
	}
	
	//自定義String->Date的轉換器
	@Override
	protected void initBinder(HttpServletRequest request, ServletRequestDataBinder binder) throws Exception {
		binder.registerCustomEditor(Date.class, new CustomDateEditor(new SimpleDateFormat("yyyy-MM-dd"), true));
	}
	@Override
	protected ModelAndView handle(HttpServletRequest request, HttpServletResponse response, Object obj, BindException bindException)
			throws Exception {
		ModelAndView modelAndView = new ModelAndView();
		Employee emp = (Employee) obj;
		empService.register(emp);
		
		modelAndView.addObject("message", "操作成功");
		modelAndView.setViewName("success");
		return modelAndView;
	}

}

6、對dao/service/action的配置

spring-emp.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    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.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">

	<!-- 注冊EmpDao類 -->
	<bean id="empDaoID" class="com.rk.dao.EmpDao"></bean>
      
	<!-- 注冊EmpService類 -->
	<bean id="empServiceID" class="com.rk.service.EmpService">
		<property name="empDao" ref="empDaoID"/>
	</bean>

	<!-- 注冊Action -->
	<bean name="/add.action" class="com.rk.action.EmpAction">
		<property name="empService" ref="empServiceID"/>
	</bean>

	<!-- /index.action請求，直接轉發到/jsp/index.jsp頁面 -->
	<bean name="/index.action" class="org.springframework.web.servlet.mvc.ParameterizableViewController">
		<property name="viewName" value="index"></property>
	</bean>

    <!-- 映射器(框架) -->  
    <bean class="org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping"></bean> 
       
    <!-- 適配器(框架) -->  
    <bean class="org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter"></bean>  
	
	<!-- 視圖解析器（框架） -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/jsp/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
</beans>

7、JSP頁面

WebRoot/jsp/index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>添加員工</title>
  </head>
  
  <body>
    <form action="${pageContext.request.contextPath}/add.action" method="post">
    	<table border="1" >
    		<tr>
    			<td>員工姓名：</td>
    			<td><input type="text" name="username"/></td>
    		</tr>
    		<tr>
    			<td>員工薪水：</td>
    			<td><input type="text" name="salary"/></td>
    		</tr>
    		<tr>
    			<td>入職時間：</td>
    			<td><input type="text" name="hiredate"/></td>
    		</tr>
    		<tr>
    			<td colspan="2">
    				<input type="submit" value="提交"/>
    			</td>
    		</tr>
    	</table>
    </form>
  </body>
</html>

WebRoot/jsp/success.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>添加成功</title>
  </head>
  
  <body>
	${message }
  </body>
</html>

演示