Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. object ScalaJdbcConnectSelect {
  2.  
  3. def main(args: Array[String]) {
  4. val driver = "oracle.jdbc.driver.OracleDriver"
  5. val url = "jdbc:oracle:thin:@xxxxx-xxxx.xxx.com:1521/xxxxx00.WORLD"
  6. val username = "xxx"
  7. val password = "xxx"
  8.  
  9. var connection:Connection = null
  10.  
  11. try {
  12. Class.forName(driver)
  13. connection = DriverManager.getConnection(url, username, password)
  14. val statement = connection.createStatement()
  15. val sql_st="INSERT INTO DCP_ITALY_STG" + " VALUES ('20411384','71771622','4378038','257.550','15.000')"
  16. statement.executeUpdate()
  17. println("Inserted records into the table...")
  18. statement.commit()
  19. } catch {
  20. case e: Throwable => e.printStackTrace
  21. }
  22. connection.close()
  23.  
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement