Scala平滑插入表，省略某些列并返回新行的主键

import slick.jdbc.MySQLProfile.api._

// 定义表结构
class MyTable(tag: Tag) extends Table[(Int, String, String)](tag, "my_table") {
  def id = column[Int]("id", O.PrimaryKey, O.AutoInc)
  def col1 = column[String]("col1")
  def col2 = column[String]("col2")

  def * = (id, col1, col2)
}

// 创建表对象
val myTable = TableQuery[MyTable]

// 创建数据库连接
val db = Database.forConfig("mydb")

// 定义要插入的数据
val data = Seq(("value1", "value2"), ("value3", "value4"))

// 执行插入操作
val insertAction = myTable.map(t => (t.col1, t.col2)) ++= data
val insertResult = db.run(insertAction)

// 获取插入后的主键
val insertedIds = insertResult.map(_.getOrElse(0, 0))

// 输出插入后的主键
insertedIds.foreach(println)

import java.sql.{Connection, DriverManager, PreparedStatement, ResultSet}

// 创建数据库连接
val url = "jdbc:mysql://localhost:3306/mydb"
val username = "root"
val password = "password"
val connection = DriverManager.getConnection(url, username, password)

// 定义要插入的数据
val data = Seq(("value1", "value2"), ("value3", "value4"))

// 执行插入操作
val insertSql = "INSERT INTO my_table (col1, col2) VALUES (?, ?)"
val insertStatement = connection.prepareStatement(insertSql, PreparedStatement.RETURN_GENERATED_KEYS)
data.foreach { case (col1, col2) =>
  insertStatement.setString(1, col1)
  insertStatement.setString(2, col2)
  insertStatement.addBatch()
}
insertStatement.executeBatch()

// 获取插入后的主键
val generatedKeys = insertStatement.getGeneratedKeys
val insertedIds = new scala.collection.mutable.ListBuffer[Int]
while (generatedKeys.next()) {
  insertedIds += generatedKeys.getInt(1)
}

// 关闭数据库连接
insertStatement.close()
connection.close()

// 输出插入后的主键
insertedIds.foreach(println)