基于javaweb+mysql的jsp+servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
发表留言,查看留言,回复留言,查看回复,删除留言(管理员)
技术框架
JSP Servlet MySQL JDBC Tomcat CSS JavaScript
基于javaweb+mysql的JSP+Servlet简单留言板(java+jsp+servlet+javabean+mysql+tomcat)
}
}
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","查看留言请登录");
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 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();
//登录
String userName = null;
userName = request.getParameter("text_username_login");
String passWord = request.getParameter("text_password_login");
request.setCharacterEncoding("utf-8");
//如果 用户名 或者密码 或者 验证码为 空,就返回
if (userName == null || passWord == null)
return;
//如果 用户名 或者密码 或者 验证码为 空字符串,就返回
if (userName == "" || passWord == "")
return;
// 进行了编码转换,以便支持中文用户名
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) && user1.getPassword().equals(passWord)) {
//传给前端得数据
request.getSession().setAttribute("info", user1);
resp.sendRedirect("MessageServlet?type=query");
return;
}
}
request.getSession().setAttribute("info", "账号或者密码错误");
resp.sendRedirect("fail.jsp");
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
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","查看留言请登录");
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 {
@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","留言请登录");
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