devbox
知新_RL
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

SSH实例（简单地增删改查功能）_用ssh框架做的增删改查案例

作者：知新_RL | 2024-03-03 17:38:40

赞

踩

用ssh框架做的增删改查案例

在网上看到一篇写的很不错的关于SSH 整合实现简单的增删改查功能的实例。

因为也是初次使用SSH框架，如有不足，请多指教。

先看一下我们完整的工程目录：

 好了  我们废话不多说 直接上操作：

1.(1.)Dept   我们的Bean  包名：com.bdqn.entity(根据自己的习惯定义就可以)

  1. package com.bdqn.entity;
  2.  
  3. import java.io.Serializable;
  4.  
  5. public class Dept implements Serializable {
  6.  
  7. 	//封装字段
  8. 	private int deptno;
  9. 	private String dname;
  10. 	private String loc;
  11. 	
  12. 	//无参构造函数
  13. 	public Dept() {
  14. 		// TODO Auto-generated constructor stub
  15. 	}
  16. 	
  17. 	//有参构造函数
  18. 	public Dept(int deptno, String dname, String loc) {
  19. 		super();
  20. 		this.deptno = deptno;
  21. 		this.dname = dname;
  22. 		this.loc = loc;
  23. 	}
  24.  
  25. 	//封装GET SET方法
  26. 	public int getDeptno() {
  27. 		return deptno;
  28. 	}
  29. 	public void setDeptno(int deptno) {
  30. 		this.deptno = deptno;
  31. 	}
  32. 	public String getDname() {
  33. 		return dname;
  34. 	}
  35. 	public void setDname(String dname) {
  36. 		this.dname = dname;
  37. 	}
  38. 	public String getLoc() {
  39. 		return loc;
  40. 	}
  41. 	public void setLoc(String loc) {
  42. 		this.loc = loc;
  43. 	}
  44. }

(2.)Dept.hbm.xml  配置映射文件：

  1. <?xml version="1.0"?>
  2. <!DOCTYPE hibernate-mapping PUBLIC 
  3. 	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
  4. 	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  5. <!--  Dept实体的映射文件
  6.       把实体类的属性和表中的字段映射在一起
  7.  -->
  8. <hibernate-mapping package="com.bdqn.entity">
  9.  
  10. 	<class name="com.bdqn.entity.Dept" table="dept">
  11. 		<!-- 配置主键 -->
  12. 		<id name="deptno"   >
  13. 			<!-- 主键生成策略 -->
  14. 			<generator class="increment"/>
  15. 		</id>
  16. 		<property name="dname"  />
  17. 		<property name="loc" />
  18. 		
  19. 	</class>
  20.  
  21. </hibernate-mapping>

2.IDeptDao  配置接口   包名：com.bdqn.dao(根据自己的习惯定义就可以)

  1. package com.bdqn.dao;
  2.  
  3. import java.util.List;
  4.  
  5. import com.bdqn.entity.Dept;
  6. /**
  7.  * 定义接口
  8.  * @author 萌萌里的小高冷
  9.  *
  10.  */
  11. public interface IDeptDao {
  12. 	//查询
  13. 	public List<Dept> findAll();
  14. 	//增加
  15. 	public int save(Dept d);
  16. 	//删除
  17. 	public int delete(int id);
  18. 	//修改
  19. 	public int update(Dept d);
  20. 	//根据ID查询
  21. 	public Dept findById(int id);
  22. 	
  23. }


3.DeptDaoImpl  配置实现类  包名：com.bdqn.dao.impl(根据自己的习惯定义就可以)

  1. package com.bdqn.dao.impl;
  2.  
  3. import java.util.List;
  4.  
  5. import org.hibernate.SessionFactory;
  6. import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
  7.  
  8. import com.bdqn.dao.IDeptDao;
  9. import com.bdqn.entity.Dept;
  10.  
  11. public class DeptDaoImpl 
  12. extends HibernateDaoSupport
  13. implements IDeptDao {
  14.  
  15. 	public int delete(int id) {
  16. 		// TODO Auto-generated method stub
  17. 		try {
  18. 			//获取对象的id
  19. 			Dept d=this.getHibernateTemplate().get(Dept.class,id);
  20. 			//执行删除方法  删除id
  21. 			this.getHibernateTemplate().delete(d);
  22. 			//删除成功  return 1;
  23. 			return 1;
  24. 		} catch (Exception e) {
  25. 			// TODO: handle exception
  26. 			System.out.println(e.getMessage());
  27. 			System.out.println(e.getStackTrace());
  28. 		}
  29. 		return 0;
  30. 	}
  31.  
  32. 	public List<Dept> findAll() {
  33. 		// TODO Auto-generated method stub
  34. 		//查询获取全部的数据
  35. 		List<Dept> list=(List<Dept>) this.getHibernateTemplate().find("from Dept");
  36. 		return list;
  37. 	}
  38.  
  39. 	public Dept findById(int id) {
  40. 		// TODO Auto-generated method stub
  41. 		//查询出对象的id
  42. 		Dept dd=this.getHibernateTemplate().get(Dept.class, id);
  43. 		return dd;
  44. 	}
  45.  
  46. 	public int save(Dept d) {
  47. 		// TODO Auto-generated method stub
  48. 		try {
  49. 			//调用我们定义的接口  增加数据
  50. 			this.getHibernateTemplate().save(d);
  51. 			return 1;
  52. 		} catch (Exception e) {
  53. 			// TODO: handle exception
  54. 			System.out.println(e.getMessage());
  55. 			System.out.println(e.getStackTrace());
  56. 		}
  57. 		return 0;
  58. 	}
  59.  
  60. 	public int update(Dept d) {
  61. 		// TODO Auto-generated method stub
  62. 		try {
  63. 			//调用我们定义的接口  增加数据
  64. 			this.getHibernateTemplate().update(d);
  65. 			return 1;
  66. 		} catch (Exception e) {
  67. 			// TODO: handle exception
  68. 			System.out.println(e.getMessage());
  69. 			System.out.println(e.getStackTrace());
  70. 		}
  71. 		return 0;
  72. 	}
  73. }


4.IDeptService 配置我们的业务逻辑层  包名：com.bdqn.service(根据自己的习惯定义就可以)

  1. package com.bdqn.service;
  2.  
  3. import java.util.List;
  4.  
  5. import com.bdqn.entity.Dept;
  6.  
  7. public interface IDeptService {
  8. 	//跟我们的dao层一样
  9. 	public List<Dept> findAll();
  10. 	public boolean save(Dept d);
  11. 	public boolean delete(int id);
  12. 	public boolean update(Dept d);
  13. 	public Dept findById(int id);
  14. }


5.DeptServiceImpl   包名：com.bdqn.service.Impl(根据自己的习惯定义就可以)

  1. package com.bdqn.service.impl;
  2.  
  3. import java.util.List;
  4.  
  5. import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
  6.  
  7. import com.bdqn.dao.IDeptDao;
  8. import com.bdqn.dao.impl.DeptDaoImpl;
  9. import com.bdqn.entity.Dept;
  10. import com.bdqn.service.IDeptService;
  11.  
  12. public class DeptServiceImpl extends HibernateDaoSupport implements IDeptService{
  13. 	// 调用我们实现类的接口  定义成私有字段进行封装
  14. 	private IDeptDao idd;
  15. 	//查询
  16. 	public List<Dept> findAll() {
  17. 		// TODO Auto-generated method stub
  18. 		return this.idd.findAll();
  19. 	}
  20.  
  21. 	//增加
  22. 	public boolean save(Dept d) {
  23. 		// TODO Auto-generated method stub
  24. 		int aa=this.idd.save(d);
  25. 		if(aa==0){
  26. 			return true;
  27. 		}else{
  28. 			return false;
  29. 		}
  30. 	}
  31.  
  32. 	//删除
  33. 	public boolean delete(int id) {
  34. 		// TODO Auto-generated method stub
  35. 		int aa=this.idd.delete(id);
  36. 		if(aa==0){
  37. 			return true;
  38. 		}else{
  39. 			return false;
  40. 		}
  41. 	}
  42.  
  43. 	//修改
  44. 	public boolean update(Dept d) {
  45. 		// TODO Auto-generated method stub
  46. 		int aa=this.idd.update(d);
  47. 		if(aa==0){
  48. 			return true;
  49. 		}else{
  50. 			return false;
  51. 		}
  52. 	}
  53.  
  54. 	//根据ID查询
  55. 	public Dept findById(int id) {
  56. 		// TODO Auto-generated method stub
  57. 		return this.idd.findById(id);
  58. 	}
  59.  
  60. 	//封装的GET  SET方法
  61. 	public IDeptDao getIdd() {
  62. 		return idd;
  63. 	}
  64.  
  65. 	public void setIdd(IDeptDao idd) {
  66. 		this.idd = idd;
  67. 	}
  68. 	
  69. }


6.DeptAction   包名：com.bdqn.action(根据自己的习惯定义就可以)

  1. package com.bdqn.action;
  2.  
  3. import java.util.List;
  4.  
  5. import com.bdqn.dao.IDeptDao;
  6. import com.bdqn.entity.Dept;
  7. import com.bdqn.service.IDeptService;
  8. import com.opensymphony.xwork2.ActionSupport;
  9.  
  10. public class DeptAction extends ActionSupport {
  11. 	
  12. 	//定义出来我们的对象名  id  以及泛型集合
  13. 	private IDeptService ids;
  14. 	private List<Dept> list;
  15. 	private Dept dept;
  16. 	private int id;
  17. 	
  18. 	//查询
  19. 	public String show(){
  20. 		list=ids.findAll();
  21. 		return "zhanshi";
  22. 	}
  23. 	
  24. 	//删除
  25. 	public String delete(){
  26. 		ids.delete(id);
  27. 		return "find";
  28. 		
  29. 	}
  30. 	
  31. 	//预修改
  32. 	public String prepup(){
  33. 		dept=ids.findById(id);
  34. 		return "prepup";
  35. 	}
  36. 	
  37. 	//增加
  38. 	public String save(){
  39. 		ids.save(dept);
  40. 		return "find";
  41. 	}
  42.  
  43. 	//修改
  44. 	public String update(){
  45. 		ids.update(dept);
  46. 		return "find";
  47. 	}
  48. 	
  49. 	
  50. 	public IDeptService getIds() {
  51. 		return ids;
  52. 	}
  53.  
  54. 	public void setIds(IDeptService ids) {
  55. 		this.ids = ids;
  56. 	}
  57.  
  58. 	public List<Dept> getList() {
  59. 		return list;
  60. 	}
  61.  
  62. 	public void setList(List<Dept> list) {
  63. 		this.list = list;
  64. 	}
  65.  
  66. 	public Dept getDept() {
  67. 		return dept;
  68. 	}
  69.  
  70. 	public void setDept(Dept dept) {
  71. 		this.dept = dept;
  72. 	}
  73.  
  74. 	public int getId() {
  75. 		return id;
  76. 	}
  77. 	
  78. 	public void setId(int id) {
  79. 		this.id = id;
  80. 	}
  81. 	
  82. }


JSP页面：

index.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%
  3. String path = request.getContextPath();
  4. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  5. %>
  6.  
  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9.   <head>
  10.     <base href="<%=basePath%>">
  11.     
  12.     <title>My JSP 'index.jsp' starting page</title>
  13. 	<meta http-equiv="pragma" content="no-cache">
  14. 	<meta http-equiv="cache-control" content="no-cache">
  15. 	<meta http-equiv="expires" content="0">    
  16. 	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  17. 	<meta http-equiv="description" content="This is my page">
  18. 	<!--
  19. 	<link rel="stylesheet" type="text/css" href="styles.css">
  20. 	-->
  21.   </head>
  22.   
  23.   <body>
  24.     	
  25.     <a href="showdept.action">展示dept表数据</a>
  26.     <a href="save.jsp">增加dept表数据</a>
  27.   </body>
  28. </html>


save.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%
  3. String path = request.getContextPath();
  4. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  5. %>
  6.  
  7. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  8. <html>
  9.   <head>
  10.     <base href="<%=basePath%>">
  11.     
  12.     <title>My JSP 'save.jsp' starting page</title>
  13.     
  14. 	<meta http-equiv="pragma" content="no-cache">
  15. 	<meta http-equiv="cache-control" content="no-cache">
  16. 	<meta http-equiv="expires" content="0">    
  17. 	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  18. 	<meta http-equiv="description" content="This is my page">
  19. 	<!--
  20. 	<link rel="stylesheet" type="text/css" href="styles.css">
  21. 	-->
  22.  
  23.   </head>
  24.   
  25.   <body>
  26.     <form action="savedept.action" method="post">
  27.     	部门：<input type="text" name="dept.dname" />
  28.     	地址：<input type="text" name="dept.loc" />
  29.     	<input type="submit" />
  30.     </form>
  31.   </body>
  32. </html>


list.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  3. <%
  4. String path = request.getContextPath();
  5. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  6. %>
  7.  
  8. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  9. <html>
  10.   <head>
  11.     <base href="<%=basePath%>">
  12.     
  13.     <title>My JSP 'list.jsp' starting page</title>
  14.     
  15. 	<meta http-equiv="pragma" content="no-cache">
  16. 	<meta http-equiv="cache-control" content="no-cache">
  17. 	<meta http-equiv="expires" content="0">    
  18. 	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  19. 	<meta http-equiv="description" content="This is my page">
  20. 	<!--
  21. 	<link rel="stylesheet" type="text/css" href="styles.css">
  22. 	-->
  23.  
  24.   </head>
  25.   
  26.   <body>
  27.     <table border="1">
  28.     	<tr>
  29.     	   <td>编号：</td>
  30.     	   <td>部门：</td>
  31.     	   <td>地址：</td>
  32.     	   <td>操作：</td>
  33.     	</tr>
  34.     	<c:forEach var="d" items="${list}">
  35.     		<tr>
  36.     	   <td>${d.deptno}</td>
  37.     	   <td>${d.dname}</td>
  38.     	   <td>${d.loc}</td>
  39.     	   <td>
  40.     	      <a href="prepupdept.action?id=${d.deptno}">修改</a>
  41.     	      <a href="deletedept.action?id=${d.deptno}">删除</a>
  42.     	   </td>
  43.     	</tr>
  44.     	</c:forEach>
  45.     </table>
  46.   </body>
  47. </html>


update.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  3. <%
  4. String path = request.getContextPath();
  5. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  6. %>
  7.  
  8. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  9. <html>
  10.   <head>
  11.     <base href="<%=basePath%>">
  12.     
  13.     <title>My JSP 'update.jsp' starting page</title>
  14.     
  15. 	<meta http-equiv="pragma" content="no-cache">
  16. 	<meta http-equiv="cache-control" content="no-cache">
  17. 	<meta http-equiv="expires" content="0">    
  18. 	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  19. 	<meta http-equiv="description" content="This is my page">
  20. 	<!--
  21. 	<link rel="stylesheet" type="text/css" href="styles.css">
  22. 	-->
  23.  
  24.   </head>
  25.   
  26.   <body>
  27.     <form action="updatedept.action" method="post">
  28.     	id:<input type="text" value="${dept.deptno}" name="dept.deptno" />
  29.     	部门：<input type="text" value="${dept.dname}" name="dept.dname" />
  30.     	地址：<input type="text" value="${dept.loc}" name="dept.loc" />
  31.     	<input type="submit" />
  32.     </form>
  33.   </body>
  34. </html>


配置文件：applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans
  3. 	xmlns="http://www.springframework.org/schema/beans"
  4. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5. 	xmlns:p="http://www.springframework.org/schema/p"
  6. 	 xmlns:tx="http://www.springframework.org/schema/tx"
  7. 	xmlns:aop="http://www.springframework.org/schema/aop"
  8. 	xsi:schemaLocation="http://www.springframework.org/schema/beans
  9. 	http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
  10. 	  http://www.springframework.org/schema/tx
  11.   http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
  12. 	http://www.springframework.org/schema/aop
  13. 	http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
  14. 	">
  15. 	
  16. 	<!-- 加载 hibernate的配置 定义sessionFactory -->
  17. 	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
  18. 		<property name="configLocation">
  19. 			<value>classpath:hibernate.cfg.xml</value>
  20. 		</property>
  21. 	</bean>
  22. 	
  23. 	<!-- dao层 -->
  24. 	<bean id="deptdaoimpl" class="com.bdqn.dao.impl.DeptDaoImpl" >
  25. 		<property name="sessionFactory" ref="sessionFactory"></property>
  26. 	</bean>
  27. 	<!-- service层 -->
  28. 	<bean id="deptservice" class="com.bdqn.service.impl.DeptServiceImpl" >
  29. 		<property name="idd" ref="deptdaoimpl" ></property>
  30. 		<property name="sessionFactory" ref="sessionFactory"></property>
  31. 	</bean>
  32. 	<!-- action层 -->
  33. 	<bean id="deptaction" class="com.bdqn.action.DeptAction" >
  34. 		<property name="ids" ref="deptservice" ></property>
  35. 	</bean>
  36. 	
  37. 	
  38. 	
  39. 	
  40. 	<!-- 事务的功能实现类-->
  41. 	<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  42. 		<property name="sessionFactory" ref="sessionFactory" />
  43. 	</bean>
  44. 	
  45. 	<!-- 把事务封装好的一个 面板  -->
  46. 	<tx:advice id="txAdvice" transaction-manager="txManager" >
  47.     	<tx:attributes>
  48.        		<tx:method name="save(..)" read-only= "true" /> 
  49.        		<tx:method name="*" />
  50.     	</tx:attributes>
  51. 	</tx:advice>
  52. 	<!-- 封装结束 -->
  53. 	
  54. 	<!-- 切入事务开始  织入  -->
  55. 	<aop:config>
  56.     	<aop:pointcut id="pointcut" expression="execution(* com.bdqn.dao.impl.*.*(..))" /> 
  57.     	<aop:advisor pointcut-ref="pointcut" advice-ref="txAdvice"/> 
  58. 	</aop:config>
  59. 	<!-- 切入事务结束 -->
  60. </beans>


hibernate.cfg.xml

  1. <!DOCTYPE hibernate-configuration PUBLIC
  2. 	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  3. 	"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  4.  
  5. <hibernate-configuration>
  6. <session-factory>
  7.  
  8. 	<!-- 数据库连接信息 -->
  9. 	<property name="connection.driver_class">
  10. 		com.mysql.jdbc.Driver
  11. 	</property>
  12. 	<property name="connection.url">
  13. 		jdbc:mysql://localhost:3306/sanban?useUnicode=true&characterEncoding=UTF-8
  14. 	</property>
  15. 	<property name="connection.username">root</property>
  16. 	<property name="connection.password">root</property>
  17.  
  18. 	<!-- 数据库方言 -->
  19. 	<property name="dialect">
  20. 		org.hibernate.dialect.MySQLDialect
  21. 	</property>
  22.  
  23. 	<!-- 是否显示sql语句 -->
  24. 	<property name="show_sql">true</property>
  25.  
  26. 	<mapping resource="com/bdqn/entity/Dept.hbm.xml" />
  27.  
  28.  
  29. </session-factory>
  30. </hibernate-configuration>


struts.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE struts PUBLIC
  3. 	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
  4. 	"http://struts.apache.org/dtds/struts-2.3.dtd">
  5.  
  6. <struts>
  7. 	<!-- 设置编码方式 -->
  8. 	<constant name="struts.i18n.encoding" value="utf-8"></constant>
  9.  
  10.     <package name="default"  extends="struts-default"  namespace="/" >
  11. 	
  12. 		<action name="*dept" class="deptaction" method="{1}">
  13. 			<result name="zhanshi">list.jsp</result>
  14. 			<result name="find" type="chain">showdept</result>
  15. 			<result name="prepup">update.jsp</result>
  16. 		</action>
  17. 		
  18.     </package>
  19.  
  20. </struts>

WEB.XML

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  3.   <welcome-file-list>
  4.     <welcome-file>index.jsp</welcome-file>
  5.   </welcome-file-list>
  6.   <context-param>
  7.     <param-name>contextConfigLocation</param-name>
  8.     <param-value>
  9. 			classpath:applicationContext.xml
  10. 	</param-value>
  11.   </context-param>
  12.   <listener>
  13.     <listener-class>
  14. 		org.springframework.web.context.ContextLoaderListener
  15. 	</listener-class>
  16.   </listener>
  17.   <filter>
  18.     <filter-name>struts2</filter-name>
  19.     <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
  20.   </filter>
  21.   <filter-mapping>
  22.     <filter-name>struts2</filter-name>
  23.     <url-pattern>/*</url-pattern>
  24.   </filter-mapping>
  25. </web-app>
  27. ​
  29. ​


如有不明白的地方  可以下载案例  附带JAR包：

案例的链接：点击下载案例

博主QQ：3044793043 写上 QQ，是因为有的问题评论区，不方便解决。而不是发源码，个人建议手写一遍比较好！！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/185260
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号