jsp+servlet campus forum campus bbs (administrator, user) based on javaweb+mysql (java+jsp+servlet+mysql)

jsp + servlet campus forum campus bbs (administrator, user) based on javaweb + mysql (java + jsp + servlet + mysql)

Private message Source code acquisition and debugging communication

Operating environment

Java≥8, MySQL≥5.7, Tomcat≥8

development tools

eclipse/idea/myeclipse/sts, etc. can be configured to run

Be applicable

Course design, major assignments, graduation projects, project exercises, learning demonstrations, etc.

Function Description

Administrator: login, registration, posting, reply, user management, post management, etc.

User: Log in, register, post, reply

user

administrator

technical framework

CSS JavaScript jQuery JSP Servlet JDBC MySQL

JSP + Servlet campus forum campus BBS (administrator, user) based on javaweb + mysql (java + jsp + servlet + mysql)

@SuppressWarnings("serial")
public class ReplyServlet extends HttpServlet{<!-- -->

public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
int fid = Integer.parseInt(request.getParameter("fid"));
int uid = Integer.parseInt(request.getParameter("uid"));
String replyContent = request.getParameter("content");
\t
ForumEntity forum = new ForumEntity();
forum.setFid(fid);
\t
UserEntity user = new UserEntity();
user.setUser_id(uid);
\t\t
ReplyEntity reply = new ReplyEntity();
reply.setForum(forum);
reply.setUser(user);
reply.setContent(replyContent);
reply.setReplyTime(new java.sql.Timestamp(new java.util.Date().getTime()));

BbsServiceInf service = new BbsServiceImpl();
service.createReply(reply);
\t
response.sendRedirect("replyList?fid=" + fid);
\t\t
}
}

@SuppressWarnings("serial")

}

@SuppressWarnings("serial")
public class FindUserByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String u_id=request.getParameter("uid");
int uid=Integer.parseInt(u_id);
\t\t
UserServiceInf service=new UserServiceImpl();
UserEntity user=service.findUser(uid);
request.setAttribute("user",user);
\t\t
request.getRequestDispatcher("userinfo.jsp").forward(request, response);
\t\t
\t\t
}

}

@SuppressWarnings("serial")
public class MdeleteUserForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{<!-- -->

\t\t
String forumid=request.getParameter("fid");
int fid=Integer.parseInt(forumid);
String uid=request.getParameter("uid");
\t\t\t\t
BbsServiceInf service=new BbsServiceImpl();

 request.getRequestDispatcher("page/tourist/userinfo.jsp").forward(request, response);
\t\t
\t\t
}
}

@SuppressWarnings("serial")
public class FindUserByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String u_id=request.getParameter("uid");
int uid=Integer.parseInt(u_id);
\t\t
UserServiceInf service=new UserServiceImpl();
UserEntity user=service.findUser(uid);
request.setAttribute("user",user);
\t\t
request.getRequestDispatcher("userinfo.jsp").forward(request, response);
\t\t
\t\t
}

}

@SuppressWarnings("serial")

 e.printStackTrace();
}
\t\t
}
}

@SuppressWarnings("serial")
public class UPersonDeleteForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{<!-- -->
\t\t
\t\t
// PrintWriter out=response.getWriter();
// out.println(forumid);
\t\t
\t\t
String forumid=request.getParameter("fid");
int fid=Integer.parseInt(forumid);
String uid=request.getParameter("uid");
\t\t
// int userid=Integer.parseInt(uid);
// out.println(userid);
\t\t
BbsServiceInf service=new BbsServiceImpl();
service.deleteReplyByFid(fid);
service.deleteForumByFid(fid);
\t\t
\t\t
\t\t
     request.setAttribute("uid", uid);
request.getRequestDispatcher("UPersonForumList").forward(request, response);
}
}

@SuppressWarnings("serial")
public class FindUserByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String u_id=request.getParameter("uid");
int uid=Integer.parseInt(u_id);
\t\t
UserServiceInf service=new UserServiceImpl();
UserEntity user=service.findUser(uid);
request.setAttribute("user",user);
\t\t
request.getRequestDispatcher("userinfo.jsp").forward(request, response);
\t\t
\t\t
}

}

@SuppressWarnings("serial")
public class MdeleteUserForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{<!-- -->

\t\t
String forumid=request.getParameter("fid");
int fid=Integer.parseInt(forumid);
String uid=request.getParameter("uid");
\t\t\t\t
BbsServiceInf service=new BbsServiceImpl();
service.deleteReplyByFid(fid);
service.deleteForumByFid(fid);
\t
     request.setAttribute("uid", uid);

 request.setAttribute("uid", uid);
request.getRequestDispatcher("MSeeUserForum").forward(request, response);
}
}

@SuppressWarnings("serial")
public class UserInfoServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
String userid=request.getParameter("uid");
int user_id=Integer.parseInt(userid);
UserServiceInf service=new UserServiceImpl();
UserEntity userinfo=service.findUser(user_id);
\t\t\t\t\t
request.setAttribute("userinfo", userinfo);
request.getRequestDispatcher("page/user/individualinfo.jsp").forward(request, response);
\t\t
}
}

@SuppressWarnings("serial")
public class TouristFindReplyServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)

String userid = request.getParameter("user_id");
int user_id=Integer.parseInt(userid);
String user_name = request.getParameter("user_name");
String user_password = request.getParameter("md5Pwd");
String user_sex = request.getParameter("user_sex");
String user_face = request.getParameter("user_face");
String user_phone = request.getParameter("user_phone");
String user_email = request.getParameter("user_email");
String user_from = request.getParameter("user_from");
\t\t \t\t\t\t 
UserEntity user = new UserEntity();
user.setUser_id(user_id);
\t\t 
user.setUser_name(user_name);
user.setUser_password(user_password);
user.setUser_sex(user_sex);
user.setUser_face(user_face);
user.setUser_phone(user_phone);
user.setUser_email(user_email);
user.setUser_from(user_from);
\t\t 
UserServiceInf service = new UserServiceImpl();
service.saveUser(user);
\t\t \t\t 
//PrintWriter out=response.getWriter();
\t\t 
response.sendRedirect("login.jsp");
//out.print("<a href='login.jsp'>Registration successful, please return to the login interface</a>");
\t\t 
}
}

 BbsServiceInf service = new BbsServiceImpl();
//Query all replies
ForumEntity forum = service.findReplyList(fid);
request.setAttribute("forum", forum);
request.getRequestDispatcher("page/user/preplyinfo.jsp").forward(request, response);
}
\t\t
\t\t
\t\t
}
}

@SuppressWarnings("serial")
public class ReplyServlet extends HttpServlet{<!-- -->

public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
int fid = Integer.parseInt(request.getParameter("fid"));
int uid = Integer.parseInt(request.getParameter("uid"));
String replyContent = request.getParameter("content");
\t
ForumEntity forum = new ForumEntity();
forum.setFid(fid);
\t
UserEntity user = new UserEntity();
user.setUser_id(uid);
\t\t
ReplyEntity reply = new ReplyEntity();
reply.setForum(forum);
reply.setUser(user);
reply.setContent(replyContent);
reply.setReplyTime(new java.sql.Timestamp(new java.util.Date().getTime()));

@SuppressWarnings("serial")
public class MSeeUserForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response){<!-- -->
String user_id=request.getParameter("uid");
int uid=Integer.parseInt(user_id);
\t\t
BbsServiceInf service=new BbsServiceImpl();
List<ForumEntity> forumlist=service.seeUserForumList(uid);
\t
\t\t
try {<!-- -->
request.setAttribute("forum",forumlist);
request.getRequestDispatcher("page/manager/userforumlist.jsp").forward(request, response);
} catch (ServletException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
\t\t
}
}

@SuppressWarnings("serial")
public class UPersonDeleteForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{<!-- -->
\t\t
\t\t
// PrintWriter out=response.getWriter();
// out.println(forumid);
\t\t
\t\t
String forumid=request.getParameter("fid");
int fid=Integer.parseInt(forumid);
String uid=request.getParameter("uid");
\t\t
// int userid=Integer.parseInt(uid);

@SuppressWarnings("serial")
public class TouristFindUserByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
\t\t
request.setCharacterEncoding("utf-8");
String u_id=request.getParameter("uid");
int uid=Integer.parseInt(u_id);
\t\t
UserServiceInf service=new UserServiceImpl();
UserEntity user=service.findUser(uid);
request.setAttribute("user",user);
\t\t
request.getRequestDispatcher("page/tourist/userinfo.jsp").forward(request, response);
\t\t
\t\t
}
}

@SuppressWarnings("serial")
public class FindUserByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String u_id=request.getParameter("uid");
int uid=Integer.parseInt(u_id);
\t\t
UserServiceInf service=new UserServiceImpl();
UserEntity user=service.findUser(uid);

\t\t
\t\t
     request.setAttribute("uid", uid);
request.getRequestDispatcher("UPersonForumList").forward(request, response);
}
}

@SuppressWarnings("serial")
public class MDeleteUserInfoServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
\t\t
String userid=request.getParameter("uid");
int user_id=Integer.parseInt(userid);
\t
BbsServiceInf bbs=new BbsServiceImpl();
\t\t
\t\t
bbs.dUserAllreplyByUid(user_id);
\t\t
bbs.dUserOtherRelyByFid(user_id);
\t\t
bbs.dUserAllForumByUid(user_id);
\t\t\t
UserServiceInf service=new UserServiceImpl();
service.deleteUser(user_id);
\t\t
\t\t
\t\t
response.sendRedirect("MUserList");
}
}

@SuppressWarnings("serial")
public class UPersonDeleteForumServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{<!-- -->
\t\t
\t\t
// PrintWriter out=response.getWriter();
// out.println(forumid);
\t\t
\t\t
String forumid=request.getParameter("fid");
int fid=Integer.parseInt(forumid);
String uid=request.getParameter("uid");
\t\t
// int userid=Integer.parseInt(uid);
// out.println(userid);
\t\t
BbsServiceInf service=new BbsServiceImpl();
service.deleteReplyByFid(fid);
service.deleteForumByFid(fid);
\t\t
\t\t
\t\t
     request.setAttribute("uid", uid);
request.getRequestDispatcher("UPersonForumList").forward(request, response);
}
}

public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
\t\t
request.setCharacterEncoding("utf-8");
// String user_id = request.getParameter("user_id");
\t\t\t 
String userid = request.getParameter("user_id");
int user_id=Integer.parseInt(userid);
String user_name = request.getParameter("user_name");
String user_password = request.getParameter("md5Pwd");
String user_sex = request.getParameter("user_sex");
String user_face = request.getParameter("user_face");
String user_phone = request.getParameter("user_phone");
String user_email = request.getParameter("user_email");
String user_from = request.getParameter("user_from");
\t\t \t\t\t\t 
UserEntity user = new UserEntity();
user.setUser_id(user_id);
\t\t 
user.setUser_name(user_name);
user.setUser_password(user_password);
user.setUser_sex(user_sex);
user.setUser_face(user_face);
user.setUser_phone(user_phone);
user.setUser_email(user_email);
user.setUser_from(user_from);
\t\t 
UserServiceInf service = new UserServiceImpl();
service.saveUser(user);
\t\t \t\t 
//PrintWriter out=response.getWriter();
\t\t 
response.sendRedirect("login.jsp");
//out.print("<a href='login.jsp'>Registration successful, please return to the login interface</a>");
\t\t 
}
}

 user.setUser_from(user_from);
\t\t
UserServiceInf service=new UserServiceImpl();
service.updateUser(user);

UserEntity userinfo=service.findUser(user_id);
request.setAttribute("userinfo", userinfo);
request.getRequestDispatcher("page/user/individualinfo.jsp").forward(request,response);
}
}

@SuppressWarnings("serial")
public class UPersonForumListServlet extends HttpServlet {<!-- -->
public void service (HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{<!-- -->
\t\t
\t\t
String user_id=request.getParameter("uid");

if(user_id==null){<!-- -->
String uid=(String)request.getAttribute("uid");
int pid=Integer.parseInt(uid);
\t\t\t
BbsServiceInf service=new BbsServiceImpl();
List<ForumEntity> personList=new ArrayList<ForumEntity>();
personList=service.personForum(pid);
request.setAttribute("perForumList", personList);
request.getRequestDispatcher("page/user/myforum.jsp").forward(request, response);
}else{<!-- -->
int pid=Integer.parseInt(user_id);
\t\t\t
BbsServiceInf service=new BbsServiceImpl();
List<ForumEntity> personList=new ArrayList<ForumEntity>();

@SuppressWarnings("serial")
public class UPfindReplyByIdServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
String forumid=request.getParameter("fid");
\t\t
if(forumid==null){<!-- -->
String fid=(String)request.getAttribute("forumid");
int f_id=Integer.parseInt(fid);
\t\t\t
PrintWriter out= response.getWriter();
out.println(f_id + "ewrew");
\t\t\t
BbsServiceInf service = new BbsServiceImpl();
//Query all replies
ForumEntity forum = service.findReplyList(f_id);
request.setAttribute("forum", forum);
request.getRequestDispatcher("page/user/preplyinfo.jsp").forward(request, response);
\t\t\t
}else{<!-- -->
int fid = Integer.parseInt(forumid);
\t\t\t
PrintWriter out= response.getWriter();
out.println(fid + "ewrew");
\t\t\t
BbsServiceInf service = new BbsServiceImpl();
//Query all replies
ForumEntity forum = service.findReplyList(fid);
request.setAttribute("forum", forum);
request.getRequestDispatcher("page/user/preplyinfo.jsp").forward(request, response);
}
\t\t
\t\t
\t\t
}
}

 user.setUser_sex(user_sex);
user.setUser_face(user_face);
user.setUser_phone(user_phone);
user.setUser_email(user_email);
user.setUser_from(user_from);
\t\t
UserServiceInf service=new UserServiceImpl();
service.updateUser(user);

UserEntity userinfo=service.findUser(user_id);
request.setAttribute("userinfo", userinfo);
request.getRequestDispatcher("page/user/individualinfo.jsp").forward(request,response);
}
}

@SuppressWarnings("serial")
public class UPersonForumListServlet extends HttpServlet {<!-- -->
public void service (HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{<!-- -->
\t\t
\t\t
String user_id=request.getParameter("uid");

if(user_id==null){<!-- -->
String uid=(String)request.getAttribute("uid");
int pid=Integer.parseInt(uid);
\t\t\t
BbsServiceInf service=new BbsServiceImpl();
List<ForumEntity> personList=new ArrayList<ForumEntity>();
personList=service.personForum(pid);
request.setAttribute("perForumList", personList);
request.getRequestDispatcher("page/user/myforum.jsp").forward(request, response);
}else{<!-- -->

request.setAttribute("forumid", forumid);
request.getRequestDispatcher("UPfindReplyById").forward(request, response);
}
}

@SuppressWarnings("serial")
public class ReplyListServlet extends HttpServlet{<!-- -->

public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
int fid = Integer.parseInt(request.getParameter("fid"));
BbsServiceInf service = new BbsServiceImpl();
ForumEntity forum = service.findReplyList(fid);
request.setAttribute("forum", forum);
request.getRequestDispatcher("reply.jsp").forward(request, response);
}
}
 

@SuppressWarnings("serial")
public class MUserListServlet extends HttpServlet {<!-- -->
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {<!-- -->
\t\t