Scala连接mariaDB笔记

/** * 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    }  }}