JSP学生信息管理系统设计
程序员文章站
2022-07-06 14:20:17
本文实例为大家分享了jsp学生信息管理系统源码,供大家参考,具体内容如下
新建学生信息数据库
1.添加记录模块
<%@ page contenttype...
本文实例为大家分享了jsp学生信息管理系统源码,供大家参考,具体内容如下
新建学生信息数据库
1.添加记录模块
<%@ page contenttype="text/html" pageencoding="utf-8"%> <html> <head> <title>添加新学生</title> </head> <body> <form action="stuinsert2.jsp" method="post"> <table border="0" width="238" heigth="252"> <tr><td>学号:</td><td><input type="text" name="id"></td></tr> <tr><td>姓名</td><td><input type="text" name="name"></td></tr> <tr><td>性别</td><td><input type="text" name="sex"></td></tr> <tr><td>年龄</td><td><input type="text" name="age"></td></tr> <tr><td>专业</td><td><input type="text" name="sdept"></td></tr> <tr align="center"> <td colspan="2"> <input type="submit" value="提交"> <input type="reset" value="取消"> </td> </tr> </table> </form> </body> </html>
<%@ page language="java" import="java.sql.*" pageencoding="utf-8"%> <html> <head> <title>添加学生处理程序</title> </head> <body> <% class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver"); string url="jdbc:sqlserver://localhost:1433; databasename=p"; string user="sa"; string password="123456"; connection conn=drivermanager.getconnection(url,user,password); request.setcharacterencoding("utf-8"); string id=request.getparameter("id"); string name=request.getparameter("name"); string sex=request.getparameter("sex"); int age=integer.parseint(request.getparameter("age")); string sdept=request.getparameter("sdept"); string sql=string.format("select * from student where sno=%s",id); statement stmt=conn.createstatement(); preparedstatement pstmt; resultset rs=stmt.executequery(sql); if(!(rs.next())){ pstmt=conn.preparestatement("insert into student values(?,?,?,?,?)"); pstmt.setstring(1,id); pstmt.setstring(2,name); pstmt.setstring(3,sex); pstmt.setint(4,age); pstmt.setstring(5,sdept); pstmt.executeupdate(); out.print("添加成功"); %> <a href="stuinsert.jsp" rel="external nofollow" rel="external nofollow" >返回菜单</a><br> <a href="main.jsp" rel="external nofollow" ></a> <%}else{ out.println("该学号已存在");%> <a href="stuinsert.jsp" rel="external nofollow" rel="external nofollow" >重新添加</a> <%}%> </body> </html>
2.查询(all)模块
<%@ page language="java" import="java.sql.*" pageencoding="utf-8"%> <%@ page import="javax.sql.*" %> <%@ page import="javax.naming.*" %> <html> <head> <title>信息查看页面</title> </head> <body> <center> <% datasource ds=null; initialcontext ctx=new initialcontext(); ds=(datasource)ctx.lookup("java:comp/env/jdbc/sqlserver"); connection conn=ds.getconnection(); preparedstatement pstmt=conn.preparestatement("select * from student"); resultset rs=pstmt.executequery(); %> <table border="2" bgcolor="ccceee" width="650"> <tr bgcolor="cccccc" align="center"> <td>记录条数</td><td>学号</td><td>姓名</td> <td>性别</td><td>年龄</td><td>专业</td> </tr> <% while(rs.next()){ %> <tr align="center"> <td><%=rs.getrow()%></td> <td><%=rs.getstring(1)%></td> <td><%=rs.getstring(2)%></td> <td><%=rs.getstring(3)%></td> <td><%=rs.getstring(4)%></td> <td><%=rs.getstring(5)%></td> </tr> <%}%> </center> <%if(rs!=null){rs.close();} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %> </table> </body> </html>
条件查询模块
<%@ page language="java" pageencoding="utf-8"%> <html> <head> <title>my jsp 'stufind2.jsp' starting page</title> </head> <body> 请选择查询条件<hr width="100%" size="3"> <form action="stufind3.jsp" method="post"> 性别<input type="radio" value="男" name="sex" checked="checked">男 <input type="radio" value="女" name="sex">女 年龄范围:<p> 最小:<input type="text" name="a1"><br><br> 最大:<input type="text" name="a2"><p> <input type="submit" value="提交"> <input type="reset" value="取消"> </form> </body> </html>
<%@ page contenttype="text/html" import="java.sql.*" pageencoding="utf-8"%> <html> <head> <title>条件查询处理页面</title> </head> <body> <center> <%class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver"); string user="sa"; string password="123456"; string url="jdbc:sqlserver://localhost:1433;databasename=p"; connection conn=drivermanager.getconnection(url,user,password); request.setcharacterencoding("utf-8"); string sex=request.getparameter("sex"); int age1=integer.parseint(request.getparameter("a1")); int age2=integer.parseint(request.getparameter("a2")); string sql="select * from student where ssex=? and sage>=? and sage<=?"; preparedstatement pstmt=conn.preparestatement(sql); pstmt.setstring(1,sex); pstmt.setint(2,age1); pstmt.setint(3,age2); resultset rs=pstmt.executequery(); %> <table border="2" bgcolor="ccceee" width="650"> <tr bgcolcor="cccccc" align="center"> <td>记录条数</td><td>学号</td><td>姓名</td> <td>性别</td><td>年龄</td><td>专业</td> </tr> <%while(rs.next()){ %> <tr align="center"> <td><%=rs.getrow()%></td> <td><%=rs.getstring(1)%></td> <td><%=rs.getstring(2)%></td> <td><%=rs.getstring(3)%></td> <td><%=rs.getstring(4)%></td> <td><%=rs.getstring(5)%></td> </tr> <%}%> </table> <%if(rs!=null){rs.close();} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %> </center> </body> </html>
3.修改模块
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <html> <head> <title>修改提交页面</title> </head> <body> <center> 请选择修改记录所满足的条件 <form action="stuupdate2.jsp" method="post"> 姓名: <input type="text" name="name"><br><br> 性别: 男<input type="radio" value="男" name="sex"> 女<input type="radio" value="女" name="sex"><br><br> <input type="submit" value="提交"> <input type="reset" value="取消"> </form> </center> </body> </html>
<%@ page contenttype="text/html" import="java.sql.*" pageencoding="utf-8"%> <html> <head> <title>修改编辑页面</title> </head> <body> <% class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver"); string user="sa"; string password="123456"; string url="jdbc:sqlserver://localhost:1433;databasename=p"; connection conn=drivermanager.getconnection(url,user,password); request.setcharacterencoding("utf-8"); string name=request.getparameter("name"); string sex=request.getparameter("sex"); session.setattribute("sex",sex); session.setattribute("name",name); string sql="select * from student where ssex=? and sname=?"; preparedstatement pstmt=conn.preparestatement(sql); pstmt.setstring(1,sex); pstmt.setstring(2,name); resultset rs=pstmt.executequery(); if(rs.next()){ string id=rs.getstring("sno"); string name2=rs.getstring("sname"); string sex2=rs.getstring("ssex"); int age=rs.getint("sage"); string sdept=rs.getstring("sdept"); if(pstmt!=null){pstmt.close();} if(rs!=null){rs.close();} if(conn!=null){conn.close();} %> <form action="stuupdate3.jsp" method="post"> <table border="0" width="238" height="252"> <tr><td>学号:</td><td><input type="text" name="id" value=<%=id%>></td></tr> <tr><td>姓名:</td><td><input type="text" name="name2" value=<%=name2%>></td></tr> <tr><td>性别:</td><td><input type="text" name="sex2" value=<%=sex2%>></td></tr> <tr><td>年龄:</td><td><input type="text" name="age" value=<%=age%>></td></tr> <tr><td>专业:</td><td><input type="text" name="sdept" value=<%=sdept%>></td></tr> <tr align="center"> <td colspan="2"> <input type="submit" value="提交"> <input type="reset" value="取消"> </td> </tr> </table> </form> <%} else{%> 没有找到合适条件的记录!!<% if(rs!=null){rs.close();} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} }%> </body> </html>
<%@ page language="java" import="java.sql.*" pageencoding="utf-8"%> <html> <head> <title>修改后重写页面</title> </head> <body> <% class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver"); string url="jdbc:sqlserver://localhost:1433; databasename=p"; string user="sa"; string password="123456"; connection conn=drivermanager.getconnection(url,user,password); string sql="update student set sno=?,sname=?,ssex=?,sage=?,sdept=? where sname=? and ssex=?"; preparedstatement pstmt=conn.preparestatement(sql); request.setcharacterencoding("utf-8"); string id=request.getparameter("id"); string name2=request.getparameter("name2"); string sex2=request.getparameter("sex2"); int age=integer.parseint(request.getparameter("age")); string sdept=request.getparameter("sdept"); string name=(string)session.getattribute("name"); string sex=(string)session.getattribute("sex"); pstmt.setstring(1,id); pstmt.setstring(2,name2); pstmt.setstring(3,sex2); pstmt.setint(4,age); pstmt.setstring(5,sdept); pstmt.setstring(6,name); pstmt.setstring(7,sex); int n=pstmt.executeupdate(); if(n>=1){%>重写数据库操作成功!<br><%} else{%>重写数据库操作失败!<br><%} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %> </body> </html>
4.删除记录模块
<%@ page language="java" import="java.util.*" pageencoding="utf-8"%> <html> <head> <title>条件删除提交页面</title> </head> <body> 请选择删除记录条件<<hr width="100%" size="3"> <form action="studelete2.jsp" method="post"> 姓名:<input type="text" name="name"><br><br> 性别:男<input type="radio" value="男" name="sex"> 女<input type="radio" value="女" name="sex"><br><br> 年龄范围:<br><p> 最小:<input type="text" name="a1"><br> 最大:<input type="text" name="a2"> </p> <input type="submit" value="提交"> <input type="reset" value="取消"> </form> </body> </html>
<%@ page language="java" import="java.sql.*" pageencoding="utf-8"%> <html> <head> <title>条件删除处理页面</title> </head> <body> <% class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver"); string user="sa"; string password="123456"; string url="jdbc:sqlserver://localhost:1433;databasename=p"; connection conn=drivermanager.getconnection(url,user,password); request.setcharacterencoding("utf-8"); string name=request.getparameter("name"); string sex=request.getparameter("sex"); string ag1=request.getparameter("a1"); string ag2=request.getparameter("a2"); int a3,a4; string sql="delete from student where sname=? and ssex=? and sage>=? and sage<=?"; preparedstatement pstmt=conn.preparestatement(sql); if(!name.equals("")) pstmt.setstring(1,name); if(sex!=null) pstmt.setstring(2,sex); if(!ag1.equals("")){a3=integer.parseint(ag1); pstmt.setint(3,a3);} if(!ag2.equals("")){a4=integer.parseint(ag2); pstmt.setint(4,a4);} int n=pstmt.executeupdate(); if(n==1){%>数据删除成功<br><%} else{%>数据删除失败!<br><%} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %> </body> </html>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。
上一篇: 实例分析基于PHP微信网页获取用户信息