Scala连接mariaDB笔记

最新推荐文章于 2024-09-18 15:15:23 发布

大鹏的NLP博客

最新推荐文章于 2024-09-18 15:15:23 发布

阅读量952

点赞数

分类专栏： scala 数据库/mariadb 文章标签： scala mariadb

本文链接：https://blog.csdn.net/philosophyatmath/article/details/46325051

版权

数据库/mariadb 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

scala

1 篇文章 0 订阅

订阅专栏

/**
 * Created by zhangdapeng on 15-6-2.
 */
import java.sql.{Statement, Connection, DriverManager, ResultSet}

object TestDB {
  def main(args: Array[String]) {
    // Connect to the database
    val url = "jdbc:mariadb://IP:3306/dbname"
    val driver = "org.mariadb.jdbc.Driver"
    val username = ""
    val password = ""
    var conn: Connection = null
    var st: Statement=null
    var rs: ResultSet=null

    Class.forName(driver)
    conn = DriverManager.getConnection(url, username, password)
    try {
      st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)
      rs = st.executeQuery("select * from table_name")
      while (rs.next) {
        println(rs.getString(1)+" "+rs.getString(2))
      }

    } finally {
      rs.close()
      st.close()
      conn.close
    }
  }
}