spring4.2+struts2.5+jdbc实例-PIMS（一）

环境

工具：Eclipse neon3、Tomcat8.0、mySQL5.6
jdk版本：jdk-1.8-x64
所使用框架：struts2.5，spring4.2，jdbc
实现功能：登录、注册，个人信息管理，日程管理，朋友信息管理
实例所需Jar包下载
实例源码下载

---

代码结构

---

框架配置

---

web.xml配置：

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">  <display-name>PIMS</display-name>  <context-param>    <param-name>contextConfigLocation</param-name>    <param-value>/WEB-INF/applicationContext.xml</param-value>  </context-param>  <listener>    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>  <filter>    <filter-name>struts2</filter-name>    <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>  </filter>  <filter-mapping>    <filter-name>struts2</filter-name>    <url-pattern>/*</url-pattern>  </filter-mapping>  <welcome-file-list>    <welcome-file>index.jsp</welcome-file>  </welcome-file-list></web-app>

applicationContext.xml配置：

<?xml version="1.0" encoding="GBK"?><!-- Spring配置文件的根元素，使用spring-beans-4.0.xsd语义约束 --><beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns="http://www.springframework.org/schema/beans"    xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">    <!-- 让Spring管理的Action实例，因为每个action里包含请求的状态信息，所以必须配置scope不能为单例 -->    <bean id="loginAction" class="org.struts.action.login.loginAction" scope="prototype"></bean>    <bean id="registerAction" class="org.struts.action.login.registerAction" scope="prototype"></bean>    <bean id="updateMessAction" class="org.struts.action.mess.updateMessAction" scope="prototype"></bean>    <bean id="updatePassAction" class="org.struts.action.mess.updatePassAction" scope="prototype"></bean>    <bean id="addFriAction" class="org.struts.action.friend.addFriAction" scope="prototype"></bean>    <bean id="findFriAction" class="org.struts.action.friend.findFriAction" scope="prototype"></bean>    <bean id="updateFriAction" class="org.struts.action.friend.updateFriAction" scope="prototype"></bean>    <bean id="deleteFriAction" class="org.struts.action.friend.deleteFriAction" scope="prototype"></bean>    <bean id="addDayAction" class="org.struts.action.date.addDayAction" scope="prototype"></bean>    <bean id="findDayAction" class="org.struts.action.date.findDayAction" scope="prototype"></bean>    <bean id="updateDayAction" class="org.struts.action.date.updateDayAction" scope="prototype"></bean>    <bean id="deleteDayAction" class="org.struts.action.date.deleteDayAction" scope="prototype"></bean></beans>

sturts.xml配置：

<!DOCTYPE struts PUBLIC        "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"        "http://struts.apache.org/dtds/struts-2.5.dtd"><struts>  <package name="default" extends="struts-default">    <!-- 这里action的class属性我们不填实现类的类名，而是填这个action在Spring配置中的bean的名称 -->    <action name="login" class="loginAction" method="execute">        <result name="success" type="redirect">/mainFrame/main.jsp</result>        <result name="input" type="redirect">/index.jsp</result>        <result name="error" type="redirect">/index.jsp</result>    </action>    <action name="register" class="registerAction" method="execute">        <result name="success" type="redirect">/index.jsp</result>        <result name="input" type="redirect">/register.jsp</result>        <result name="error" type="redirect">/register.jsp</result>    </action>    <action name="upMessAction" class="updateMessAction" method="execute">        <result name="success" type="redirect">/personMessage/lookMessage.jsp</result>        <result name="input" type="redirect">/personMessage/updateMessage.jsp</result>        <result name="error" type="redirect">/personMessage/updateMessage.jsp</result>    </action>    <action name="upPassAction" class="updatePassAction" method="execute">        <result name="success" type="redirect">/personMessage/lookMessage.jsp</result>        <result name="input" type="redirect">/personMessage/updatePass.jsp</result>        <result name="error" type="redirect">/personMessage/updatePass.jsp</result>    </action>    <action name="addFri" class="addFriAction" method="execute">        <result name="success" type="redirect">/friendManager/lookFriends.jsp</result>        <result name="input" type="redirect">/friendManager/addFriend.jsp</result>        <result name="error" type="redirect">/friendManager/addFriend.jsp</result>    </action>    <action name="findFriAction" class="findFriAction" method="execute">        <result name="success" type="redirect">/friendManager/findFriends.jsp</result>        <result name="input" type="redirect">/friendManager/lookFriends.jsp</result>        <result name="error" type="redirect">/friendManager/lookFriends.jsp</result>    </action>    <action name="upFriAction" class="updateFriAction" method="execute">        <result name="success" type="redirect">/friendManager/lookFriends.jsp</result>        <result name="input" type="redirect">/friendManager/updateFriend.jsp</result>        <result name="error" type="redirect">/friendManager/updateFriend.jsp</result>    </action>    <action name="deleteFriAction" class="deleteFriAction" method="execute">        <result name="success" type="redirect">/friendManager/lookFriends.jsp</result>        <result name="input" type="redirect">/friendManager/deleteFriend.jsp</result>         <result name="error" type="redirect">/friendManager/deleteFriend.jsp</result>     </action>    <action name="addDayAction" class="addDayAction" method="execute">        <result name="success" type="redirect">/dateTimeManager/lookDay.jsp</result>        <result name="input" type="redirect">/dateTimeManager/addDay.jsp</result>        <result name="error" type="redirect">/dateTimeManager/addDay.jsp</result>    </action>    <action name="findDayAction" class="findDayAction" method="execute">        <result name="success" type="redirect">/dateTimeManager/findDay.jsp</result>        <result name="input" type="redirect">/dateTimeManager/lookDay.jsp</result>        <result name="error" type="redirect">/dateTimeManager/lookDay.jsp</result>    </action>    <action name="upDayAction" class="updateDayAction" method="execute">        <result name="success" type="redirect">/dateTimeManager/lookDay.jsp</result>        <result name="input" type="redirect">/dateTimeManager/updateDay.jsp</result>        <result name="error" type="redirect">/dateTimeManager/updateDay.jsp</result>    </action>    <action name="deleteDayAction" class="deleteDayAction" method="execute">        <result name="success" type="redirect">/dateTimeManager/lookDay.jsp</result>        <result name="input" type="redirect">/dateTimeManager/deleteDay.jsp</result>        <result name="error" type="redirect">/dateTimeManager/deleteDay.jsp</result>    </action>  </package></struts>

数据库连接代码：

public class DB implements ServletRequestAware {    private Connection con = null;    private Statement st = null;    private ResultSet rs = null;    private HttpServletRequest request;    public DB() {         st = getStatement();    }    public void setServletRequest(HttpServletRequest hsr) {        request = hsr;    }    //返回statement对象    public Statement getStatement() {        String url="jdbc:mysql://localhost:3306/pims?useUnicode=true&characterEncoding=utf-8";        try {            Class.forName("com.mysql.jdbc.Driver");            con = DriverManager.getConnection(url,"root","root");            return con.createStatement();        }catch(Exception e) {            e.printStackTrace();            return null;        }    }}