Scala JDBC连接mysql

下载JDBC
Using Scala with JDBC to connect to MySQL

    import java.sql.{Connection, DriverManager,ResultSet}
    /*
    * insert mysql into hbase
    */
try{
      Class.forName("com.mysql.jdbc.Driver")
      val connStr = "jdbc:mysql://ip_address:port/TABLENAME?user=USERNAME&password=PASSWORD"
    //for example:ip_address: 10.10.10.10
    //            port: 3306
    //            TABLENAME: 数据库名称
    //            USERNAME:用户名，如root
    //            PASSWORD:密码
      val conn = DriverManager.getConnection(connStr)
      val statement = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)//只读

      val rs = statement.executeQuery("SELECT * from user_problem_info LIMIT 5")
      while(rs.next){
        println(rs.getString("user_level"))
      }
      conn.close