jsp取表单值存入mysql数据库

<form action="save.jsp" method="post">
  <input type="text" name="name" placeholder="姓名"><br>
  <input type="email" name="email" placeholder="邮箱"><br>
  <input type="submit" value="提交">
</form>

<%@ page import="java.sql.*" %>
<%
  String name = request.getParameter("name");
  String email = request.getParameter("email");

  // 连接MySQL数据库
  String url = "jdbc:mysql://localhost:3306/mydatabase";
  String username = "username";
  String password = "password";
  Connection connection = DriverManager.getConnection(url, username, password);

  // 执行SQL插入语句
  String insertQuery = "INSERT INTO users (name, email) VALUES (?, ?)";
  PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
  preparedStatement.setString(1, name);
  preparedStatement.setString(2, email);
  preparedStatement.executeUpdate();

  // 关闭连接
  preparedStatement.close();
  connection.close();

  // 显示成功消息
  out.println("数据已成功保存到数据库。");
%>