Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. Connection con;
  2. String driver = "org.postgres.Driver";
  3. String DB_SERVER = "localhost:5432";
  4. String DB_NAME = "Musik";
  5. String password = "regis";
  6. String user = "regis";
  7. String url = "jdbc:postgressql://" + DB_SERVER + "/" + DB_NAME;
  8. try {
  9. Class.forName(driver);
  10.  
  11. con = DriverManager.getConnection(url, user, password);
  12. Statement stmt = con.createStatement();
  13. ResultSet rs = stmt.executeQuery("select name from person");
  14.  
  15. while(rs.next()) {
  16. System.out.println(rs.getString(1));
  17. }
  18. } catch (SQLException e) {
  19. // TODO Auto-generated catch block
  20. e.printStackTrace();
  21. } catch (ClassNotFoundException e) {
  22. // TODO Auto-generated catch block
  23. e.printStackTrace();
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement