Advertisement
Guest User

Untitled

a guest
Apr 3rd, 2020
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.73 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.         CallableStatement cst = conn.prepareCall("SELECT * FROM func_create_new_project( '"+ name +"', '" + desc + "', '" + startingDate + "', '" + expectedFinishDate + "')");
  8.        
  9.         ResultSet rs = cst.executeQuery();
  10.         while(rs.next()){
  11.             System.out.print(rs.getInt(1));
  12.             //setNewId(rs.getInt(1));
  13.         }
  14.         rs.close();
  15.         cst.close();
  16.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement