JSP(Java Server Pages)是一种动态网页技术,它允许在HTML或XML文档中直接嵌入Java代码片段和表达式。数据库插入数据是指将数据从应用程序传输到数据库的过程。
以下是一个简单的JSP页面示例,演示如何使用JDBC将数据插入数据库:
<%@ page import="java.sql.*" %>
<%
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
String name = request.getParameter("name");
String email = request.getParameter("email");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, username, password);
String sql = "INSERT INTO users (name, email) VALUES (?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, email);
int rowsInserted = pstmt.executeUpdate();
if (rowsInserted > 0) {
out.println("A new user was inserted successfully!");
}
} catch (ClassNotFoundException | SQLException e) {
out.println("Error: " + e.getMessage());
}
%>
<!DOCTYPE html>
<html>
<head>
<title>Insert Data</title>
</head>
<body>
<h1>Insert User Data</h1>
<form action="insert.jsp" method="post">
Name: <input type="text" name="name"><br><br>
Email: <input type="text" name="email"><br><br>
<input type="submit" value="Insert">
</form>
</body>
</html>
希望这些信息对你有所帮助!如果有更多问题,请随时提问。
领取专属 10元无门槛券
手把手带您无忧上云