Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("oracle.jdbc.OracleDriver");
- } catch (ClassNotFoundException e) {
- System.out.println("JDBC driver not found");
- e.printStackTrace();
- }
- Connection insertDNA = null;
- try {
- insertDNA = DriverManager.getConnection("jdbc:oracle:thin:@//cytosine.nl:1521/xe", "owe7_pg3", "blaat1234");
- Statement statement = insertDNA.createStatement();
- statement.executeUpdate("INSERT INTO sequentie VALUES('" + sequence + "',0.0,(SELECT MAX(DNA_SEQUENTIE_ID) FROM DNA_SEQUENTIE)+1)");
- } catch (SQLException ex) {
- ex.printStackTrace();
- } finally {
- try {
- if (insertDNA != null && !insertDNA.isClosed()) {
- insertDNA.close();
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement