学生管理系统（web版）

最新推荐文章于 2023-10-21 17:27:05 发布

Parsley_Peak

最新推荐文章于 2023-10-21 17:27:05 发布

阅读量353

点赞数

文章标签： java-ee

本文链接：https://blog.csdn.net/Parsley_Peak/article/details/123959226

版权

admin.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="admin.jsp" align="center">
		<input type="text" name="str"> <input type="submit" value="查询">
	</form>
	<table border="1" align="center" width="80%">
		<tr>
			<td>编号</td>
			<td>姓名</td>
			<td>性别</td>
			<td>年龄</td>
			<td>爱好</td>
			<td>地址</td>
			<td>操作</td>
		</tr>
		<%
			//获取模糊查询的关键字
			String str=request.getParameter("str");
			if(str==null){
				str="";
			}
			String sql="select * from stus where sname like '%"+str+"%' order by sid";
			//连接数据库
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@localhost:1521:orcl";
			Connection con = DriverManager.getConnection(url, "scott", "1234");
			PreparedStatement ps = con.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
		%>
		<tr align="center">
			<td><%=rs.getInt(1)%></td>
			<td><%=rs.getString("sname")%></td>
			<td><%=rs.getString("sex")%></td>
			<td><%=rs.getInt(4)%></td>
			<td><%=rs.getString("slike")%></td>
			<td><%=rs.getString("saddress")%></td>
			<td><a href="update_stus.jsp?sid=<%=rs.getInt(1) %>">修改</a> <a href="doinfo.jsp?sid=<%=rs.getInt(1) %>">详情</a> <a href="dodel_stus.jsp?sid=<%=rs.getInt(1) %>">删除</a></td>
		</tr>
		<%
			}
		%>
	</table><br>
	<div id="opt_list">
			<ul>
				<li><a href="add_stus.jsp">添加学生</a></li>
			</ul>
		</div>
</body>
</html>

add_stu.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="doadd_stus.jsp" method="post">
		姓名:<input type="text" name="sname"><br> 
		性别:<input name="sex" type="radio" />男
			<input checked='true' type="radio" name="sex" />女<br>
		年龄:<input type="text" name="sage"><br>
		爱好:<input type="text" name="slike"><br> 
		地址:<input type="text" name="saddress"><br> 
		<input type="submit" value="添加"> 
		<input type="reset" value="重置">
	</form>
</body>
</html>

doadd_stu.jsp

<%
	request.setCharacterEncoding("utf-8");
	String sname=request.getParameter("sname");
	String sex=request.getParameter("sex");
	String sage=request.getParameter("sage");
	String slike=request.getParameter("slike");
	String saddress=request.getParameter("saddress");
	//连接数据库
	Class.forName("oracle.jdbc.OracleDriver");
	String url="jdbc:oracle:thin:@localhost:1521:ORCL";
	Connection con=DriverManager.getConnection(url, "scott", "1234");
	//获取学生的下一个编号
	int nextSid=1;
	PreparedStatement ps=con.prepareStatement("select max(sid) from stus");
	ResultSet rs=ps.executeQuery();
	if(rs.next()){
		nextSid=rs.getInt(1)+1;
	}
 	ps=con.prepareStatement("insert into stus values(?,?,?,?,?,?)");
	ps.setInt(1, nextSid);
	ps.setString(2, sname);
	ps.setString(3,sex);
	ps.setString(4,sage);
	ps.setString(5,slike);
	ps.setString(6,saddress);
	int i=ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('添加成功');location.href='admin.jsp'</script>");	
	}else{
		out.print("<script>alert('添加失败');location.href='add_stus.jsp'</script>");
	}
%>

dodel.jsp

<%
	int sid = Integer.valueOf(request.getParameter("sid"));
	Class.forName("oracle.jdbc.driver.OracleDriver");
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	Connection con = DriverManager.getConnection(url, "scott", "1234");
	PreparedStatement ps = con.prepareStatement("delete stus where sid=" + sid);
	int i = ps.executeUpdate();
	if (i > 0) {
		out.print("<script>alert('删除成功');location.href='admin.jsp'</script>");
	} else {
		out.print("<script>alert('删除失败');location.href='admin.jsp'</script>");
	}
%>

doinfo.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<%
		int sid = Integer.valueOf(request.getParameter("sid"));
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//2、连接数据库
		String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
		Connection con = DriverManager.getConnection(url, "scott", "1234");
		//3、定义那个对象，用来执行sql语句
		PreparedStatement ps = con.prepareStatement("select * from stus where sid=" + sid);
		ResultSet rs = ps.executeQuery();
		String sname = "";
		String sex = "";
		String sage = "";
		String slike= "";
		String saddress= "";
		if (rs.next()) {
			sname = rs.getString(2);
			sex = rs.getString(3);
			sage = rs.getString(4);
			slike = rs.getString(5);
			saddress = rs.getString(6);
		}
	%>
	<form action="admin.jsp" method="post">
		姓名:<input type="text" value="<%=sname %>" name="sname"><br> 
		性别:<input type="text" value="<%=sex %>" name="sex"><br> 
		年龄:<input type="text" value="<%=sage %>" name="sage"><br> 
		爱好:<input type="text" value="<%=slike %>" name="slike"><br>
		地址:<input type="text" value="<%=saddress %>" name="saddress"><br>
		<input name="sid" type="hidden" value="<%=sid%>">
		 <input type="submit" value="返回">
	</form>
</body>
</html>

doupdate.jsp

<%
	request.setCharacterEncoding("utf-8");
	int sid = Integer.valueOf(request.getParameter("sid"));
	String sname=request.getParameter("sname");
	String sex=request.getParameter("sex");
	String sage=request.getParameter("sage");
	String slike=request.getParameter("slike");
	String saddress=request.getParameter("saddress");
	//连接数据库
	Class.forName("oracle.jdbc.OracleDriver");
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	Connection con = DriverManager.getConnection(url, "scott", "1234");
	PreparedStatement ps  = con.prepareStatement("update stus set sname=?,sex=?,sage=?,slike=?,saddress=? where sid="+sid);
	ps.setString(1, sname);
	ps.setString(2, sex);
	ps.setString(3, sage);
	ps.setString(4, slike);
	ps.setString(5, saddress);
	int i = ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('修改成功');location.href='admin.jsp'</script>");
	}else{
		out.print("<script>alert('修改失败');location.href='update_stus.jsp'</script>");
	}
%>

update.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<%
		int sid = Integer.valueOf(request.getParameter("sid"));
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//2、连接数据库
		String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
		Connection con = DriverManager.getConnection(url, "scott", "1234");
		//3、定义那个对象，用来执行sql语句
		PreparedStatement ps = con.prepareStatement("select * from stus where sid=" + sid);
		ResultSet rs = ps.executeQuery();
		String sname = "";
		String sex = "";
		String sage = "";
		String slike= "";
		String saddress= "";
		if (rs.next()) {
			sname = rs.getString(2);
			sex = rs.getString(3);
			sage = rs.getString(4);
			slike = rs.getString(5);
			saddress = rs.getString(6);
		}
	%>
	<form action="doupdate_stus.jsp" method="post">
		姓名:<input type="text" value="<%=sname %>" name="sname"><br> 
		性别:<input type="text" value="<%=sex %>" name="sex"><br> 
		年龄:<input type="text" value="<%=sage %>" name="sage"><br> 
		爱好:<input type="text" value="<%=slike %>" name="slike"><br>
		地址:<input type="text" value="<%=saddress %>" name="saddress"><br>
		<input name="sid" type="hidden" value="<%=sid%>">
		 <input type="submit" value="修改"> <input type="reset" value="重置">
	</form>
</body>
</html>