Advertisement
Guest User

Untitled

a guest
May 2nd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. Enter your code herepackage Server;
  2. import java.io.ObjectInputStream.GetField;
  3. import java.sql.Connection;
  4. import java.sql.Date;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.Statement;
  8. import java.util.ArrayList;
  9.  
  10.  
  11. public class DBHandler {
  12.  
  13. public ArrayList<String> getFromDatabase() {
  14. Connection c = null;
  15. Statement stmt = null;
  16. ArrayList<String> list = new ArrayList<String>();
  17. int i = 0;
  18. try {
  19. Class.forName("org.postgresql.Driver");
  20. c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres", "postgres", "spanacus");
  21. c.setAutoCommit(true);
  22. System.out.println("Opened database successfully");
  23. stmt = c.createStatement();
  24. ResultSet rs = stmt.executeQuery("SELECT goods.name FROM \"SDJ3\".Goods");
  25. while(rs.next()){
  26. String name = rs.getString("Name");
  27.  
  28. list.add(name);
  29. }
  30.  
  31. rs.close();
  32. stmt.close();
  33. c.close();
  34. } catch (Exception e) {
  35. System.err.println(e.getClass().getName() + ": " + e.getMessage());
  36. System.exit(0);
  37. }
  38.  
  39. //System.out.println("Operation done successfully");
  40.  
  41. return list;
  42.  
  43. }
  44. public static void main(String args[]){
  45. DBHandler db = new DBHandler();
  46. }
  47.  
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement