Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void createNewProject(String name, String desc, String startingDate, String expectedFinishDate) throws SQLException {
- String url = "jdbc:postgresql://158.75.112.103:55655/pz2020";
- String user = "pz2020";
- String password = "P3zetka";
- Connection conn = DriverManager.getConnection(url, user, password);
- //String name = "siema";
- //String desc = "SIEMANOELOELOELO";
- //Date startingDate= new Date(2020, 01, 01);
- //Date expectedFinishDate = new Date(2020, 10, 10);
- CallableStatement cst = conn.prepareCall("SELECT * FROM func_create_new_project(?, ?, ?, ?)");
- cst.setString(1, name);
- cst.setString(2, desc);
- //cst.setDate(3, startingDate);
- //cst.setDate(4, expectedFinishDate);
- 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
- cst.setString(4, expectedFinishDate);
- ResultSet rs = cst.executeQuery();
- while(rs.next()){
- System.out.print(rs.getInt(1));
- //setNewId(rs.getInt(1));
- }
- rs.close();
- cst.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement