package Bean; public class Bean1 { private String zhuti; private String mudi; private String leixing; private String shijian; private String didian; private String duixiang; private String neirong; private String anpai; public String getZhuti() { return zhuti; } public void setZhuti(String zhuti) { this.zhuti = zhuti; } public String getMudi() { return mudi; } public void setMudi(String mudi) { this.mudi = mudi; } public String getLeixing() { return leixing; } public void setLeixing(String leixing) { this.leixing = leixing; } public String getShijian() { return shijian; } public void setShijian(String shijian) { this.shijian = shijian; } public String getDidian() { return didian; } public void setDidian(String didian) { this.didian = didian; } public String getDuixiang() { return duixiang; } public void setDuixiang(String duixiang) { this.duixiang = duixiang; } public String getNeirong() { return neirong; } public void setNeirong(String neirong) { this.neirong = neirong; } public String getAnpai() { return anpai; } public void setAnpai(String anpai) { this.anpai = anpai; } /*@Override public String toString() { return "Bean1 [zhuti=" + zhuti + ", mudi=" + mudi + ", leixing=" + leixing + ", shijian=" + shijian + ", didian=" + didian + ", duixiang=" + duixiang + ", neirong=" + neirong + ", anpai=" + anpai + ", getClass()=" + getClass() + ", hashCode()=" + hashCode() + ", toString()=" + super.toString() + "]"; }*/ public Bean1(String zhuti, String mudi, String leixing, String shijian, String didian, String duixiang, String neirong, String anpai) { this.zhuti=zhuti; this.mudi=mudi; this.leixing=leixing; this.shijian=shijian; this.didian=didian; this.duixiang=duixiang; this.neirong=neirong; this.anpai=anpai; //super(); // TODO Auto-generated constructor stub } }
package Dao; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import Bean.Bean1; import Util.Util1; public class Dao1 { public static int add(Bean1 bean) { String sql = "insert into 校园社团活动管理系统(zhuti,mudi,leixing,shijian,didian,duixiang,neirong,anpai) values('" +bean.getZhuti() + "','" + bean.getMudi() + "','" +bean.getLeixing() + "','"+bean.getShijian() + "','"+bean.getDidian() + "','"+bean.getDuixiang() + "','"+ bean.getNeirong() + "','" +bean.getAnpai()+"')"; Connection conn = Util1.getConn(); Statement state = null; int count=0; try { state = conn.createStatement(); count = state.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } finally { //关闭连接 Util1.close(state, conn); } return count; } public static int update(Bean1 bean) { String sql = "update 校园社团活动管理系统 set mudi='" + bean.getMudi() + "', leixing='" + bean.getLeixing() +"', shijian='" + bean.getShijian() +"', didian='" + bean.getDidian() +"', duixiang='" + bean.getDuixiang() +"', neirong='" + bean.getNeirong() + "', anpai='" + bean.getAnpai() + "' where zhuti='" + bean.getZhuti() + "'"; Connection conn = Util1.getConn(); Statement state = null; int count=0; try { state = conn.createStatement(); count = state.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } finally { //关闭连接 Util1.close(state, conn); } return count; } public static int delete (String t) { int count=0; String sql = "delete from 校园社团活动管理系统 where zhuti='" + t + "'"; System.out.println(sql); Connection conn = Util1.getConn(); Statement state = null; try { state = conn.createStatement(); count = state.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } finally { Util1.close(state, conn); } return count; } }
package Util; import java.sql.*; public class Util1 { static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost:3306/demo?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"; static final String USER = "root"; static final String PASS = "123456"; public static Connection getConn () { Connection conn = null; try { Class.forName(JDBC_DRIVER); System.out.println("连接数据库..."); conn = DriverManager.getConnection(DB_URL,USER,PASS); } catch (Exception e) { e.printStackTrace(); } return conn; } public static void close (Statement state, Connection conn) { if (state != null) { try { state.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void close (ResultSet rs, Statement state, Connection conn) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (state != null) { try { state.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
package servlet; import java.sql.*; import java.io.IOException; import java.io.UnsupportedEncodingException; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import Bean.Bean1; import service.Service; @WebServlet("/Servlet") public class Servlet extends HttpServlet { private static final long serialVersionUID = 1L; Service service=new Service(); /** * @see HttpServlet#HttpServlet() */ public Servlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String method = req.getParameter("method"); if ("add".equals(method)) { try { add(req, res); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } if ("update".equals(method)) { try { update(req, res); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } if ("delete".equals(method)) { try { delete(req, res); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ // TODO Auto-generated method stub req.setCharacterEncoding("utf-8"); String zhuti = req.getParameter("zhuti"); int i =service.delete(zhuti); if(i>0) { req.setAttribute("message", "删除成功!"); req.getRequestDispatcher("shanchu.jsp").forward(req,resp); } else { req.setAttribute("message", "删除失败!"); req.getRequestDispatcher("shanchu.jsp").forward(req,resp); } } private void add(HttpServletRequest req, HttpServletResponse res) throws Exception { req.setCharacterEncoding("utf-8"); String zhuti = req.getParameter("zhuti"); String mudi = req.getParameter("mudi"); String leixing = req.getParameter("leixing"); String shijian = req.getParameter("shijian"); String didian = req.getParameter("didian"); String duixiang = req.getParameter("duixiang"); String neirong = req.getParameter("neirong"); String anpai = req.getParameter("anpai"); //people people = new people(hu_bie,zhu_fang_lei_bie,name,idc,min_zu,jiao_yu,sex,S,N); Bean1 bean=new Bean1(zhuti,mudi,leixing,shijian,didian,duixiang,neirong,anpai); //添加后消息显示 if(service.add(bean)>0) { req.setAttribute("message", "添加成功"); req.getRequestDispatcher("add.jsp").forward(req,res); } else { req.setAttribute("message", "添加失败,请重新录入"); req.getRequestDispatcher("add.jsp").forward(req,res); } } private void update(HttpServletRequest req, HttpServletResponse res) throws Exception { req.setCharacterEncoding("utf-8"); String zhuti = req.getParameter("zhuti"); String mudi = req.getParameter("mudi"); String leixing = req.getParameter("leixing"); String shijian = req.getParameter("shijian"); String didian = req.getParameter("didian"); String duixiang = req.getParameter("duixiang"); String neirong = req.getParameter("neirong"); String anpai = req.getParameter("anpai"); //people people = new people(hu_bie,zhu_fang_lei_bie,name,idc,min_zu,jiao_yu,sex,S,N); Bean1 bean=new Bean1(zhuti,mudi,leixing,shijian,didian,duixiang,neirong,anpai); //添加后消息显示 if(service.update(bean)>0) { req.setAttribute("message", "修改成功"); req.getRequestDispatcher("xiugai.jsp").forward(req,res); } else { req.setAttribute("message", "修改失败,请重新录入"); req.getRequestDispatcher("xiugai.jsp").forward(req,res); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
package service; import Bean.Bean1; import Dao.Dao1; public class Service { public int add(Bean1 bean) { if(Dao1.add(bean)>0) { return 1; } else { return 0; } } public int update(Bean1 bean) { if(Dao1.update(bean)>0) { return 1; } else { return 0; } } public int delete(String zhuti) { if(Dao1.delete(zhuti)>0) { return 1; } return 0; } }
Screen.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>校园社团活动管理系统</title> </head> <body> <div align="center"> <form name="form" method="post" action="add.jsp"> <input type="submit" value="发布活动信息"> </form> <form name="form" method="post" action="xiugai.jsp"> <input type="submit" value="修改活动信息"> </form> <form name="form" method="post" action="shanchu.jsp"> <input type="submit" value="删除活动信息"> </form> <form name="form" method="post" action="chaxun.jsp"> <input type="submit" value="查询活动信息"> </form> <form name="form" method="post" action="liulan.jsp"> <input type="submit" value="活动信息浏览"> </form> </div> </body> </html>
add.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>校园社团活动管理系统</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: black;">校园社团活动管理系统</h1> <a href="Screen.jsp">返回主页</a> <form name="form1" action="Servlet?method=add" method="post" onsubmit="return check()"> 活动主题 <input type="text" name="zhuti"required pattern="^[\u4e00-\u9fa5]{1,20}"/> <br> 活动目的 <input type="text" name="mudi"required pattern="^[\u4e00-\u9fa5]{1,50}"/><br> 活动类型 <td> <input type="radio" name="leixing" value="社团竞赛" >社团竞赛 <input type="radio" name="leixing" value="野外采风" >野外采风<br> <input type="radio" name="leixing" value="校内集会" >校内集会 <input type="radio" name="leixing" value="社团纳新" >社团纳新 </td><br> 活动时间 <input type="text" name="shijian"><br> 活动地点 <input type="text" name="didian"><br> 活动对象 <tr> <td> <input type="checkbox" name="duixiang" value="社团成员">社团成员 <input type="checkbox" name="duixiang" value="全体学生">全体学生 </td> </tr> <br> 活动内容 <input type="text" name="neirong"required pattern="^[\u4e00-\u9fa5]{1,500}"/><br> 活动日程安排 <input type="text" name="anpai"required pattern="^[\u4e00-\u9fa5]{1,500}"/><br> <input type="submit" value="添加"> <input type="reset" value="重置"><br> <div > </body> </html>
liulan.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="Bean.Bean1" %> <%@ page import="Dao.Dao1" %> <%@ page import="Util.Util1" %> <%@ page import="java.sql.*" %> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>社团活动浏览</title> </head> <body> <div align="center"> <form name="form" method="post" action="Screen.jsp"> <input type="submit" value="返回主页"> </form> <table align="center" border="1" width="500"> <tr> <th>活动主题</th> <th>活动目的</th> <th>活动类型</th> <th>活动时间</th> <th>活动地点</th> <th>对象</th> <th>活动内容</th> <th>活动安排</th> </tr> <% String sql = "SELECT * FROM `校园社团活动管理系统`"; Connection conn = Util1.getConn(); Statement state = null; ResultSet rs = null; Bean1 tbean=null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { String zhuti = rs.getString("zhuti"); String mudi = rs.getString("mudi"); String leixing = rs.getString("leixing"); String shijian = rs.getString("shijian"); String didian = rs.getString("didian"); String duixiang = rs.getString("duixiang"); String neirong = rs.getString("neirong"); String anpai = rs.getString("anpai"); out.println("<tr>"+"<td>"+zhuti+"</td>"); out.println("<td>"+mudi+"</td>"); out.println("<td>"+leixing+"</td>"); out.println("<td>"+shijian+"</td>"); out.println("<td>"+didian+"</td>"); out.println("<td>"+duixiang+"</td>"); out.println("<td>"+neirong+"</td>"); out.println("<td>"+anpai+"</td>"+"</tr>"); } } catch (Exception e) { e.printStackTrace(); } finally { Util1.close(rs, state, conn); } %> </body> </html>
shanchu.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>删除界面</title> </head> <body> <div align="center"> <form name="form" method="post" action="Screen.jsp"> <input type="submit" value="返回主页"> </form> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <form action="Servlet?method=delete" method="post" onsubmit="return check()"> 请重新输入删除的主题 <input type="text" name="zhuti" /> <input type="submit" value="删除" /> </body> </html>
xiugai.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>校园社团活动管理系统</title> </head> <body> <% Object message = request.getAttribute("message"); if(message!=null && !"".equals(message)){ %> <script type="text/javascript"> alert("<%=request.getAttribute("message")%>"); </script> <%} %> <div align="center"> <h1 style="color: black;">校园社团活动管理系统</h1> <a href="Screen.jsp">返回主页</a> <form name="form1" action="Servlet?method=update" method="post" onsubmit="return check()"> 活动主题 <input type="text" name="zhuti"required pattern="^[\u4e00-\u9fa5]{1,20}"/> <br> 活动目的 <input type="text" name="mudi"required pattern="^[\u4e00-\u9fa5]{1,50}"/><br> 活动类型 <td> <input type="radio" name="leixing" value="社团竞赛" >社团竞赛 <input type="radio" name="leixing" value="野外采风" >野外采风<br> <input type="radio" name="leixing" value="校内集会" >校内集会 <input type="radio" name="leixing" value="社团纳新" >社团纳新 </td><br> 活动时间 <input type="text" name="shijian"><br> 活动地点 <input type="text" name="didian"><br> 活动对象 <tr> <td> <input type="checkbox" name="duixiang" value="社团成员">社团成员 <input type="checkbox" name="duixiang" value="全体学生">全体学生 </td> </tr> <br> 活动内容 <input type="text" name="neirong"required pattern="^[\u4e00-\u9fa5]{1,500}"/><br> 活动日程安排 <input type="text" name="anpai"required pattern="^[\u4e00-\u9fa5]{1,500}"/><br> <input type="submit" value="修改"> <input type="reset" value="重置"><br> <div > </body> </html>
标签:didian,java,String,管理系统,req,zhuti,bean,社团活动,public From: https://www.cnblogs.com/LvJinshuai/p/16875185.html