Advertisement
Guest User

Untitled

a guest
May 24th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. try {
  2. Class.forName("oracle.jdbc.OracleDriver");
  3. } catch (ClassNotFoundException e) {
  4. System.out.println("JDBC driver not found");
  5. e.printStackTrace();
  6. }
  7.  
  8. Connection insertDNA = null;
  9. try {
  10. insertDNA = DriverManager.getConnection("jdbc:oracle:thin:@//cytosine.nl:1521/xe", "owe7_pg3", "blaat1234");
  11. Statement statement = insertDNA.createStatement();
  12. statement.executeUpdate("INSERT INTO sequentie VALUES('" + sequence + "',0.0,(SELECT MAX(DNA_SEQUENTIE_ID) FROM DNA_SEQUENTIE)+1)");
  13. } catch (SQLException ex) {
  14. ex.printStackTrace();
  15. } finally {
  16. try {
  17. if (insertDNA != null && !insertDNA.isClosed()) {
  18. insertDNA.close();
  19. }
  20. } catch (SQLException ex) {
  21. ex.printStackTrace();
  22. }
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement