scala mysql操作_scala 快速入门开发四（连接mysql增删改查）

scala 可以与Java一起连接mysql 操作数据库

首先引入mysql 的jar包

方式一使用scala 中的api 进行插入操作

package org.zw.sql

import java.sql.{ResultSet, DriverManager}

import scala.util.parsing.json.{JSONFormat, JSONObject, JSONArray, JSON}

object ScalaMysql {

def main(args: Array[String]) {

// create database connection

val dbc = "jdbc:mysql://localhost:3306/test?user=root&password=root"

classOf[com.mysql.jdbc.Driver]

val conn = DriverManager.getConnection(dbc)

val driver = "com.mysql.jdbc.Driver"

val url = "jdbc:mysql://localhost:3306/test"

val username = "root"

val password = "root"

// do database insert

try {

Class.forName(driver)

val connection = DriverManager.getConnection(url, username, password)

val prep = conn.prepareStatement("INSERT INTO blog (title, body) VALUES (?, ?) ")

prep.setString(1, "Nothing great was ever achieved without enthusiasm.")

prep.setString(2, "Ralph Waldo Emerson")

prep.executeUpdate

}

finally {

conn.close

}

}

}

方式二、使用Java  API 斤行数据库数据查询

package org.zw.sql

import java.sql.DriverManager

import java.sql.Connection

object ScalaMysql2 {

def main(args: Array[String]) {

// connect to the database named "mysql" on the localhost

val driver = "com.mysql.jdbc.Driver"

val url = "jdbc:mysql://localhost/test"

val username = "root"

val password = "root"

var connection:Connection = null

try {

Class.forName(driver)

connection = DriverManager.getConnection(url, username, password)

val statement = connection.createStatement()

val resultSet = statement.executeQuery("select * from blog")

while ( resultSet.next() ) {

val name = resultSet.getString("title")

val password = resultSet.getString("body")

println("name, password = " + name + ", " + password)

}

} catch {

case e => e.printStackTrace

//case _: Throwable => println("ERROR")

}

connection.close()

}

} 其实大部分与Java 的jdbc 是差不多的