宿舍值日系统jsp

1、界面展示：1，主界面包括：所有值日信息 三个操作按钮用于跳转2，添加条目 包括：输入相关 返回主页按钮 提交时先判断输入是否合理（学号为数据库主键，不可重复） 成功输入效果： 输入失败效果：3，修改条目 包括：修改选择，提交按钮 选中后提交出现如下页面： 修改时判断修改是否合理，分别提示，图类似上面。4，删除条目项目文件：所用数据库及表：源码：/文件名：index.jsp<%page import="java.sql.*"%><% page language="java" import="java.util.*" p

2、ageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"%><!DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN"&g

3、t;<html><head><base href="<%=basePath%>"><title>宿舍值日管理系统</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" c

4、ontent="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!-<link rel="stylesheet" type="text/css" href="styles.css">-&g

5、t;</head><body><h2 align="center">宿舍值日表</h2><table border="1" align="center"><tr><th width="87" align="center">学号</th><th width="87" align="center">姓名</th><th width=&q

6、uot;87" align="center">值日</th><th width="87" align="center">备注</th></tr><%Connection connection = null;Statement statement = null;ResultSet resultSet = null;Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql

7、:/localhost:3306/dor_cleaning"connection = DriverManager.getConnection(url, "root", "root");statement = connection.createStatement();resultSet = statement.executeQuery("select * from plan");while (resultSet.next() %><tr><td align="center">&

8、lt;%=resultSet.getString("number")%></td><td align="center"><%=resultSet.getString("name")%></td><td align="center"><%=resultSet.getString("day")%></td><td align="center"><%=resultSet.ge

9、tString("note")%></td></tr><%resultSet.close();statement.close();connection.close();%></table><form action="add.jsp" method="get"><table align="center"><tr><td><input type=submit value="增加值日">&

10、lt;/td></tr></table></form><form action="change.jsp" method="get"><table align="center"><tr><td><input type=submit value="修改值日"></td></tr></table></form><form action="delete.jsp

11、" method="get"><table align="center"><tr><td><input type=submit value="删除值日"></td></tr></table></form><br></body></html>/文件名：add.jsp<% page language="java" import="java.util.*&qu

12、ot; pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"%><!DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN&qu

13、ot;><html><head><base href="<%=basePath%>"><title>增加值日</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires"

14、content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!-<link rel="stylesheet" type="text/css" href="styles.css">-&

15、gt;</head><body><h2 align="center">增加值日条目</h2><hr><form action="add_check.jsp"><table align="center"><tr><td>学号:</td><td><input type="text" name="number"></td></tr>&l

16、t;tr><td>姓名:</td><td><input type="text" name="name"></td></tr><tr><td>值日:</td><td><input type="text" name="day"></td></tr><tr><td>备注:</td><td><input typ

17、e="text" name="note"></td></tr><tr><td><input type="reset" value="清空"></td><td align="right"><input type="submit" value="提交"></td></tr></table></form><h

18、r><form action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页"></td></tr></table></form><br></body></html>/文件名：add_check.jsp<% page language="java&qu

19、ot; import="java.util.*" pageEncoding="utf-8"%><%page import="java.sql.*"%><%String path = request.getContextPath();String basePath = request.getScheme() + ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"

20、;%><!DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN"><html><head><base href="<%=basePath%>"><title>添加结果</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control&quo

21、t; 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"><!-<link rel="s

22、tylesheet" type="text/css" href="styles.css">-></head><body><%String name = request.getParameter("name");byte b1 = name.getBytes("iso-8859-1");name = new String(b1, "utf-8");String number = request.getParameter("number&

23、quot;);byte b2 = number.getBytes("iso-8859-1");number = new String(b2, "utf-8");String day = request.getParameter("day");byte b3 = day.getBytes("iso-8859-1");day = new String(b3, "utf-8");String note = request.getParameter("note");byte b4 =

24、 note.getBytes("iso-8859-1");note = new String(b4, "utf-8");Connection connection = null;Statement statement = null;ResultSet resultSet = null;Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql:/localhost:3306/dor_cleaning"connection = DriverManag

25、er.getConnection(url, "root", "root");statement = connection.createStatement();resultSet = statement.executeQuery("select * from plan");String result = new String("添加成功");while (resultSet.next() if (resultSet.getString("number").equals(number) result

26、 = new String("对不起，添加失败，值日表中已经含有该学号，请检查");break;if (result.equals("添加成功") String url2 = "insert into plan values('" + number + "','"+ name + "','" + day + "','" + note + "')"statement.executeUpdate(

27、url2);statement.close();connection.close();%><h2 align="center"><%=result %></h2><hr><form action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页"></td></tr&

28、gt;</table></form></body></html>/文件名：change.jsp<% page language="java" import="java.util.*" pageEncoding="utf-8"%><%page import="java.sql.*"%><%String path = request.getContextPath();String basePath = request.getScheme()

29、+ ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"%><!DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN"><html><head><base href="<%=basePath%>"><title>修改条目</title><meta h

30、ttp-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"><m

31、eta http-equiv="description" content="This is my page"></head><body><h2 align="center">修改值日条目</h2><hr><form action="change_check.jsp"><table align="center"><tr><td>请选择要修改的条目:</td><td&g

32、t;<select name="select" size="1"><%Connection connection = null;Statement statement = null;ResultSet resultSet = null;Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql:/localhost:3306/dor_cleaning"connection = DriverManager.getConnection

33、(url, "root", "root");statement = connection.createStatement();resultSet = statement.executeQuery("select * from plan");while (resultSet.next() %><option><%=resultSet.getString("number")%><%=resultSet.getString("name")%><%=res

34、ultSet.getString("day")%><%=resultSet.getString("note")%></option><%resultSet.close();statement.close();connection.close();%></select></td><td><input type="submit" value="修改"></td></tr></table><

35、/form><hr><form action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页"></td></tr></table></form></body></html>/文件名：change_check.jsp<% page language="

36、java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme() + ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"%><!DOCTYPE HTML PUBLIC "

37、-/W3C/DTD HTML 4.01 Transitional/EN"><html><head><base href="<%=basePath%>"><title>选择修改条目</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache">

38、<meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!-<link rel="stylesheet" type="text/css

39、" href="styles.css">-></head><body><%String string = request.getParameter("select");byte b = string.getBytes("iso-8859-1");string = new String(b, "utf-8");String s = string.split(" ");%><h2 align="center">

40、请输入要修改的参数</h2><hr><form action="change_check2.jsp"><table align="center"><tr><td>学号:</td><td><input type="text" name="number" value=<%=s0%>></td></tr><tr><td>姓名:</td><

41、td><input type="text" name="name" value=<%=s1%>></td></tr><tr><td>值日:</td><td><input type="text" name="day" value=<%=s2%>></td></tr><tr><td>备注:</td><td><input

42、 type="text" name="note" value=<%=s3%>></td></tr><tr><td><input type="hidden" name="hidden_number" value=<%=s0%>></td></tr><tr><td><input type="reset" value="全部重置">&

43、lt;td align="right"><input type="submit" value="提交"></td></tr></table></form><hr><form action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页&

44、quot;></td></tr></table></form></body></html>/文件名：change_check2.jsp<% page language="java" import="java.util.*" pageEncoding="utf-8"%><%page import="java.sql.*"%><%String path = request.getContextPath();Str

45、ing basePath = request.getScheme()+":/"+request.getServerName()+":"+request.getServerPort()+path+"/"%><!DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN"><html><head><base href="<%=basePath%>"><title>修改条

46、目成功</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,keywo

47、rd2,keyword3"><meta http-equiv="description" content="This is my page"><!-<link rel="stylesheet" type="text/css" href="styles.css">-></head><%String hidden_number = request.getParameter("hidden_number");by

48、te b = hidden_number.getBytes("iso-8859-1");hidden_number = new String(b,"utf-8");String name = request.getParameter("name");byte b1 = name.getBytes("iso-8859-1");name = new String(b1, "utf-8");String number = request.getParameter("number")

49、;byte b2 = number.getBytes("iso-8859-1");number = new String(b2, "utf-8");String day = request.getParameter("day");byte b3 = day.getBytes("iso-8859-1");day = new String(b3, "utf-8");String note = request.getParameter("note");byte b4 = note.

50、getBytes("iso-8859-1");note = new String(b4, "utf-8");Connection connection = null;Statement statement = null;ResultSet resultSet = null;Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql:/localhost:3306/dor_cleaning"connection = DriverManager.get

51、Connection(url, "root", "root");statement = connection.createStatement();resultSet = statement.executeQuery("select * from plan");String result = new String("修改成功");while (resultSet.next() if (resultSet.getString("number").equals(number) && !

52、resultSet.getString("number").equals(hidden_number) result = new String("对不起，修改失败，值日表中已经含有该学号，请检查");break;if (result.equals("修改成功") String url2 = "delete from plan where number="+hidden_number;String url3 = "insert into plan values('" + number +

53、"','" + name+ "','" + day + "','" + note + "')"statement.executeUpdate(url2);statement.executeUpdate(url3);statement.close();connection.close(); %><h2 align="center"><%=result %></h2><hr><form

54、 action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页"></td></tr></table></form></body></html>/文件名：delete.jsp<% page language="java" import="java.util

55、.*" pageEncoding="utf-8"%><%page import="java.sql.*"%><%String path = request.getContextPath();String basePath = request.getScheme() + ":/"+ request.getServerName() + ":" + request.getServerPort()+ path + "/"%><!DOCTYPE HTML PU

56、BLIC "-/W3C/DTD HTML 4.01 Transitional/EN"><html><head><base href="<%=basePath%>"><title>删除值日条目</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cach

57、e"><meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!-<link rel="stylesheet" type=&qu

58、ot;text/css" href="styles.css">-></head><body><h2 align="center">删除值日条目</h2><hr><form action="delete_check.jsp"><table align="center"><tr><td>请选择要删除的条目:</td><td><select name="

59、select" size="1"><%Connection connection = null;Statement statement = null;ResultSet resultSet = null;Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql:/localhost:3306/dor_cleaning"connection = DriverManager.getConnection(url, "root",

60、"root");statement = connection.createStatement();resultSet = statement.executeQuery("select * from plan");while (resultSet.next() %><option><%=resultSet.getString("number")%><%=resultSet.getString("name")%><%=resultSet.getString("d

61、ay")%><%=resultSet.getString("note")%></option><%resultSet.close();statement.close();connection.close();%></select></td><td align="center"><input type="submit" value="提交"></td></tr></table></form><hr><form action="index.jsp"><table align="center"><tr><td><input type="submit" value="返回首页"></td>