基于javaweb+mysql的jsp+servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet学生信息管理系统(java+servlet+jsp+easyui+mysql)
介绍
学生信息管理系统,该项目分为管理员、老师、学生三种角色; 管理员主要功能: 学生信息管理、班级信息管理、教师信息管理、系统管理; 老师主要功能: 学生信息管理、班级信息管理、教师信息管理、系统管理; 学生主要功能: 学生信息管理、系统管理;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目 6.数据库:MySql 5.7版本;
技术栈
- Servlet+Jsp+easyui
使用说明
- 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat,然后运行; 2. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 3. 将项目中DbUtil.java中的数据库配置改为自己的配置 4. 配置tomcat,运行项目,在浏览器中输入localhost:8080/xxx 登录 5.管理员账号:admin 密码:admin 教师账号:王鹤翔老师 密码:111 学生账号:江小雷 密码:1
// TODO Auto-generated method stub
String name = request.getParameter("studentName");
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Integer clazz = request.getParameter("clazzid") == null ? 0 : Integer.parseInt(request.getParameter("clazzid"));
//获取当前登录用户类型
int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
Student student = new Student();
student.setName(name);
student.setClazzId(clazz);
if(userType == 2){
//如果是学生,只能查看自己的信息
Student currentUser = (Student)request.getSession().getAttribute("user");
student.setId(currentUser.getId());
}
StudentDao studentDao = new StudentDao();
List<Student> clazzList = studentDao.getStudentList(student, new Page(currentPage, pageSize));
int total = studentDao.getStudentListTotal(student);
studentDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", clazzList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(clazzList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void addStudent(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String name = request.getParameter("name");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
String mobile = request.getParameter("mobile");
String qq = request.getParameter("qq");
int clazzId = Integer.parseInt(request.getParameter("clazzid"));
Student student = new Student();
student.setClazzId(clazzId);
student.setMobile(mobile);
student.setName(name);
student.setPassword(password);
student.setQq(qq);
student.setSex(sex);
student.setSn(SnGenerateUtil.generateSn(clazzId));
StudentDao studentDao = new StudentDao();
if(studentDao.addStudent(student)){
Student currentUser = (Student)request.getSession().getAttribute("user");
studentId = currentUser.getId();
}
score.setCourseId(courseId);
score.setStudentId(studentId);
ScoreDao scoreDao = new ScoreDao();
List<Score> courseList = scoreDao.getScoreList(score, new Page(currentPage, pageSize));
int total = scoreDao.getScoreListTotal(score);
scoreDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", courseList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(courseList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void addScore(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
Double scoreNum = Double.parseDouble(request.getParameter("score"));
String remark = request.getParameter("remark");
Score score = new Score();
score.setCourseId(courseId);
score.setStudentId(studentId);
score.setScore(scoreNum);
score.setRemark(remark);
ScoreDao scoreDao = new ScoreDao();
if(scoreDao.isAdd(studentId, courseId)){
try {
response.getWriter().write("added");
scoreDao.closeCon();
return;
int total = attendanceDao.getAttendanceListTotal(attendance);
attendanceDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", attendanceList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(attendanceList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void AddAttendance(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
String type = request.getParameter("type").toString();
AttendanceDao attendanceDao = new AttendanceDao();
Attendance attendance = new Attendance();
attendance.setCourseId(courseId);
attendance.setStudentId(studentId);
attendance.setType(type);
attendance.setDate(DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"));
String msg = "success";
response.setCharacterEncoding("UTF-8");
if(attendanceDao.isAttendanced(studentId, courseId, type,DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"))){
msg = "已签到,请勿重复签到!";
}else if(!attendanceDao.addAttendance(attendance)){
msg = "系统内部出错。请联系管理员!";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void getStudentSelectedCourseList(HttpServletRequest request,
attendance.setCourseId(courseId);
attendance.setStudentId(studentId);
attendance.setDate(date);
attendance.setType(type);
AttendanceDao attendanceDao = new AttendanceDao();
List<Attendance> attendanceList = attendanceDao.getSelectedCourseList(attendance, new Page(currentPage, pageSize));
int total = attendanceDao.getAttendanceListTotal(attendance);
attendanceDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", attendanceList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(attendanceList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void AddAttendance(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
String type = request.getParameter("type").toString();
AttendanceDao attendanceDao = new AttendanceDao();
Attendance attendance = new Attendance();
attendance.setCourseId(courseId);
attendance.setStudentId(studentId);
attendance.setType(type);
attendance.setDate(DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"));
String msg = "success";
response.setCharacterEncoding("UTF-8");
if(attendanceDao.isAttendanced(studentId, courseId, type,DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"))){
msg = "已签到,请勿重复签到!";
}else if(!attendanceDao.addAttendance(attendance)){
msg = "系统内部出错。请联系管理员!";
}
try {
response.getWriter().write(msg);
request.getRequestDispatcher("view/scoreStats.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("getStatsList".equals(method)){
getStatsList(request,response);
}
}
private void getStatsList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
String searchType = request.getParameter("searchType");
response.setCharacterEncoding("UTF-8");
if(courseId == 0){
try {
response.getWriter().write("error");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
ScoreDao scoreDao = new ScoreDao();
Score score = new Score();
score.setCourseId(courseId);
if("avg".equals(searchType)){
Map<String, Object> avgStats = scoreDao.getAvgStats(score);
List<Double> scoreList = new ArrayList<Double>();
scoreList.add(Double.parseDouble(avgStats.get("max_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("min_score").toString()));
scoreList.add(Double.parseDouble(avgStats.get("avg_score").toString()));
List<String> avgStringList = new ArrayList<String>();
avgStringList.add("最高分");
avgStringList.add("最低分");
avgStringList.add("平均分");
Map<String, Object> retMap = new HashMap<String, Object>();
retMap.put("courseName", avgStats.get("courseName").toString());
retMap.put("scoreList", scoreList);
retMap.put("avgList", avgStringList);
retMap.put("type", "suceess");
try {
response.getWriter().write(JSONObject.fromObject(retMap).toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
List<Map<String, Object>> scoreList = scoreDao.getScoreList(score);
List<Integer> numberList = new ArrayList<Integer>();
numberList.add(0);
ret.put("total", total);
ret.put("rows", attendanceList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(attendanceList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void AddAttendance(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
String type = request.getParameter("type").toString();
AttendanceDao attendanceDao = new AttendanceDao();
Attendance attendance = new Attendance();
attendance.setCourseId(courseId);
attendance.setStudentId(studentId);
attendance.setType(type);
attendance.setDate(DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"));
String msg = "success";
response.setCharacterEncoding("UTF-8");
if(attendanceDao.isAttendanced(studentId, courseId, type,DateFormatUtil.getFormatDate(new Date(), "yyyy-MM-dd"))){
msg = "已签到,请勿重复签到!";
}else if(!attendanceDao.addAttendance(attendance)){
msg = "系统内部出错。请联系管理员!";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void getStudentSelectedCourseList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void addLeave(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = Integer.parseInt(request.getParameter("studentid"));
String info = request.getParameter("info");
Leave leave = new Leave();
leave.setStudentId(studentId);
leave.setInfo(info);
leave.setRemark("");
LeaveDao leaveDao = new LeaveDao();
String msg = "error";
if(leaveDao.addLeave(leave)){
msg = "success";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
leaveDao.closeCon();
}
}
}
/**
*
*学生信息管理功能实现servlet
retMap.put("courseName", avgStats.get("courseName").toString());
retMap.put("scoreList", scoreList);
retMap.put("avgList", avgStringList);
retMap.put("type", "suceess");
try {
response.getWriter().write(JSONObject.fromObject(retMap).toString());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
List<Map<String, Object>> scoreList = scoreDao.getScoreList(score);
List<Integer> numberList = new ArrayList<Integer>();
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
numberList.add(0);
List<String> rangeStringList = new ArrayList<String>();
rangeStringList.add("60分以下");
rangeStringList.add("60~70分");
rangeStringList.add("70~80分");
rangeStringList.add("80~90分");
rangeStringList.add("90~100分");
String courseName = "";
for(Map<String, Object> entry:scoreList){
courseName = entry.get("courseName").toString();
double scoreValue = Double.parseDouble(entry.get("score").toString());
if(scoreValue < 60){
numberList.set(0, numberList.get(0)+1);
continue;
}
if(scoreValue <= 70 && scoreValue >= 60){
numberList.set(1, numberList.get(1)+1);
continue;
}
if(scoreValue <= 80 && scoreValue > 70){
numberList.set(2, numberList.get(2)+1);
continue;
}
request.getRequestDispatcher("view/leaveList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("AddLeave".equals(method)){
addLeave(request,response);
}else if("LeaveList".equals(method)){
getLeaveList(request,response);
}else if("EditLeave".equals(method)){
editLeave(request,response);
}else if("CheckLeave".equals(method)){
checkLeave(request,response);
}
else if("DeleteLeave".equals(method)){
deleteLeave(request,response);
}
}
private void deleteLeave(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int id = Integer.parseInt(request.getParameter("id"));
LeaveDao leaveDao = new LeaveDao();
String msg = "success";
if(!leaveDao.deleteLeave(id)){
msg = "error";
}
try {
response.getWriter().write(msg);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void checkLeave(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = Integer.parseInt(request.getParameter("studentid"));
int id = Integer.parseInt(request.getParameter("id"));
int status = Integer.parseInt(request.getParameter("status"));
String info = request.getParameter("info");
String remark = request.getParameter("remark");
Leave leave = new Leave();
leave.setStudentId(studentId);
leave.setInfo(info);
leave.setRemark(remark);
leave.setStatus(status);
leave.setId(id);
}
private void deleteStudent(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String[] ids = request.getParameterValues("ids[]");
String idStr = "";
for(String id : ids){
idStr += id + ",";
}
idStr = idStr.substring(0, idStr.length()-1);
StudentDao studentDao = new StudentDao();
if(studentDao.deleteStudent(idStr)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
studentDao.closeCon();
}
}
}
private void editStudent(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String name = request.getParameter("name");
int id = Integer.parseInt(request.getParameter("id"));
String sex = request.getParameter("sex");
String mobile = request.getParameter("mobile");
String qq = request.getParameter("qq");
int clazzId = Integer.parseInt(request.getParameter("clazzid"));
Student student = new Student();
student.setClazzId(clazzId);
student.setMobile(mobile);
student.setName(name);
student.setId(id);
student.setQq(qq);
student.setSex(sex);
StudentDao studentDao = new StudentDao();
if(studentDao.editStudent(student)){
public class CourseServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = -1991371597134855732L;
public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{
doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{
String method = request.getParameter("method");
if("toCourseListView".equals(method)){
try {
request.getRequestDispatcher("view/courseList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("AddCourse".equals(method)){
addCourse(request,response);
}else if("CourseList".equals(method)){
getCourseList(request,response);
}else if("EditCourse".equals(method)){
editCourse(request,response);
}else if("DeleteCourse".equals(method)){
deleteCourse(request,response);
}
}
private void deleteCourse(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String[] ids = request.getParameterValues("ids[]");
String idStr = "";
continue;
}
Score score = new Score();
score.setCourseId(courseId);
score.setRemark(remark);
score.setScore(scoreValue);
score.setStudentId(studentId);
if(scoreDao.addScore(score)){
count++;
}
}
errorMsg += "成功录入" + count + "条成绩信息!";
studentDao.closeCon();
courseDao.closeCon();
selectedCourseDao.closeCon();
scoreDao.closeCon();
try {
response.getWriter().write("<div id='message'>"+errorMsg+"</div>");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
} catch (ProtocolException e) {
// TODO Auto-generated catch block
try {
response.getWriter().write("<div id='message'>上传协议错误!</div>");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}catch (NullFileException e1) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>上传的文件为空!</div>");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
e1.printStackTrace();
}
catch (SizeException e2) {
// TODO: handle exception
try {
response.getWriter().write("<div id='message'>上传文件大小不能超过"+fileUpload.getFileSize()+"!</div>");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
request.getRequestDispatcher("view/scoreList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("AddScore".equals(method)){
addScore(request,response);
}else if("ScoreList".equals(method)){
getScoreList(request,response);
}else if("EditScore".equals(method)){
editScore(request,response);
}else if("DeleteScore".equals(method)){
deleteScore(request,response);
}else if("ImportScore".equals(method)){
importScore(request,response);
}else if("ExportScoreList".equals(method)){
exportScore(request,response);
}else if("toScoreStatsView".equals(method)){
try {
request.getRequestDispatcher("view/scoreStats.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("getStatsList".equals(method)){
getStatsList(request,response);
}
}
private void getStatsList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
String searchType = request.getParameter("searchType");
response.setCharacterEncoding("UTF-8");
if(courseId == 0){
try {
response.getWriter().write("error");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return;
}
ScoreDao scoreDao = new ScoreDao();
Score score = new Score();
int id = Integer.parseInt(request.getParameter("id"));
String sex = request.getParameter("sex");
String mobile = request.getParameter("mobile");
String qq = request.getParameter("qq");
int clazzId = Integer.parseInt(request.getParameter("clazzid"));
Teacher teacher = new Teacher();
teacher.setClazzId(clazzId);
teacher.setMobile(mobile);
teacher.setName(name);
teacher.setId(id);
teacher.setQq(qq);
teacher.setSex(sex);
TeacherDao teacherDao = new TeacherDao();
if(teacherDao.editTeacher(teacher)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
teacherDao.closeCon();
}
}
}
private void getTeacherList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String name = request.getParameter("teacherName");
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Integer clazz = request.getParameter("clazzid") == null ? 0 : Integer.parseInt(request.getParameter("clazzid"));
//获取当前登录用户类型
int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
Teacher teacher = new Teacher();
teacher.setName(name);
teacher.setClazzId(clazz);
if(userType == 3){
//如果是学生,只能查看自己的信息
Teacher currentUser = (Teacher)request.getSession().getAttribute("user");
teacher.setId(currentUser.getId());
}
TeacherDao teacherDao = new TeacherDao();
List<Teacher> teacherList = teacherDao.getTeacherList(teacher, new Page(currentPage, pageSize));
int total = teacherDao.getTeacherListTotal(teacher);
teacherDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", teacherList);
try {
clazz.setName(name);
clazz.setInfo(info);
ClazzDao clazzDao = new ClazzDao();
if(clazzDao.addClazz(clazz)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
clazzDao.closeCon();
}
}
}
private void clazzList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
try {
request.getRequestDispatcher("view/clazzList.jsp").forward(request, response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void getClazzList(HttpServletRequest request,HttpServletResponse response){
String name = request.getParameter("clazzName");
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Clazz clazz = new Clazz();
clazz.setName(name);
ClazzDao clazzDao = new ClazzDao();
List<Clazz> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));
int total = clazzDao.getClazzListTotal(clazz);
clazzDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", clazzList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(clazzList).toString());
}else{
response.getWriter().write(JSONObject.fromObject(ret).toString());
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void deleteStudent(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String[] ids = request.getParameterValues("ids[]");
String idStr = "";
for(String id : ids){
idStr += id + ",";
}
idStr = idStr.substring(0, idStr.length()-1);
StudentDao studentDao = new StudentDao();
if(studentDao.deleteStudent(idStr)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
studentDao.closeCon();
}
}
}
private void editStudent(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
String name = request.getParameter("name");
int id = Integer.parseInt(request.getParameter("id"));
String sex = request.getParameter("sex");
String mobile = request.getParameter("mobile");
String qq = request.getParameter("qq");
int clazzId = Integer.parseInt(request.getParameter("clazzid"));
Student student = new Student();
student.setClazzId(clazzId);
student.setMobile(mobile);
student.setName(name);
student.setId(id);
student.setQq(qq);
student.setSex(sex);
StudentDao studentDao = new StudentDao();
if(studentDao.editStudent(student)){
try {
response.getWriter().write("success");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
HttpServletResponse response) {
// TODO Auto-generated method stub
int id = Integer.parseInt(request.getParameter("id"));
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
Double scoreNum = Double.parseDouble(request.getParameter("score"));
String remark = request.getParameter("remark");
Score score = new Score();
score.setId(id);
score.setCourseId(courseId);
score.setStudentId(studentId);
score.setScore(scoreNum);
score.setRemark(remark);
ScoreDao scoreDao = new ScoreDao();
String ret = "success";
if(!scoreDao.editScore(score)){
ret = "error";
}
try {
response.getWriter().write(ret);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void getScoreList(HttpServletRequest request,
HttpServletResponse response) {
// TODO Auto-generated method stub
int studentId = request.getParameter("studentid") == null ? 0 : Integer.parseInt(request.getParameter("studentid").toString());
int courseId = request.getParameter("courseid") == null ? 0 : Integer.parseInt(request.getParameter("courseid").toString());
Integer currentPage = request.getParameter("page") == null ? 1 : Integer.parseInt(request.getParameter("page"));
Integer pageSize = request.getParameter("rows") == null ? 999 : Integer.parseInt(request.getParameter("rows"));
Score score = new Score();
//获取当前登录用户类型
int userType = Integer.parseInt(request.getSession().getAttribute("userType").toString());
if(userType == 2){
//如果是学生,只能查看自己的信息
Student currentUser = (Student)request.getSession().getAttribute("user");
studentId = currentUser.getId();
}
score.setCourseId(courseId);
score.setStudentId(studentId);
ScoreDao scoreDao = new ScoreDao();
List<Score> courseList = scoreDao.getScoreList(score, new Page(currentPage, pageSize));
int total = scoreDao.getScoreListTotal(score);
scoreDao.closeCon();
response.setCharacterEncoding("UTF-8");
Map<String, Object> ret = new HashMap<String, Object>();
ret.put("total", total);
ret.put("rows", courseList);
try {
String from = request.getParameter("from");
if("combox".equals(from)){
response.getWriter().write(JSONArray.fromObject(courseList).toString());