利用JDBC、Servlet实现对数据库的创建,数据库名为Student_姓名,创建user数据表,表的字段设置学号、姓名、年龄和学历,对应数据填写本人信息,通过jsp表单的方式传递数据到数据表里面。
时间: 2024-03-03 15:51:24 浏览: 14
好的,我可以为您提供一些实现步骤:
1. 首先,您需要在MySQL数据库中创建一个名为Student_姓名的数据库,可以使用以下命令:
```
CREATE DATABASE Student_姓名;
```
2. 然后,在该数据库中创建一个名为user的数据表,可以使用以下命令:
```
USE Student_姓名;
CREATE TABLE user (
id INT(11) NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
age INT(11) NOT NULL,
education VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);
```
3. 接下来,您需要编写一个Servlet来处理从JSP表单提交的数据。您可以在Servlet的doPost()方法中获取表单数据,并将其插入到user数据表中。以下是示例代码:
```java
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/AddUserServlet")
public class AddUserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String name = request.getParameter("name");
int age = Integer.parseInt(request.getParameter("age"));
String education = request.getParameter("education");
Connection conn = null;
PreparedStatement pstmt = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/Student_姓名";
String user = "root";
String password = "root";
conn = DriverManager.getConnection(url, user, password);
String sql = "INSERT INTO user (name, age, education) VALUES (?, ?, ?)";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, education);
pstmt.executeUpdate();
response.sendRedirect("success.jsp");
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
} finally {
try {
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
```
4. 最后,您需要编写一个JSP表单页面,以便用户输入数据并将其提交到AddUserServlet。以下是示例代码:
```html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Add User</title>
</head>
<body>
<h1>Add User</h1>
<form action="AddUserServlet" method="post">
<label>Name:</label>
<input type="text" name="name"><br>
<label>Age:</label>
<input type="text" name="age"><br>
<label>Education:</label>
<input type="text" name="education"><br>
<input type="submit" value="Add">
</form>
</body>
</html>
```
以上就是利用JDBC、Servlet实现对数据库的创建,并通过JSP表单的方式将数据添加到数据库的步骤。希望对您有所帮助!