欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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="提交">&nbsp;&nbsp;&nbsp;
 <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>&nbsp;&nbsp;
 最小:<input type="text" name="a1"><br><br>&nbsp;
 最大:<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="提交">&nbsp;&nbsp;&nbsp;
  <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="提交">&nbsp;&nbsp;&nbsp;
  <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>

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。