thelittlewozniak

Untitled

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