学生管理系统(web版)_学生管理系统web项目-CSDN博客

本文链接：https://blog.csdn.net/suzhuhua/article/details/123959154

index.jsp页面：绑定所有的学生信息(类似新闻中的admin页面)

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script language="javascript">
				function clickdel() {
					return confirm("删除请点击确认");
				}
			</script>
</head>
<body background = 'images/1.jpg'>
<form action = 'index.jsp'>
	<div align = 'center'>
	<a style = 'color:pink' href = "add.jsp">添加</a>
	<input type = 'text' name = 'str'>
		<input type = 'submit' value = '查询'>
	</div>
</form>
	<div align="center">
		<ul>
			<%
				String str = request.getParameter("str");
				String sql = "select * from T277 order by uuid";
				if(str != null){
					sql = "select * from T277 where uname like '%"+str+"%'";
				}
				//注册驱动类
				Class.forName("oracle.jdbc.driver.OracleDriver");
				//连接数据库
				String url = "jdbc:oracle:thin:@localhost:1521:orcl";
				Connection con = DriverManager.getConnection(url, "scott", "tiger");
				//创建Pre对象
				PreparedStatement ps = con.prepareStatement(sql);
				//执行sql语句
				ResultSet rs = ps.executeQuery();
				//处理结果-遍历结果集
				while (rs.next()) {
			%>
			<li><%=rs.getString("uname")%>
				<%out.print("&nbsp"+"&nbsp"+"&nbsp"); %>
				<%=rs.getString("upwd")%>
				<%out.print("&nbsp"+"&nbsp"+"&nbsp"); %>
				<%=rs.getString(4)%>
				<%out.print("&nbsp"+"&nbsp"+"&nbsp"); %>
				<a style = 'color:pink' href="update.jsp?uuid=<%=rs.getInt(1)%>">修改</a>
				<%out.print("&nbsp"+"&nbsp"+"&nbsp"); %>
				<a style = 'color:pink'
				href="info.jsp?uuid=<%=rs.getInt(1)%>&&uname=<%=rs.getString(2)%>&&upwd=<%=rs.getString(3)%>&&uinfo=<%=rs.getString(4)%>">详情</a>
				<%out.print("&nbsp"+"&nbsp"+"&nbsp"); %>
				<a style = 'color:pink' href="dodel.jsp?uuid=<%=rs.getInt(1) %>" onclick = 'clickdel()'>删除</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 background = 'images/1.jpg'>
	<form action='doadd.jsp'>
		<div align='center'>
			用户名：<input type='text' name='uname'>
		</div>
		<div align='center'>
			密码：<input type='text' name='upwd'>
		</div>
		<div align='center'>
			备注：<input type='text' name='uinfo'>
		</div>
		<div align='center'>
			<input type='submit' value='添加'>
		</div>
	</form>
</body>
</html>

doadd_stu.jsp

<%
	Class.forName("oracle.jdbc.driver.OracleDriver");
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	Connection con = DriverManager.getConnection(url, "scott", "tiger");
	PreparedStatement ps = con.prepareStatement("select max(uuid) from T277 ");
	ResultSet rs = ps.executeQuery();
	int nextId = 1;
	if(rs.next()){
		nextId = rs.getInt(1)+1;
	}
	String uname = request.getParameter("uname");
	String upwd = request.getParameter("upwd");
	String uinfo = request.getParameter("uinfo");
	ps = con.prepareStatement("insert into T277 values (?,?,?,?)");
	ps.setInt(1, nextId);
	ps.setString(2, uname);
	ps.setString(3, upwd);
	ps.setString(4,uinfo);
	int i = ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('添加成功');location.href='index.jsp'</script>");
	}else{
		out.print("<script>alert('添加失败');location.href='index.jsp'</script>");
	}
%>

删除学生dodel_stu.jsp

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

修改学生update_stu.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body background = 'images/1.jpg'>
	<form action='doup.jsp'>
		<div align='center'>
			<input type='hidden' value=<%=request.getParameter("uuid")%> name = 'uuid'>
			用户名：<input type='text' name='uname'>
		</div>
		<div align='center'>
			密码：<input type='text' name='upwd'>
		</div>
		<div align='center'>
			备注：<input type='text' name='uinfo'>
		</div>
		<div align='center'>
			<input type='submit' value='修改'>
		</div>
	</form>
</body>
</html>

doupdate_stu.jsp

<%
	String id = request.getParameter("uuid");
	int uuid = Integer.valueOf(id);
	String uname = request.getParameter("uname");
	String upwd = request.getParameter("upwd");
	String uinfo = request.getParameter("uinfo");
	//注册驱动类
	Class.forName("oracle.jdbc.driver.OracleDriver");
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	//
	Connection con = DriverManager.getConnection(url, "scott", "tiger");
	PreparedStatement ps = con.prepareStatement("update T277 set uname = ?,upwd = ?,uinfo = ? where uuid=" + uuid);
	ps.setString(1, uname);
	ps.setString(2, upwd);
	ps.setString(3, uinfo);
	int i = ps.executeUpdate();
	if(i>0){
		out.print("<script>alert('修改成功');location.href='index.jsp'</script>");
	}else{
		out.print("<script>alert('修改失败');location.href='update.jsp'</script>");
	}
%>

查看学生详情info_stu.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action='index.jsp'>
		<div align='center'>
			用户名：<input type='text' name='uname' value = <%=request.getParameter("uname") %>>
		</div>
		<div align='center'>
			密码：<input type='text' name='upwd' value = <%=request.getParameter("upwd") %>>
		</div>
		<div align='center'>
			备注：<input type='text' name='uinfo' value = <%=request.getParameter("uinfo") %>>
		</div>
		<div align='center'>
			<input type='submit' value='返回'>
		</div>
	</form>
</body>
</html>