石家庄铁道大学选课管理系统2

jsp

主界面

<%@ page import="Bean.student" %>
<%@ page import="java.util.List" %>
<%@ page import="Dao.dao" %><%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/11/26
  Time: 13:42
  To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>石家庄铁道大学选课管理系统</title>
  <style type="text/css">
    .bg {
      background-image:url("src/图片1");
      background-size:cover;
    }
    *{font-style: "微软雅黑"}
    #table{ border-collapse: collapse; margin: auto;text-align: center;}
    #table th{background-color: #fff7d5;border: 1px solid black;}
    #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
    #table a{text-decoration: none;font-weight: bold;}
    #table a:hover {text-decoration: underline;}
  </style>
</head>
<body>

<form  method="post"  action="houtai.jsp"  class="form-login">
<h2 style="text-align: center;">石家庄铁道大学选课系统</h2>
<br>
<div style="text-align: center;">
    <tr>
        <td>身份:

            <select name="profession">
                <option value="1">管理员</option>
                <option value="2">教师</option>
                <option value="3" selected>学生</option>
            </select>
        </td>
    </tr>

    <tr><td>
        用户名:<input type="text" name="username"><br></tr>

    <tr><td>
        密码:<input pattern="[a-zA-Z0-9]{6,12}" type="password" name="password"></td> </tr>
    </div>

    <tr>
        <td colspan="2"><div align="center">
            <input type="submit" value="登录"></div></td> </tr>
    </table>
    </form>
</div>
</body>
</html>

houtai.jsp

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/11/26
  Time: 23:15
  To change this template use File | Settings | File Templates.
--%>


<%@ page import="java.sql.*"    contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="Bean.lesson" %>
<head>
    <title>从index获取数据</title>

</head>
<body>
<%
    //获取前端index的登录数据
    request.setCharacterEncoding("UTF-8");//编码一定设置
    String profession=request.getParameter("profession");
    String username=request.getParameter("username");
    String password=request.getParameter("password");//取出login.jsp的值


//1.将Driver驱动加载进jvm
    try {
        Class.forName ("com.mysql.cj.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    String mysqlname = "xuanke";
    String url = "jdbc:mysql://localhost:3306/"+mysqlname+"?serverTimezone=UTC";
    Connection cnn=null;
    Statement st = null;

    try {
        //2.创建链接对象
        cnn =  DriverManager.getConnection (url, "root", "123456");
        //3。创建sql语句

        String sql = "select * from userdata where username=" + "'" + username + "'";//定义一个查询语句
        System.out.println (sql);
        //创建链接管道
        st = cnn.createStatement ();
        //4.执行sql语句
        ResultSet res=st.executeQuery(sql);//运行上面的语句
        res.getObject("password");
        if (password.equals("123456")){
            switch(profession) {
                case "1":response.sendRedirect("manager.jsp");break;
                case "2": String teacher=request.getParameter("username");
                    // session.setAttribute("teacher", teacher);
                    request.setAttribute("teacher", teacher);
                    response.sendRedirect("teacher.jsp");break;
                case "3":String student=request.getParameter("username");
                    // session.setAttribute("teacher", teacher);
                    request.setAttribute("student", student);
                    response.sendRedirect("student.jsp");break;
            }

        } else {
            out.print("<script language='javaScript'> alert('密码错误');</script>");
            response.setHeader("refresh", "0;url=index.jsp");
        }
         }catch (Exception ignored){

          }
%>

</body>
</html>

student

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/11/26
  Time: 15:38
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <meta charset="UTF-8">
    <title>学生功能页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">你好!同学,请选择以下操作</h2>
<br>
<div style="text-align: center;">
    <a href="update.jsp" target="_self">修改个人信息</a><br>
    <a href="add.jsp" target="_self">浏览课程信息</a><br>
    <a href="add.jsp" target="_self">选课</a><br>

</div>
<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");

%>

</body>
</html>

teacher

<%@ page import="Bean.lesson" %><%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/11/26
  Time: 16:02
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <meta charset="UTF-8">
    <title>教师功能页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">你好!教师,请选择以下操作</h2>
<br>
<div style="text-align: center;">
    <a href="update2.jsp" target="_self">修改个人信息</a><br>
    <a href="add.jsp" target="_self">浏览选课学生信息</a><br>
    <a href="add3.jsp" target="_self">添加课程</a><br>

</div>
<br>
<%

    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");

%>

</body>
</html>

manager

<%--
  Created by IntelliJ IDEA.
  User: 榕宝
  Date: 2021/11/26
  Time: 15:39
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <meta charset="UTF-8">
    <title>管理员功能页面</title>
    <style type="text/css">
        .bg {
            background-image:url(images/bg_2.jpg);
            background-size:cover;
        }
        *{font-style: "微软雅黑"}
        #table{ border-collapse: collapse; margin: auto;text-align: center;}
        #table th{background-color: #fff7d5;border: 1px solid black;}
        #table td{background-color:#cffcd5;border: 1px solid black;padding: 15px;color: #000;}
        #table a{text-decoration: none;font-weight: bold;}
        #table a:hover {text-decoration: underline;}
    </style>
</head>
<body class="bg">
<h2 style="text-align: center;">你好!管理员,请选择以下操作</h2>
<br>
<div style="text-align: center;">
    <a href="add.jsp" target="_self">添加学生信息</a><br>
    <a href="add2.jsp" target="_self">添加教师信息</a><br>

</div>
<br>
<%
    request.setCharacterEncoding("utf-8");
    response.setCharacterEncoding("utf-8");

%>

</body>
</html>

 

posted @ 2021-11-26 22:50  zrswheart  阅读(177)  评论(0编辑  收藏  举报