/************************************************************
* Add resident
************************************************************
*/
public boolean addResident(String userID,String realName,String gender,
String birth,String addr,String tel,String email,String checkin) {
Connection conn = this.getConnection();
CallableStatement stmt = null;
Date birthDate = null;
Date checkinDate = null;
if(birth!=null && (!birth.equals(""))) {
birthDate = Date.valueOf(birth);
}
if(checkin!=null && (!checkin.equals(""))) {
checkinDate = Date.valueOf(checkin);
}
try {
stmt = conn.prepareCall("{call ICommunity.addResident(?,?,?,?,?,?,?,?,?)}");
stmt.setString(1, userID);
stmt.setString(2, realName);
stmt.setString(3, gender);
stmt.setDate(4, birthDate);
stmt.setString(5, addr);
stmt.setString(6, tel);
stmt.setString(7, email);
stmt.setDate(8, checkinDate);
stmt.registerOutParameter(9, Types.BOOLEAN);
stmt.execute();
return stmt.getBoolean(9);
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
finally {
try {
conn.close();
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
* Add resident
************************************************************
*/
public boolean addResident(String userID,String realName,String gender,
String birth,String addr,String tel,String email,String checkin) {
Connection conn = this.getConnection();
CallableStatement stmt = null;
Date birthDate = null;
Date checkinDate = null;
if(birth!=null && (!birth.equals(""))) {
birthDate = Date.valueOf(birth);
}
if(checkin!=null && (!checkin.equals(""))) {
checkinDate = Date.valueOf(checkin);
}
try {
stmt = conn.prepareCall("{call ICommunity.addResident(?,?,?,?,?,?,?,?,?)}");
stmt.setString(1, userID);
stmt.setString(2, realName);
stmt.setString(3, gender);
stmt.setDate(4, birthDate);
stmt.setString(5, addr);
stmt.setString(6, tel);
stmt.setString(7, email);
stmt.setDate(8, checkinDate);
stmt.registerOutParameter(9, Types.BOOLEAN);
stmt.execute();
return stmt.getBoolean(9);
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return false;
}
finally {
try {
conn.close();
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}