在Java Web开发中,JSP(JavaServer Pages)是一种用于创建动态网页的技术。下面是一个简单的个人博客留言功能的JSP代码示例:
leaveMessage.jsp
)<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>留言板</title>
</head>
<body>
<h1>欢迎来到我的博客,请留下您的足迹:</h1>
<form action="submitMessage.jsp" method="post">
姓名:<input type="text" name="name"><br><br>
邮箱:<input type="email" name="email"><br><br>
留言内容:<textarea name="message" rows="5" cols="40"></textarea><br><br>
<input type="submit" value="提交留言">
</form>
</body>
</html>
submitMessage.jsp
)<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>留言提交成功</title>
</head>
<body>
<%
String name = request.getParameter("name");
String email = request.getParameter("email");
String message = request.getParameter("message");
// 数据库连接信息
String url = "jdbc:mysql://localhost:3306/blogdb?useSSL=false&serverTimezone=UTC";
String username = "root";
String password = "your_password";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, username, password);
String sql = "INSERT INTO messages (name, email, message) VALUES (?, ?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, email);
pstmt.setString(3, message);
pstmt.executeUpdate();
pstmt.close();
conn.close();
%>
<h2>您的留言已成功提交!</h2>
<p>姓名:<%= name %></p>
<p>邮箱:<%= email %></p>
<p>留言内容:<%= message %></p>
<%
} catch (Exception e) {
e.printStackTrace();
%>
<h2>提交留言时发生错误,请稍后再试。</h2>
<%
}
%>
<a href="leaveMessage.jsp">返回留言板</a>
</body>
</html>
messages
表)CREATE TABLE messages (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
message TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
PreparedStatement
代替Statement
来防止SQL注入。通过以上步骤和注意事项,您可以实现一个基本的个人博客留言功能。希望这些信息对您有所帮助!
领取专属 10元无门槛券
手把手带您无忧上云