AI 助理
文档备案控制台
开发者社区 数据库 文章 正文

IDEA+Java+Jsp+Mysql实现Web毕业设计选题系统（下）

2022-05-26 389
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： IDEA+Java+Jsp+Mysql实现Web毕业设计选题系统

TeacherManager


教师信息管理类，实现教师信息的增加，查看，删除。

package com.sjsq.service;
import com.sjsq.model.Teacher;
import com.sjsq.util.DB;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class TeacherManager {
    public static boolean save(Teacher te) {
        Connection conn = DB.getConn();
        String sql = null;
        boolean b = false;
        sql = "insert into teacher_info values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        PreparedStatement pstmt = DB.prepare(conn, sql);
        try {
            pstmt.setString(1, te.getNumber());
            pstmt.setString(2, te.getName());
            pstmt.setString(3, te.getSex());
            pstmt.setString(4, te.getDept());
            pstmt.setString(5, te.getDegree());
            pstmt.setString(6, te.getTitle());
            pstmt.setShort(7, te.getRight());
            pstmt.setString(8, te.getPhone());
            pstmt.setString(9, te.getEmail());
            pstmt.setString(10, te.getGroup());
            pstmt.setString(11, te.getPassword());
            pstmt.execute();
            b = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(pstmt);
            DB.close(conn);
        }
        return b;
    }
    public static int getTeachers(List<Teacher> teachers, int pageNo,
                                  int pageSize) {
        int totalRecords = -1;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from teacher_info limit " + (pageNo - 1) * pageSize
                + "," + pageSize;
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Statement stmtCount = DB.getStatement(conn);
        ResultSet rsCount = null;
        rsCount = DB.getResultSet(stmtCount,
                "select count(*) from teacher_info");
        try {
            rsCount.next();
            totalRecords = rsCount.getInt(1);
            while (rs.next()) {
                Teacher teacher = new Teacher();
                teacher.setEmail(rs.getString("temail"));
                teacher.setGroup(rs.getString("tgroup"));
                teacher.setName(rs.getString("tname"));
                teacher.setNumber(rs.getString("tno"));
                teacher.setPassword(rs.getString("tpassword"));
                teacher.setPhone(rs.getString("ttel"));
                teacher.setDept(rs.getString("tdept"));
                teacher.setSex(rs.getString("tsex"));
                teacher.setDegree(rs.getString("tdegree"));
                teacher.setRight(rs.getShort("tright"));
                teacher.setTitle(rs.getString("ttitle"));
                teachers.add(teacher);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rsCount);
            DB.close(stmtCount);
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return totalRecords;
    }
    public static boolean deleteByTno(String id) {
        boolean b = false;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "delete from teacher_info where tno = '" + id + "'";
        Statement stmt = DB.getStatement(conn);
        try {
            DB.executeUpdate(stmt, sql);
            b = true;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DB.close(stmt);
            DB.close(conn);
        }
        return b;
    }
    public static Teacher check(String num, String password)
            throws UserNotFoundException, PasswordNotCorrectException {
        Teacher teacher = null;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from teacher_info where tno = '" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        try {
            if (!rs.next()) {
                throw new UserNotFoundException("用户不存在:" + num);
            } else {
                if (!password.equals(rs.getString("tpassword"))) {
                    throw new PasswordNotCorrectException("密码不正确!");
                }
            }
            teacher = new Teacher();
            teacher.setEmail(rs.getString("temail"));
            teacher.setGroup(rs.getString("tgroup"));
            teacher.setName(rs.getString("tname"));
            teacher.setNumber(rs.getString("tno"));
            teacher.setPassword(rs.getString("tpassword"));
            teacher.setPhone(rs.getString("ttel"));
            teacher.setDept(rs.getString("tdept"));
            teacher.setSex(rs.getString("tsex"));
            teacher.setDegree(rs.getString("tdegree"));
            teacher.setRight(rs.getShort("tright"));
            teacher.setTitle(rs.getString("ttitle"));
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return teacher;
    }
    public static Teacher getByTno(String num) {
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from teacher_info where tno='" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Teacher teacher = null;
        try {
            if (rs.next()) {
                teacher = new Teacher();
                teacher.setEmail(rs.getString("temail"));
                teacher.setGroup(rs.getString("tgroup"));
                teacher.setName(rs.getString("tname"));
                teacher.setNumber(rs.getString("tno"));
                teacher.setPassword(rs.getString("tpassword"));
                teacher.setPhone(rs.getString("ttel"));
                teacher.setDept(rs.getString("tdept"));
                teacher.setSex(rs.getString("tsex"));
                teacher.setDegree(rs.getString("tdegree"));
                teacher.setRight(rs.getShort("tright"));
                teacher.setTitle(rs.getString("ttitle"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return teacher;
    }
    public static boolean update(Teacher te) {
        Connection conn = DB.getConn();
        String sql = null;
        boolean b = false;
        sql = "update teacher_info set tpassword=?, tgroup=?, tname=?, tsex=?, ttel=?, temail=?, tdept=?, ttitle=?, tright=?,  tdegree=? where tno = ?";
        PreparedStatement pstmt = DB.prepare(conn, sql);
        try {
            pstmt.setString(1, te.getPassword());
            pstmt.setString(2, te.getGroup());
            pstmt.setString(3, te.getName());
            pstmt.setString(4, te.getSex());
            pstmt.setString(5, te.getPhone());
            pstmt.setString(6, te.getEmail());
            pstmt.setString(7, te.getDept());
            pstmt.setString(8, te.getTitle());
            pstmt.setShort(9, te.getRight());
            pstmt.setString(10, te.getDegree());
            pstmt.setString(11, te.getNumber());
            pstmt.executeUpdate();
            b = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(pstmt);
            DB.close(conn);
        }
        return b;
    }
    public static int query(List<Teacher> teachers, int pageNo, int pageSize,
                            String dept, String num, String name) {
        int totalRecords = -1;
        Connection conn = DB.getConn();
        String sql = null;
        if (dept == null)
            dept = "";
        if (name == null)
            name = "";
        if (num == null)
            num = "";
        sql = "select * from teacher_info where tdept like '%" + dept
                + "%' and tname like '%" + name + "%' and tno like '%" + num
                + "%'";
        sql += "limit " + (pageNo - 1) * pageSize + "," + pageSize;
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Statement stmtCount = DB.getStatement(conn);
        ResultSet rsCount = null;
        rsCount = DB.getResultSet(stmtCount,
                "select count(*) from teacher_info where tdept like '%" + dept
                        + "%' and tname like '%" + name + "%' and tno like '%"
                        + num + "%'");
        try {
            rsCount.next();
            totalRecords = rsCount.getInt(1);
            while (rs.next()) {
                Teacher teacher = new Teacher();
                teacher.setEmail(rs.getString("temail"));
                teacher.setGroup(rs.getString("tgroup"));
                teacher.setName(rs.getString("tname"));
                teacher.setNumber(rs.getString("tno"));
                teacher.setPassword(rs.getString("tpassword"));
                teacher.setPhone(rs.getString("ttel"));
                teacher.setDept(rs.getString("tdept"));
                teacher.setSex(rs.getString("tsex"));
                teacher.setDegree(rs.getString("tdegree"));
                teacher.setRight(rs.getShort("tright"));
                teacher.setTitle(rs.getString("ttitle"));
                teachers.add(teacher);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rsCount);
            DB.close(stmtCount);
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return totalRecords;
    }
    public static List<String> adds(String file) {
        Connection conn = DB.getConn();
        Workbook info;
        List<String> tnumber = new ArrayList<String>();
        String sql = "insert into teacher_info values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        try {
            info = Workbook.getWorkbook(new FileInputStream(file));
            Sheet sheet = info.getSheet(0);
            int size = sheet.getRows();
            for (int i = 1; i < size; i++) {
                Cell c = sheet.getCell(0, i);
                if (TeacherManager.getByTno(c.getContents().trim()) != null) {
                    tnumber.add(c.getContents().trim());
                    continue;
                }
                PreparedStatement pstmt = DB.prepare(conn, sql);
                for (int j = 0; j < 11; j++) {
                    c = sheet.getCell(j, i);
                    if (j != 6) {
                        pstmt.setString(j + 1, c.getContents().trim());
                    } else
                        pstmt.setShort(j + 1, Short.parseShort(c.getContents()));
                }
                pstmt.execute();
            }
        } catch (BiffException e) {
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IndexOutOfBoundsException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return tnumber;
    }
}

TopicManager


选题信息管理，实现选题新的增加，修改，查看，删除。

package com.sjsq.service;
import com.sjsq.model.Topic;
import com.sjsq.util.DB;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class TopicManager {
    public static boolean save(Topic t) {
        Connection conn = DB.getConn();
        String sql = null;
        boolean b = false;
        sql = "insert into topic_info values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        PreparedStatement pstmt = DB.prepare(conn, sql);
        try {
            pstmt.setString(1, t.getNumber());
            pstmt.setString(2, t.getName());
            pstmt.setString(3, t.getType());
            pstmt.setString(4, t.getKind());
            pstmt.setString(5, t.getSource());
            pstmt.setString(6, t.getStatus());
            pstmt.setString(7, t.getContent());
            pstmt.setString(8, t.getResult());
            pstmt.setString(9, t.getDirection());
            pstmt.setString(10, t.getTnumber());
            pstmt.setString(11, t.getSnumber());
            pstmt.execute();
            b = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(pstmt);
            DB.close(conn);
        }
        return b;
    }
    public static int getTopics(List<Topic> topics, int pageNo,
                                int pageSize) {
        int totalRecords = -1;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from topic_info limit " + (pageNo - 1) * pageSize
                + "," + pageSize;
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Statement stmtCount = DB.getStatement(conn);
        ResultSet rsCount = null;
        rsCount = DB
                .getResultSet(stmtCount, "select count(*) from topic_info");
        try {
            rsCount.next();
            totalRecords = rsCount.getInt(1);
            while (rs.next()) {
                Topic topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
                topics.add(topic);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rsCount);
            DB.close(stmtCount);
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return totalRecords;
    }
    public static boolean deleteByHno(String hno) {
        boolean b = false;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "delete from topic_info where hno = '" + hno + "'";
        Statement stmt = DB.getStatement(conn);
        try {
            DB.executeUpdate(stmt, sql);
            b = true;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DB.close(stmt);
            DB.close(conn);
        }
        return b;
    }
    public static boolean check(String tno, String hname) {
        boolean b = false;
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from topic_info where tno = '" + tno + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        try {
            if (rs.next()) b = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return b;
    }
    public static boolean update(Topic t) {
        Connection conn = DB.getConn();
        String sql = null;
        boolean b = false;
        sql = "update topic_info set htype=?, tno=?, hname=?, hsource=?, hkind=?, hstatus=?, hresult=?, sno=?, direction=?,  hcontent=? where hno = ?";
        PreparedStatement pstmt = DB.prepare(conn, sql);
        try {
            pstmt.setString(1, t.getType());
            pstmt.setString(2, t.getTnumber());
            pstmt.setString(3, t.getName());
            pstmt.setString(4, t.getSource());
            pstmt.setString(5, t.getKind());
            pstmt.setString(6, t.getStatus());
            pstmt.setString(7, t.getResult());
            pstmt.setString(8, t.getSnumber());
            pstmt.setString(9, t.getDirection());
            pstmt.setString(10, t.getContent());
            pstmt.setString(11, t.getNumber());
            pstmt.executeUpdate();
            b = true;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(pstmt);
            DB.close(conn);
        }
        return b;
    }
    public static Topic getByNum(String num) {
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from topic_info where hno='" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Topic topic = null;
        try {
            if (rs.next()) {
                topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return topic;
    }
    public static List<Topic> getByTno(String num) {
        Connection conn = DB.getConn();
        String sql = null;
        List<Topic> topics = new ArrayList<Topic>();
        sql = "select * from topic_info where tno='" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Topic topic = null;
        try {
            while (rs.next()) {
                topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
                topics.add(topic);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return topics;
    }
    public static int query(List<Topic> topics, int pageNo, int pageSize, String str, String kind, String name) {
        int totalRecords = -1;
        Connection conn = DB.getConn();
        String sql = null;
        if (str == null)
            str = "";
        if (kind == null)
            kind = "";
        if (name == null)
            name = "";
        sql = "select * from topic_info where hname like '%" + name
                + "%' and htype like '%" + str + "%' and hkind like '%" + kind + "%'";
        sql += "limit " + (pageNo - 1) * pageSize + "," + pageSize;
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Statement stmtCount = DB.getStatement(conn);
        ResultSet rsCount = null;
        rsCount = DB
                .getResultSet(stmtCount, "select count(*) from topic_info where hname like '%" + name
                        + "%' and htype like '%" + str + "%' and hkind like '%" + kind + "%'");
        try {
            if (rsCount != null) rsCount.next();
            totalRecords = rsCount.getInt(1);
            while (rs.next()) {
                Topic topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
                topics.add(topic);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rsCount);
            DB.close(stmtCount);
            DB.close(rs);
            DB.close(stmt);
            DB.close(conn);
        }
        return totalRecords;
    }
    public static List<Topic> getByStatus(String num) {
        Connection conn = DB.getConn();
        List<Topic> topics = new ArrayList<Topic>();
        String sql = null;
        sql = "select * from topic_info where hstatus='" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Topic topic = null;
        try {
            while (rs.next()) {
                topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
                topics.add(topic);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return topics;
    }
    public static Topic getBySnum(String num) {
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from topic_info where sno='" + num + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Topic topic = null;
        try {
            if (rs.next()) {
                topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return topic;
    }
    public static Topic getByTnumAndHname(String tnum, String hname) {
        Connection conn = DB.getConn();
        String sql = null;
        sql = "select * from topic_info where tno='" + tnum + "' and hname='" + hname + "'";
        Statement stmt = DB.getStatement(conn);
        ResultSet rs = DB.getResultSet(stmt, sql);
        Topic topic = null;
        try {
            if (rs.next()) {
                topic = new Topic();
                topic.setContent(rs.getString("hcontent"));
                topic.setDirection(rs.getString("direction"));
                topic.setKind(rs.getString("hkind"));
                topic.setName(rs.getString("hname"));
                topic.setNumber(rs.getString("hno"));
                topic.setResult(rs.getString("hresult"));
                topic.setSnumber(rs.getString("sno"));
                topic.setSource(rs.getString("hsource"));
                topic.setStatus(rs.getString("hstatus"));
                topic.setType(rs.getString("htype"));
                topic.setTnumber(rs.getString("tno"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DB.close(rs);
            DB.close(conn);
        }
        return topic;
    }
}

DB


数据库连接类

package com.sjsq.util;
import java.sql.*;
/**
 *
 * 对数据库连接的封装
 *
 */
public class DB {
  /**
   * 获得对要用的数据库的连接
   * @return 返回数据库的连接
   */
  public static Connection getConn() {
    Connection conn = null;
    try {
      Class.forName("com.mysql.cj.jdbc.Driver");//数据库的驱动类 若数据库为sqlserver 应为： （"com.microsoft.sqlserver.jdbc.SQLServerDriver"）
      conn = DriverManager.getConnection("jdbc:mysql://localhost/jsp_select_topic?serverTimezone=UTC","root","admin");
      //jdbc：myseql数据库的类型  localhost:3306本机3306端口 select_course 数据库名 user=root 用户名为root password=root 用户密码为root
      // 若是sqlserver应为("jdbc:sqlserver://localhst:1422;databaseName=select_course", "root", "root");
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return conn;
  }
  /**
   * 获得多数据库的预编译的 SQL 语句的对象
   * @param conn 数据库的连接
   * @param sql 要执行的SQL语句
   * @return 返回预编译的 SQL 语句的对象
   */
  public static PreparedStatement prepare(Connection conn,  String sql) {
    PreparedStatement pstmt = null;
    try {
      if(conn != null) {
        pstmt = conn.prepareStatement(sql);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return pstmt;
  }
  /**
   *
   * @param conn 数据库的连接
   * @return 返回执行静态 SQL 语句对象
   */
  public static Statement getStatement(Connection conn) {
    Statement stmt = null;
    try {
      if(conn != null) {
        stmt = conn.createStatement();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return stmt;
  }
  /**
   *
   * @param stmt 执行静态SQl语句的对象
   * @param sql 要执行的SQL语句
   * @return 执行后的结果集
   */
  public static ResultSet getResultSet(Statement stmt, String sql) {
    ResultSet rs = null;
    try {
      if(stmt != null) {
        rs = stmt.executeQuery(sql);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return rs;
  }
  /**
   *
   * @param stmt 静态执行sql语句的对象
   * @param sql 要执行的SQL语句
   */
  public static void executeUpdate(Statement stmt, String sql) {
    try {
      if(stmt != null) {
        stmt.executeUpdate(sql);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
  /**
   * 关闭数据库的连接
   * @param conn 数据库的连接
   */
  public static void close(Connection conn) {
    try {
      if(conn != null) {
        conn.close();
        conn = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
  /**
   * 关闭Statement
   * @param stmt
   */
  public static void close(Statement stmt) {
    try {
      if(stmt != null) {
        stmt.close();
        stmt = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
  /**
   * 关闭ResultSet
   * @param rs
   */
  public static void close(ResultSet rs) {
    try {
      if(rs != null) {
        rs.close();
        rs = null;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
}

Login.jsp


登录前端页面，实现用户登录，判断用户类型，调用登录函数。

<%@ page language="java" import="com.sjsq.model.Student" pageEncoding="UTF-8" %>
<%@ page import="com.sjsq.model.Teacher" %>
<%@ page import="com.sjsq.service.PasswordNotCorrectException" %>
<%@ page import="com.sjsq.service.StudentManager" %>
<%@ page import="com.sjsq.service.TeacherManager" %>
<%@ page import="com.sjsq.service.UserNotFoundException" %>
<%
    String username = request.getParameter("user_no").trim();
    String password = request.getParameter("user_pass").trim();
    int type = Integer.parseInt(request.getParameter("u_type").trim());
    try {
        if (type == 1) {
            Student student = StudentManager.check(username, password);
            session.setAttribute("user", student);
            session.setAttribute("type", type);
            response.sendRedirect("student/student.jsp");
        }
        if (type == 2) {
            Teacher teacher = TeacherManager.check(username, password);
            session.setAttribute("user", teacher);
            session.setAttribute("type", type);
            response.sendRedirect("teacher/teacher.jsp");
        }
        if (type == 3) {
            Teacher teacher = TeacherManager.check(username, password);
            if (teacher.getRight() == 0) {
                session.setAttribute("user", teacher);
                session.setAttribute("type", type);
                response.sendRedirect("admin/admin.jsp");
            } else {
                out.println("您没有管理员权限!");
                return;
            }
        }
    } catch (UserNotFoundException e) {
        out.println(e.getMessage());
        return;
    } catch (PasswordNotCorrectException e) {
        out.println(e.getMessage());
        return;
    }
%>

index.jsp


用户登录界面

<%@page pageEncoding="UTF-8" %>
<%@page import="com.sjsq.service.MsgManager" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>毕业设计选题系统-用户登录</title>
    <link href="js/css.css" rel="stylesheet" type="text/css">
    <style type="text/css">
        .STYLE4 {
            color: #FFFFFF;
            font-family: "楷体_GB2312";
            font-size: 24px;
            font-weight: bold;
        }
        .STYLE5 {
            color: #FFFFFF;
            font-weight: bold;
            font-size: 16px;
        }
        .STYLE7 {
            color: #0000FF;
            font-size: 16px;
        }
        .STYLE3 {
            font-size: 12px;
            color: #FFFFFF;
            text-decoration: none;
        }
    </style>
    <script language="javascript" type="text/javascript">
        function CheckForm() {
            if (document.login.user_no.value.length == 0) {
                alert("请输入用户编号，学生为8位数的学号!");
                document.login.user_no.focus();
                return false;
            }
            return true;
        }
    </script>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    </head>
<body class="bg">
<table width="100%" height="100%" border="0" cellpadding="0"
       cellspacing="0">
    <tr>
        <td align="center" valign="middle">
            <table width="817" height="384" border="0" cellpadding="0"
                   cellspacing="0" background="images/login.jpg">
                <tr>
                    <td>&nbsp;</td>
                    <td>
                        <p align="left">
                            <br> <br> <br>
                        </p>
                        <table width="95%" height="14" border="0" align="left"
                               cellpadding="0" cellspacing="0">
                            <tr>
                                <td><span class="STYLE4">毕业设计选题系统</span></td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td width="100">&nbsp;</td>
                    <td height="239">
                        <form id="login" name="login" method="post" action="Login.jsp"
                              onSubmit="return CheckForm();">
                            <table width="85%" border="0" align="left" cellspacing="3">
                                <tr>
                                    <td class="FontWit">&nbsp;</td>
                                    <td>&nbsp;</td>
                                    <td class="STYLE3">
                                        <div align="center" class="STYLE5"></div>
                                    </td>
                                    <td width="44%" rowspan="5" class="STYLE3">
                                        <MARQUEE
                                                style="WIDTH: 220; HEIGHT: 180; color:red;" scrollAmount=1
                                                scrollDelay=77 direction=up width=280 height=200
                                                onMouseOut="this.start()" onMouseOver="this.stop()">
                                            <%
                                                String[] title = MsgManager.getTitles();
                                                for (int i = 0; title[i] != null; i++) {
                                            %>
                                            <p>
                                                <a href="news.jsp?id=<%=title[i]%>" target="_blank"
                                                   style="color: red;"><%=title[i]%>
                                                </a>
                                            </p>
                                            <%
                                                }
                                            %>
                                        </MARQUEE>
                                    </td>
                                </tr>
                                <tr>
                                    <td width="20%" class="FontWit">
                                        <div align="right">用户编号：</div>
                                    </td>
                                    <td width="34%">
                                        <div align="left">
                                            <input name="user_no" type="text" id="user_no" size="18"
                                                   <%--title="用户名或编号，学生为学号！"/> <span class="FontWit"--%>
                                                                                 <%--title="姓名或编号（学生为学号）">提示</span>--%>
                                        </div>
                                    </td>
                                    <td width="8%" class="STYLE3">
                                        <div align="center">
                                            <span class="STYLE5">公</span>
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td class="FontWit">
                                        <div align="right">用户密码：</div>
                                    </td>
                                    <td>
                                        <div align="left">
                                            <input name="user_pass" type="password" id="user_pass"
                                                   size="18" title="默认密码是admin，登录后请自行修改！"/>
                                            <%--<span class="FontWit" title="默认密码是admin，登录后请自行修改！">提示</span>--%>
                                        </div>
                                       </td>
                                    <td class="STYLE3">
                                        <div align="center">
                                            <span class="STYLE5">告</span>
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td class="FontWit">
                                        <div align="right">用户类型：</div>
                                    </td>
                                    <td>
                                        <div align="left">
                                            <select name="u_type" id="u_type">
                                                <option value="1">学 生</option>
                                                <option value="2">教师</option>
                                                <option value="3">管理员</option>
                                            </select>
                                        </div>
                                    </td>
                                    <td class="STYLE3">
                                        <div align="center">
                                            <span class="STYLE5">通</span>
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="24" class="FontWit">
                                        <div align="right"></div>
                                    </td>
                                    <td>
                                        <div align="left">
                                            <input type="submit" name="Submit" value=" 登 录 "/> <input
                                                type="reset" name="Submit2" value=" 重 置 ">
                                        </div>
                                    </td>
                                    <td class="STYLE3">
                                        <div align="center">
                                            <span class="STYLE5">知</span>
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td height="72"></td>
                                    <td></td>
                                    <td colspan="2"></td>
                                </tr>
                            </table>
                        </form>
                    </td>
                </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td>
                        <div align="center" class="FontWit">
                            <TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
                                <TBODY>
                                <TR>
                                    <TD>
                                        <DIV align="center" class="FontWit">
                                            <p>
                                                2022-2022 XXX软件开发有限技术公司<A href="" target="_blank" class="STYLE3"></A>
                                                <%--<a target="_blank"--%>
                                                         <%--href="http://wpa.qq.com/msgrd?v=3&uin=3079118617&site=qq&menu=yes"><img--%>
                                                    <%--border="0" src="http://wpa.qq.com/pa?p=2:287433220:41"--%>
                                                    <%--alt="点击这里给我发消息" title="点击这里给我发消息"> </a> <br>--%>
                                            </p>
                                        </DIV>
                                    </TD>
                                </TR>
                                </TBODY>
                            </TABLE>
                        </div>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
</table>
</body>
</html>

news.jsp


新闻公告界面

<%@page pageEncoding="UTF-8" import="com.sjsq.service.MsgManager" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
    <link rel="stylesheet" href="../js/CssAdmin.css">
    <title>公告详情</title>
</head>
<body>
<table width="100%" border="0" cellpadding="3" cellspacing="1"
       bgcolor="#6298E1">
    <tr>
        <td height="24" nowrap>
            <font color="#FFFFFF"><img src="images/Explain.gif"
                                       width="18" height="18" border="0" align="absmiddle"> &nbsp;<strong>公告详情</strong>
            </font>
        </td>
    </tr>
</table>
<center>
    <br/>
    <%
        String number = new String(request.getParameter("id").getBytes("UTF-8"), "UTF-8");
        String text = MsgManager.getTexts(number);
    %>
    <table width="100%" border="0" cellpadding="3" cellspacing="1"
           bgcolor="#6298E1">
        <tr>
            <td height="24" nowrap bgcolor="#EBF2F9">
                <table width="100%" border="0" cellpadding="0" cellspacing="0"
                       id="editProduct" idth="100%">
                    <tr>
                        <td width="120" height="20" align="right">
                            &nbsp;
                        </td>
                        <td>
                            <div align="left"></div>
                        </td>
                    </tr>
                    <tr>
                        <td height="20" align="right">
                            标题：
                        </td>
                        <td>
                            <div align="center">
                                <%=number%>
                            </div>
                        </td>
                    </tr>
                    <tr>
                        <td>&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="20" align="right">
                            内容：
                        </td>
                        <td>
                            <div align="center">
                                <%=text%>
                            </div>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</center>
</body>
</html>


四、其他

1.更多系统


Java+JSP系统系列实现


Java+JSP实现学生图书管理系统


Java+JSP实现学生信息管理系统


Java+JSP实现用户信息管理系统


Java+JSP实现教师信息管理系统


Java+JSP实现学生宿舍管理系统


Java+JSP实现商品信息管理系统


Java+JSP实现宠物信息管理系统


Java+JSP实现学生成绩管理系统


Java+Servlet系统系列实现

Java+Servlet+JSP实现航空订票系统


Java+Servlet+JSP实现新闻发布系统


Java+Servlet+JSP学生宿舍管理系统


Java+Servlet+JSP实现图书管理系统


Java+Servlet+JSP实现停车场管理系统


Java+Servlet+JSP实现房屋租赁管理系统


Java+Servlet+JSP实现学生信息管理系统


Java+Servlet+JSP实现学生选课管理系统


Java+Servlet+JSPl实现学生选课签到系统


Java+Servlet+JSP实现宠物诊所管理系统


Java+Servlet+JSP实现学生成绩管理系统-1


Java+Servlet+JSP实现学生成绩管理系统-2


Java+SSM系统系列实现

Java+SSM+JSP实现网上考试系统


Java+SSM+JSP实现宠物商城系统


Java+SSM+JSP实现超市管理系统


Java+SSM+JSP实现学生成绩管理系统


Java+SSM+JSP实现学生信息管理系统


Java+SSM+JSP实现药品信息管理系统


Java+SSM+JSP实现汽车信息管理系统


Java+SSM+Jspl实现商品信息管理系统


Java+SSM+JSP+Maven实现网上书城系统


Java+SSM+JSP+Maven实现学校教务管理系统


Java+SSH系统系列实现

Java+SSH+JSP实现在线考试系统


Java+SSH+JSP实现医院在线挂号系统


Java+Springboot系统系列实现

Java+Springboot+H-ui+Maven实现营销管理系统


Java+Springboot+Bootstrap+Maven实现网上商城系统


Java+Springboot+Bootstrap+Maven实现景区旅游管理系统


1.更多JavaWeb系统请关注专栏。


https://blog.csdn.net/helongqiang/category_10020130.html

https://blog.csdn.net/helongqiang/category_10020130.html


2.更多JavaSwing系统请关注专栏。


https://blog.csdn.net/helongqiang/category_6229101.html

https://blog.csdn.net/helongqiang/category_6229101.html


2.源码下载

sql在sql文件夹下面


系统账号信息


1.管理员


账号：101  密码：admin


2.教师


账号：102  密码：123456


3.学生


账号：1001 密码：123456


Java+Jsp+Mysql实现Web毕业设计选题系统


3.运行项目

关注B站：水坚石青


后期有更多干货视频推出！！！


IDEA如何导入JavaWeb项目超详细视频教程


4.备注

如有侵权请联系我删除。


5.支持博主

如果您觉得此文对您有帮助，请点赞加关注加收藏。祝您生活愉快！


文章标签：
云数据库 RDS MySQL 版
云数据库 RDS SQL Server 版
前端开发
SQL
数据安全/隐私保护
数据库连接
关键词：
Java系统
Java Web
Java MYSQL
Idea系统
Idea Java
相关实践学习
每个IT人都想学的“Web应用上云经典架构”实战
本实验从Web应用上云这个最基本的、最普遍的需求出发，帮助IT从业者们通过“阿里云Web应用上云解决方案”，了解一个企业级Web应用上云的常见架构，了解如何构建一个高可用、可扩展的企业级应用架构。
MySQL数据库入门学习
本课程通过最流行的开源数据库MySQL带你了解数据库的世界。 &nbsp; 相关的阿里云产品：云数据库RDS MySQL 版 阿里云关系型数据库RDS（Relational Database Service）是一种稳定可靠、可弹性伸缩的在线数据库服务，提供容灾、备份、恢复、迁移等方面的全套解决方案，彻底解决数据库运维的烦恼。 了解产品详情:&nbsp;https://www.aliyun.com/product/rds/mysql&nbsp;
水坚石青
目录
相关文章
青云交（Java大数据AI云原生Python）
|
负载均衡 算法 关系型数据库
大数据大厂之MySQL数据库课程设计：揭秘MySQL集群架构负载均衡核心算法：从理论到Java代码实战，让你的数据库性能飙升！
本文聚焦 MySQL 集群架构中的负载均衡算法，阐述其重要性。详细介绍轮询、加权轮询、最少连接、加权最少连接、随机、源地址哈希等常用算法，分析各自优缺点及适用场景。并提供 Java 语言代码实现示例，助力直观理解。文章结构清晰，语言通俗易懂，对理解和应用负载均衡算法具有实用价值和参考价值。
青云交（Java大数据AI云原生Python）
727 14
大数据大厂之MySQL数据库课程设计：揭秘MySQL集群架构负载均衡核心算法：从理论到Java代码实战，让你的数据库性能飙升！
心疼你的一切
|
存储 Java 关系型数据库
java调用mysql存储过程
在 Java 中调用 MySQL 存储过程主要借助 JDBC（Java Database Connectivity）。其核心原理是通过 JDBC 与 MySQL 建立连接，调用存储过程并处理结果。具体步骤包括：加载 JDBC 驱动、建立数据库连接、创建 CallableStatement 对象、设置存储过程参数并执行调用。此过程实现了 Java 程序与 MySQL 数据库的高效交互。
心疼你的一切
759 7
蓝易云
|
10月前
|
SQL Java 关系型数据库
Java连接MySQL数据库环境设置指南
请注意，在实际部署时应该避免将敏感信息（如用户名和密码）硬编码在源码文件里面；应该使用配置文件或者环境变量等更为安全可靠地方式管理这些信息。此外，在处理大量数据时考虑使用PreparedStatement而不是Statement可以提高性能并防止SQL注入攻击；同时也要注意正确处理异常情况，并且确保所有打开过得资源都被正确关闭释放掉以防止内存泄漏等问题发生。
蓝易云
461 13
运营研究坊
|
人工智能 Java 关系型数据库
Java的时间处理与Mysql的时间查询
本文总结了Java中时间与日历的常用操作，包括时间的转换、格式化、日期加减及比较，并介绍了MySQL中按天、周、月、季度和年进行时间范围查询的方法，适用于日常开发中的时间处理需求。
运营研究坊
227 0
卓伊凡
|
人工智能 JavaScript 关系型数据库
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
卓伊凡
577 14
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
蓝易云
|
NoSQL Java 关系型数据库
Liunx部署java项目Tomcat、Redis、Mysql教程
本文详细介绍了如何在 Linux 服务器上安装和配置 Tomcat、MySQL 和 Redis，并部署 Java 项目。通过这些步骤，您可以搭建一个高效稳定的 Java 应用运行环境。希望本文能为您在实际操作中提供有价值的参考。
蓝易云
1022 26
蓝易云
|
自然语言处理 Java 关系型数据库
Java mysql根据很长的富文本如何自动获取简介
通过使用Jsoup解析富文本并提取纯文本，然后根据需要生成简介，可以有效地处理和展示长文本内容。该方法简单高效，适用于各种应用场景。希望本文对您在Java中处理富文本并生成简介的需求提供实用的指导和帮助。
蓝易云
332 9
凉凉心.
|
9月前
|
算法 Java Go
【GoGin】（1）上手Go Gin 基于Go语言开发的Web框架，本文介绍了各种路由的配置信息；包含各场景下请求参数的基本传入接收
gin 框架中采用的路优酷是基于httprouter做的是一个高性能的 HTTP 请求路由器，适用于 Go 语言。它的设计目标是提供高效的路由匹配和低内存占用，特别适合需要高性能和简单路由的应用场景。
凉凉心.
664 4
游客u6vcprrm3r23y
|
缓存 JavaScript 前端开发
鸿蒙5开发宝藏案例分享---Web开发优化案例分享
本文深入解读鸿蒙官方文档中的 `ArkWeb` 性能优化技巧，从预启动进程到预渲染，涵盖预下载、预连接、预取POST等八大优化策略。通过代码示例详解如何提升Web页面加载速度，助你打造流畅的HarmonyOS应用体验。内容实用，按需选用，让H5页面快到飞起！
游客u6vcprrm3r23y
639 0
游客u6vcprrm3r23y
|
JavaScript 前端开发 API
鸿蒙5开发宝藏案例分享---Web加载时延优化解析
本文深入解析了鸿蒙开发中Web加载完成时延的优化技巧，结合官方案例与实际代码，助你提升性能。核心内容包括：使用DevEco Profiler和DevTools定位瓶颈、四大优化方向（资源合并、接口预取、图片懒加载、任务拆解）及高频手段总结。同时提供性能优化黄金准则，如首屏资源控制在300KB内、关键接口响应≤200ms等，帮助开发者实现丝般流畅体验。
游客u6vcprrm3r23y
474 0

热门文章

最新文章

  • 1
    【WEB】当HTTPS资源引入HTTP导致报错blocked:mixed-content （混合加载/Mixed Content）如何解决
  • 2
    如何在SpringBoot中集成JWT(JSON Web Token)鉴权
  • 3
    Docker 与 Podman：探索用于现代 Web 开发的容器技术
  • 4
    如何轻松使用AWS Web应用程序防火墙？
  • 5
    【WEB安全】PHPMyAdmin后台GetShell姿势总结（上）
  • 6
    好程序员web前端培训分享React学习笔记（三）
  • 7
    Spring Web MVC框架（六） 异常处理
  • 8
    SpringBoot 各种 Web 容器服开启 AccessLog 日志
  • 9
    eclipse+maven开发web项目环境配置详解
  • 10
    WEB标准
  • 1
    IDEA 使用 lombak 时的一个小警告：Generating equals/hashCode implementation but without a call to superclass
    1490
  • 2
    【556AI】（一）IntelliJ IDEA全流程AI设计开发平台
    1117
  • 3
    IntelliJ IDEA最新版安装下载教程及安装教程（附安装包)
    22095
  • 4
    idea中使用灵码无法识别git暂存区
    276
  • 5
    IDEA的插件大总汇 (让你的工作效率大大提高!)
    3773
  • 6
    【Java基础-环境搭建-创建项目】IntelliJ IDEA创建Java项目的详细步骤
    2213
  • 7
    IDEA项目调试你都会用了么，快看看是否有你不知道的调试技巧
    724
  • 8
    IntelliJ IDEA使用技巧：在一个项目中如何正确引用其他子模块。
    1126
  • 9
    IDEA修改JDK版本
    4043
  • 10
    在IntelliJ IDEA中使用Maven配置Tomcat环境
    1812

    • 相关课程

    更多
  • MySQL企业常见架构与调优经验分享
  • 阿里云云原生数据仓库AnalyticDB MySQL版 使用教程
  • MySQL实战进阶
  • 阿里云数据库产品家族及特性
  • 数据库及SQL/MySQL基础
  • 云数据库MySQL快速入门

    • 相关电子书

    更多
  • 阿里云数据库运维实战手册
  • 搭建电商项目架构连接MySQL
  • 搭建4层电商项目架构，实战连接MySQL

    • 推荐镜像

    更多
  • mysql
    • 下一篇
    一条命令迁移，帮你实现 OpenClaw 与 Hermes Agent 记忆互通！