基于javaweb+mysql的jsp+servlet學(xué)生成績(jī)管理系統(tǒng)(管理員、教師、學(xué)生)(java+jsp+servlet+javabean+mysql+tomcat)
運(yùn)行環(huán)境
Java≥8、MySQL≥5.7、Tomcat≥8
開(kāi)發(fā)工具
eclipse/idea/myeclipse/sts等均可配置運(yùn)行
適用
課程設(shè)計(jì)，大作業(yè)，畢業(yè)設(shè)計(jì)，項(xiàng)目練習(xí)，學(xué)習(xí)演示等
功能說(shuō)明
管理員：個(gè)人信息、課程管理、成績(jī)管理、教師管理、學(xué)生管理
教師：個(gè)人信息、課程管理、成績(jī)管理、學(xué)生信息查看
學(xué)生：人個(gè)信息管理、成績(jī)查詢
管理員
教師
學(xué)生
技術(shù)框架
JSP Servlet MySQL JDBC Tomcat CSS JavaScript bootstrap jquery
基于javaweb+mysql的JSP+Servlet學(xué)生成績(jī)管理系統(tǒng)(管理員、教師、學(xué)生)(java+jsp+servlet+javabean+mysql+tomcat)
// 得到文件保存目錄
String realSavePath = makePath(saveFileName, savePath);
// 創(chuàng)建一個(gè)文件輸出流
FileOutputStream fos = new FileOutputStream(realSavePath
+ "\\" + saveFileName);
// 創(chuàng)建一個(gè)緩沖區(qū)
byte buffer[] = new byte[1024];
// 判斷輸入流中的數(shù)據(jù)是否已經(jīng)讀完的標(biāo)識(shí)
int len = 0;
// 循環(huán)將輸入流讀入到緩沖區(qū)中，（len=in.read(buffer)）>0就表示in里面還有數(shù)據(jù)
while ((len = is.read(buffer)) > 0) {
// 使用FileOutputStream輸出流將緩沖區(qū)的數(shù)據(jù)寫(xiě)入到指定的目錄(savePath + "\\"
// + filename)當(dāng)中
fos.write(buffer, 0, len);
}
// 關(guān)閉輸入流
is.close();
// 關(guān)閉輸出流
fos.close();
// 刪除處理文件上傳時(shí)生成的臨時(shí)文件
// item.delete();
message = "文件上傳成功！";
}
}
} catch (FileUploadBase.FileSizeLimitExceededException e) {
e.printStackTrace();
request.setAttribute("message", "單個(gè)文件超出最大值！??！");
request.getRequestDispatcher("admin/fileLoadFail.jsp").forward(
request, response);
return;
// e.printStackTrace();
} catch (FileUploadBase.SizeLimitExceededException e) {
e.printStackTrace();
request.setAttribute("message", "上傳文件的總的大小超出限制的最大值?。。?);
request.getRequestDispatcher("admin/fileLoadFail.jsp").forward(
request, response);
return;
} catch (Exception e) {
message = "文件上傳失??！";
e.printStackTrace();
}
if(cos==null){
int rs=courseServiceImpl.addCos(course,coDate);
if(rs>0){
request.setAttribute("msg", "添加成功??！");
servletFindAllCos.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "添加失敗??！");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "該課程已錄入，請(qǐng)重新輸入！！");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
public class ServletEditCos extends HttpServlet{
private Course course;
private ServletFindAllCos servletFindAllCos=new ServletFindAllCos();
private ServletSelectCos selectOne=new ServletSelectCos();
private CourseServiceImpl courseServiceImpl=new CourseServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
public class ServletRegistersStudent extends HttpServlet{
private User user;
private Student student;
private UserServiceImpl userServiceImpl = new UserServiceImpl();
private StudentServiceImpl studentServiceImpl =new StudentServiceImpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String pwd = request.getParameter("password");
String stuSex = request.getParameter("stuSex");
int stuAge = Integer.parseInt(request.getParameter("stuAge"));
String stuClass = request.getParameter("stuClass");
String major = request.getParameter("major");
String department = request.getParameter("department");
String phone = request.getParameter("phone");
int roleID = Integer.parseInt(request.getParameter("role"));
user = new User(stuNum, stuName, pwd, phone, roleID);
student = new Student(stuNum, stuName, stuSex, stuAge, stuClass, major,
department);
int rsUser=userServiceImpl.addUser(user);
int rsStu=studentServiceImpl.addStu(student);
if(rsStu>0 && rsUser>0){
public class ServletaddStudent extends HttpServlet {
private User user;
private Student student;
private UserServiceImpl userServiceImpl = new UserServiceImpl();
private StudentServiceImpl studentServiceImpl =new StudentServiceImpl();
private ServletFindAllStu findStu=new ServletFindAllStu();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String pwd = request.getParameter("password");
String stuSex = request.getParameter("stuSex");
int stuAge = Integer.parseInt(request.getParameter("stuAge"));
String stuClass = request.getParameter("stuClass");
String major = request.getParameter("major");
String department = request.getParameter("department");
String phone = request.getParameter("phone");
int roleID = Integer.parseInt(request.getParameter("role"));
user = new User(stuNum, stuName, pwd, phone, roleID);
student = new Student(stuNum, stuName, stuSex, stuAge, stuClass, major,
department);
//驗(yàn)證是否存在該學(xué)生
User rs=userServiceImpl.login(user);
if(rs.getUserID()==0){
int rsUser=userServiceImpl.addUser(user);
int rsStu=studentServiceImpl.addStu(student);
if(rsStu>0 && rsUser>0){
request.setAttribute("msg", "添加成功?。?);
findStu.doGet(request, response);
/*List list=studentDaoImpl.findAll();
request.setAttribute("list", list);
request.getRequestDispatcher("admin/studentAllInfo.jsp").forward(request, response);*/
}else{
request.setAttribute("msg", "添加失?。?！");
request.getRequestDispatcher("admin/addStudent.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "該學(xué)號(hào)已存在，請(qǐng)重新錄入??！");
request.getRequestDispatcher("admin/addStudent.jsp").forward(request, response);
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
public class ServletListFile extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//獲取上傳文件的目錄
String uploadFilePath=this.getServletContext().getRealPath("/WEB-INF/upload");
//存儲(chǔ)要下載的文件名
Map<String,String> fileNameMap=new HashMap<String, String>();
/*
* 遞歸遍歷filepath目錄下的所有文件和目錄，將文件的文件名存儲(chǔ)到map集合中
*/
//file既可以代表一個(gè)文件也可以代表一個(gè)目錄
listFile(new File(uploadFilePath),fileNameMap);
//將map集合發(fā)送到listFile.jsp頁(yè)面進(jìn)行顯示
request.setAttribute("fileNameMap", fileNameMap);
request.getRequestDispatcher("admin/fileList.jsp").forward(request, response);
}
private void listFile(File file, Map<String, String> fileNameMap) {
//如果file代表的不是一個(gè)文件，而是一個(gè)目錄
if(!file.isFile()){
//列出該目錄下的所有文件和目錄
File files[]=file.listFiles();
public class ServletEditTeacherInfo extends HttpServlet{
private Teacher teacher;
private TeacherServiceImpl teacherServiceImpl=new TeacherServiceImpl();
private ServletTeacherInfo servletTeacherInfo=new ServletTeacherInfo();
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String teaNum=request.getParameter("teaNum");
String teaName = request.getParameter("teaName");
String teaSex = request.getParameter("teaSex");
int teaAge = Integer.parseInt(request.getParameter("teaAge"));
String teaCourse = request.getParameter("teaCourse");
String major = request.getParameter("major");
String department = request.getParameter("department");
teacher = new Teacher(teaNum, teaName, teaSex, teaAge, teaCourse, major,
department);
int rs=teacherServiceImpl.editTea(teacher);
if(rs>0){
request.setAttribute("msg", "修改成功！！");
servletTeacherInfo.doGet(request, response);
}else{
request.setAttribute("msg", "修改失?。?！");
request.getRequestDispatcher("teacher/editTeacherInfo.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doGet(request,response);
}
}
stuName=null;
}
if(stuClass==""){
stuClass=null;
}
if(major==""){
major=null;
}*/
double scoreGrade=0;
score=new Score( stuNum, stuName, stuClass,
courseName, scoreGrade, major);
PageBean rs=scoreServiceImpl.selectStuScore(pageNo, pageCount, score);
request.setAttribute("list", rs);
request.setAttribute("score", score);
request.getRequestDispatcher("admin/selectblurScore.jsp").forward(request, response);
}
}
public class ServletEditUser extends HttpServlet{
private User user;
private ServletFindAllUser servletFindAllUser=new ServletFindAllUser();
private UserServiceImpl userServiceImpl=new UserServiceImpl();
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String userNum=request.getParameter("userNum");
String userName=request.getParameter("userName");
String pwd=request.getParameter("password");
String phone=request.getParameter("phone");
int roleID=Integer.parseInt(request.getParameter("roleID"));
user=new User(userNum,userName,pwd,phone,roleID);
int rs=userServiceImpl.editUser(user);
if(rs>0){
request.setAttribute("msg", "修改成功??！");
throws ServletException, IOException {
int pageNo=1;
int pageCount=1;
String teaName=(String) request.getSession().getAttribute("username");
String pageNoStr=request.getParameter("pageNo");
String pageCountStr=request.getParameter("pageCount");
if(pageNoStr!=null){
pageNo=Integer.parseInt(pageNoStr);
}
if(pageCountStr!=null){
pageCount=Integer.parseInt(pageCountStr);
}
String stuNum=request.getParameter("stuNum");
String stuName=request.getParameter("stuName");
String stuClass=request.getParameter("stuClass");
score=new Score();
score.setStuNum(stuNum);
score.setStuName(stuName);
score.setStuClass(stuClass);
PageBean list=scoreServiceImpl.selectTeaScore(pageNo, pageCount, teaName,score);
request.setAttribute("list", list);
request.setAttribute("score", score);
request.getRequestDispatcher("teacher/stuTeaScore.jsp").forward(request, response);
}
}
Date courseDate=null;
try {
courseDate = new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("courseDate"));
} catch (ParseException e) {
e.printStackTrace();
}
// System.out.println(courseDate);
course=new Course(courseName,courseCredit,courseHours,courseTea,courseDate);
//new Course( courseName, courseCredit, courseHours,
// courseTea, courseDate);
//驗(yàn)證是否存在該教師課程
Course cos=courseServiceImpl.selectOneCos(course);
if(cos==null){
int rs=courseServiceImpl.addCos(course,coDate);
if(rs>0){
request.setAttribute("msg", "添加成功?。?);
servletFindAllCos.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "添加失?。?！");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}else{
request.setAttribute("msg", "該課程已錄入，請(qǐng)重新輸入??！");
request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
return null;
}
}
public class ServletaddTeacher extends HttpServlet{
private User user;
private Teacher teacher;
private UserServiceImpl userServiceImpl = new UserServiceImpl();
private TeacherServiceImpl teacherServiceImpl =new TeacherServiceImpl();
private ServletFindAllTea findTea=new ServletFindAllTea();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String teaNum = request.getParameter("teaNum");
String teaName = request.getParameter("teaName");
String pwd = request.getParameter("password");
String teaSex = request.getParameter("teaSex");
int teaAge = Integer.parseInt(request.getParameter("teaAge"));
String teaCourse = request.getParameter("teaCourse");
String major = request.getParameter("major");
String department = request.getParameter("department");
public class ServletEditCos extends HttpServlet{
private Course course;
private ServletFindAllCos servletFindAllCos=new ServletFindAllCos();
private ServletSelectCos selectOne=new ServletSelectCos();
private CourseServiceImpl courseServiceImpl=new CourseServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int courseID=Integer.parseInt(request.getParameter("courseID"));
String courseName = request.getParameter("courseName");
int courseCredit = Integer.parseInt(request.getParameter("courseCredit"));
int courseHours = Integer.parseInt(request.getParameter("courseHours"));
String courseTea = request.getParameter("courseTea");
String coDate = request.getParameter("courseDate");
Date courseDate = null;
try {
courseDate = new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("courseDate"));
} catch (ParseException e) {
e.printStackTrace();
}
course=new Course(courseID,courseName,courseCredit,courseHours,courseTea,courseDate);
int rs=courseServiceImpl.editCos(course,coDate);
if(rs>0){
request.setAttribute("msg", "修改成功！！");
servletFindAllCos.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
List rs=userDaoImpl.selectOneUser(userID);
request.setAttribute("list", rs);
request.getRequestDispatcher("admin/editUser.jsp").forward(request, response);*/
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doGet(request,response);
}
}
public class ServletEditScore extends HttpServlet{
private Score score;
private ServletFindAllScore servletFindAllScore=new ServletFindAllScore();
private ScoreServiceImpl scoreServiceImpl=new ScoreServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int scoreID = Integer.parseInt(request.getParameter("scoreID"));
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String stuClass = request.getParameter("stuClass");
String courseName = request.getParameter("courseName");
double scoreGrade=Double.parseDouble(request.getParameter("scoreGrade"));
String major = request.getParameter("major");
score=new Score(scoreID,stuNum,stuName,stuClass,courseName,scoreGrade,major);
int rs=scoreServiceImpl.editCos(score);
if(rs>0){
request.setAttribute("msg", "修改成功??！");
servletFindAllScore.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "修改失?。?！");
request.getRequestDispatcher("admin/editScore.jsp").forward(request, response);
}
String major = request.getParameter("major");
String department = request.getParameter("department");
String phone = request.getParameter("phone");
int roleID = Integer.parseInt(request.getParameter("role"));
user = new User(stuNum, stuName, pwd, phone, roleID);
student = new Student(stuNum, stuName, stuSex, stuAge, stuClass, major,
department);
int rsUser=userServiceImpl.addUser(user);
int rsStu=studentServiceImpl.addStu(student);
if(rsStu>0 && rsUser>0){
request.setAttribute("massage", "注冊(cè)成功??！");
request.getRequestDispatcher("login/login.jsp").forward(request, response);
}else{
request.setAttribute("msg", "注冊(cè)失敗??！");
request.getRequestDispatcher("register/register.jsp").forward(request, response);
}
}
}
public class ServletaddScore extends HttpServlet{
private Score score;
private ServletFindAllScore servletFindAllScore=new ServletFindAllScore();
private ScoreServiceImpl scoreServiceImpl=new ScoreServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String stuClass = request.getParameter("stuClass");
String courseName = request.getParameter("courseName");
double scoreGrade=Double.parseDouble(request.getParameter("scoreGrade"));
}
}else{
/**
* 處理文件名，上傳后的文件是以u(píng)uid_文件名的形式去重新命名的，去除文件名的uuid_部分
file.getName().indexOf("_")檢索字符串中第一次出現(xiàn)"_"字符的位置，
如果文件名類似于：9349249849-88343-8344_阿_凡_達(dá).avi
那么file.getName().substring(file.getName().indexOf("_")+1)
處理之后就可以得到阿_凡_達(dá).avi部分
*/
String realName=file.getName().substring(file.getName().indexOf("_")+1);
//file.getName()得到的是文件的原始名稱，這個(gè)名稱是唯一的，因此可以作為key，realName是處理過(guò)后的名稱，有可能會(huì)重復(fù)
fileNameMap.put(file.getName(), realName);
}
}
}
public class ServletaddCourse extends HttpServlet{
private Course course;
private ServletFindAllCos servletFindAllCos=new ServletFindAllCos();
private CourseServiceImpl courseServiceImpl=new CourseServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String courseName = request.getParameter("courseName");
// item.delete();
message = "文件上傳成功！";
}
}
} catch (FileUploadBase.FileSizeLimitExceededException e) {
e.printStackTrace();
request.setAttribute("message", "單個(gè)文件超出最大值！??！");
request.getRequestDispatcher("admin/fileLoadFail.jsp").forward(
request, response);
return;
// e.printStackTrace();
} catch (FileUploadBase.SizeLimitExceededException e) {
e.printStackTrace();
request.setAttribute("message", "上傳文件的總的大小超出限制的最大值?。?！");
request.getRequestDispatcher("admin/fileLoadFail.jsp").forward(
request, response);
return;
} catch (Exception e) {
message = "文件上傳失??！";
e.printStackTrace();
}
request.setAttribute("message", message);
request.getRequestDispatcher("admin/fileLoadFail.jsp").forward(
request, response);
}
private String makePath(String saveFileName, String savePath) {
// 得到文件名的hashCode的值，得到的就是fileName這個(gè)字符串對(duì)象在內(nèi)存中的地址
int hashCode = saveFileName.hashCode();
int dir1 = hashCode & 0xf; // 0-15
int dir2 = (hashCode & 0xf0) >> 4; // 0-15
// 構(gòu)造信息的保存目錄
String dir = savePath + "\\" + dir1 + "\\" + dir2;
// file既可以代表文件也可以代表目錄
File file = new File(dir);
// 如果目錄不存在
if (!file.exists()) {
// 創(chuàng)建目錄
file.mkdirs();
}
return dir;
}
private ScoreServiceImpl scoreServiceImpl=new ScoreServiceImpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int pageNo=1;
int pageCount=1;
String pageNoStr=request.getParameter("pageNo");
String pageCountStr=request.getParameter("pageCount");
if(pageNoStr!=null){
pageNo=Integer.parseInt(pageNoStr);
}
if(pageCountStr!=null){
pageCount=Integer.parseInt(pageCountStr);
}
String stuNum=request.getParameter("stuNum");
String courseName=request.getParameter("cosName");
String stuName=request.getParameter("stuName");
String stuClass=request.getParameter("stuClass");
String major=request.getParameter("major");
/*if(stuNum==""){
stuNum=null;
}
if(courseName==""){
courseName=null;
}
if(stuName==""){
stuName=null;
}
if(stuClass==""){
stuClass=null;
}
if(major==""){
String dir = savePath + "\\" + dir1 + "\\" + dir2;
// file既可以代表文件也可以代表目錄
File file = new File(dir);
// 如果目錄不存在
if (!file.exists()) {
// 創(chuàng)建目錄
file.mkdirs();
}
return dir;
}
private String makeFileName(String fileName) {
// 為防止文件覆蓋的現(xiàn)象發(fā)生，要為上傳文件產(chǎn)生一個(gè)唯一的文件名
return UUID.randomUUID().toString() + "_" + fileName;
}
}
public class ServletDownloadFile extends HttpServlet{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
/*request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");*/
private ScoreServiceImpl scoreServiceImpl=new ScoreServiceImpl();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
int scoreID = Integer.parseInt(request.getParameter("scoreID"));
String stuNum = request.getParameter("stuNum");
String stuName = request.getParameter("stuName");
String stuClass = request.getParameter("stuClass");
String courseName = request.getParameter("courseName");
double scoreGrade=Double.parseDouble(request.getParameter("scoreGrade"));
String major = request.getParameter("major");
score=new Score(scoreID,stuNum,stuName,stuClass,courseName,scoreGrade,major);
int rs=scoreServiceImpl.editCos(score);
if(rs>0){
request.setAttribute("msg", "修改成功?。?);
servletFindAllScore.doGet(request, response);
// request.getRequestDispatcher("admin/addCourse.jsp").forward(request, response);
}else{
request.setAttribute("msg", "修改失?。。?);
request.getRequestDispatcher("admin/editScore.jsp").forward(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-785841.html
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-785841.html
到了這里，關(guān)于基于javaweb+mysql的jsp+servlet學(xué)生成績(jī)管理系統(tǒng)(管理員、教師、學(xué)生)(java+jsp+servlet+javabean+mysql+tomcat)的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
