JSP实训开发-学生选课系统之管理员操作
写完普通用户的功能接下来开始写管理员的操作功能。
详情要求可参考https://www.zaesky123.top/thread-65.htm
管理员左侧边栏功能模块：主要提供首页课程查询修改，用户管理和添加课程功能。
管理员左侧边栏jsp代码
<%@page import="com.sun.net.ssl.SSLContext"%>
<%@page import="java.util.*"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@page import="com.sun.xml.internal.bind.v2.runtime.Name"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML>
<!------------ 管理员左侧边栏功能 -------------->
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE11" />
<title>学生选课系统</title>
</head>
<link href="css/style.css" type="text/css" rel="stylesheet">
<body>
<% Date d = new Date();
SimpleDateFormat df = new SimpleDateFormat("yyyy年MM月dd日");
String now = df.format(d);
%>
<div>
<div><%=now %></div>
<div>
<form action="admin_search_classtable.jsp" method="post" target="right">
<input type="search" name="search" placeholder="查询课程">
<!--<input type="submit" name="search_btn" value="查询">-->
<input type="image" name="search_btn" src="img/sousuo.png" onClick="document.formName.submit()">
</form>
</div>
<div>
<ul>
<li style="background:url(img/shouye.png) no-repeat;background-size:30px;"><a href="admin_classtable.jsp" target="right">首页</a></li>
<li style="background:url(img/gerenxx.png) no-repeat;background-size:30px;"><a href="userset.jsp" target="right">用户管理</a></li>
<li style="background:url(img/xiugaimima.png) no-repeat;background-size:30px;"><a href="admin_addclass.jsp" target="right">添加课程</a></li>
</ul>
</div>
</div>
</body>
</html>管理员课程修改删除模块：管理员可在首页对课程进行修改可删除。
管理员修改课程jsp代码
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<!------------ 管理员-课程修改界面 ----------------->
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE11" />
<title>Insert title here</title>
</head>
<link rel="stylesheet" type="text/css" href="css/style.css">
<body>
<%
String url = "jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=UTF8"; //数据库名
String username = "root"; //数据库用户名
String password = ""; //数据库用户密码
Connection conn = null; //连接状态
Statement stmt = null;
ResultSet rs = null;
String classid=request.getParameter("classid");
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(url, username, password);
stmt = conn.createStatement(); //查询语句
rs = stmt.executeQuery("SELECT id,classid,classname,point,teacher,place,classtime FROM classsql where classid='"+classid+"';");
%>
<body bgcolor="#d9e1e8">
<div>
<form action="admin_us_process.jsp" method="post">
<table >
<caption><h1>修改课程<h1></caption>
<%while(rs.next()){ %>
<tr><td><input type="hidden" name="s_id" value="<%=rs.getString("id") %>"></td></tr>
<tr><td>课程号：<input type="text" name="s_classid" value="<%=rs.getString("classid") %>"></td></tr>
<tr><td>课程名：<input type="text" name="s_classname" value="<%=rs.getString("classname") %>"></td></tr>
<tr><td>学分：<input type="text" name="s_point" value="<%=rs.getString("point") %>"></td></tr>
<tr><td>老师：<input type="text" name="s_teacher" value="<%=rs.getString("teacher") %>"></td></tr>
<tr><td>地点：<input type="text" name="s_place" value="<%=rs.getString("place") %>"></td></tr>
<tr><td>时间：<input type="text" name="s_classtime" value="<%=rs.getString("classtime") %>"></td></tr>
<tr><td><input type="reset" value="清空"/>
<input type="submit" value="提交" name="rgsubmit"/></td></tr>
<%}
rs.close();
conn.close();
%>
</table>
</form>
</div>
</body>
</html>管理员修改课程处理过程jsp代码
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<!------------- 管理员-课程修改过程 -------------->
<html>
<head>
<title>Insert title here</title>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE11" />
</head>
<body>
<%
String url = "jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=UTF8"; //数据库名
String username = "root"; //数据库用户名
String password = ""; //数据库用户密码
Connection conn = null; //连接状态
Statement stmt = null;
ResultSet rs = null;
request.setCharacterEncoding("utf-8");
String id = request.getParameter("s_id");//课程id
String classid = request.getParameter("s_classid");//课程号
String classname = request.getParameter("s_classname");//课程名
String point = request.getParameter("s_point");//学分
String teacher = request.getParameter("s_teacher");//老师
String place = request.getParameter("s_place");//地点
String classtime = request.getParameter("s_classtime");//时间
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
//执行修改的sql语句
stmt.executeUpdate("update classsql set classid='"+classid+"',classname='"+classname+"',point='"+point+"',teacher='"+teacher+"',place='"+place+"',classtime='"+classtime+"' where id='"+id+"';");
out.println("<script language='javascript'>alert('修改成功！');window.location.href='admin_classtable.jsp';</script>");
%>
</body>
</html>管理员删除课程处理过程jsp代码
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<!----------------- 管理员删除课程过程 ------------------->
<html>
<head>
<title>Insert title here</title>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE11" />
</head>
<body>
<% String url = "jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=UTF8"; //数据库名
String username = "root"; //数据库用户名
String password = ""; //数据库用户密码
Connection conn = null; //连接状态
Statement stmt = null;
Statement stm = null;
ResultSet rs = null;
String classid=request.getParameter("classid");
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
stmt.executeUpdate("delete FROM classsql where classid='"+classid+"';");
out.println("<script language='javascript'>alert('删除成功！');window.location.href='admin_classtable.jsp';</script>");
%>
</body>
</body>
</html>
暂无评论