• JSP 装饰公司网站myeclipse开发mysql数据库MVC模式java编程网页设计系统采用mvc框架

    一、源码特点
         JSP 装饰公司网站是一套完善的web设计系统（系统采用serlvet mvc框架进行设计开发），对理解JSP java编程开发语言有帮助，系统具有完整的源代码
    和数据库，系统主要采用B/S模式开发。

    JSP SSH装饰公司网站myeclipse开发mysql


    二、功能介绍
    前台
    首页
    案例展示
    关于我们
    设计师介绍
    公司信息
    后台
    (1)权限管理：对权限信息进行添加、删除、修改和查看
    (2)用户管理：对用户信息进行添加、删除、修改和查看
    (3)关于我们类别管理：对关于我们类别信息进行添加、删除、修改和查看
    (4)关于我们管理：对关于我们信息进行添加、删除、修改和查看
    (5)案例展示管理：对案例展示信息进行添加、删除、修改和查看
    (6)信息类型管理：对信息类型信息进行添加、删除、修改和查看
    (7)信息管理：对信息进行添加、删除、修改和查看
    (8)设计师管理：对设计师信息进行添加、删除、修改和查看
    (9)预约管理：对预约信息进行添加、删除、修改和查看

    控制层代码

    1. package com.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import javax.servlet.ServletException;
    6. import javax.servlet.http.HttpServlet;
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    9. import javax.servlet.http.HttpSession;
    10.  
    11. import com.bean.xinxi;
    12. import com.dao.xinxiDao;
    13.  
    14.  
    15. import java.util.List;
    16. import java.sql.ResultSet;
    17.  
    18. public class xinxiServlet extends HttpServlet  {
    19. 	public void service(HttpServletRequest request, HttpServletResponse response)
    20. 	throws ServletException, IOException {
    21. 		request.setCharacterEncoding("gb2312");
    22. 		System.out.println("method"+request.getParameter("method"));
    23. 		String method=(String)request.getParameter("method");
    24. 		if(method.equals("insert")){//信息添加
    25. 			insertM(request, response);
    26. 		}else if(method.equals("list")){//信息列表
    27. 			ListM(request, response);
    28. 		}else if(method.equals("delete")){//信息删除
    29. 			deleteM(request, response);
    30. 		}else if(method.equals("modifyindex")){//信息修改页面
    31. 			modifyIndex(request, response);
    32. 		}
    33. 		else if(method.equals("modify")){//信息修改
    34. 			modifyM(request, response);
    35. 		}else if(method.equals("detail")){//信息详细信息
    36. 			detailM(request, response);
    37. 		}else if(method.equals("Plist")){//信息列表信息
    38. 			PListM(request, response);
    39. 		}
    40. 	}
    41. 	private void insertM(HttpServletRequest request, HttpServletResponse response){//信息添加
    42. 		xinxiDao dao=new xinxiDao();
    43. 		xinxi xinxi=new xinxi();
    44. 		xinxi.setXxid((String)request.getParameter("keyid"));
    45. xinxi.setBt((String)request.getParameter("bt"));
    46. xinxi.setNr((String)request.getParameter("nr"));
    47. xinxi.setLx((String)request.getParameter("lx"));
    48. xinxi.setSj((String)request.getParameter("sj"));
    49.  
    50. 	response.setCharacterEncoding("gb2312");
    51. 		try {
    52. 			dao.insert(xinxi);
    53. 			request.setAttribute("flag", "操作成功"); 
    54. 			
    55. 			
    56. 			
    57. 			request.getRequestDispatcher("xinxi/xinxiadd.jsp").forward(request, response);
    58. 		} catch (Exception e) {
    59. 			e.printStackTrace();
    60. 		}
    61. 				
    62. 	}
    63. 	private void ListM(HttpServletRequest request, HttpServletResponse response){//信息信息列表
    64. 		ResultSet rs=null;
    65. 		xinxiDao dao = new xinxiDao();
    66. 	    System.out.println("alist");
    67.  
    68. 		String sql="";
    69. 		response.setCharacterEncoding("gb2312");
    70. 		try{
    71. 			rs=dao.qlist(sql);
    72.  
    73. 			PrintWriter out = response.getWriter();
    74. 			request.setAttribute("rs", rs); 
    75. 		
    76.  
    77. 			request.getRequestDispatcher("xinxi/xinxilist.jsp").forward(request, response);
    78. 		}catch(Exception e){
    79. 			e.toString();
    80. 			e.printStackTrace();
    81. 		}
    82. 		
    83. 	}
    84. 	private void PListM(HttpServletRequest request, HttpServletResponse response){//测试信息列表
    85. 		ResultSet rs=null;
    86. 		xinxiDao dao = new xinxiDao();
    87. 	   
    88. 	    String str=(String)request.getParameter("Page");
    89. 		String sql="";
    90. 		response.setCharacterEncoding("gb2312");
    91. 		try{
    92. 			
    93. if(str==null){
    94. 				str="0";
    95. 				}
    96. rs=dao.qlist(sql);
    97.  
    98. 			PrintWriter out = response.getWriter();
    99. 			request.setAttribute("rs", rs); 
    100. 		
    101.  
    102. 		request.getRequestDispatcher("xinxi/xinxiPlist.jsp?Page=1").forward(request, response);
    103. 		}catch(Exception e){
    104. 			e.toString();
    105. 			e.printStackTrace();
    106. 		}
    107. 		
    108. 	}
    109. 	private void modifyIndex(HttpServletRequest request, HttpServletResponse response){//信息修改首页
    110. 			ResultSet rs=null;
    111. 	response.setCharacterEncoding("gb2312");
    112. 		xinxiDao dao = new xinxiDao();
    113. 		
    114. 	
    115. 		String keyid=(String)request.getParameter("keyid");
    116. 		String sql="";
    117. 	
    118. 		
    119. 		if(keyid!=null&&!keyid.equals("")){
    120. 			
    121. 			sql+=" and xxid='"+keyid+"'";
    122. 			
    123. 		}
    124. 		try{
    125. 			rs=dao.qlist(sql);
    126. 			PrintWriter out = response.getWriter();
    127. 			request.setAttribute("rs", rs); 
    128. 			
    129. 			request.getRequestDispatcher("xinxi/xinximodify.jsp").forward(request, response);
    130. 			//response.sendRedirect("xinxi/xinximodify.jsp");
    131. 		}catch(Exception e){
    132. 			e.toString();
    133. 			e.printStackTrace();
    134. 		}
    135. 		
    136. 	}
    137. 	private void detailM(HttpServletRequest request, HttpServletResponse response){//信息详细信息页面
    138. 		
    139. 		ResultSet rs=null;
    140. 	response.setCharacterEncoding("gb2312");
    141. 		xinxiDao dao = new xinxiDao();
    142. 		
    143. 	
    144. 		String keyid=(String)request.getParameter("keyid");
    145. 		String sql="";
    146. 	
    147. 		
    148. 		if(keyid!=null&&!keyid.equals("")){
    149. 			
    150. 			sql+=" and xxid='"+keyid+"'";
    151. 			
    152. 		}
    153. 		try{
    154. 			rs=dao.qlist(sql);
    155. 			
    156. 			request.setAttribute("rs", rs); 
    157. 		request.getRequestDispatcher("xinxi/xinxidetail.jsp").forward(request, response);
    158. 		}catch(Exception e){
    159. 			e.toString();
    160. 			e.printStackTrace();
    161. 		}
    162. 		
    163. 	}
    164. 	private void deleteM(HttpServletRequest request, HttpServletResponse response){//信息删除
    165. 		ResultSet lst=null;
    166. 		xinxiDao dao = new xinxiDao();
    167. 	  response.setCharacterEncoding("gb2312");
    168. 		String keyid=(String)request.getParameter("keyid"); 
    169. 	
    170. 		try{
    171. 			dao.delete(keyid);
    172. 				request.setAttribute("flag", "删除成功"); 
    173. 		request.getRequestDispatcher("xinxiServlet?method=list").forward(request, response);
    174. 		
    175. 			//response.sendRedirect("xinxiServlet?method=list");
    176. 		}catch(Exception e){
    177. 			e.toString();
    178. 			e.printStackTrace();
    179. 		}
    180. 		
    181. 	}
    182.  
    183. 	private void modifyM(HttpServletRequest request, HttpServletResponse response){//信息修改功能
    184. 		xinxiDao dao=new xinxiDao();
    185. 		xinxi xinxi=new xinxi();
    186. 		xinxi.setXxid((String)request.getParameter("keyid"));
    187. xinxi.setBt((String)request.getParameter("bt"));
    188. xinxi.setNr((String)request.getParameter("nr"));
    189. xinxi.setLx((String)request.getParameter("lx"));
    190. xinxi.setSj((String)request.getParameter("sj"));
    191.  
    192. 	response.setCharacterEncoding("gb2312");
    193. 		try {
    194. 			dao.modify(xinxi);
    195. 			PrintWriter out = response.getWriter();
    196. 			
    197. 			request.setAttribute("flag", "操作成功"); 
    198. 			request.getRequestDispatcher("xinxiServlet?method=list").forward(request, response);
    199. 			
    200. 			//response.sendRedirect("xinxiServlet?method=list");
    201. 		} catch (Exception e) {
    202. 			e.printStackTrace();
    203. 		}
    204. 				
    205. 	}
    206. }

    dao层代码

    1. package com.dao;
    2. import java.sql.Connection;
    3. import java.sql.PreparedStatement;
    4. import java.sql.ResultSet;
    5.  
    6.  
    7.  
    8.  
    9. import com.bean.xinxi;
    10. import com.util.DBO;
    11. import java.util.List;
    12. import java.sql.ResultSet;
    13. public class xinxiDao {
    14. 	private DBO db=null;//
    15. 	 private xinxi xinxi=null;
    16. 	 public void  insert(xinxi xinxi) throws Exception{//添加信息
    17. 			db=new DBO();
    18. 		   db.open();
    19. 			
    20. 			String sql = "insert into xinxi (bt,nr,lx,sj ) values ('"+xinxi.getBt()+"','"+xinxi.getNr()+"','"+xinxi.getLx()+"','"+xinxi.getSj()+"')";
    21. 		
    22. 			
    23. 			db.update(sql);
    24. 			//db.commit();
    25. 			db.close();
    26. 		
    27. 		}
    28. 	 public void  modify(xinxi xinxi) throws Exception{//修改信息
    29. 			db=new DBO();
    30. 		   db.open();
    31. 			
    32. 			String sql = "update xinxi set  bt='"+xinxi.getBt()+"',nr='"+xinxi.getNr()+"',lx='"+xinxi.getLx()+"',sj='"+xinxi.getSj()+"' where xxid ='"+xinxi.getXxid()+"'";
    33. 		
    34. 			
    35. 			db.update(sql);
    36. 			//db.commit();
    37. 			db.close();
    38. 		
    39. 		}
    40. 	 public void  delete(String keyid) throws Exception{//删除信息
    41. 			db=new DBO();
    42. 		        db.open();
    43. 			
    44. 			String sql = "delete from xinxi where xxid='"+keyid+"'";
    45. 		
    46. 			
    47. 			db.update(sql);
    48. 			//db.commit();
    49. 			db.close();
    50. 		
    51. 		}
    52. 	 public ResultSet  qlist(String sl) throws Exception{//查询信息
    53. 		   db=new DBO();
    54. 		   db.open();
    55. 		   String sql="select * from xinxi where  1=1 ";
    56. 		if(!sl.equals("")){
    57. 			sql+=sl;
    58. 			
    59. 		}
    60. 		   System.out.println("sql="+sql);
    61. 			return db.query(sql);
    62. 			
    63. 		}
    64. }

    bean

    1. package com.bean;
    2.  
    3.  
    4.  
    5. public class xinxi {
    6.  
    7.  
    8.  
    9. 	private String xxid="";//信息编号
    10.  
    11. private String bt="";//标题
    12.  
    13. private String nr="";//内容
    14.  
    15. private String lx="";//类型
    16.  
    17. private String sj="";//时间
    18.  
    19.  
    20.  
    21.  
    22.  
    23. 	public String getXxid(){
    24.           return xxid;
    25.    }
    26.  
    27. public void setXxid(String xxid){
    28.  this.xxid = xxid;
    29.    }
    30.  
    31. public String getBt(){
    32.           return bt;
    33.    }
    34.  
    35. public void setBt(String bt){
    36.  this.bt = bt;
    37.    }
    38.  
    39. public String getNr(){
    40.           return nr;
    41.    }
    42.  
    43. public void setNr(String nr){
    44.  this.nr = nr;
    45.    }
    46.  
    47. public String getLx(){
    48.           return lx;
    49.    }
    50.  
    51. public void setLx(String lx){
    52.  this.lx = lx;
    53.    }
    54.  
    55. public String getSj(){
    56.           return sj;
    57.    }
    58.  
    59. public void setSj(String sj){
    60.  this.sj = sj;
    61.    }
    62.  
    63.   
    64.  
    65.  
    66.  
    67.  
    68.  
    69. }
    70.


    三、注意事项
        1、管理员账号：admin 密码：admin 数据库配置文件DBO。java
         2、开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为Mysql5.0，使用java语言
        3、数据库文件名是jspfzhuangshi.mdf，系统名称zhuangshi
        4、系统首页地址：http://127.0.0.1:8080/zhuangshi/

     

     

     

     

     

  • 相关阅读:
    vue知识点————$nextTick
    如何快速收割小程序第一波红利？
    image.paste()函数【将一张图片粘贴到另一张图片上】
    浏览器打不开DevTools？
    Swift Combine — Publisher、Operator、Subscriber概念介绍
    气传导耳机有哪些品牌？性能不错的气传导耳机分享
    MySQL的join你真的了解吗！！！
    SSM毕设项目 - 基于SSM的毕业设计管理系统(含源码+论文)
    Vue + Element-UI —— 项目实战（七）
    3D着色器(OpenGL)
  • 原文地址：https://blog.csdn.net/qq_41221322/article/details/127038190