JSP学生信息管理系统设计(简单的学生信息管理系统界面java)学会了吗

随心笔谈9个月前发布 admin
70 0



本文实例为大家分享了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=”https://www.jb51.net/article/stuinsert.jsp” rel=”external nofollow” rel=”external nofollow” >返回菜单</a><br>
<a href=”https://www.jb51.net/article/main.jsp” rel=”external nofollow” ></a>
<%}else{
out.println(“该学号已存在”);%>
<a href=”https://www.jb51.net/article/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>

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

您可能感兴趣的文章:VueJS实现用户管理系统Node.js实现简单管理系统jdbc+jsp实现简单员工管理系统JSP实现简单人事管理系统JSP实现客户信息管理系统详解nodejs中express搭建权限管理系统基于jsp实现新闻管理系统 附完整源码如何使用AngularJs打造权限管理系统【简易型】JSP学生信息管理系统js实现车辆管理系统

© 版权声明

相关文章