简单网课选课系统

最新推荐文章于 2022-12-04 14:11:13 发布

狐狸先森。

最新推荐文章于 2022-12-04 14:11:13 发布

阅读量544

点赞数 1

分类专栏：选课系统 tomcat 文章标签： java idea mysql

本文链接：https://blog.csdn.net/weixin_61684487/article/details/127520624

版权

选课系统同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

tomcat

1 篇文章 0 订阅

订阅专栏

登入界面：

管理员界面：

学生界面：

完整代码：

kuser：

package dao;

public class kUser {
    private Integer k_id;
    private String k_kcm;
    private String k_js;
    private Integer k_jxl;
    private String k_sj;
    private Integer k_xf;

    public Integer getK_id() {
        return k_id;
    }

    public void setK_id(Integer k_id) {
        this.k_id = k_id;
    }

    public String getK_kcm() {
        return k_kcm;
    }

    public void setK_kcm(String k_kcm) {
        this.k_kcm = k_kcm;
    }

    public String getK_js() {
        return k_js;
    }

    public void setK_js(String k_js) {
        this.k_js = k_js;
    }

    public Integer getK_jxl() {
        return k_jxl;
    }

    public void setK_jxl(Integer k_jxl) {
        this.k_jxl = k_jxl;
    }

    public String getK_sj() {
        return k_sj;
    }

    public void setK_sj(String k_sj) {
        this.k_sj = k_sj;
    }

    public Integer getK_xf() {
        return k_xf;
    }

    public void setK_xf(Integer k_xf) {
        this.k_xf = k_xf;
    }

}

suser：

package dao;

public class sUser {
    private Integer s_id;
    private String s_word;
    private String s_pass;
    private String s_name;
    private Integer s_bj;
    private String s_xy;
    private Integer s_xk;

    public Integer getS_xk() {
        return s_xk;
    }

    public void setS_xk(Integer s_xk) {
        this.s_xk = s_xk;
    }

    public Integer getS_id() {
        return s_id;
    }

    public void setS_id(Integer s_id) {
        this.s_id = s_id;
    }

    public String getS_name() {
        return s_name;
    }

    public void setS_name(String s_name) {
        this.s_name = s_name;
    }

    public String getS_word() {
        return s_word;
    }

    public void setS_word(String s_word) {
        this.s_word = s_word;
    }

    public String getS_pass() {
        return s_pass;
    }

    public void setS_pass(String s_pass) {
        this.s_pass = s_pass;
    }

    public Integer getS_bj() {
        return s_bj;
    }

    public void setS_bj(Integer s_bj) {
        this.s_bj = s_bj;
    }

    public String getS_xy() {
        return s_xy;
    }

    public void setS_xy(String s_xy) {
        this.s_xy = s_xy;
    }


}

user：

package dao;

public class User {
    private Integer id;
    private String u_word;
    private String u_pass;
    private String u_name;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getU_word() {
        return u_word;
    }

    public void setU_word(String u_word) {
        this.u_word = u_word;
    }

    public String getU_pass() {
        return u_pass;
    }

    public void setU_pass(String u_pass) {
        this.u_pass = u_pass;
    }

    public String getU_name() {
        return u_name;
    }

    public void setU_name(String u_name) {
        this.u_name = u_name;
    }


}

userdao：

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class userDao {
    private Connection con = null;
    private PreparedStatement ps = null;

    static {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    private void prepareConnection() {
        try {
            if (con == null || con.isClosed()) {
                con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true", "设置自己的数据库账户", "设置自己的数据库密码");
            }
        } catch (SQLException e) {
            throw new RuntimeException("###" + e.getMessage());
        }
    }

    private void close() {
        try {
            if (ps != null) {
                ps.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException e) {
            throw new RuntimeException("?????????:" + e.getMessage());
        }
    }

    private void rollback() {
        try {
            con.rollback();
        } catch (SQLException e) {
            throw new RuntimeException("??????:" + e.getMessage());
        }
    }

    public boolean yzUser(sUser suser) {
        boolean val = false;

        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM s_user ");
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                if (rs.getString(2).equals(suser.getS_word()) && rs.getString(3).equals(suser.getS_pass())) {
                    val = true;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return val;

    }

    public int zcUser(sUser suser) {
        int i = 0;

        try {
            prepareConnection();
            con.setAutoCommit(false);
            String sql = "INSERT INTO s_user (s_word,s_pass,s_name,s_bj,s_xy) VALUES(?,?,?,?,?)";
            ps = con.prepareStatement(sql);
            ps.setString(1, suser.getS_word());
            ps.setString(2, suser.getS_pass());
            ps.setString(3, suser.getS_name());
            ps.setInt(4, suser.getS_bj());
            ps.setString(5, suser.getS_xy());
            i = ps.executeUpdate();
            con.commit();
        } catch (SQLException e) {
            rollback();
            e.printStackTrace();
        } finally {
            close();
        }
        return i;
    }

    public List<kUser> getAllkUser() {
        List<kUser> kusers = new ArrayList<kUser>();
        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM k_user ");
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                kUser kuser = new kUser();
                kuser.setK_id(rs.getInt(1));
                kuser.setK_kcm(rs.getString(2));
                kuser.setK_js(rs.getString(3));
                kuser.setK_jxl(rs.getInt(4));
                kuser.setK_sj(rs.getString(5));
                kuser.setK_xf(rs.getInt(6));
                kusers.add(kuser);
                // ?????????к??м???????????????????User????????????List??
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return kusers;
    }

    public kUser getkUserById(Integer id) {
        kUser kuser = null;
        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM k_user WHERE k_id=?");
            ps.setInt(1, id);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                kuser = new kUser();
                kuser.setK_id(rs.getInt(1));
                kuser.setK_kcm(rs.getString(2));
                kuser.setK_js(rs.getString(3));
                kuser.setK_jxl(rs.getInt(4));
                kuser.setK_sj(rs.getString(5));
                kuser.setK_xf(rs.getInt(6));

                // ?????????к??м???????????????????User????
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return kuser;
    }

    public Integer getNameByid(sUser suser) {
        Integer a = null;
        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM s_user WHERE s_word=?");
            ps.setString(1, suser.getS_word());
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                a = rs.getInt(7);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return a;
    }

    public kUser getIdByKc(Integer a) {
        kUser kuser = null;
        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM k_user WHERE k_id=?");
            ps.setInt(1, a);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                kuser = new kUser();
                kuser.setK_id(rs.getInt(1));
                kuser.setK_kcm(rs.getString(2));
                kuser.setK_js(rs.getString(3));
                kuser.setK_jxl(rs.getInt(4));
                kuser.setK_sj(rs.getString(5));
                kuser.setK_xf(rs.getInt(6));

                // ?????????к??м???????????????????User????
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return kuser;
    }


    public kUser getkUserByName(String name) {
        kUser kuser = null;
        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM k_user WHERE k_kcm=?");
            ps.setString(1, name);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                kuser = new kUser();
                kuser.setK_id(rs.getInt(1));
                kuser.setK_kcm(rs.getString(2));
                kuser.setK_js(rs.getString(3));
                kuser.setK_jxl(rs.getInt(4));
                kuser.setK_sj(rs.getString(5));
                kuser.setK_xf(rs.getInt(6));

                // ?????????к??м???????????????????User????
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return kuser;
    }


    public int bcId(sUser suser) {
        int i = 0;
        try {
            prepareConnection();
            con.setAutoCommit(false);
            ps = con
                    .prepareStatement("UPDATE s_user SET s_xk=? WHERE s_word=?");
            ps.setInt(1, suser.getS_xk());
            ps.setString(2, suser.getS_word());
            i = ps.executeUpdate();
            con.commit();
        } catch (SQLException e) {
            rollback();
            e.printStackTrace();
        } finally {
            close();
        }
        return i;
    }

    public boolean adminUser(User user) {
        boolean val = false;

        try {
            prepareConnection();
            ps = con.prepareStatement("SELECT * FROM admin ");
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                if (rs.getString(2).equals(user.getU_word()) && rs.getString(3).equals(user.getU_pass())) {
                    val = true;
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close();
        }
        return val;

    }

    public int addkUser(kUser kuser) {
        int i = 0;
        try {
            prepareConnection();
            con.setAutoCommit(false);
            ps = con.prepareStatement("INSERT INTO k_user (k_kcm,k_js,k_jxl,k_sj,k_xf) VALUES(?,?,?,?,?)");
            ps.setString(1, kuser.getK_kcm());
            ps.setString(2, kuser.getK_js());
            ps.setInt(3, kuser.getK_jxl());
            ps.setString(4, kuser.getK_sj());
            ps.setInt(5, kuser.getK_xf());
            i = ps.executeUpdate();
            con.commit();
        } catch (SQLException e) {
            rollback();
            e.printStackTrace();
        } finally {
            close();
        }
        return i;
    }

    public int deletekUser(kUser kuser) {
        int i = 0;
        try {
            prepareConnection();
            con.setAutoCommit(false);
            ps = con.prepareStatement("DELETE FROM k_user WHERE k_id=?");
            ps.setInt(1, kuser.getK_id());
            i = ps.executeUpdate();
            con.commit();
        } catch (SQLException e) {
            rollback();
            e.printStackTrace();
        } finally {
            close();
        }
        return i;
    }

    public int updatekUser(kUser kuser) {
        int i = 0;
        try {
            prepareConnection();
            con.setAutoCommit(false);
            ps = con.prepareStatement("UPDATE k_user SET k_kcm=?,k_js=?,k_jxl=?,k_sj=?,k_xf=?  WHERE k_id=?");
            ps.setString(1, kuser.getK_kcm());
            ps.setString(2, kuser.getK_js());
            ps.setInt(3, kuser.getK_jxl());
            ps.setString(4, kuser.getK_sj());
            ps.setInt(5, kuser.getK_xf());
            ps.setInt(6, kuser.getK_id());
            i = ps.executeUpdate();
            con.commit();
        } catch (SQLException e) {
            rollback();
            e.printStackTrace();
        } finally {
            close();
        }
        return i;
    }

}

admin：

package servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.User;
import dao.userDao;
import dao.kUser;

public class admin extends HttpServlet {

    /**
     *
     */
    private static final long serialVersionUID = 1L;


    public admin() {
        super();
    }


    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }


    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }


    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String zsgc = request.getParameter("zsgc").replace(" ", "");
        if (zsgc.equals("dl")) {

            dlAdmin(request, response);

        } else if (zsgc.equals("zj")) {

            addkUser(request, response);
            allkUser(request, response);

        } else if (zsgc.equals("xg")) {

            updatekUser(request, response);
            allkUser(request, response);

        } else if (zsgc.equals("sc")) {

            delectkUser(request, response);
            allkUser(request, response);

        } else {

            request.getRequestDispatcher("error.jsp").forward(request, response);

        }


    }


    public void init() throws ServletException {
        // Put your code here
    }

    private void dlAdmin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = request.getParameter("word").replace(" ", "");
        String pass = request.getParameter("pass");
        User user = new User();
        user.setU_word(name);
        user.setU_pass(pass);
        if (new userDao().adminUser(user)) {
            request.getSession().setAttribute("gly", name);
            allkUser(request, response);
        } else {
            request.getRequestDispatcher("admin.jsp").forward(request, response);
        }
    }

    private void addkUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String kcm = request.getParameter("kcm").replace(" ", "");
        String js = request.getParameter("js");
        String jxl = request.getParameter("jxl");
        String sj = request.getParameter("sj");
        String xf = request.getParameter("xf");
        kUser kuser = new kUser();
        kuser.setK_kcm(kcm);
        kuser.setK_js(js);
        kuser.setK_jxl(Integer.parseInt(jxl));
        kuser.setK_sj(sj);
        kuser.setK_xf(Integer.parseInt(xf));
        new userDao().addkUser(kuser);

    }

    private void updatekUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        String kcm = request.getParameter("kcm").replace(" ", "");
        String js = request.getParameter("js");
        String jxl = request.getParameter("jxl");
        String sj = request.getParameter("sj");
        String xf = request.getParameter("xf");
        //System.out.println(id+"---"+kcm+"---"+js+"---"+jxl+"---"+sj+"---"+xf);
        kUser kuser = new kUser();
        kuser.setK_id(Integer.parseInt(id));
        kuser.setK_kcm(kcm);
        kuser.setK_js(js);
        kuser.setK_jxl(Integer.parseInt(jxl));
        kuser.setK_sj(sj);
        kuser.setK_xf(Integer.parseInt(xf));
        new userDao().updatekUser(kuser);
    }

    private void delectkUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        kUser kuser = new kUser();
        kuser.setK_id(Integer.parseInt(id));
        new userDao().deletekUser(kuser);
    }

    private void allkUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<kUser> kuser = new userDao().getAllkUser();
        request.getSession().setAttribute("bgkUser", kuser);
        request.getRequestDispatcher("/background.jsp").forward(request, response);
    }

}

chaxun：

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.kUser;
import dao.userDao;

public class chaxun extends HttpServlet {

    /**
     *
     */
    private static final long serialVersionUID = 1L;


    /**
     * Constructor of the object.
     */
    public chaxun() {
        super();
    }


    public void destroy() {
        super.destroy();
    }


    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("name").replace(" ", "");
        kUser kuser = new userDao().getkUserByName(name);
        request.setAttribute("query", kuser);
        request.getRequestDispatcher("query.jsp").forward(request, response);
    }


    public void init() throws ServletException {

    }

}

demo：

package servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.kUser;

public class demo extends HttpServlet {


    /**
     *
     */
    private static final long serialVersionUID = 1L;


    public demo() {
        super();
    }

    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }


    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }


    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.getSession().setAttribute("yh", null);
        request.getSession().setAttribute("gly", null);
        List<kUser> kusers = new ArrayList<kUser>();
        request.getSession().setAttribute("kuse", kusers);
        request.getSession().setAttribute("kuser1", new kUser());
        request.getRequestDispatcher("index.jsp").forward(request, response);
    }


    public void init() throws ServletException {
        // Put your code here
    }

}

kcuser：

package servlet;

import java.io.IOException;
import java.util.List;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.kUser;
import dao.sUser;
import dao.userDao;

public class kcUser extends HttpServlet {


    /**
     *
     */
    private static final long serialVersionUID = 1L;


    public kcUser() {
        super();
    }


    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }


    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String cx = request.getParameter("cx").replace(" ", "");
        String a = request.getParameter("id");
        if (cx.equals("cx")) {
            request.getSession().setAttribute("moren2", "");
            request.getSession().setAttribute("moren1", "active");
            queryAll(request, response);
        } else if (cx.equals("ck")) {
            request.getSession().setAttribute("moren1", "");
            request.getSession().setAttribute("moren2", "active");
            Integer id = Integer.valueOf(a);
            getkUserById(request, response, id);
            queryAll(request, response);
        } else if (cx.equals("bc")) {
            String id = request.getParameter("bcId");
            String word = (String) request.getSession().getAttribute("yh");
            sUser suser = new sUser();
            suser.setS_xk(Integer.parseInt(id));
            suser.setS_word(word);
            bcId(request, response, suser);
        } else if (cx.equals("zf")) {
            request.getRequestDispatcher("/home.jsp").forward(request, response);
        } else {
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }

    }


    public void init() throws ServletException {
        // Put your code here
    }

    private void queryAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<kUser> kusers = new userDao().getAllkUser();
        request.getSession().setAttribute("kuse", kusers);
        request.getRequestDispatcher("/home.jsp").forward(request, response);
    }

    private void getkUserById(HttpServletRequest request, HttpServletResponse response, Integer id) throws ServletException, IOException {
        kUser kuser = new userDao().getkUserById(id);
        request.getSession().setAttribute("kuser1", kuser);
    }

    private void bcId(HttpServletRequest request, HttpServletResponse response, sUser suser) throws ServletException, IOException {

        new userDao().bcId(suser);
        request.getRequestDispatcher("/win.jsp").forward(request, response);
    }

}

yzuser：

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.kUser;
import dao.sUser;
import dao.userDao;

public class yzUser extends HttpServlet {


    /**
     *
     */
    private static final long serialVersionUID = 1L;


    public yzUser() {
        super();
    }


    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String met = request.getParameter("dlzc");
        if (met.equals("dl")) {
            dl(request, response);
        } else if (met.equals("zc")) {
            zc(request, response);
        } else {
            request.getRequestDispatcher("/error.jsp").forward(request, response);
        }

    }


    public void init() throws ServletException {
        // Put your code here
    }

    public void dl(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String word = request.getParameter("word");
        String pass = request.getParameter("pass");
        sUser suser = new sUser();
        suser.setS_word(word);
        suser.setS_pass(pass);
        if (new userDao().yzUser(suser)) {
            //cx查询
            request.getSession().setAttribute("yh", word);
            userDao userdao = new userDao();
            Integer a = userdao.getNameByid(suser);
            if (a != 0) {
                kUser kuser = userdao.getIdByKc(a);
                request.getSession().setAttribute("kuser1", kuser);
            }
            request.getRequestDispatcher("kcUser?cx=cx").forward(request, response);
        } else {
            request.getRequestDispatcher("/index.jsp?end=end").forward(request, response);
        }
    }


    public void zc(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String word = request.getParameter("word");
        String name = request.getParameter("name");
        String pass = request.getParameter("pass");
        String bj = request.getParameter("bj");
        String yx = request.getParameter("yx");
        sUser suser = new sUser();
        suser.setS_name(name);
        suser.setS_pass(pass);
        suser.setS_word(word);
        suser.setS_bj(Integer.parseInt(bj));
        suser.setS_xy(yx);
        new userDao().zcUser(suser);
        request.getRequestDispatcher("MyJsp.jsp").forward(request, response);
    }

}

数据库：

admin：

k_user:

s_suer:


DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `word` varchar(32) NOT NULL,
  `pass` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2013002 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('2013001', 'admin', 'admin');

-- ----------------------------
-- Table structure for k_user
-- ----------------------------
DROP TABLE IF EXISTS `k_user`;
CREATE TABLE `k_user` (
  `k_id` int(12) unsigned NOT NULL AUTO_INCREMENT,
  `k_kcm` varchar(50) NOT NULL,
  `k_js` varchar(32) NOT NULL,
  `k_jxl` int(12) NOT NULL,
  `k_sj` varchar(12) NOT NULL,
  `k_xf` int(12) NOT NULL,
  PRIMARY KEY (`k_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2016016 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of k_user
-- ----------------------------
INSERT INTO `k_user` VALUES ('2016001', '网络文化概论', '曾静平', '4213', '1-56', '1');
INSERT INTO `k_user` VALUES ('2016002', '音乐鉴赏', '项仲平', '3210', '1-78', '2');
INSERT INTO `k_user` VALUES ('2016003', '毛笔书法', '方明东', '5510', '2-56', '1');
INSERT INTO `k_user` VALUES ('2016004', '电子竞技论', '张宇', '4413', '3-56', '2');
INSERT INTO `k_user` VALUES ('2016005', '应用写作', '叶蓉', '3306', '3-78', '2');
INSERT INTO `k_user` VALUES ('2016006', '银河系与行星', '魏丹', '4410', '2-12', '2');
INSERT INTO `k_user` VALUES ('2016007', 'CSS', '杨光伟', '4411', '4-78', '2');
INSERT INTO `k_user` VALUES ('2016008', 'BootStrap', '江平', '2311', '4-12', '2');
INSERT INTO `k_user` VALUES ('2016009', 'JQuery', '张汉芳', '4211', '5-12', '2');
INSERT INTO `k_user` VALUES ('2016010', 'JavaScript', '汪晓青', '5513', '5-34', '2');
INSERT INTO `k_user` VALUES ('2016011', '古诗词鉴赏', '倪文景', '3210', '5-56', '2');
INSERT INTO `k_user` VALUES ('2016012', '大学生心理健康', '金琼', '3211', '5-34', '2');
INSERT INTO `k_user` VALUES ('2016014', '计算机应用基础', '丁文浩', '5210', '4-56', '2');
INSERT INTO `k_user` VALUES ('2016015', 'JAVAweb网络开发', '张小帅', '5211', '1-34', '2');

-- ----------------------------
-- Table structure for s_user
-- ----------------------------
DROP TABLE IF EXISTS `s_user`;
CREATE TABLE `s_user` (
  `s_id` int(32) NOT NULL AUTO_INCREMENT,
  `s_word` varchar(50) NOT NULL,
  `s_pass` varchar(50) NOT NULL,
  `s_name` varchar(32) NOT NULL,
  `s_bj` int(12) NOT NULL,
  `s_xy` varchar(32) NOT NULL,
  `s_xk` int(12) DEFAULT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2015008 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of s_user
-- ----------------------------
INSERT INTO `s_user` VALUES ('2015001', '123', '19970921', '丁文浩', '1508', '计算机', '2016001');
INSERT INTO `s_user` VALUES ('2015002', '111', '123', '傻逼', '1508', '计算机', '2016006');
INSERT INTO `s_user` VALUES ('2015003', '辰氏男人', '123', '辰氏男人', '1508', '计算机', null);
INSERT INTO `s_user` VALUES ('2015004', '158', '123', '158', '1508', '计算机', null);
INSERT INTO `s_user` VALUES ('2015005', 'ding', '123', '456', '1508', '', '2016001');
INSERT INTO `s_user` VALUES ('2015006', 'wen', '123', '张三', '1508', '计算机', null);
INSERT INTO `s_user` VALUES ('2015007', 'zs', '123456', '张三', '1801', '计算机', null);

注：Tomcat没要求，jdk1.8，以上是本项目的全部代码，运行调试不出来的可以私信我