Scala的操作和Java的操作大同小异:
import java.sql.{Connection, DriverManager, PreparedStatement, ResultSet}
object JdbcHelper {
val sqlUrl = "jdbc:mysql://localhost:3306/test"
val user = "root"
val password = "123456"
def main(args: Array[String]): Unit = {
Class.forName("com.mysql.jdbc.Driver")
val connection: Connection = DriverManager.getConnection(sqlUrl, user, password)
val prepareStatement: PreparedStatement = connection.prepareStatement("""update blacklist set name =? where id = ?""")
prepareStatement.setNString(1, "rachard")
prepareStatement.setInt(2, 62)
prepareStatement.execute()
val rs: ResultSet = prepareStatement.executeQuery("select * from blacklist")
try {
while (rs.next()) {
println(rs.getInt("id") + ":" + rs.getNString("name"))
}
} catch {
case e => e.printStackTrace()
}finally {
rs.close()
prepareStatement.close()
connection.close()
}
}
}