Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Override
- public boolean create(User obj) {
- CallableStatement stmt=null;
- ResultSet resultSet=null;
- try{
- stmt=connect.prepareCall("{? = call USERPACKAGE.add(?,?,?,?,?,?,?,?,?,?,?)}");
- stmt.registerOutParameter(1,OracleTypes.NUMBER);
- stmt.setString(2,obj.getFirstname());
- stmt.setString(3,obj.getLastname());
- stmt.setString(4,obj.getEmail());
- stmt.setString(5,obj.getPassword());
- stmt.setString(6,obj.getAddress());
- stmt.setDate(7,java.sql.Date.valueOf(obj.getBirthday().toInstant().atZone(ZoneId.of("Europe/Brussels")).toLocalDate()));
- stmt.setDate(8,java.sql.Date.valueOf(obj.getRegisterDate().toInstant().atZone(ZoneId.of("Europe/Brussels")).toLocalDate()));
- stmt.setInt(9,obj.getRelationship()?1:0);
- stmt.setInt(10,obj.getPhoneNumber());
- stmt.setInt(11,obj.getGender()?1:0);
- stmt.setInt(12,obj.getInterestedIn()?1:0);
- stmt.execute();
- return stmt.getInt(1)!=-1?true:false;
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment