INSERT INTO user VALUES (1, ‘160341’, ‘王五’, ‘123456’, ‘14829726746’, 0);
INSERT INTO user VALUES (2, ‘170340’, ‘张三’, ‘123456’, ‘15869483651’, 0);
INSERT INTO user VALUES (3, ‘170339’, ‘李四’, ‘123456’, ‘13589462584’, 0);
INSERT INTO user VALUES (6, ‘1123’, ‘肖兴江’, ‘123456’, ‘17418953551’, 1);
INSERT INTO user VALUES (7, ‘1124’, ‘汪维清’, ‘123456’, ‘15897683584’, 1);
INSERT INTO user VALUES (9, ‘1125’, ‘胡继宽’, ‘123456’, ‘12378945862’, 1);
INSERT INTO user VALUES (10, ‘1126’, ‘郑蔚’, ‘123456’, ‘13589462584’, 1);
INSERT INTO user VALUES (11, ‘1001’, ‘管理员’, ‘admin’, ‘18179586325’, 2);
INSERT INTO user VALUES (12, ‘1127’, ‘丁华峰’, ‘123456’, ‘16123598785’, 1);
INSERT INTO user VALUES (13, ‘1128’, ‘杜治国’, ‘123456’, ‘13158794456’, 1);
INSERT INTO user VALUES (14, ‘160344’, ‘陈淑婷’, ‘123456’, ‘14829726746’, 0);
INSERT INTO user VALUES (15, ‘160345’, ‘周梦琪’, ‘123456’, ‘14829726746’, 0);
– Triggers structure for table student
DROP TRIGGER IF EXISTS stuLogin;
delimiter ;;
CREATE TRIGGER stuLogin AFTER DELETE ON student FOR EACH ROW begin
delete from user where user_num=old.stu_num;
end
;;
delimiter ;
– Triggers structure for table teacher
DROP TRIGGER IF EXISTS teaLogin;
delimiter ;;
CREATE TRIGGER teaLogin AFTER DELETE ON teacher FOR EACH ROW begin
delete from user where user_num=old.tea_num;
end
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;
5.工程截图
二、系统展示
======
1.注册页面
2.登录页面
3.学生-主页面
4.学生-个人信息-查询登录密码
5.学生-个人信息-查看个人信息
6.学生-个人信息-修改个人信息
7.学生-成绩管理-成绩信息查看
8.教师-主页面
9.教师-个人信息-查询登录密码
10.教师-个人信息-查看个人信息
11.教师-个人信息-修改个人信息
12.教师-课程管理-课程信息查看
13.教师-课程管理-添加课程信息
14.教师-成绩管理-成绩信息查看
15.教师-成绩管理-添加学生成绩
16.教师-学生管理-查询学生信息
17.管理员-主页面
18.管理员-个人信息
19.管理员-课程管理-课程信息查看
20.管理员-课程管理-添加课程信息
21.管理员-成绩管理-成绩信息查看
22.管理员-成绩管理-添加学生成绩
23.管理员-成绩管理-学生总成绩
24.管理员-教师管理-查询教师信息
25.管理员-教师管理-添加教师信息
26.管理员-学生管理-查询学生信息
27.管理员-学生管理-添加学生信息
28.管理员-查询所有账号
三、部分代码
======
CourseDaoImpl
package dao.Impl;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.List;
import model.Course;
import model.PageBean;
import dao.CourseDao;
import db.DBCon;
public class CourseDaoImpl implements CourseDao {
private DBCon dbCon = new DBCon();
private Course course;
private PageBean pageBean;
public int addCos(Course course, String courseDate) {
System.out.println(courseDate);
// Date courseDate=(Date) course.getCourseDate();
// DateFormat
// data=DateFormat.getDateTimeInstance(DateFormat.MEDIUM,DateFormat.MEDIUM);
String sql = “insert into course(course_name,course_credit,course_hours,course_teacher,coursedate) values('”
course.getCourseName() “',” course.getCourseCredit() “,” course.getCourseHours() “,'” course.getCourseTeacher() + “‘,DATE(’” + courseDate + “'))”;
int rs = dbCon.query(sql);
return rs;
}
public int deleteCos(int courseID) {
String sql = “delete from course where course_id=” + courseID;
int rs = dbCon.query(sql);
return rs;
}
public int editCos(Course course, String courseDate) {
String sql = “update course set course_name='” + course.getCourseName()
“',course_credit=” + course.getCourseCredit() “,course_hours=” + course.getCourseHours() “,course_teacher='” + course.getCourseTeacher() “‘,coursedate=DATE(’” + courseDate + “') where course_id=” course.getCourseID();
int rs = dbCon.query(sql);
return rs;
}
public List findAll() {
List list = new ArrayList();
String sql = “select * from course”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int courseID = rs.getInt(“course_id”);
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
Date courseDate = rs.getDate(“coursedate”);
course = new Course(courseID, courseName, courseCredit,
courseHours, courseTea, courseDate);
list.add(course);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List findOne(int courseID) {
List list = new ArrayList();
String sql = “select * from course where course_id=” + courseID;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int courseid = rs.getInt(“course_id”);
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
Date courseDate = rs.getDate(“coursedate”);
course = new Course(courseid, courseName, courseCredit,
courseHours, courseTea, courseDate);
list.add(course);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public Course selectOneCos(Course cours) {
String sql = “select * from course where course_name='”
cours.getCourseName() + “’ and course_teacher='” cours.getCourseTeacher() + “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int courseid = rs.getInt(“course_id”);
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
Date courseDate = rs.getDate(“coursedate”);
course = new Course(courseid, courseName, courseCredit,
courseHours, courseTea, courseDate);
}
} catch (SQLException e) {
e.printStackTrace();
}
return course;
}
public PageBean courseListPage(int pageNo, int pageCount) {
int totalCount=0;
List list = new ArrayList();
String sql = “select * from course limit “+((pageNo-1)*pageCount)+”,”+pageCount;
String sqlCount=“select count(*) from course”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int courseID = rs.getInt(“course_id”);
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
Date courseDate = rs.getDate(“coursedate”);
course = new Course(courseID, courseName, courseCredit,
courseHours, courseTea, courseDate);
list.add(course);
}
rs=dbCon.find(sqlCount);
while(rs.next()){
totalCount=rs.getInt(1);
}
pageBean=new PageBean(list,totalCount,pageNo,pageCount);
} catch (SQLException e) {
e.printStackTrace();
}
return pageBean;
}
}
ScoreDaoImpl
package dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import model.PageBean;
import model.Score;
import model.ScoreCou;
import model.ScoreSum;
import dao.ScoreDao;
import db.DBCon;
public class ScoreDaoImpl implements ScoreDao {
private Score score = null;
private ScoreCou scoreCou = null;
private PageBean pageBean = null;
private ScoreSum scoreSum = null;
private DBCon dbCon = new DBCon();
public int addScore(Score score) {
String sql = “insert into score(stu_num,stu_name,stu_class,course_name,score_grade,major) values('”
score.getStuNum() “‘,’” score.getStuName() “‘,’” score.getStuClass() “‘,’” score.getCourseName() “',” score.getScoreGrade() + “,'” + score.getMajor() + “')”;
int rs = dbCon.query(sql);
return rs;
}
public int deleteScore(int scoreID) {
String sql = “delete from score where score_id=” + scoreID;
int rs = dbCon.query(sql);
return rs;
}
public int editCos(Score score) {
String sql = “update score set stu_num='” + score.getStuNum()
“‘,stu_name=’” + score.getStuName() + “‘,stu_class=’” score.getStuClass() + “‘,course_name=’” score.getCourseName() + “',score_grade=” score.getScoreGrade() + “,major='” + score.getMajor() “’ where score_id=” + score.getScoreID();
int rs = dbCon.query(sql);
return rs;
}
public List findAll() {
List list = new ArrayList();
String sql = “select * from score”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
Score score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List findOne(String stuNum) {
List list = new ArrayList();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
“from score,course where score.course_name=course.course_name and stu_num='” stuNum + “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
String major = rs.getString(“major”);
Date courseDate = rs.getDate(“coursedate”);
double scoreGrade = rs.getDouble(“score_grade”);
ScoreCou scoreCou = new ScoreCou(courseName, courseCredit,
courseHours, courseTea, major, courseDate, scoreGrade);
list.add(scoreCou);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List selectScore(int scoreID) {
List list = new ArrayList();
String sql = “select * from score where score_id=” + scoreID;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreid = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
Score score = new Score(scoreid, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public Score selectScoreInfo(Score scor) {
String sql = “select * from score where stu_num='” + scor.getStuNum()
“’ and course_name='” + scor.getCourseName() + “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreid = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
score = new Score(scoreid, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
}
} catch (SQLException e) {
e.printStackTrace();
}
return score;
}
public PageBean scoreListPage(int pageNo, int pageCount, String stuNum) {
int totalCount = 0;
List list = new ArrayList();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
“from score,course where score.course_name=course.course_name and stu_num='” stuNum "’ limit " ((pageNo - 1) * pageCount) “,” pageCount;
String sqlCount = “select count(*) from score,course where score.course_name=course.course_name and stu_num='”
stuNum + “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String courseName = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
String major = rs.getString(“major”);
Date courseDate = rs.getDate(“coursedate”);
double scoreGrade = rs.getDouble(“score_grade”);
ScoreCou scoreCou = new ScoreCou(courseName, courseCredit,
courseHours, courseTea, major, courseDate, scoreGrade);
list.add(scoreCou);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public PageBean scoreListPage(int pageNo, int pageCount) {
int totalCount = 0;
List list = new ArrayList();
String sql = "select * from score limit " + ((pageNo - 1) * pageCount)
“,” + pageCount;
String sqlCount = “select count(*) from score”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public List findStuOne(String stuNum, String courseName) {
List list = new ArrayList();
String sql = "select score.course_name,course_credit,course_hours,course_teacher,major,coursedate,score_grade "
“from score,course where score.course_name=course.course_name and stu_num='” stuNum + “’ and course.course_name='” + courseName + “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
String coursename = rs.getString(“course_name”);
int courseCredit = rs.getInt(“course_credit”);
int courseHours = rs.getInt(“course_hours”);
String courseTea = rs.getString(“course_teacher”);
String major = rs.getString(“major”);
Date courseDate = rs.getDate(“coursedate”);
double scoreGrade = rs.getDouble(“score_grade”);
scoreCou = new ScoreCou(coursename, courseCredit, courseHours,
courseTea, major, courseDate, scoreGrade);
list.add(scoreCou);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public PageBean selectScoreSum(int pageNo, int pageCount) {
int totalCount = 0;
int i = 1;
List list = new ArrayList();
String sql = "select score.stu_num,score.stu_name,score.stu_class,score.major, sum(score.score_grade) as total,avg(score.score_grade) as avg "
"from score group by score.stu_num order by total DESC limit " ((pageNo - 1) * pageCount) + “,” + pageCount;
String sqlCount = “select count(*) from (select stu_num from score group by score.stu_num ) as a”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int number = i;
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String major = rs.getString(“major”);
double total = rs.getDouble(“total”);
double avg = rs.getDouble(“avg”);
scoreSum = new ScoreSum(number, stuNum, stuName, stuClass,
major, total, avg);
list.add(scoreSum);
i++;
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public PageBean selectStuScore(int pageNo, int pageCount, Score score) {
int totalCount = 0;
List list = new ArrayList();
String sql = “select * from score where stu_num like '%”
score.getStuNum() + “%’ and course_name like '%” score.getCourseName() + “%’ and stu_name like '%” score.getStuName() + “%’ and stu_class like '%” score.getStuClass() + “%’ and major like '%” score.getMajor() + "%’ limit " + ((pageNo - 1) * pageCount) “,” + pageCount;
String sqlCount = “select count(*) from score where stu_num like '%”
score.getStuNum() + “%’ and course_name like '%” score.getCourseName() + “%’ and stu_name like '%” score.getStuName() + “%’ and stu_class like '%” score.getStuClass() + “%’ and major like '%” score.getMajor() + “%'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
public PageBean selectTeaScore(int pageNo, int pageCount, String teaName,
Score score) {
int totalCount = 0;
List list = new ArrayList();
String sql = “select score.score_id,score.stu_num,score.stu_name,score.stu_class,score.course_name,score.score_grade,score.major from score,course where score.course_name=course.course_name and course.course_teacher='”
teaName “’ and score.stu_name like '%” score.getStuName() “%’ and score.stu_class like '%” score.getStuClass() “%’ and score.stu_num like '%” score.getStuNum() "%’ limit " ((pageNo - 1) * pageCount) “,” + pageCount;
String sqlCount = “select count(*) from score,course where score.course_name=course.course_name and course.course_teacher='”
teaName “’ and score.stu_name like '%” score.getStuName() “%’ and score.stu_class like '%” score.getStuClass() “%’ and score.stu_num like '%” score.getStuNum() “'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int scoreID = rs.getInt(“score_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuClass = rs.getString(“stu_class”);
String courseName = rs.getString(“course_name”);
double scoreGrade = rs.getDouble(“score_grade”);
String major = rs.getString(“major”);
score = new Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
totalCount = rs.getInt(1);
}
pageBean = new PageBean(list, totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
}
StudentDaoImpl
package dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import model.PageBean;
import model.Student;
import dao.StudentDao;
import db.DBCon;
public class StudentDaoImpl implements StudentDao {
private DBCon dbCon = new DBCon();
private Student student;
private PageBean pageBean;
public int addStu(Student student) {
String sql = “insert into student(stu_num,stu_name,stu_sex,stu_age,stu_class,major,department) values('”
student.getStuNum() “‘,’” student.getStuName() “‘,’” student.getStuSex() “',” student.getStuAge() “,'” student.getStuClass() “‘,’” student.getMajor() “‘,’” student.getDepartment() + “')”;
int rs = dbCon.query(sql);
return rs;
}
public int deleteStu(String stuNum) {
String sql = “delete from student where stu_num='” + stuNum + “'”;
int rs = dbCon.query(sql);
return rs;
}
public int editStu(Student student) {
String sql = “update student set stu_name='” + student.getStuName()
“‘,stu_sex=’” + student.getStuSex() + “',stu_age=” student.getStuAge() + “,stu_class='” + student.getStuClass() “‘,major=’” + student.getMajor() + “‘,department=’” student.getDepartment() + “’ where stu_num='” student.getStuNum() + “'”;
int rs=dbCon.query(sql);
return rs;
}
public List findAll() {
List list = new ArrayList();
String sql = “select * from student”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int stuID = rs.getInt(“stu_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuSex = rs.getString(“stu_sex”);
int stuAge = rs.getInt(“stu_age”);
String stuClass = rs.getString(“stu_class”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
student = new Student(stuID, stuNum, stuName, stuSex, stuAge,
stuClass, major, department);
list.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List findOne(String stuNum) {
List list = new ArrayList();
String sql=“select * from student where stu_num='”+stuNum+“'”;
ResultSet rs=dbCon.find(sql);
try {
while(rs.next()){
int stuID = rs.getInt(“stu_id”);
String stunum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuSex = rs.getString(“stu_sex”);
int stuAge = rs.getInt(“stu_age”);
String stuClass = rs.getString(“stu_class”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
student = new Student(stuID, stunum, stuName, stuSex, stuAge,
stuClass, major, department);
list.add(student);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
//pageNo当前页码,pageCount每页显示总条数
public PageBean stuListPage(int pageNo, int pageCount) {
int totalCount=0;
List list = new ArrayList();
String sql=“select * from student limit “+((pageNo-1)*pageCount)+”,”+pageCount;
String sqlCount=“select count(*) from student”;
try {
ResultSet rs=dbCon.find(sql);
while(rs.next()){
int stuID = rs.getInt(“stu_id”);
String stuNum = rs.getString(“stu_num”);
String stuName = rs.getString(“stu_name”);
String stuSex = rs.getString(“stu_sex”);
int stuAge = rs.getInt(“stu_age”);
String stuClass = rs.getString(“stu_class”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
student = new Student(stuID, stuNum, stuName, stuSex, stuAge,
stuClass, major, department);
list.add(student);
}
rs=dbCon.find(sqlCount);
while(rs.next()){
totalCount=rs.getInt(1);
}
pageBean=new PageBean(list , totalCount, pageNo, pageCount);
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
return pageBean;
}
}
TeacherDaoImpl
package dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import model.PageBean;
import model.Student;
import model.Teacher;
import dao.TeacherDao;
import db.DBCon;
public class TeacherDaoImpl implements TeacherDao{
private DBCon dbCon = new DBCon();
private Teacher teacher;
private PageBean pageBean;
public int addTea(Teacher teacher) {
String sql = “insert into teacher(tea_num,tea_name,tea_sex,tea_age,tea_course,major,department) values('”
teacher.getTeaNum() “‘,’” teacher.getTeaName() “‘,’” teacher.getTeaSex() “',” teacher.getTeaAge() “,'” teacher.getTeaCourse() “‘,’” teacher.getMajor() “‘,’” teacher.getDepartment() + “')”;
int rs = dbCon.query(sql);
return rs;
}
public int deleteTea(String teaNum) {
String sql = “delete from teacher where tea_num='” + teaNum + “'”;
int rs = dbCon.query(sql);
return rs;
}
public int editTea(Teacher teacher) {
String sql = “update teacher set tea_name='” + teacher.getTeaName()
“‘,tea_sex=’” + teacher.getTeaSex() + “',tea_age=” teacher.getTeaAge() + “,tea_course='” + teacher.getTeaCourse() “‘,major=’” + teacher.getMajor() + “‘,department=’” teacher.getDepartment() + “’ where tea_num='” teacher.getTeaNum() + “'”;
int rs=dbCon.query(sql);
return rs;
}
public List findAll() {
List list=new ArrayList();
String sql=“select * from teacher”;
ResultSet rs=dbCon.find(sql);
try {
while (rs.next()) {
int teaID = rs.getInt(“tea_id”);
String teaNum = rs.getString(“tea_num”);
String teaName = rs.getString(“tea_name”);
String teaSex = rs.getString(“tea_sex”);
int teaAge = rs.getInt(“tea_age”);
String teaCourse = rs.getString(“tea_course”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
teacher = new Teacher(teaID, teaNum, teaName, teaSex, teaAge,
teaCourse, major, department);
list.add(teacher);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List findOne(String teaNum) {
List list=new ArrayList();
String sql=“select * from teacher where tea_num='”+teaNum+“'”;
ResultSet rs=dbCon.find(sql);
try {
while (rs.next()) {
int teaID = rs.getInt(“tea_id”);
String teanum = rs.getString(“tea_num”);
String teaName = rs.getString(“tea_name”);
String teaSex = rs.getString(“tea_sex”);
int teaAge = rs.getInt(“tea_age”);
String teaCourse = rs.getString(“tea_course”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
teacher = new Teacher(teaID, teanum, teaName, teaSex, teaAge,
teaCourse, major, department);
list.add(teacher);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public PageBean teaListPage(int pageNo, int pageCount) {
List list=new ArrayList();
int totalCount=0;
String sql=“select * from teacher limit “+((pageNo-1)*totalCount)+”,”+totalCount;
String sqlCount=“select count(*) from teacher”;
ResultSet rs=dbCon.find(sql);
try {
while(rs.next()){
int teaID = rs.getInt(“tea_id”);
String teanum = rs.getString(“tea_num”);
String teaName = rs.getString(“tea_name”);
String teaSex = rs.getString(“tea_sex”);
int teaAge = rs.getInt(“tea_age”);
String teaCourse = rs.getString(“tea_course”);
String major = rs.getString(“major”);
String department = rs.getString(“department”);
teacher = new Teacher(teaID, teanum, teaName, teaSex, teaAge,
teaCourse, major, department);
list.add(teacher);
}
rs=dbCon.find(sqlCount);
while(rs.next()){
totalCount=rs.getInt(1);
}
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
pageBean=new PageBean(list,totalCount,pageNo,pageCount);
return pageBean;
}
}
UserDaoImpl
package dao.Impl;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import model.UsRole;
import model.User;
import dao.UserDao;
import db.DBCon;
public class UserDaoImpl implements UserDao {
private DBCon dbCon = new DBCon();
private User user;
private UsRole usRole;
public User login(User user) {
String sql = “select *from user where user_num='” + user.getUserNum()
“'”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int userID = rs.getInt(“user_id”);
String userNum = rs.getString(“user_num”);
String userName = rs.getString(“user_name”);
String pwd = rs.getString(“password”);
String phone = rs.getString(“phone”);
int roleID = rs.getInt(“role_id”);
user = new User(userID, userNum, userName, pwd, phone, roleID);
}
} catch (SQLException e) {
e.printStackTrace();
}
return user;
}
public int editPwd(User user) {
String sql = “update user set password='” + user.getPassword()
“’ where user_num='” + user.getUserNum() + “'”;
int rs = dbCon.query(sql);
return rs;
}
public int addUser(User user) {
String sql = “insert into user(user_num,user_name,password,phone,role_id) values('”
user.getUserNum() “‘,’” user.getUserName() “‘,’” user.getPassword() “',” user.getPhone() “,” user.getRoleID() + “)”;
int rs = dbCon.query(sql);
return rs;
}
public List findAll() {
List list = new ArrayList();
String sql = “select user_id,user_num,user_name,password,phone,role_name from user,role where user.role_id=role.role_id”;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int userID = rs.getInt(“user_id”);
String userNum = rs.getString(“user_num”);
String userName = rs.getString(“user_name”);
String pwd = rs.getString(“password”);
String phone = rs.getString(“phone”);
String roleName = rs.getString(“role_name”);
usRole = new UsRole(userID, userNum, userName, pwd, phone,
roleName);
list.add(usRole);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public List selectOneUser(int userID) {
List list = new ArrayList();
String sql = “select * from user where user_id=” + userID;
ResultSet rs = dbCon.find(sql);
try {
while (rs.next()) {
int userid = rs.getInt(“user_id”);
String userNum = rs.getString(“user_num”);
String userName = rs.getString(“user_name”);
String pwd = rs.getString(“password”);
String phone = rs.getString(“phone”);
int roleID = rs.getInt(“role_id”);
user = new User(userID, userNum, userName, pwd, phone, roleID);
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public int editUser(User user) {
String sql = “update user set user_name='” + user.getUserName()
“',password=” + user.getPassword() + “,phone='” user.getPhone() + “’ where user_num='” + user.getUserNum() “'”;
int rs = dbCon.query(sql);
return rs;
}
}
DBCon
package db;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DBCon {
Connection con = null;
Statement st = null;
ResultSet rs = null;
String driver=null;
String url = null;
String username = null;
String password = null;
public Connection dbCon() {
try {
InputStream is=DBCon.class.getClassLoader().getResourceAsStream(“db.properties”);
Properties prop=new Properties();
try {
prop.load(is);
driver=prop.getProperty(“driver”);
url=prop.getProperty(“url”);
username=prop.getProperty(“username”);
password=prop.getProperty(“password”);
} catch (IOException e1) {
e1.printStackTrace();
}
Class.forName(driver);
/*Class.forName(“com.mysql.jdbc.Driver”);
url = “jdbc:mysql:///sams?useUnicode=true&characterEncoding=utf8”;
username = “root”;
password = “root”;*/
try {
con = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return con;
}
/*
增删改
*/
public int query(String sql) {
int rs = 0;
con = dbCon();
try {
st = con.createStatement();
rs = st.executeUpdate(sql);
} catch (SQLException e) {
close();
e.printStackTrace();
}
return rs;
}
/*
查
*/
public ResultSet find(String sql) {
try {
con = dbCon();
st = con.createStatement();
rs = st.executeQuery(sql);
} catch (SQLException e) {
close();
e.printStackTrace();
}
return rs;
}
/*
关闭数据库
*/
public void close() {
try {
if (rs != null)
rs.close();
if (st != null)
st.close();
if (con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
register.jsp
<%@ page language=“java” import=“java.util.*” pageEncoding=“utf-8”%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+“/”+request.getServerName()+“:”+request.getServerPort()+path+“/”;
%>
注册页面
${msg}
注册页面
**自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。**
深知大多数前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上前端开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注:前端)
最后
分享一套阿里大牛整理的前端资料给大家,点击前端校招面试题精编解析大全即可获取
❤️ 谢谢支持,喜欢的话别忘了 关注、点赞哦。
lHttpRequest!=null){
//拿到账号
var stuNum=document.getElementById(“stuNum”);
if(stuNum.value==“”){
document.getElementById(“stuNumcheck”).innerHTML = “学号不能为空”;
return;
}else{
var url=“ServletRegisterStu?stuNum=”+stuNum.value;
xmlHttpRequest.open(“get”,url,true);
xmlHttpRequest.send();
xmlHttpRequest.onreadystatechange=function(){
if(xmlHttpRequest.readyState4 && xmlHttpRequest.status200){
var text = xmlHttpRequest.responseText;
//alert(text);
document.getElementById(“stuNumcheck”).innerHTML = text;
}
};
}
}
}
function namecheck(){
var stuName=document.getElementById(“stuName”).value;
var rename=/1+$/gi; //中文判断
if(stuName==“”){
document.getElementById(“stuNamecheck”).innerHTML = “用户名不能为空”;
}
else if (!rename.test(stuName))
{
document.getElementById(“stuNamecheck”).innerHTML = “请输入中文名,如:王文军”;
}else{
document.getElementById(“stuNamecheck”).innerHTML = “正确”;
}
}
function pwdcheck(){
var pwd1=document.getElementById(“password”).value;
if(pwd1==“”){
document.getElementById(“stuPwdcheck”).innerHTML = “密码不能为空”;
}else if(pwd1.length<6){
document.getElementById(“stuPwdcheck”).innerHTML = “密码不能小于六位”;
}else {
document.getElementById(“stuPwdcheck”).innerHTML = “正确”;
}
}
function pwdc(){
var pwd1=document.getElementById(“password”).value;
var pwd2=document.getElementById(“pwd”).value;
if(pwd1==“”){
document.getElementById(“stuPwdrcheck”).innerHTML = “确认密码不能为空”;
}else if(pwd1!=pwd2){
document.getElementById(“stuPwdrcheck”).innerHTML = “两次密码不一致”;
}else {
document.getElementById(“stuPwdrcheck”).innerHTML = “正确”;
}
}
${msg}
注册页面
**自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。**
深知大多数前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Web前端开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
[外链图片转存中…(img-sJyo1DjF-1712420326249)]
[外链图片转存中…(img-AFcC9iLh-1712420326249)]
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上前端开发知识点,真正体系化!
[外链图片转存中…(img-hPeiRb8a-1712420326250)]
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注:前端)
最后
分享一套阿里大牛整理的前端资料给大家,点击前端校招面试题精编解析大全即可获取
❤️ 谢谢支持,喜欢的话别忘了 关注、点赞哦。
\u4e00-\u9fa5 ↩︎
参考文章
发表评论