SSI整合小例子-增删改查

一，数据库设计

create database ibatis;         --创建数据库ibatis
use ibatis;


create table sperson
(
 id int primary key auto_increment,
 name varchar(50),
 sex varchar(20),
 age int,
 salary float
);

二，搭建框架，创建web项目

打开MyEclipse8.5新建一个web project如图：

填写完项目名称后选择Java EE 5.0，点finish.

添加Spring支持：

选择spring2.5，这里的包默认就可以，因为jar包冲突所以我将不会使用MyEclipse里自带的包，这里我只要后边这个文件 如图：点next

将applicationContext.xml放在src文件夹下，即Folder的路径是src，点finish。

然后我将把导入的spring包删除

导入自己的包

点next

选择你要导入的spring的jar包，放在test/WebRoot/WEB-INF/lib目录下，finish。

接下来导入struts：

选择struts2.1 和  /*

点finish。然后删除导入的struts包，引入自己的jar包

finish.

引入其他jar包的方法：

选择好jar包后就能引入。本程序所用到的所有jar包为：

三，配置SSI3三部分所需要的配置文件

 （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">
 <!-- 配置Spring -->
 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>
   WEB-INF/classes/com/us/jack/config/applicationContext.xml
   WEB-INF/classes/com/us/jack/config/applicationContext-services.xml
  </param-value>
 </context-param>
 <listener>
  <listener-class>
   org.springframework.web.context.ContextLoaderListener
  </listener-class>
 </listener>
 <!-- 配置Struts2 -->
 <filter>
  <filter-name>struts2</filter-name>
  <filter-class>
   org.apache.struts2.dispatcher.FilterDispatcher
  </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>

(2)  Struts2部分

struts.xml部分：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
 <include file="com/us/jack/action/sbookAction.xml"></include>
</struts>

spersonAction.xml部分：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
 
 <constant name="struts.i18n.encoding" value="GBK"/> 
 <package name="sperson" extends="struts-default" namespace="/user">
    
  <!-- 添加员工信息 记住：class="spersonAction"中的 spersonAction是在applicationContext-services.xml文件被Spring管理-->
  <action name="addSPerson" class="spersonAction" method="addSPerson">
   <result name="success">/addPerson.jsp</result>
   <result name="error">/addPerson.jsp</result>
  </action>
  
  <!-- 你也可以下面这种写：这种就没有给Spring控制了
  
  <action name="addSPerson" class="com.bjsxt.ssi2.action.SPersonAction" method="addSPerson">
   <result name="success">/addPerson.jsp</result>
   <result name="error">/addPerson.jsp</result>
  </action>
   -->
  
  <!-- 查看全部员工信息 -->
  <action name="viewSPerson" class="spersonAction" method="viewSPerson">
   <result name="success">/viewPerson.jsp</result>
   <result name="error">/viewPerson.jsp</result>
  </action>
  
  <!-- 通过ID查找员工 -->
  <action name="modifySPerson" class="spersonAction" method="modifySPerson">
   <result name="success">/personMsg.jsp</result>
   <result name="error">/personMsg.jsp</result>
  </action>
  
  <!-- 更新员工 -->
  <action name="updateSPerson" class="spersonAction" method="updateSPerson">
   <result name="success" type="redirectAction">viewSPerson</result>      <!-- action重定向 -->
   <result name="error">/personMsg.jsp</result>
  </action>
  
  <!-- 删除员工 -->
  <action name="removeSPerson" class="spersonAction" method="removeSPerson">
   <result name="success" type="redirectAction">viewSPerson</result>
   <result name="error" type="redirectAction">viewSPerson</result>
  </action>


   
 </package>
</struts>

(3) Spring部分

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">
   
   <!--配置一个数据源,根据上面propertyConfig指定的location去找数据库连接的配置信息-->  
  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<!-- 
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:thin:@134.224.15.38:1521:test38"/>
-->
  <property name="driverClassName" value="com.mysql.jdbc.Driver" />
  <property name="url" value="jdbc:mysql://localhost:3306/ibatis" />
  <property name="username" value="root" />
  <property name="password" value="root" />
  <property name="maxActive" value="100"/>
        <property name="maxIdle" value="30"/>
        <property name="maxWait" value="1000"/>
        <property name="logAbandoned" value="true"/>
        <property name="defaultAutoCommit" value="true"/>
        <property name="removeAbandoned" value="true"/>
        <property name="removeAbandonedTimeout" value="60"/>
  </bean>


 <!-- SqlMap setup for iBATIS Database Layer -->
  <bean id="sqlMapClient"
  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation">
<value>classpath:sqlMapConfig.xml</value>
</property>
<property name="dataSource">
<ref bean="dataSource" />
</property>
 
   </bean>
 
<!--根据sqlMapClien创建一个SqlMapClient模版类-->     
<bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">  


  
  <property name="sqlMapClient">   
  <ref bean="sqlMapClient" />   
  </property>   
</bean>   
 


<!--将上面的模版类织入到我们的DAO对象中(注入PersonDAO层)-->   
  <bean id="spersonDAO" class="com.bjsxt.ssi3.dao.impl.SPersonDAO">
  <property name="sqlMapClientTemplate">   
    <ref bean="sqlMapClientTemplate" />   
  </property>   
    </bean>
 
</beans>

applicationContext-services.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:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="
   http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
   http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
 
 <!-- 将业务逻辑Service类交给DAO去处理 -->
 <bean id="spersonServices" class="com.bjsxt.ssi3.services.impl.SPersonServices">
  <property name="spersonDAO" ref="spersonDAO"/>
 </bean>
 
 <!-- 将PeractionAction交给Spring控制 -->
 <bean id="spersonAction" class="com.bjsxt.ssi3.action.SPersonAction">
  <property name="spersonServices" ref="spersonServices"/>
 </bean>
 
 <!-- Transaction manager for a single JDBC DataSource -->
 <bean id="transactionManager"
  class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource" />
 </bean>


 <aop:config>
  <!-- 管理事务操作 -->
  <aop:pointcut id="servicesPointcut"
   expression="execution(* com.bjsxt.ssi3.services.*.*(..))" />
  <aop:advisor advice-ref="txAdvice"
   pointcut-ref="servicesPointcut" />
 </aop:config>
 
 <!-- 事务控制 -->
 <tx:advice id="txAdvice" transaction-manager="transactionManager">
  <tx:attributes>
   <tx:method name="save*" propagation="REQUIRED" />
   <tx:method name="update*" propagation="REQUIRED" />
   <tx:method name="remove*" propagation="REQUIRED" />
   <tx:method name="get*" read-only="true" />
  </tx:attributes>
 </tx:advice>
</beans>

四， IBatis部分

sqlMapConfig.xml部分：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
 <sqlMap resource="com/bjsxt/ssi3/dao/impl/SPerson.xml"/>
</sqlMapConfig>

SPerson.xml部分：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>


 <typeAlias alias="sperson" type="com.bjsxt.ssi3.vo.SPerson" />
 
 <!-- 添加一新员工-->
 <insert id="savePerson" parameterClass="sperson">
  <selectKey keyProperty="id" resultClass="int">
   <![CDATA[
    SELECT LAST_INSERT_ID() AS VALUE
   ]]>
  </selectKey>
  <![CDATA[
   INSERT INTO sperson(name,sex,age,salary)
   VALUES(#name#,#sex#,#age#,#salary#)
  ]]>
 </insert>
 
 <!-- 删除员工 -->
 <delete id="deletePerson" parameterClass="int">
  <![CDATA[
   DELETE FROM SPERSON WHERE ID=#id#
  ]]>
 </delete>
 
 <!-- 查找所有的员工 -->
 <select id="findAllPerson" resultClass="sperson">
  <![CDATA[
   SELECT * FROM sperson 
  ]]>
 </select>
 <!-- 更新员工信息 -->
 <update id="updatePerson" parameterClass="sperson">
  <![CDATA[
   UPDATE SPERSON SET 
   name=#name#,sex=#sex#,salary=#salary#
   WHERE id=#id#
  ]]>
 </update>
 <!-- 查找特定员工 -->
 <select id="findPersonById" parameterClass="int" resultClass="sperson">
  <![CDATA[
   SELECT * FROM sperson WHERE ID=#id#
  ]]>
 </select>
</sqlMap>

五，后台代码部分

1、vo实体类部分：SPerson.java

package com.bjsxt.ssi3.vo;
/**
 * 员工类
 * @author xia
 * 
 * 其实就是JavaBen，对应的名字与表名一致
 *
 */
public class SPerson {
private int id;
private String name;
private String sex;
private int age;
private float salary;


public int getId() {
 return id;
}

public void setId(int id) {
 this.id = id;
}


public String getName() {
return name;
}


public void setName(String name) {
this.name = name;
}


public String getSex() {
return sex;
}


public void setSex(String sex) {
this.sex = sex;
}


public float getSalary() {
return salary;
}


public void setSalary(float salary) {
this.salary = salary;
}


public int getAge() {
return age;
}


public void setAge(int age) {
this.age = age;
}

}

2、DAO层

ISPersonDAO.java文件：

package com.bjsxt.ssi3.dao;


import java.util.List;


import com.bjsxt.ssi3.vo.SPerson;


/****
 * DAO层
 * @author Administrator
 *
 */
public interface ISPersonDAO {
/**
 * 添加一员工至数据库中
 * 
 * @param person
 *            员工对象
 * @throws RuntimeException
 */
public void savePerson(SPerson person) throws RuntimeException;

/**
 * 删除员工信息
 * 
 * @param id
 *            ID编码
 * @throws RuntimeException
 */
public void deletePerson(int id) throws RuntimeException;

/**
 * 更新一员工的信息
 * 
 * @param person
 *           员工对象
 * @throws RuntimeException
 */
/**
 */
public void updatePerson(SPerson person) throws RuntimeException;

/**
 * 查找库中所有的员工
 * 
 * @return 返回员工列表列表
 * @throws RuntimeException
 */
public List findAllPerson() throws RuntimeException;

/**
 * 通过ID查找特定的员工
 * 
 * @param id
 *            员工的ID号
 * @return 返回此ID对应的员工信息
 * @throws RuntimeException
 */
public SPerson findPersonById(int id) throws RuntimeException;
}

SPersonDAO.java文件：

package com.bjsxt.ssi3.dao.impl;


import java.util.List;
import org.springframework.orm.ibatis.SqlMapClientTemplate;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.bjsxt.ssi3.vo.SPerson;
import com.bjsxt.ssi3.dao.ISPersonDAO;

public class SPersonDAO implements ISPersonDAO {

private SqlMapClientTemplate sqlMapClientTemplate;         //sqlMapClientTemplate 在applicationContext.xml配置 

public SqlMapClientTemplate getSqlMapClientTemplate() {
return sqlMapClientTemplate;
}

public void setSqlMapClientTemplate(SqlMapClientTemplate sqlMapClientTemplate) {
this.sqlMapClientTemplate = sqlMapClientTemplate;
}
 

/***
 * //注意:insert("","")方法,第一个参数与SPerson.xml中的select元素的id属性值对应，第2个参数是传进来的参数    
 */
public void savePerson(SPerson person) throws RuntimeException {
 
sqlMapClientTemplate.insert("savePerson", person);
 
}
 

public void deletePerson(int id) throws RuntimeException {
 
sqlMapClientTemplate.delete("deletePerson", id);
}

public void updatePerson(SPerson person) throws RuntimeException {
 
sqlMapClientTemplate.update("updatePerson", person);
 
}

@SuppressWarnings("unchecked")
public List findAllPerson() throws RuntimeException {
 
List findList = null; 
 
try {
findList = (List)sqlMapClientTemplate.queryForList("findAllPerson");
 
}catch (Exception e) {
e.printStackTrace();
}
 
return findList;
 
}

/****
 * 通过ID查询
 */
public SPerson findPersonById(int id) throws RuntimeException {
 
SPerson sPerson = null;

try {

sPerson = (SPerson)sqlMapClientTemplate.queryForObject( "findPersonById", id);
}catch (Exception e) {
e.printStackTrace();
}

return sPerson;
}
 
}

3、业务逻辑层部分

ISPersonServices.java文件：

ISPersonServices.java文件：
package com.bjsxt.ssi3.services;


import java.util.List;
import com.bjsxt.ssi3.vo.SPerson;

public interface ISPersonServices {
/**
 * 添加一员工至数据库中
 * 
 * @param person
 *            员工对象
 * @throws RuntimeException
 */
public void savePerson(SPerson person) throws RuntimeException;

/**
 * 删除员工信息
 * 
 * @param id
 *            ID编码
 * @throws RuntimeException
 */
public void removePerson(int id) throws RuntimeException;


/**
 * 更新一员工的信息
 * 
 * @param person
 *            员工对象
 * @throws RuntimeException
 */
public void updatePerson(SPerson person) throws RuntimeException;

/**
 * 查找库中所有的员工
 * 
 * @return 返回员工列表
 * @throws RuntimeException
 */
public List getAllPerson() throws RuntimeException;

/**
 * 通过员工ID号得到员工对象
 * 
 * @param id
 *            员工ID号码
 * @return 返回此ID对应的员工信息
 * @throws RuntimeException
 */
public SPerson getPersonById(int id) throws RuntimeException;
}

SPersonServices.java文件：

package com.bjsxt.ssi3.services;


import java.util.List;
import com.bjsxt.ssi3.vo.SPerson;

public interface ISPersonServices {
/**
 * 添加一员工至数据库中
 * 
 * @param person
 *            员工对象
 * @throws RuntimeException
 */
public void savePerson(SPerson person) throws RuntimeException;

/**
 * 删除员工信息
 * 
 * @param id
 *            ID编码
 * @throws RuntimeException
 */
public void removePerson(int id) throws RuntimeException;


/**
 * 更新一员工的信息
 * 
 * @param person
 *            员工对象
 * @throws RuntimeException
 */
public void updatePerson(SPerson person) throws RuntimeException;

/**
 * 查找库中所有的员工
 * 
 * @return 返回员工列表
 * @throws RuntimeException
 */
public List getAllPerson() throws RuntimeException;

/**
 * 通过员工ID号得到员工对象
 * 
 * @param id
 *            员工ID号码
 * @return 返回此ID对应的员工信息
 * @throws RuntimeException
 */
public SPerson getPersonById(int id) throws RuntimeException;
}

4、控制层

SPersonAction.JAVA文件：

package com.bjsxt.ssi3.action;


import java.util.List;
import com.bjsxt.ssi3.services.ISPersonServices;
import com.bjsxt.ssi3.vo.SPerson;
import com.opensymphony.xwork2.ActionSupport;

public class SPersonAction extends ActionSupport {

private ISPersonServices spersonServices;
private SPerson sperson;
private String tips;
private String personId;
 
private List personList;


/**
 * 添加员工信息
 * 
 * @return 返回添加是否成功
 */
public String addSPerson() {
 
 String result = "error";
 
 try {
  spersonServices.savePerson(sperson);
  this.setTips("添加成功");
  
  result = "success";
  
 } catch (Exception e) {
  e.printStackTrace();
  this.setTips("系统出现问题");
 }
 
 return result;
}


/**
 * 查看所有员工
 * 
 * @return
 */
public String viewSPerson() {
 String result = "error";
 try {
  personList = spersonServices.getAllPerson();
  result = "success";
 } catch (Exception e) {
  e.printStackTrace();
  this.setTips("系统出现问题，请稍后访问");
 }
 return result;
}


/**
 * 修改员工信息
 * 
 * @return
 */
public String modifySPerson() {
 String result = "error";
 try {
  sperson = spersonServices.getPersonById(Integer.parseInt(this.getPersonId()));
  result = "success";
 } catch (Exception e) {
  e.printStackTrace();
  this.setTips("系统出现问题");
 }
 return result;
}


public String updateSPerson(){
 String result = "error";
 try{
  spersonServices.updatePerson(sperson);
  result = "success";
 }catch(Exception e){
  e.printStackTrace();
  this.setTips("更新操作失败");
 }
 return result;
}
 
/**
 * 删除图书
 * @return
 */
public String removeSPerson(){
 String result = "error";
 try{
  spersonServices.removePerson(Integer.parseInt(this.getPersonId()));
  result = "success";
 }catch(Exception e){
  e.printStackTrace();
  this.setTips("删除操作失败");
 }
 return result;
}
 
public SPerson getSperson() {
 return sperson;
}


public void setSperson(SPerson sperson) {
 this.sperson = sperson;
}


public void setSpersonServices(ISPersonServices spersonServices) {
 this.spersonServices = spersonServices;
}




public String getTips() {
 return tips;
}

public void setTips(String tips) {
 this.tips = tips;
}

public String getPersonId() {
return personId;
}

public void setPersonId(String personId) {
this.personId = personId;
}

public List getPersonList() {
return personList;
}

public void setPersonList(List personList) {
this.personList = personList;
}
}

（五）前台页面的开发

1、增加页面文件addPerson.jsp

<%@ page language="java"  pageEncoding="GBK"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>添加员工</title>
  </head>


  <body>
   <s:property value="tips"/>           <!--s:property 拿到Action类中定义的属性值，tips表示属性  -->
    <s:form action="addSPerson" method="post"  namespace="/user">
     <s:textfield name="sperson.name" label="姓名"/>
     <s:textfield name="sperson.sex" label="性别"/>
     <s:textfield name="sperson.age" label="年龄"/>
     <s:textfield name="sperson.salary" label="薪水"/>
     <s:submit value="添加"/>
    </s:form>
    <a href="<%=request.getContextPath() %>/user/viewSPerson.action">查看现有员工</a>
  </body>
</html>

2、修改页面文件personMsg.jsp

<%@ page language="java" pageEncoding="GBK"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
  <title>修改员工信息</title>
 </head>


 <body>
  <s:form action="updateSPerson" method="post"  namespace="/user">
   <s:hidden name="sperson.id">${id}</s:hidden>
   <s:textfield name="sperson.name" label="姓名" readonly="true">${name}</s:textfield>
   <s:textfield name="sperson.sex" label="性别">${sex}</s:textfield>
   <s:textfield name="sperson.age" label="年龄">${age}</s:textfield>
   <s:textfield name="sperson.salary" label="薪水">${salary}</s:textfield>
   <s:submit/>
  </s:form>
  <s:property value="tips" />
 </body>
</html>

3、登录页面文件index.jsp

<%@ page language="java" pageEncoding="GBK"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>员工管理页面</title>
 <meta http-equiv="pragma" content="no-cache">
 <meta http-equiv="cache-control" content="no-cache">
 <meta http-equiv="expires" content="0">    
 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
 <meta http-equiv="description" content="This is my page">
  </head> 
  <body>
    <a href="addPerson.jsp">添加员工</a>
    <a href="user/viewSPerson.action">浏览员工</a>
  </body>
</html>

4、浏览页面文件viewPerson.jsp

<%@ page language="java" pageEncoding="GBK"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head>
  <title>浏览员工</title>
 </head>


 <body>
  <table align="center" border="1" style="width:80%;">
   <tr>
    <th colspan="7" align="center">员工信息</th>
   </tr>
   <tr>
    <td align="left" colspan="7"><a href="<%=request.getContextPath()%>/addPerson.jsp">添加员工</a></td>
   </tr>
   <tr>
    <td>姓名</td>
    <td>性别</td>
    <td>年龄</td>
    <td>薪水</td>
    <td>操作</td>
   </tr>
   <s:iterator value="personList">        <!-- 表示的是SPersonAction.java类中定义List对象personList -->
    <tr>
     <td>
      <s:property value="name"/>
     </td>
     <td>
      <s:property value="sex"/>
     </td>
     <td>
      <s:property value="age"/>
     </td>
     <td>
      <s:property value="salary"/>
     </td>
     <td>
      <a href="<%=request.getContextPath()%>/user/modifySPerson.action?personId=${id}">修改信息</a>
      <a href="<%=request.getContextPath()%>/user/removeSPerson.action?personId=${id}">删除</a>
     </td>
    </tr>
   </s:iterator>
   <s:property value="tips"/>
  </table>
 </body>
</html>