具体和jsp代码和servlet代码
时间: 2024-03-04 07:48:17 浏览: 21
以下是一个简单的示例,展示了如何使用JSP和Servlet向数据库中插入数据。这个示例假设你已经创建了一个名为 "user" 的表,包含名为 "username" 和 "gender" 的两个字段。
index.jsp:
```jsp
<!DOCTYPE html>
<html>
<head>
<title>Insert User Data</title>
</head>
<body>
<h1>Insert User Data</h1>
<form action="InsertUserDataServlet" method="post">
<label>Username:</label>
<input type="text" name="username"><br>
<label>Gender:</label>
<select name="gender">
<option value="male">Male</option>
<option value="female">Female</option>
</select><br>
<input type="submit" value="Submit">
</form>
</body>
</html>
```
InsertUserDataServlet.java:
```java
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class InsertUserDataServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取表单数据
String username = request.getParameter("username");
String gender = request.getParameter("gender");
// 创建数据库连接
Connection conn = null;
PreparedStatement pstmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mydatabase", "root", "password");
// 创建SQL语句并执行插入操作
String sql = "INSERT INTO user (username, gender) VALUES (?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, gender);
pstmt.executeUpdate();
// 显示成功信息
response.sendRedirect("success.jsp");
} catch (Exception e) {
// 显示错误信息
response.sendRedirect("error.jsp");
} finally {
// 关闭连接和语句
try { pstmt.close(); } catch (Exception e) {}
try { conn.close(); } catch (Exception e) {}
}
}
}
```
success.jsp:
```jsp
<!DOCTYPE html>
<html>
<head>
<title>Success</title>
</head>
<body>
<h1>Success</h1>
<p>The user data has been successfully inserted.</p>
</body>
</html>
```
error.jsp:
```jsp
<!DOCTYPE html>
<html>
<head>
<title>Error</title>
</head>
<body>
<h1>Error</h1>
<p>An error occurred while inserting the user data.</p>
</body>
</html>
```
请注意,上述示例中的数据库连接字符串、用户名和密码应该根据你的实际情况进行修改。另外,为了确保安全性,你应该对用户输入进行验证和过滤。