<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<title>石家庄铁道大学选课管理系统</title>
</head>
<body>
<h1>石家庄铁道大学选课管理系统</h1>
<h2>请选择您的身份：</h2>
<ul>
<li><a href="teacher_manage.jsp">教师账号登录</a></li>
<li><a href="student_manage.jsp">学生账号登录</a></li>
<li><a href="manage.jsp">管理员账号登录</a></li>
</ul>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<title>学生功能页</title>
</head>
<body>
<h1>功能菜单：</h1>
<ul>
<li><a href="">浏览课程信息</a></li>
<li><a href="update_student.jsp">修改个人信息</a></li>
<li><a href="">选课</a></li>
</ul>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<title>教师功能页</title>
</head>
<body>
<h1>功能菜单：</h1>
<ul>
<li><a href="">添加课程</a></li>
<li><a href="update_teacherProcess.jsp">修改个人信息</a></li>
<li><a href="">浏览选课学生信息</a></li>
</ul>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<title>管理员登录页面</title>
</head>
<body>
<h1>请输入管理员专属账号：</h1>
<form action="manage_deng.jsp" method="POST">
<label for="id">账号：</label>
<input type="text" name="id" id="id" required>
<br><br>
<label for="mi">密码：</label>
<input type="text" name="mi" id="mi" required>
<br><br>
<input type="submit" value="登录">
</form>
</body>
</html>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<%
request.setCharacterEncoding("UTF-8");
String id = request.getParameter("id");
String mi = request.getParameter("mi");
// 数据库连接信息
String dbURL = "jdbc:mysql://localhost:3306/select_class";
String dbUsername = "root";
String dbPassword = "822611";
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
// 连接数据库
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(dbURL, dbUsername, dbPassword);
// 查询学生信息的SQL语句
String sql = "SELECT * FROM teacher_id WHERE id = ? AND mi=?";
// 创建PreparedStatement对象
statement = connection.prepareStatement(sql);
// 设置参数值
statement.setString(1, id);
statement.setString(2, mi);
// 执行查询操作
resultSet = statement.executeQuery();
// 检查是否有结果
if (resultSet.next()) {
response.sendRedirect("teacher.jsp");
} else {
out.println("账号或密码错误");
}
} catch (Exception e) {
// 处理异常情况
out.println("登录异常：" + e.getMessage());
} finally {
// 关闭ResultSet、PreparedStatement和数据库连接
if (resultSet != null) {
resultSet.close();
}
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
}
%>
