public boolean updateCspUserInfo(final CspUserInfoPo po) {
String sql =
"UPDATE csp_user_info SET "
+ " `phone` = ? , `wangwang` = ? , `phone_feature` = ? ,"
+ " `wangwang_feature` = ? , `permission_desc` = ? , `accept_apps` = ? WHERE `mail` = ? ";
try {
this.execute(
sql,
new Object[] {
po.getPhone(), po.getWangwang(),
po.getPhone_feature(), po.getWangwang_feature(),
po.getPermission_desc(), po.getAccept_apps(),
po.getMail()
});
} catch (Exception e) {
logger.info(e);
return false;
}
return true;
}
public boolean insertCspUserInfo(CspUserInfoPo po) {
String sql =
"insert into csp_user_info(phone,wangwang,mail,phone_feature,wangwang_feature,permission_desc,accept_apps) values(?,?,?,?,?,?,?)";
try {
this.execute(
sql,
new Object[] {
po.getPhone(),
po.getWangwang(),
po.getMail(),
po.getPhone_feature(),
po.getWangwang_feature(),
po.getPermission_desc(),
po.getAccept_apps()
});
} catch (SQLException e) {
logger.info(e);
return false;
}
return true;
}
