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; }