/**
**********************************************************
* 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 & amp; & amp; ( ! birth.equals( & quot; & quot;))) {
birthDate = Date.valueOf(birth);
}
if (checkin != null & amp; & amp; ( ! checkin.equals( & quot; & quot;))) {
checkinDate = Date.valueOf(checkin);
}
try {
stmt = conn.prepareCall( & quot;{call ICommunity.addResident( ? , ? , ? , ? , ? , ? , ? , ? , ? )} & quot;);
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 & amp; & amp; ( ! birth.equals( & quot; & quot;))) {
birthDate = Date.valueOf(birth);
}
if (checkin != null & amp; & amp; ( ! checkin.equals( & quot; & quot;))) {
checkinDate = Date.valueOf(checkin);
}
try {
stmt = conn.prepareCall( & quot;{call ICommunity.addResident( ? , ? , ? , ? , ? , ? , ? , ? , ? )} & quot;);
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();
}
}
}