Advertisement
Guest User

Untitled

a guest
Apr 3rd, 2020
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.99 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.setString(3, startingDate);
  16.         cst.setString(4, expectedFinishDate);
  17.  
  18.         ResultSet rs = cst.executeQuery();
  19.         while(rs.next()){
  20.             System.out.print(rs.getInt(1));
  21.             //setNewId(rs.getInt(1));
  22.         }
  23.         rs.close();
  24.         cst.close();
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement