本文实例为大家分享了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,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,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,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,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,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>