一个简单的javaweb小项目(适合新手上手)_javaweb项目案例

• @Version: 1.0
• @Description:
  */
  public class ManageDaoImpl implements ManageDao{
  @Override
  public List getAllPerson() {
  String sql = “select * from person where userIdentify != 2”;
  return getAPerson(sql);
  }

@Override
public List getAllTask(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
task task = new task();
task.setTask(resultSet.getString(“taskAccount”));
task.setTaskDate(resultSet.getString(“taskDate”));
task.setTaskName(resultSet.getString(“taskName”));
task.setTeacherAccount(resultSet.getString(“teacherAccount”));
personLsit.add(task);
}
DBUtils.ClearAll(connection,preparedStatement,resultSet);

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return personLsit;
}

private List getAPerson(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
Person person = new Person();
person.setUserName(resultSet.getString(“userName”));
person.setUserSex(resultSet.getString(“userSex”));
person.setUserIdCard(resultSet.getString(“userIdCard”));
person.setUserOtherName(resultSet.getString(“userOtherName”));
person.setUserIdentify(resultSet.getInt(“userIdentify”));
person.setUserAccount(resultSet.getString(“userAccount”));
person.setUserPassword(resultSet.getString(“userPassword”));
person.setUserBirthday(resultSet.getString(“userBirthday”));
personLsit.add(person);
}

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return personLsit;
}
}

package com.Dao;

import com.DBUtiles.DBUtils;
import com.bean.Person;
import com.bean.studentTask;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.Dao
• @FileName: registerDaoImpl
• @Author: 峰。
• @Date: 2023/8/24-18:16
• @Version: 1.0
• @Description:
  */
  public class registerDaoImpl implements registerDao {
  @Override
  public int addUser(String sql) {
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  int res = 0;
  List personLsit = new ArrayList<>();
  try {
  connection = DBUtils.getConnection();
  preparedStatement = connection.prepareStatement(sql);
  res = preparedStatement.executeUpdate(sql);

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
if (res == 1) {
System.out.println(“添加成功”);
return res;
} else {
System.out.println(“添加失败”);
return res;
}
}
}

package com.Dao;

import com.DBUtiles.DBUtils;
import com.bean.Person;
import com.bean.studentTask;
import com.bean.task;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.Dao
• @FileName: StudentDaoImpl
• @Author: 峰。
• @Date: 2023/8/22-20:11
• @Version: 1.0
• @Description:
  */
  public class StudentDaoImpl implements StudentDao{
  @Override
  public List getStudentList(String sql) {
  Connection connection = null;
  PreparedStatement preparedStatement = null;
  ResultSet resultSet = null;
  List personLsit = new ArrayList<>();
  try {
  connection = DBUtils.getConnection();
  preparedStatement = connection.prepareStatement(sql);
  resultSet = preparedStatement.executeQuery();
  while(resultSet.next()){
  Person person = new Person();
  person.setUserName(resultSet.getString(“userName”));
  person.setUserSex(resultSet.getString(“userSex”));
  person.setUserIdCard(resultSet.getString(“userIdCard”));
  person.setUserOtherName(resultSet.getString(“userOtherName”));
  person.setUserIdentify(resultSet.getInt(“userIdentify”));
  person.setUserAccount(resultSet.getString(“userAccount”));
  person.setUserPassword(resultSet.getString(“userPassword”));
  person.setUserBirthday(resultSet.getString(“userBirthday”));
  personLsit.add(person);
  }
  DBUtils.ClearAll(connection,preparedStatement,resultSet);

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return personLsit;
}

@Override
public List getAllMyTask(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
task task = new task();
task.setTask(resultSet.getString(“taskAccount”));
task.setTaskDate(resultSet.getString(“taskDate”));
task.setTaskName(resultSet.getString(“taskName”));
task.setTeacherAccount(resultSet.getString(“teacherAccount”));
personLsit.add(task);
}
DBUtils.ClearAll(connection,preparedStatement,resultSet);

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return personLsit;
}

@Override
public List getTaskDetail(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
studentTask st = new studentTask();
st.setIsFinish(resultSet.getInt(“isFinish”));
st.setScore(resultSet.getInt(“Score”));
st.setStudentAccount(resultSet.getString(“StudentAccount”));
st.setTaskAccount(resultSet.getString(“taskAccount”));
st.setStudentName(resultSet.getString(“userName”));
st.setStudentAnswer(resultSet.getString(“studentAnswer”));
personLsit.add(st);
}
DBUtils.ClearAll(connection,preparedStatement,resultSet);
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}

return personLsit;
}

@Override
public int upScore(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
int res = 0;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
res = preparedStatement.executeUpdate();
DBUtils.ClearAll(connection,preparedStatement,resultSet);
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}

return res;
}

@Override
public List getMySelf(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
Person person = new Person();
person.setUserName(resultSet.getString(“userName”));
person.setUserSex(resultSet.getString(“userSex”));
person.setUserIdCard(resultSet.getString(“userIdCard”));
person.setUserOtherName(resultSet.getString(“userOtherName”));
person.setUserIdentify(resultSet.getInt(“userIdentify”));
person.setUserAccount(resultSet.getString(“userAccount”));
person.setUserPassword(resultSet.getString(“userPassword”));
person.setUserBirthday(resultSet.getString(“userBirthday”));
personLsit.add(person);
}
DBUtils.ClearAll(connection,preparedStatement,resultSet);

} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return personLsit;
}

@Override
public void upAnswer(String sql) {
upScore(sql);
}

@Override
public List getStuTask(String sql) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List personLsit = new ArrayList<>();
try {
connection = DBUtils.getConnection();
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
while(resultSet.next()){
studentTask st = new studentTask();
st.setIsFinish(resultSet.getInt(“isFinish”));
st.setScore(resultSet.getInt(“Score”));
st.setStudentAccount(resultSet.getString(“StudentAccount”));
st.setTaskAccount(resultSet.getString(“taskAccount”));
st.setStudentAnswer(resultSet.getString(“studentAnswer”));
personLsit.add(st);
}
DBUtils.ClearAll(connection,preparedStatement,resultSet);
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} catch (SQLException e) {
throw new RuntimeException(e);
}

return personLsit;
}
}

数据库连接工具:

package com.DBUtiles;

import java.sql.*;

/**

• @BelongsProject: Tab8
• @BelongsPackage: com.JDBCConnect.www
• @FileName: DBUtils
• @Author: 峰。
• @Date: 2023/5/9-23:27
• @Version: 1.0
• @Description: JDBC工具类,两个方法，1)获取连接，2)释放资源
  */
  public class DBUtils {
  //1)建立连接
  public static Connection getConnection() throws ClassNotFoundException, SQLException {
  Class.forName(“com.mysql.cj.jdbc.Driver”);
  String url = “jdbc:mysql://localhost:3306/db_it1?useSSL=false”;
  String user = “root”;
  String password = “wbf”;
  Connection connection = (Connection) DriverManager.getConnection(url, user, password);
  System.out.println(“数据库连接成功~”);
  return connection;
  }

//2)释放资源
public static void ClearAll(Connection connection, Statement statement, ResultSet resultSet) throws SQLException {
//空值不能关闭 先开后关
if (resultSet!=null){
resultSet.close();
}
if (statement!=null){
statement.close();
}
if (connection!=null){
connection.close();
}
}
}

业务逻辑层(此处省略了接口):

package com.service;

import com.Dao.commonDao;
import com.Dao.commonDaoImpl;
import com.bean.Person;
import com.bean.studentTask;
import com.bean.task;

import java.util.List;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.service
• @FileName: commonServiceImpl
• @Author: 峰。
• @Date: 2023/8/26-14:33
• @Version: 1.0
• @Description:
  */
  public class commonServiceImpl implements commonService{
  commonDao cd = new commonDaoImpl();
  @Override
  public void deletePerson(String userAccount) {
  String sql = “delete from person where userAccount = '”+userAccount+“'”;
  cd.deletePerson(sql);
  }

@Override
public List getAllTea() {
String sql = “select * from person where userIdentify = 0”;
return cd.getAllTea(sql);
}

@Override
public void selectPash(String userAccount, String Account) {
String sql = “insert into userteacher(userAccount,teacherAccount) values('”+Account+“‘,’”+userAccount+“')”;
cd.selectTea(sql);
}

@Override
public List selectTaskDetail(String taskAccount) {
String sql = “select * from studenttask where taskAccount = “+taskAccount+””;
return cd.getMyTask(sql);
}

}

package com.service;

import com.Dao.ManageDao;
import com.Dao.ManageDaoImpl;
import com.bean.Person;
import com.bean.task;

import java.util.List;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.service
• @FileName: ManageServiceImpl
• @Author: 峰。
• @Date: 2023/8/22-20:04
• @Version: 1.0
• @Description:
  */
  public class ManageServiceImpl implements ManageService{

ManageDao md = new ManageDaoImpl();
@Override
public List getAllPerson() {

return md.getAllPerson();
}

@Override
public List getAllTask() {
String sql = “select * from task”;
return md.getAllTask(sql);
}
}

package com.service;

import com.Dao.registerDao;
import com.Dao.registerDaoImpl;
import com.bean.Person;

import java.util.Random;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.service
• @FileName: registerServiceImpl
• @Author: 峰。
• @Date: 2023/8/24-18:16
• @Version: 1.0
• @Description:
  */
  public class registerServiceImpl implements registerService{
  registerDao rd = new registerDaoImpl();
  @Override
  public int addUser(Person person) {
  person.setUserIdCard(RandomIdCard());
  String sql = “insert into person (userAccount,userBirthday,userIdCard,userIdentify,userName,userOtherName,userPassword,userSex) \n” +
  “values ('”+person.getUserAccount()+“‘,’”+person.getUserBirthday()+“‘,’”+person.getUserIdCard()+“',” +
  “”+person.getUserIdentify()+“,'”+person.getUserName()+“‘,’”+person.getUserOtherName()+“‘,’”+person.getUserPassword()+“'” +
  “,'”+person.getUserSex()+“')”;
  return rd.addUser(sql);
  }

public String RandomIdCard(){
Random random = new Random();
String idcard = “”;
for (int i = 0 ;i<9;i++) {
String randomNumber = String.valueOf(random.nextInt(10));
System.out.println("随机数: " + randomNumber);
idcard = idcard+randomNumber;
}
System.out.println(idcard);
return idcard;
}
}

package com.service;

import com.Dao.StudentDao;
import com.Dao.StudentDaoImpl;
import com.bean.Person;
import com.bean.studentTask;
import com.bean.task;

import java.util.List;

/**

• @BelongsProject: MUST3
• @BelongsPackage: com.service
• @FileName: StudentServiceImpl
• @Author: 峰。
• @Date: 2023/8/22-20:03
• @Version: 1.0
• @Description:
  */
  public class StudentServiceImpl implements StudentService{
  StudentDao sd = new StudentDaoImpl();
  @Override
  public List getAllStudent(String userAccount) {
  String sql = “select * from person where userAccount in (select userAccount from userteacher where teacherAccount = '”+userAccount+“')”;
  return sd.getStudentList(sql);
  }

@Override
public List getAllMyTask(String userAccount) {
String sql = “select * from task where teacherAccount = '”+userAccount+“'”;
return sd.getAllMyTask(sql);
}

public List getAllStuTask(String userAccount) {
String sql = “select * from studenttask where studentAccount = '”+userAccount+“'”;
return sd.getStuTask(sql);
}
@Override
public List getTaskDetail(String taskAccount) {
String sql = “select * from studenttask,person where studenttask.studentAccount=person.userAccount and taskAccount='”+taskAccount+“';”;
return sd.getTaskDetail(sql);
}

@Override
public int upScore(int upScore, String taskAccount) {
String sql = “update studenttask set Score = “+upScore+” where taskAccount = '”+taskAccount+“';”;

return sd.upScore(sql);
}

@Override
public int DelTask(String taskAccount) {
String sql = “delete from studenttask where taskAccount = '”+taskAccount+“'”;
String sql1 = “delete from task where taskAccount = '”+taskAccount+“'”;
sd.upScore(sql);
sd.upScore(sql1);
return 0;
}

@Override
public void upName(String upName,String userName) {
String sql = “update person set userName = '”+upName+“’ where userAccount = '”+userName+“'”;
sd.upScore(sql);
}

@Override
public void upSex(String upSex,String userName) {
String sql = “update person set userSex = '”+upSex+“’ where userAccount = '”+userName+“'”;
sd.upScore(sql);
}

@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
• @Description:
  */
  @WebServlet(“/regServlet”)
  public class regServlet extends HttpServlet {
  @Override
  protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  req.setCharacterEncoding(“UTF-8”);
  registerService rs = new registerServiceImpl();
  Person person = new Person();
  person.setUserAccount(req.getParameter(“userAccount”));
  person.setUserPassword(req.getParameter(“userPassword”));
  person.setUserBirthday(req.getParameter(“userBirthday”));
  person.setUserIdentify(1);
  person.setUserName(req.getParameter(“userName”));
  person.setUserSex(req.getParameter(“userSex”));
  person.setUserOtherName(req.getParameter(“userOtherName”));
  System.out.println(person.toString());
  int bool = rs.addUser(person);
  if (bool == 1){
  req.getRequestDispatcher(“UserLogin.jsp”).forward(req,resp);
  }else {
  req.setAttribute(“registerFalse”,“注册失败”);
  req.getRequestDispatcher(“UserLogin.jsp”).forward(req,resp);
  }
  }
  }

package com.stu;

import com.bean.Person;
import com.bean.studentTask;
import com.bean.task;
import com.service.StudentService;
import com.service.StudentServiceImpl;

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: TeacherServlet
• @Author: 峰。
• @Date: 2023/8/22-19:59
• @Version: 1.0
• @Description:
  */
  @WebServlet(“/tea.action”)
  public class TeacherServlet extends HttpServlet {
  @Override
  protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  req.setCharacterEncoding(“UTF-8”);
  String action = req.getParameter(“action”);
  StudentService ss = new StudentServiceImpl();
  // Person session_person = (Person) req.getAttribute(“session_person”);直接获取拿不到person对象,需要通过session获取
  Person session_person = (Person) req.getSession().getAttribute(“session_person”);
  if (action.equals(“list”)){
  List personList = ss.getAllStudent(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(“goMyTask”)) {
  List taskList = ss.getAllMyTask(session_person.getUserAccount());
  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);

} else if (action.equals(“goSkimDetail”)) {
//查看任务
String taskAccount = req.getParameter(“taskAccount”);
List taskList= ss.getTaskDetail(taskAccount);
req.setAttribute(“arr”,taskList);
req.setAttribute(“mainRight”,“studentTask.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“myThing”)) {
List personList = ss.getMySelf(session_person.getUserAccount());
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“SelfThing.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upScoree”)) {
String taskAccount = req.getParameter(“taskAccount”);
int upScore = Integer.parseInt(req.getParameter(“Score”));
int res = ss.upScore(upScore,taskAccount);
if (res == 1){
List taskList= ss.getTaskDetail(taskAccount);
req.setAttribute(“arr”,taskList);
req.setAttribute(“mainRight”,“studentTask.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}
} else if (action.equals(“upScore”)) {
String taskAccount = req.getParameter(“taskAccount”);
List taskList= ss.getTaskDetail(taskAccount);
req.setAttribute(“arr”,taskList);
req.setAttribute(“mainRight”,“upScore.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“Del”)) {
String taskAccount = req.getParameter(“taskAccount”);
int res = ss.DelTask(taskAccount);
List taskList = ss.getAllMyTask(session_person.getUserAccount());
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);
} else if (action.equals(“upSelf”)) {
Person p = (Person) req.getSession().getAttribute(“session_person”);
List personList= new ArrayList<>();
personList.add§;
req.setAttribute(“arr”,personList);
req.setAttribute(“mainRight”,“upSelf.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upSelfName”)) {
System.out.println(“111”);
String upName = req.getParameter(“userName”);
String userAccount = req.getParameter(“userAccount”);
System.out.println(upName);
ss.upName(upName,userAccount);
List p = ss.getMySelf(userAccount);
req.setAttribute(“arr”,p);
req.setAttribute(“mainRight”,“upSelf.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upSelfSex”)) {

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”,“upSelf.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
} else if (action.equals(“upSelfBirthday”)) {

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”,“upSelf.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else if (action.equals(“upSelfOtherName”)){

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”,“upSelf.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}
}
}

package com.stu;

import com.Dao.TestDAO;
import com.bean.Person;
import com.service.UserLoginService;
import com.service.UserLoginServiceImpl;

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: MSTU1
• @BelongsPackage: com.stu
• @FileName: UserLoginServlet
• @Author: 峰。
• @Date: 2023/8/20-19:25
• @Version: 1.0
• @Description:
  */
  @WebServlet(“/UserLogin”)
  public class UserLoginServlet extends HttpServlet {
  @Override
  protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  // System.out.println(“进来了”);
  //1.拿到前端传递过来的信息，比方说用户名和密码
  String username = req.getParameter(“userAccount”);
  String password = req.getParameter(“userPassword”);
  Person person = new Person(username,password);
  // Person person1 = TestDAO.Login(person);
  UserLoginService uls = new UserLoginServiceImpl();
  Person person1 = uls.getLogin(person);
  // if (username.equals(“admin”) && password.equals(“word”)){
  if (username.equals(person1.getUserAccount())&&password.equals(person1.getUserPassword())){
  // 进入主页面
  System.out.println(person1);

req.getSession().setAttribute(“session_person”,person1);//默认保存30分钟
// req.setAttribute(“person”,person1);
req.setAttribute(“mainRight”,“blank.jsp”);
req.getRequestDispatcher(“main.jsp”).forward(req,resp);
}else {
// 否则，跳回登录界面
req.setAttribute(“tip”,“账户密码错误”);
req.getRequestDispatcher(“UserLogin.jsp”).forward(req,resp);//转跳回界面
}
}
}

数据库连接信息:

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_it1
user=root
password=wbf

静态页面(其中用到的一些图片需要自己提供）：

<%–
Created by IntelliJ IDEA.
User: 峰。
Date: 2023/8/21
Time: 19:14
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

欢迎来到此系统

<%–
Created by IntelliJ IDEA.
User: 峰。
Date: 2023/8/23
Time: 15:19
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

table td{
height: 60px;
vertical-align: middle!important; /设置文字垂直居中/
text-align: center;
}

tr,td{border-right:1px solid #888;border-bottom:1px solid #888;padding:5px 15px;}

th{font-weight:bold;background:#ccc;}

.con-b .row .lf{
width: 15%;
text-align: center;
padding: 10px;
}
.con-b .row .rg{
width: 85%;
}

.con-b tr:nth-of-type(odd){
background-color: #f2f2f2;
}
#ee{
width: 73px;
height: 44px;
}

<%@taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>

任务账户	任务名称	任务时间	查看详细

<%-- 删除–%>
<%-- 修改–%>

${task.getTask()} ${task.getTaskName()} ${task.getTaskDate()} <%-- ${person.getUserIdCard()}--%> <%-- --%> <%-- 学生--%> <%-- 老师--%> <%-- --%> <%-- ${person.getUserOtherName()}--%> <%-- --%> <%-- --%> <%--

<%-- function upThis(userAccount){–%>
<%-- alert(userAccount);–%>
<%-- }–%>
<%––%>

<%–
Created by IntelliJ IDEA.
User: 峰。
Date: 2023/8/18
Time: 13:46
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

<%–
Created by IntelliJ IDEA.
User: 峰。
Date: 2023/8/20
Time: 21:39
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

#daohang{
width: 200px;
height: 320px;
border: grey 1px solid;
float: left;
}

#file{
width: 180px;
height: 50px;
margin-left: 10px;
margin-top: 10px;
border: grey 1px solid;
background-color: antiquewhite;
}
a{
color: black;
font-size: 26px;
margin-left: 15px;
margin-top: 15px;
}

<%@taglib prefix=“c” uri=“http://java.sun.com/jsp/jstl/core” %>

当前用户:${session_person.userName} <%-- 修改密码--%>

<c:if test=“${session_person.getUserIdentify()==0}”>

• 查看首页
• <%-- 回到首页的动作--%>
• 学生管理
• 任务管理
• 我的信息
• 退出系统

• <c:if test=“${session_person.getUserIdentify()==1}”>

• 查看首页
• 选择老师
• 我的任务
• 我的信息
• 退出系统

• <c:if test=“${session_person.getUserIdentify()==2}”>

• 查看首页
• 人员管理
• 任务管理
• 我的信息
• 退出系统
• <%--
  --%>

  <jsp:include page=“$mainRight=null{?}^{\prime }blank.js{p}^{\prime }:mainRight"></jsp:include><${downJSP = null ;downJSP}”></jsp:include>–%>
  <%–mainRight是从后端传过来的数据值–%>

  <%–
  Created by IntelliJ IDEA.
  User: 峰。
  Date: 2023/8/22
  Time: 19:57
  To change this template use File | Settings | File Templates.
  –%>
  <%–
  Created by IntelliJ IDEA.
  User: 30890
  Date: 2023/4/17
  Time: 9:47
  To change this template use File | Settings | File Templates.
  –%>
  <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

  table td{
  height: 60px;
  vertical-align: middle!important; /设置文字垂直居中/
  text-align: center;
  }

  tr,td{border-right:1px solid #888;border-bottom:1px solid #888;padding:5px 15px;}

  th{font-weight:bold;background:#ccc;}

  .con-b .row .lf{
  width: 15%;
  text-align: center;
  padding: 10px;
  }
  .con-b .row .rg{
  width: 85%;
  }

  .con-b tr:nth-of-type(odd){
  background-color: #f2f2f2;
  }
  #ee{
  width: 73px;
  height: 44px;
  }

  <%@taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>

  账户	姓名	性别	生日	身份证号码	角色	其他名称	删除	修改

  ${person.getUserAccount()} ${person.getUserName()} ${person.getUserSex()} ${person.getUserBirthday()} ${person.getUserIdCard()} 老师 学生 管理员 ${person.getUserOtherName()}

  function upThis(userAccount){
  window.location.href=“common.action?action=upStudent&student=”+userAccount;
  }
  

  <%–
  Created by IntelliJ IDEA.
  User: 峰。
  Date: 2023/8/24
  Time: 17:48
  To change this template use File | Settings | File Templates.
  –%>
  <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

  #innerLoginFrame{
  width: 360px;
  /border: grey 2px solid;/
  margin-left: 80px;
  margin-top: 50px;
  height: 250px;
  color: grey;
  font-size: 25px;
  }
  input{
  width: 220px;
  height: 30px;
  }
  

  <%-- --%>

  注 册 账 号

  账户:
  
  姓名:
  
  密码:
  
  性别:
  
  生日:
  
  别称:
  
  
  

  <%–
  Created by IntelliJ IDEA.
  User: 峰。
  Date: 2023/8/23
  Time: 18:37
  To change this template use File | Settings | File Templates.
  –%>
  <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

  table td{
  height: 60px;
  vertical-align: middle!important; /设置文字垂直居中/
  text-align: center;
  }

  tr,td{border-right:1px solid #888;border-bottom:1px solid #888;padding:5px 15px;}

  th{font-weight:bold;background:#ccc;}

  .con-b .row .lf{
  width: 15%;
  text-align: center;
  padding: 10px;
  }
  .con-b .row .rg{
  width: 85%;
  }

  .con-b tr:nth-of-type(odd){
  background-color: #f2f2f2;
  }
  #ee{
  width: 73px;
  height: 44px;
  }

  <%@taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>

  账户	姓名	性别	生日	身份证号码	角色	其他名称	修改

  ${person.getUserAccount()} ${person.getUserName()} ${person.getUserSex()} ${person.getUserBirthday()} ${person.getUserIdCard()} 学生 老师 管理员 ${person.getUserOtherName()}

  <%–
  Created by IntelliJ IDEA.
  User: 峰。
  Date: 2023/8/23
  Time: 17:14
  To change this template use File | Settings | File Templates.
  –%>
  <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

  自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

  深知大多数大数据工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！

  因此收集整理了一份《2024年大数据全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友。
  
  
  
  
  

  既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上大数据开发知识点，真正体系化！

  由于文件比较大，这里只是将部分目录大纲截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且后续会持续更新

  如果你觉得这些内容对你有帮助，可以添加VX：vip204888 （备注大数据获取）
  

  ${person.getUserBirthday()} ${person.getUserIdCard()} 学生 老师 管理员 ${person.getUserOtherName()}

  <%–
  Created by IntelliJ IDEA.
  User: 峰。
  Date: 2023/8/23
  Time: 17:14
  To change this template use File | Settings | File Templates.
  –%>
  <%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

  自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

  深知大多数大数据工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！

  因此收集整理了一份《2024年大数据全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友。
  [外链图片转存中…(img-aXuO1RIk-1712549751750)]
  [外链图片转存中…(img-F4n0HVJU-1712549751751)]
  [外链图片转存中…(img-TELr6RSp-1712549751751)]
  [外链图片转存中…(img-T7b4W11C-1712549751751)]
  [外链图片转存中…(img-7eh9adH6-1712549751751)]

  既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上大数据开发知识点，真正体系化！

  由于文件比较大，这里只是将部分目录大纲截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且后续会持续更新

  如果你觉得这些内容对你有帮助，可以添加VX：vip204888 （备注大数据获取）
  [外链图片转存中…(img-2nk0VfPw-1712549751752)]