jsp + servlet simple message board based on javaweb + mysql (java + jsp + servlet + javabean + mysql + tomcat)
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
Post a message, view the message, reply to the message, view the reply, delete the message (administrator)
technical framework
JSP Servlet MySQL JDBC Tomcat CSS JavaScript
JSP + Servlet simple message board based on javaweb + mysql (java + jsp + servlet + javabean + mysql + tomcat)
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
Reply reply=new Reply();
if(type.equals("reply")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to leave a message");
response.sendRedirect("fail.jsp");
return;
}
String reusername=request.getParameter("reusername");
String recontent=request.getParameter("recontent");
reply.setReUsername(reusername);
reply.setReContent(recontent);
reply.setMid(Integer.parseInt(mid));
try {<!-- -->
reply.add(reply);
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
reply.add(reply);
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("lookreply")){<!-- -->
try {<!-- -->
//Message id
String getId=request.getParameter("getId");
ArrayList<Reply> replies=new ArrayList<Reply>();
replies=reply.queryAll(Integer.parseInt(getId));
request.getSession().setAttribute("replies", replies);
response.sendRedirect("lookreply.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class UserServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UserServlet() {<!-- -->
super();
// TODO Auto-generated constructor stub
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req, resp);
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
Reply reply=new Reply();
if(type.equals("reply")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to leave a message");
response.sendRedirect("fail.jsp");
return;
}
String reusername=request.getParameter("reusername");
String recontent=request.getParameter("recontent");
reply.setReUsername(reusername);
reply.setReContent(recontent);
request.getSession().setAttribute("info", user1);
resp.sendRedirect("MessageServlet?type=query");
return;
}
}
request.getSession().setAttribute("info", "Wrong account or password");
resp.sendRedirect("fail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
public class RegServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req,resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
User user=new User();
//register
String userName = null;
userName = request.getParameter("text_username");
String passWord = request.getParameter("text_password");
request.setCharacterEncoding("utf-8");
//If the username or password or verification code is empty, return
if(userName == null || passWord == null)
return;
//If the username or password or verification code is an empty string, return
if(userName == "" || passWord == "" )
return;
//Encoding conversion was performed to support Chinese usernames
userName = new String(userName.getBytes("ISO-8859-1"), "UTF-8");
message.delete(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("queryOne")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to view messages");
response.sendRedirect("fail.jsp");
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("message",one);
response.sendRedirect("detail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
Reply reply=new Reply();
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<!-- -->
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String getId = request.getParameter("getId");
String type=request.getParameter("type");
System.out.println("type:" + type);
Message message=new Message();
if(type.equals("add")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to leave a message");
response.sendRedirect("fail.jsp");
return;
}
String title=request.getParameter("title");
String content=request.getParameter("content");
String theme=request.getParameter("theme");
message.setTitle(title);
message.setContent(content);
message.setTheme(theme);
message.setTime(String.valueOf(new Date()));
message.setUsername(((User)request.getSession().getAttribute("info")).getUsername());
try {<!-- -->
message.add(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
Reply reply=new Reply();
if(type.equals("reply")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to leave a message");
response.sendRedirect("fail.jsp");
return;
}
String reusername=request.getParameter("reusername");
String recontent=request.getParameter("recontent");
reply.setReUsername(reusername);
reply.setReContent(recontent);
reply.setMid(Integer.parseInt(mid));
try {<!-- -->
reply.add(reply);
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("lookreply")){
try {
//Message id
String getId=request.getParameter("getId");
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("queryOne")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to view messages");
response.sendRedirect("fail.jsp");
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("message",one);
response.sendRedirect("detail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("message",one);
response.sendRedirect("detail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@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");
String mid = request.getParameter("mid");
String type=request.getParameter("type");
System.out.println("type:" + type);
Reply reply=new Reply();
if(type.equals("reply")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
}
}
public class UserServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UserServlet() {<!-- -->
super();
// TODO Auto-generated constructor stub
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
User user = new User();
//Log in
String userName = null;
userName = request.getParameter("text_username_login");
String passWord = request.getParameter("text_password_login");
request.setCharacterEncoding("utf-8");
//If the username or password or verification code is empty, return
if (userName == null || passWord == null)
return;
//If the username or password or verification code is an empty string, return
if (userName == "" || passWord == "")
return;
//Encoding conversion was performed to support Chinese usernames
userName = new String(userName.getBytes("ISO-8859-1"), "UTF-8");
try {<!-- -->
ArrayList<User> users = user.queryAll();
for (User user1 : users) {<!-- -->
if (user1.getUsername().equals(userName) & amp; & amp; user1.getPassword().equals(passWord)) {<!-- -->
//Transmit data to the front end
request.getSession().setAttribute("info", user1);
try {<!-- -->
//Message id
String getId=request.getParameter("getId");
ArrayList<Reply> replies=new ArrayList<Reply>();
replies=reply.queryAll(Integer.parseInt(getId));
request.getSession().setAttribute("replies", replies);
response.sendRedirect("lookreply.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public class UserServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UserServlet() {<!-- -->
super();
// TODO Auto-generated constructor stub
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
User user = new User();
//Log in
String userName = null;
userName = request.getParameter("text_username_login");
String passWord = request.getParameter("text_password_login");
public class UserServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public UserServlet() {<!-- -->
super();
// TODO Auto-generated constructor stub
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
User user = new User();
//Log in
String userName = null;
userName = request.getParameter("text_username_login");
String passWord = request.getParameter("text_password_login");
request.setCharacterEncoding("utf-8");
//If the username or password or verification code is empty, return
if (userName == null || passWord == null)
return;
//If the username or password or verification code is an empty string, return
if (userName == "" || passWord == "")
return;
//Encoding conversion was performed to support Chinese usernames
userName = new String(userName.getBytes("ISO-8859-1"), "UTF-8");
try {<!-- -->
ArrayList<User> users = user.queryAll();
request.getSession().setAttribute("messages", messages);
\t\t\t\t
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("delete")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to delete message");
response.sendRedirect("fail.jsp");
return;
}else{<!-- -->
if(!info.getGrade().equals("admin")){<!-- -->
request.getSession().setAttribute("info","Cannot be deleted by non-administrators");
response.sendRedirect("fail.jsp");
return;
}
}
String idString=request.getParameter("id");
int id=Integer.parseInt(idString);
message.setId(id);
try {<!-- -->
message.delete(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("queryOne")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to view messages");
response.sendRedirect("fail.jsp");
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("info","Cannot be deleted by non-administrators");
response.sendRedirect("fail.jsp");
return;
}
}
String idString=request.getParameter("id");
int id=Integer.parseInt(idString);
message.setId(id);
try {<!-- -->
message.delete(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("queryOne")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to view messages");
response.sendRedirect("fail.jsp");
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("message",one);
response.sendRedirect("detail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
}
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public MessageServlet() {<!-- -->
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<!-- -->
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {<!-- -->
request.setCharacterEncoding("utf-8");
String getId = request.getParameter("getId");
String type=request.getParameter("type");
System.out.println("type:" + type);
Message message=new Message();
if(type.equals("add")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to leave a message");
response.sendRedirect("fail.jsp");
return;
}
String title=request.getParameter("title");
String content=request.getParameter("content");
String theme=request.getParameter("theme");
message.setTitle(title);
message.setContent(content);
message.setTheme(theme);
message.setTime(String.valueOf(new Date()));
message.setUsername(((User)request.getSession().getAttribute("info")).getUsername());
try {<!-- -->
response.sendRedirect("fail.jsp");
return;
}
String title=request.getParameter("title");
String content=request.getParameter("content");
String theme=request.getParameter("theme");
message.setTitle(title);
message.setContent(content);
message.setTheme(theme);
message.setTime(String.valueOf(new Date()));
message.setUsername(((User)request.getSession().getAttribute("info")).getUsername());
try {<!-- -->
message.add(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("query")){<!-- -->
try {<!-- -->
ArrayList<Message> messages=new ArrayList<Message>();
\t\t\t\t
messages=message.queryAll();
\t\t\t\t
request.getSession().setAttribute("messages", messages);
\t\t\t\t
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("delete")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to delete message");
response.sendRedirect("fail.jsp");
return;
}else{<!-- -->
if(!info.getGrade().equals("admin")){<!-- -->
request.getSession().setAttribute("info","Cannot be deleted by non-administrators");
response.sendRedirect("fail.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("queryOne")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to view messages");
response.sendRedirect("fail.jsp");
return;
}
try {<!-- -->
Message one = message.queryOne(getId);
request.getSession().setAttribute("message",one);
response.sendRedirect("detail.jsp");
} catch (SQLException throwables) {<!-- -->
throwables.printStackTrace();
}
}
}
}
public class ReplyServlet extends HttpServlet {<!-- -->
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {<!-- -->
doPost(req,resp);
}
message.setTime(String.valueOf(new Date()));
message.setUsername(((User)request.getSession().getAttribute("info")).getUsername());
try {<!-- -->
message.add(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("query")){<!-- -->
try {<!-- -->
ArrayList<Message> messages=new ArrayList<Message>();
\t\t\t\t
messages=message.queryAll();
\t\t\t\t
request.getSession().setAttribute("messages", messages);
\t\t\t\t
response.sendRedirect("show.jsp");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if(type.equals("delete")){<!-- -->
User info = (User) request.getSession().getAttribute("info");
if(info==null){<!-- -->
request.getSession().setAttribute("info","Please log in to delete message");
response.sendRedirect("fail.jsp");
return;
}else{<!-- -->
if(!info.getGrade().equals("admin")){<!-- -->
request.getSession().setAttribute("info","Cannot be deleted by non-administrators");
response.sendRedirect("fail.jsp");
return;
}
}
String idString=request.getParameter("id");
int id=Integer.parseInt(idString);
message.setId(id);
try {<!-- -->
message.delete(message);
response.sendRedirect("MessageServlet?type=query");
} catch (SQLException e) {<!-- -->
// TODO Auto-generated catch block
e.printStackTrace();
}
