请登录后探索更多精彩内容!
写完普通用户的功能接下来开始写管理员的操作功能。
详情要求可参考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>
暂无评论
请先登录后发表评论!
暂无评论