普通数据写入mysql

最新推荐文章于 2024-08-02 08:32:51 发布

tang_xiaotang

最新推荐文章于 2024-08-02 08:32:51 发布

阅读量350

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/tang_xiaotang/article/details/80967013

mysql 专栏收录该内容

13 篇文章

订阅专栏

val url = "jdbc:mysql://地址/库名?characterEncoding=utf8"
val username = "user"
val password = "password"

classOf[com.mysql.jdbc.Driver]

def getConnection(): sql.Connection = {
  DriverManager.getConnection(url, username, password)
}

val conn = this.getConnection()
try{
  val sql = new StringBuilder()
 .append("INSER TINTO 表名(doc_id,client_name,call_center,address,latitude,longitude,city_id,area_id,month_sale_num,shipping_time,geo_hash,create_time,update_time)")
    .append("     VALUES(?,?,?)")
  val pstm = conn.prepareStatement(sql.toString())
  pstm.setInt(1, doc_id)
  pstm.setString(2, client_name)
  pstm.setString(3, call_center)

  pstm.executeUpdate() > 0
}
finally {
  conn.close()
}