DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return totalRecords;
}
public static List adds(String file) {
Connection conn = DB.getConn();
List snumber = new ArrayList();
Workbook info;//定义工作簿
String sql = “insert into student_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);//获得表单的i行0列的单元格即学号
if(StudentManager.getBySno(c.getContents().trim())!=null) {
snumber.add(c.getContents().trim());
continue;
}
PreparedStatement pstmt = DB.prepare(conn, sql);
for(int j=0; j<8; j++) {
c = sheet.getCell(j,i);
pstmt.setString(j+1, c.getContents().trim());
}
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 snumber;
}
}
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 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) 《大厂前端面试题解析+Web核心总结学习笔记+企业项目实战源码+最新高清讲解视频》无偿开源 徽信搜索公众号【编程进阶路】 ;
}
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 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 adds(String file) {
Connection conn = DB.getConn();
Workbook info;
List tnumber = new ArrayList();
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 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 getByTno(String num) {
Connection conn = DB.getConn();
String sql = null;
List topics = new ArrayList();
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 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 getByStatus(String num) {
Connection conn = DB.getConn();
List topics = new ArrayList();
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 {
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;
}
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;
}
public static Statement getStatement(Connection conn) {
Statement stmt = null;
try {
if(conn != null) {
stmt = conn.createStatement();
}
} catch (SQLException e) {
e.printStackTrace();
}
return stmt;
}
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;
}
public static void executeUpdate(Statement stmt, String sql) {
try {
if(stmt != null) {
stmt.executeUpdate(sql);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Connection conn) {
try {
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stmt) {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
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” %>
cellspacing=“0”>
cellspacing=“0” background=“images/login.jpg”>
cellpadding=“0” cellspacing=“0”>
毕业设计选题系统onSubmit=“return CheckForm();”>



