通过groovy在MS Access 2013中插入数据

@GrabConfig(systemClassLoader = true)
@Grab('net.ucanaccess:ucanaccess:5.0.0')
@Grab('net.ucanaccess:ucanaccessjdbc:5.0.0')
import java.sql.*

// 定义数据库连接字符串
String connectionString = "jdbc:ucanaccess://C:/path/to/your/database.accdb"

// 建立数据库连接
Connection connection = DriverManager.getConnection(connectionString)

// 创建插入语句
String insertQuery = "INSERT INTO TableName (Column1, Column2) VALUES (?, ?)"

// 创建预编译的语句
PreparedStatement statement = connection.prepareStatement(insertQuery)

// 设置参数值
statement.setString(1, "Value1")
statement.setString(2, "Value2")

// 执行插入操作
statement.executeUpdate()

// 关闭连接和语句
statement.close()
connection.close()