尝试测试INSERT语句是否成功执行的java.lang.AssertionError

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class InsertTest {
    public static void main(String[] args) {
        // 假设已经正确配置了数据库连接参数
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "myusername";
        String password = "mypassword";

        try {
            // 加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");
            
            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);
            
            // 定义INSERT语句
            String sql = "INSERT INTO mytable (column1, column2) VALUES (?, ?)";
            
            // 创建PreparedStatement对象
            PreparedStatement statement = conn.prepareStatement(sql);
            
            // 设置INSERT语句的参数
            statement.setString(1, "value1");
            statement.setString(2, "value2");
            
            // 执行INSERT语句
            int rowsInserted = statement.executeUpdate();
            
            // 断言插入的行数是否为1
            assert rowsInserted == 1 : "Failed to insert data";
            
            // 关闭数据库连接
            conn.close();
            
            System.out.println("INSERT statement executed successfully!");
        } catch (ClassNotFoundException | SQLException | AssertionError e) {
            e.printStackTrace();
        }
    }
}