}
@Override
public void upBirthday(String upBirthday,String userName) {
String sql = “update person set userBirthday = '”+upBirthday+“’ where userAccount = '”+userName+“'”;
sd.upScore(sql);
}
@Override
public void upOtherName(String upOtherName,String userName) {
String sql = “update person set userOtherName = '”+upOtherName+“’ where userAccount = '”+userName+“'”;
sd.upScore(sql);
}
@Override
public List getMySelf(String userAccount) {
String sql = “select * from person where userAccount = '”+userAccount+“'”;
return sd.getMySelf(sql);
}
@Override
public List getAllPersonn(String userAccount) {
String sql = “select * from person”;
return sd.getStudentList(sql);
}
@Override
public void upAnswer(String answer,String taskAccount) {
String sql = “update studenttask set studentAnswer = '”+answer+“’ where taskAccount = “+taskAccount+””;
sd.upAnswer(sql);
}
@Override
public List getStuTaskByTask(String taskAccount) {
String sql = “select * from studenttask where taskAccount = '”+taskAccount+“'”;
return sd.getStuTask(sql);
}
}
package com.service;
import com.Dao.TestDAO;
import com.bean.Person;
/**
- @BelongsProject: MSTU1
- @BelongsPackage: com.service
- @FileName: UserLoginServiceImpl
- @Author: 峰。
- @Date: 2023/8/21-20:13
- @Version: 1.0
- @Description:
*/
public class UserLoginServiceImpl implements UserLoginService{
@Override
public Person getLogin(Person person) {
Person person1 = TestDAO.Login(person);
return person1;
}
}
Servlet包:
package com.stu;
import com.bean.Person;
import com.bean.studentTask;
import com.bean.task;
import com.service.StudentService;
import com.service.StudentServiceImpl;
import com.service.commonService;
import com.service.commonServiceImpl;
import javafx.concurrent.Task;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
/**
- @BelongsProject: MUST3
- @BelongsPackage: com.stu
- @FileName: CommonServlet
- @Author: 峰。
- @Date: 2023/8/22-19:51
- @Version: 1.0
- @Description:
*/
@WebServlet(“/common.action”)
public class CommonServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding(“UTF-8”);
String action = req.getParameter(“action”);
commonService sc = new commonServiceImpl();
StudentService ss = new StudentServiceImpl();
if (action.equals(“index”)){
//转跳到首页
req.setAttribute(“mainRight”,“blank.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“myThing”)) {
Person p = (Person) req.getSession().getAttribute(“session_person”);
List personList= new ArrayList<>();
personList.add§;
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“SelfThing.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“deletePerson”)) {
List personList = new ArrayList<>();
String userAccount = req.getParameter(“personAccount”);
sc.deletePerson(userAccount);
Person session_person = (Person) req.getSession().getAttribute(“session_person”);
if (session_person.getUserIdentify() == 0){
personList = ss.getAllStudent(session_person.getUserAccount());
} else if (session_person.getUserIdentify() == 2) {
personList = ss.getAllPersonn(session_person.getUserAccount());
}
//获取学生列表
for (Person p:personList){
System.out.println(p.toString());
}
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“person.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upStudent”)) {
String studentAccount = req.getParameter(“student”);
List personList = ss.getMySelf(studentAccount);
//获取学生列表
for (Person p:personList){
System.out.println(p.toString());
}
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“upPerson.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upPersonName”)) {
String upName = req.getParameter(“userName”);
String userAccount = req.getParameter(“userAccount”);
ss.upName(upName,userAccount);
List p = ss.getMySelf(userAccount);
req.setAttribute(“arr”,p);
req.setAttribute(“mainRight”,“upPerson.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else if (action.equals(“upPersonSex”)) {
String upSex = req.getParameter(“userSex”);
String userAccount = req.getParameter(“userAccount”);
ss.upSex(upSex,userAccount);
List p = ss.getMySelf(userAccount);
req.setAttribute(“arr”,p);
req.setAttribute(“mainRight”,“upPerson.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else if (action.equals(“upPersonBirthday”)) {
String upBirthday = req.getParameter(“userBirthday”);
String userAccount = req.getParameter(“userAccount”);
ss.upBirthday(upBirthday,userAccount);
List p = ss.getMySelf(userAccount);
req.setAttribute(“arr”,p);
req.setAttribute(“mainRight”,“upPerson.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else if (action.equals(“upPersonOtherName”)) {
String upOtherName = req.getParameter(“OtherName”);
String userAccount = req.getParameter(“userAccount”);
ss.upOtherName(upOtherName,userAccount);
List p = ss.getMySelf(userAccount);
req.setAttribute(“arr”,p);
req.setAttribute(“mainRight”,“upPerson.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“list”)) {
Person session_person = (Person) req.getSession().getAttribute(“session_person”);
List personList = ss.getAllPersonn(session_person.getUserAccount());
//获取学生列表
for (Person p:personList){
System.out.println(p.toString());
}
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“person.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“selectTeacher”)) {
Person session_person = (Person) req.getSession().getAttribute(“session_person”);
List teaList = sc.getAllTea();
for (Person p:teaList){
System.out.println(p.toString());
}
req.setAttribute(“arr”,teaList);
req.setAttribute(“mainRight”,“teaList.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“MyTask”)) {
Person session_person = (Person) req.getSession().getAttribute(“session_person”);
String userAccount = session_person.getUserAccount();
List allMyTask = ss.getAllStuTask(userAccount);
for (studentTask t:allMyTask){
System.out.println(t.toString());
}
req.setAttribute(“arr”,allMyTask);
req.setAttribute(“mainRight”,“taskDetail.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“selectPash”)) {
Person session_person = (Person) req.getSession().getAttribute(“session_person”);
String userAccount = req.getParameter(“userAccount”);
sc.selectPash(userAccount,session_person.getUserAccount());
req.setAttribute(“mainRight”,“blank.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“goSkimDetail”)) {
String taskAccount = req.getParameter(“taskAccount”);
List tasks = sc.selectTaskDetail(taskAccount);
req.getSession().setAttribute(“task”,tasks.get(0));
req.setAttribute(“arr”,tasks);
req.setAttribute(“mainRight”,“taskDetail.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upAnswer”)) {
String taskAccount = req.getParameter(“taskAccount”);
List tasks = ss.getStuTaskByTask(taskAccount);
req.setAttribute(“arr”,tasks);
req.setAttribute(“mainRight”,“upAnswer.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“answer”)) {
String answer = req.getParameter(“answer”);
String taskAccount = req.getParameter(“taskAccount”);
ss.upAnswer(answer,taskAccount);
List tasks = ss.getStuTaskByTask(taskAccount);
req.getSession().setAttribute(“task”,tasks.get(0));
req.setAttribute(“arr”,tasks);
req.setAttribute(“mainRight”,“taskDetail.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}
}
}
package com.stu;
import com.bean.Person;
import com.bean.task;
import com.service.ManageService;
import com.service.ManageServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
/**
- @BelongsProject: MUST3
- @BelongsPackage: com.stu
- @FileName: ManageServlet
- @Author: 峰。
- @Date: 2023/8/22-20:00
- @Version: 1.0
- @Description:
*/
@WebServlet(“/man.action”)
public class ManageServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding(“UTF-8”);
String action = req.getParameter(“action”);
ManageService ms = new ManageServiceImpl();
if (action.equals(“list”)){
List personList = ms.getAllPerson();
for (Person p :personList){
System.out.println(p.toString());
}
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“person.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else if (action.equals(“myThing”)) {
Person p = (Person) req.getSession().getAttribute(“session_person”);
List personList= new ArrayList<>();
personList.add§;
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“SelfThing.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“taskList”)) {
Person p = (Person) req.getSession().getAttribute(“session_person”);
List taskList = ms.getAllTask();
for (task t:taskList){
System.out.println(t.toString());
}
req.setAttribute(“arr”,taskList);
req.setAttribute(“mainRight”,“task.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}
}
}
package com.stu;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
/**
- @BelongsProject: MUST3
- @BelongsPackage: com.stu
- @FileName: OutLoginServlet
- @Author: 峰。
- @Date: 2023/8/22-21:18
- @Version: 1.0
- @Description:
*/
@WebServlet(“/outLogin”)
public class OutLoginServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.getSession().getAttribute(“session_person”);
HttpSession session = req.getSession();
session.removeAttribute(“session_person”);
req.getRequestDispatcher(“UserLogin.jsp”).forward(req,resp);
}
}
package com.stu;
import com.bean.Person;
import com.service.registerService;
import com.service.registerServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
/**
- @BelongsProject: MUST3
- @BelongsPackage: com.stu
- @FileName: regServlet
- @Author: 峰。
- @Date: 2023/8/24-18:11
- @Version: 1.0