留言板
前言
本程序使用java在jsp文件中实现留言功能，并且用户可以使用本程序进行登录、注册、修改留言、删除留言等操作。这是JavaWeb课程一次作业，本来想用servlet写来着，写着写着发现在jsp文件里面写Java也可实现，就写了下来。本人JavaWeb小白一个，代码封装以及界面设计方面有待改进。本程序如有漏洞欢迎各位在评论区指正，源码已上传至gitee，链接在文末，有错误会及时改正。如需要使用servlet实现功能，欢迎评论区催更。
程序思路
利用session进行jsp文件之间的传值，在jsp内部使用表单传值获取表单内输入的数值，并且在每个jsp文件里连接数据库，根据获取的值对数据库进行增删改查操作。
运行界面
数据库
核心代码
留言功能部分代码
session获取login.jsp发来的用户名，根据表单内输入的内容，判定非空后将内容输入数据库。然后查询数据库的留言内容，对留言进行打印并显示。
webboard.jsp
<html>
<head>
<title>留言板</title>
</head>
<body>
<div class="main_box">
<div class="box">
<div class="title">留言板</div>
<form class="submit_box">
<div class="user_name">
<%
String name = (String) session.getAttribute("name");
%>
欢迎用户：<% out.print(name);%>
</div>
<div class="area_box">
<textarea rows="5" cols="40" placeholder=" 发表新鲜事儿......" name="area" class="area"></textarea>
</div>
<button class="submit" >发表</button>
</form>
<div class="content_box">
<%
try {
System.out.println("留言板界面正在加载。");
session.setAttribute("name",name);
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/webboard?user=root&password=111111&useUnicode=true&characterEncoding=utf8");
Statement stat = conn.createStatement();
System.out.println("数据库已连接");
String content = request.getParameter("area");
System.out.println("用户名："+name);
System.out.println("内容："+content);
System.out.println("name = "+session.getAttribute("name"));//session获取login.jsp传值
if(content != null){
String sql = "INSERT INTO user(id,content)VALUES('"+name+"','"+content+"')";
try {
stat.executeUpdate(sql);
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
String sql1 = "SELECT * FROM user order by time DESC";
ResultSet rs = null;
rs = stat.executeQuery(sql1);
while(rs.next()){
String id = rs.getString("id");
String r_content = rs.getString("content");
String time = rs.getString("time");
String num =rs.getString("num");
out.print("<div class='item'><div class='inner_box'><div class='user_box'>用 户:"+id+"</div><br><div class='content'>"+r_content+"</div><br><div class='time_box'>"+time+"</div><a class='delete' href='delete.jsp?num="+num+"&id="+id+"'>删除</a><a class='delete' href='change.jsp?number="+num+"&id="+id+"'>修改</a></div></div>");
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
%>
</div>
</div>
</div>
</body>
</html>
删除留言部分代码
webboard.jsp通过链接传送要删除的留言编号，delete.jsp通过编号对数据库操作，删除相应的留言。
delete.jsp
<html>
<head>
<title>删除留言</title>
</head>
<body>
<%
try{
System.out.println("删除界面正在加载。");
String name = (String) session.getAttribute("name");
System.out.println("当前用户为："+name);
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/webboard?user=root&password=111111&useUnicode=true&characterEncoding=utf8");
Statement stat = conn.createStatement();
Statement stat1 = conn.createStatement();
String num = request.getParameter("num");//获取留言编号
String sql1 = "SELECT id FROM user WHERE num ='"+num+"'";
ResultSet rs = stat1.executeQuery(sql1);
while(rs.next()){
if(rs.getString(1).equals(name)){
num = new String(num.getBytes());
System.out.print("num="+num);
String sql = "DELETE FROM USER WHERE num ='"+num+"';";
int i = stat.executeUpdate(sql);
System.out.print("成功删除数据，编号为"+num);
response.setHeader("refresh", "3;URL=webboard.jsp");//三秒后返回留言界面
System.out.print("当前留言属于用户："+rs.getString(1));
out.print("<div class='box'><div class='delete'>已删除！</div>" + "<div class='delete'>3秒后返回</div></div>");
}else{
out.print("<div class='box'><div class='delete'>不能删除其他用户的留言哦！</div>" + "<div class='delete'>3秒后返回</div></div>");
response.setHeader("refresh", "3;URL=webboard.jsp");
}
}
}catch (SQLException e){
System.out.print(e);
}
%>
</body>
</style>
</html>
修改留言部分代码
获取用户名和留言内容编号后，判断用户名与数据库内对应编号留言的用户名，如果相同则可以根据表单提交的新留言进行修改。如果不同，则不能删除并在三秒后返回界面。
change.jsp
<head>
<title>修改留言</title>
</head>
<body>
<div class="change_box">
<form class="change_form" action="change.jsp" method="post">
将留言修改为：<input type="text" name="content" class="content"><br>
<div class="submit_box">
<input type="submit" class="submit" value="修改">
</div>
</form>
</div>
<%
try{
System.out.println("修改界面正在加载。");
request.setCharacterEncoding("UTF-8");
String name = (String) session.getAttribute("name");
String num = request.getParameter("number");
String id = request.getParameter("id");
if(request.getParameter("number")!=null&&request.getParameter("id") != null){
application.setAttribute("num1",num);
application.setAttribute("id1",id);
}
String num1 = (String) application.getAttribute("num1");
String id1 = (String) application.getAttribute("id1");
System.out.println("num="+num1);
System.out.println("id="+id1);
String new_content = request.getParameter("content");
System.out.println("当前用户为："+name);
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/webboard?user=root&password=111111&useUnicode=true&characterEncoding=utf8");
Statement stat = conn.createStatement();
System.out.print("收到的更改语句为:"+new_content);
System.out.println("断点2");
if(id1.equals(name) && new_content != null){
System.out.print("断点2");
String sql = "UPDATE user SET content='"+new_content+"' WHERE num ='"+num1+"';";
stat.executeUpdate(sql);
// out.print("<script>alert('修改成功！');</script>");
Frame frame = new Frame();
frame.setAlwaysOnTop(true);
JOptionPane.showMessageDialog((Component) frame,"修改成功！");
response.sendRedirect("webboard.jsp");
}else if(!id1.equals(name) && new_content != null){
System.out.print("断点2");
out.print("<script>alert('不能修改其他用户的留言哦!');</script>");
response.setHeader("refresh", "URL=webboard.jsp");
}
}catch (SQLException e){
System.out.print(e);
}
%>
</body>
扫一扫
3212
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
