本文實(shí)例為大家分享了JSP學(xué)生信息管理系統(tǒng)源碼，供大家參考，具體內(nèi)容如下
新建學(xué)生信息數(shù)據(jù)庫
1.添加記錄模塊
<%@ page contentType="text/html" pageEncoding="UTF-8"%><html> <head> <title>添加新學(xué)生</title> </head> <body> <form action="stuinsert2.jsp" method="post"> <table border="0" width="238" heigth="252"> <tr><td>學(xué)號：</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>專業(yè)</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>添加學(xué)生處理程序</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("該學(xué)號已存在");%> <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>記錄條數(shù)</td><td>學(xué)號</td><td>姓名</td> <td>性別</td><td>年齡</td><td>專業(yè)</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>記錄條數(shù)</td><td>學(xué)號</td><td>姓名</td> <td>性別</td><td>年齡</td><td>專業(yè)</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>學(xué)號:</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>專業(yè):</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{%> 沒有找到合適條件的記錄?。?lt;% 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){%>重寫數(shù)據(jù)庫操作成功！<br><%} else{%>重寫數(shù)據(jù)庫操作失敗！<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> 最?。?lt;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){%>數(shù)據(jù)刪除成功<br><%} else{%>數(shù)據(jù)刪除失?。?lt;br><%} if(pstmt!=null){pstmt.close();} if(conn!=null){conn.close();} %> </body></html>以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持VeVb武林網(wǎng)。
新聞熱點(diǎn)
疑難解答
圖片精選
