之前的Java查询Mysql的工具类地址:
Java 获取mysql连接工具类_小菜菜1223的博客-CSDN博客
scala配合工具类进行mysql查询代码:
package utils
object SelectUtils {
def selectConf(sql: String): String = {
var conf: String = ""
val conn = JdbcUtils.getConnection
val pst = conn.prepareStatement(sql)
val result = pst.executeQuery()
while (result.next()) {
conf = result.getString("conf")
}
JdbcUtils.closeResource(conn, pst)
conf
}
}