设计一个jsp评论区页面
时间: 2023-12-04 10:05:30 浏览: 86
好的,以下是一个简单的jsp评论区页面的设计:
1. 首先创建一个jsp页面,命名为comment.jsp。在页面中添加一个表单用于提交评论:
```
<form action="submitComment.jsp" method="post">
<label for="name">Name:</label>
<input type="text" id="name" name="name"><br><br>
<label for="comment">Comment:</label><br>
<textarea id="comment" name="comment" rows="4" cols="50"></textarea><br><br>
<input type="submit" value="Submit">
</form>
```
2. 创建一个名为submitComment.jsp的页面用于处理表单提交,并将评论保存到数据库中。在该页面中需要进行以下操作:
- 连接数据库
- 获取表单中的数据
- 将数据插入到数据库中
- 关闭数据库连接
以下是submitComment.jsp页面的代码示例:
```
<%@ page import="java.sql.*" %>
<%
// Connect to database
String url = "jdbc:mysql://localhost:3306/comment_db";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
// Get data from form
String name = request.getParameter("name");
String comment = request.getParameter("comment");
// Insert data into database
String query = "INSERT INTO comments (name, comment) VALUES (?, ?)";
PreparedStatement statement = connection.prepareStatement(query);
statement.setString(1, name);
statement.setString(2, comment);
statement.executeUpdate();
// Close database connection
statement.close();
connection.close();
%>
<p>Comment submitted successfully!</p>
```
3. 创建一个名为viewComments.jsp的页面用于显示所有评论。在该页面中需要进行以下操作:
- 连接数据库
- 查询数据库中的所有评论
- 将评论显示在页面上
- 关闭数据库连接
以下是viewComments.jsp页面的代码示例:
```
<%@ page import="java.sql.*" %>
<%
// Connect to database
String url = "jdbc:mysql://localhost:3306/comment_db";
String username = "root";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);
// Query database for comments
String query = "SELECT * FROM comments";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(query);
// Display comments on page
while (resultSet.next()) {
String name = resultSet.getString("name");
String comment = resultSet.getString("comment");
out.print("<p><b>" + name + ":</b> " + comment + "</p>");
}
// Close database connection
resultSet.close();
statement.close();
connection.close();
%>
```
4. 最后,将comment.jsp和viewComments.jsp页面链接在一起,以便用户可以提交评论并查看所有评论。例如,可以在主页面中添加一个链接以便用户可以打开评论页面:
```
<html>
<head>
<title>My Website</title>
</head>
<body>
<h1>Welcome to My Website</h1>
<a href="comment.jsp">Leave a Comment</a>
<hr>
<h2>Comments</h2>
<%@ include file="viewComments.jsp" %>
</body>
</html>
```