最近用到spark streaming程序处理数据时,想要将结果保存到关系数据库中,于是先考虑到怎么样连接数据库,以及如何操作数据库
连接操作方法如下:
一、基本查询
import java.sql.{Connection, DriverManager, ResultSet}
// Change to Your Database Config
val conn_str = "jdbc:mysql://hadoopMaster:3306/streaming?user=root&password=hadoop"
// Load the driver
classOf[com.mysql.jdbc.Driver]
// Setup the connection
val conn = DriverManager.getConnection(conn_str)
// Configure to be Read Only
val statement = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)
// Execute Query
val rs = statement.executeQuery("SELECT id,price FROM money")
// Iterate Over ResultSet
while (rs.next) {
<span style="white-space:pre"> </span>println(rs.getString("id")+rs.getString("price"))