栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

IDEA+Java+Jsp

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

IDEA+Java+Jsp

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();”>

   

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++) {

%>

” target=“_blank”

style=“color: red;”><%=title[i]%>

<%

}

%>

用户编号:

<%–title=“用户名或编号,学生为学号!”/>

<%–title=“姓名或编号(学生为学号)”>提示–%>

公

用户密码:

size=“18” title=“默认密码是admin,登录后请自行修改!”/>

<%–提示–%>

告

用户类型: 学 生 教师 管理员

通

type=“reset” name=“Submit2” value=" 重 置 ">

知

2022-2022 XXX软件开发有限技术公司

<%–

<%–href=“http://wpa.qq.com/msgrd?v=3&uin=3079118617&site=qq&menu=yes”>

<%–border=“0” src=“http://wpa.qq.com/pa?p=2:287433220:41”–%>

<%–alt=“点击这里给我发消息” title=“点击这里给我发消息”>
–%>

news.jsp


新闻公告界面

<%@page pageEncoding=“UTF-8” import=“com.sjsq.service.MsgManager” %>

公告详情

bgcolor=“#6298E1”>

width=“18” height=“18” border=“0” align=“absmiddle”>  公告详情


<%

String number = new String(request.getParameter(“id”).getBytes(“UTF-8”), “UTF-8”);

String text = MsgManager.getTexts(number);

%>

bgcolor=“#6298E1”>

id=“editProduct” idth=“100%”>

 

标题:

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/930787.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号