Guest User

Untitled

a guest
Jan 31st, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. try {
  2. Class.forName("org.postgresql.Driver");
  3. c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/javadb","postgres", "mypass");
  4. stmt = c.createStatement();
  5. String sql = "CREATE TABLE GAMES " +
  6. "(GAME_NAME TEXT PRIMARY KEY NOT NULL, " +
  7. " PRICE FLOAT NOT NULL, " +
  8. " URL CHAR(800))";
  9. String sql2 = "INSERT INTO GAMES (GAME_NAME, PRICE, URL) "
  10. + "VALUES (" + this.GAME_NAME + ", " +
  11. Float.toString(this.PRICE) + ", " +
  12. this.URL + ");";
  13. stmt.executeUpdate(sql);
  14. stmt.executeUpdate(sql2);
  15. stmt.close();
  16. } catch (Exception e) {
  17. e.printStackTrace();
  18. }
  19.  
  20. public class UploadToDB {
  21. String GAME_NAME, URL;
  22. float PRICE;
  23. public UploadToDB(String GAME_NAME, float PRICE, String URL) {
  24. this.GAME_NAME = GAME_NAME;
  25. this.PRICE = PRICE;
  26. this.URL = URL;
  27. }
  28. }
Add Comment
Please, Sign In to add comment