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