Guest User

Untitled

a guest
Jul 1st, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. try {
  2. Class.forName("oracle.jdbc.driver.OracleDriver");
  3. //Creating a connection between Java program and Oracle database.
  4. Connection con;
  5. con = DriverManager.getConnection("jdbc:oracle:thin:@ora-******");
  6.  
  7.  
  8. result.forEach(record ->
  9. {
  10. String fpml = record.getPayload().get();
  11.  
  12.  
  13. Summary summary = SUMMARIZER.summarize(fpml);
  14.  
  15.  
  16. }
  17.  
  18. String a1= (String) summary.getFields().get("xxx");
  19. String a2= (String) summary.getFields().get("yyy");
  20. String a3= (String) summary.getFields().get("zzz");
  21.  
  22. //Loading and registering Oracle database thin driver
  23.  
  24. //Creating a Statement object to excute SQL statements
  25. Statement sql;
  26. try {
  27. sql = con.createStatement();
  28.  
  29. //Executing a SQL INSERT query using executeUpdate() method of Statement object.
  30.  
  31. sql.executeUpdate("INSERT INTO Execution_TEMP VALUES("+"'"+a1+"'"+","+"'"+a2+"'"+","+"'"+a3+"'"+")");
  32. } catch (SQLException e) {
  33. // TODO Auto-generated catch block
  34. e.printStackTrace();
  35. }
  36.  
  37. });
  38. con.close(); }
  39.  
  40. catch (SQLException e) {
  41. // TODO Auto-generated catch block
  42. e.printStackTrace();
  43. } catch (ClassNotFoundException e) {
  44. // TODO Auto-generated catch block
  45. e.printStackTrace();
  46. }
Add Comment
Please, Sign In to add comment