Advertisement
Guest User

Untitled

a guest
Apr 3rd, 2020
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.24 KB | None | 0 0
  1. public void createNewProject(String name, String desc, String startingDate, String expectedFinishDate) throws SQLException {
  2.         String url = "jdbc:postgresql://158.75.112.103:55655/pz2020";
  3.         String user = "pz2020";
  4.         String password = "P3zetka";
  5.         Connection conn = DriverManager.getConnection(url, user, password);
  6.  
  7.         //String name = "siema";
  8.         //String desc = "SIEMANOELOELOELO";
  9.         //Date startingDate= new Date(2020, 01, 01);
  10.         //Date expectedFinishDate = new Date(2020, 10, 10);
  11.  
  12.         CallableStatement cst = conn.prepareCall("SELECT * FROM func_create_new_project(?, ?, ?, ?)");
  13.         cst.setString(1, name);
  14.         cst.setString(2, desc);
  15.         //cst.setDate(3, startingDate);
  16.         //cst.setDate(4, expectedFinishDate);
  17.         cst.setString(3, startingDate); //generalnie powinienes wyjebac te linijkę i te nizej i odkomentowac te dwie linijki wyzej z setDate, i wtedy date deklarowac jako te date kilka linijek wyzej
  18.         cst.setString(4, expectedFinishDate);
  19.  
  20.         ResultSet rs = cst.executeQuery();
  21.         while(rs.next()){
  22.             System.out.print(rs.getInt(1));
  23.             //setNewId(rs.getInt(1));
  24.         }
  25.         rs.close();
  26.         cst.close();
  27.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement