使用动态数组JSP在数据库中添加动态数据

<%@ page import="java.sql.*" %>

<%
  // 连接数据库
  String url = "jdbc:mysql://localhost:3306/数据库名";
  String username = "用户名";
  String password = "密码";
  Connection conn = null;
  PreparedStatement stmt = null;
  
  try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);
    
    // 准备SQL语句
    String sql = "INSERT INTO 表名 (列1, 列2) VALUES (?, ?)";
    stmt = conn.prepareStatement(sql);
    
    // 设置参数
    stmt.setString(1, "值1");
    stmt.setString(2, "值2");
    
    // 执行SQL语句
    int rows = stmt.executeUpdate();
    
    if (rows > 0) {
      out.println("数据插入成功！");
    } else {
      out.println("数据插入失败！");
    }
  } catch (Exception e) {
    e.printStackTrace();
  } finally {
    // 关闭数据库连接
    if (stmt != null) {
      stmt.close();
    }
    if (conn != null) {
      conn.close();
    }
  }
%>