Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- object ScalaJdbcConnectSelect {
- def main(args: Array[String]) {
- val driver = "oracle.jdbc.driver.OracleDriver"
- val url = "jdbc:oracle:thin:@xxxxx-xxxx.xxx.com:1521/xxxxx00.WORLD"
- val username = "xxx"
- val password = "xxx"
- var connection:Connection = null
- try {
- Class.forName(driver)
- connection = DriverManager.getConnection(url, username, password)
- val statement = connection.createStatement()
- val sql_st="INSERT INTO DCP_ITALY_STG" + " VALUES ('20411384','71771622','4378038','257.550','15.000')"
- statement.executeUpdate()
- println("Inserted records into the table...")
- statement.commit()
- } catch {
- case e: Throwable => e.printStackTrace
- }
- connection.close()
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement