Guest User

Untitled

a guest
Apr 29th, 2017
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. Connection c = null;
  2. Statement stmt = null;
  3. List<Integer> fixtureNrList = new ArrayList<Integer>();
  4. try {
  5. Class.forName("org.sqlite.JDBC");
  6. c = DriverManager.getConnection("jdbc:sqlite:test.db");
  7.  
  8. c.setAutoCommit(false);
  9. System.out.println("Opened database successfully");
  10. //
  11. stmt = c.createStatement();
  12. ResultSet rs = stmt.executeQuery( "SELECT DISTINCT FixtureNr FROM MATCH;" );
  13. while ( rs.next() ) {
  14. Integer nr = rs.getInt("FixtureNr");
  15. fixtureNrList.add(nr);
  16.  
  17. }
  18. rs.close();
  19. stmt.close();
  20. c.close();
  21. } catch ( Exception e ) {
  22. System.err.println( e.getClass().getName() + ": " + e.getMessage() );
  23. //System.exit(0);
  24. }
  25. System.out.println("Operation done successfully");
  26. return fixtureNrList;
Advertisement
Add Comment
Please, Sign In to add comment