public boolean updateSendStatusFail(SmsSendStatus smsSendStatus) {
// JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
String sql = "update smssendstatus set sendstatus=? where mainid=? and mobile=?";
if (jdbcTemplate.update(
sql,
new Object[] {
smsSendStatus.getSendstatus(), smsSendStatus.getMainid(), smsSendStatus.getMobile()
})
> 0) return true;
else return false;
}
public boolean updateSendStatus(SmsSendStatus smsSendStatus) {
// JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
String sql = "update smssendstatus set sendstatus=? where smsid=? and mobile= ?";
if (jdbcTemplate.update(
sql,
new Object[] {
smsSendStatus.getSendstatus(), smsSendStatus.getSmsid(), smsSendStatus.getMobile()
})
> 0) return true;
else return false;
}
public boolean urlUpdateSendStatus(SmsSendStatus smsSendStatus) {
JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
String sql = "update smssendstatus set sendstatus=? ,sendtime= ? where smsid=? and mobile= ?";
if (jdbcTemplate.update(
sql,
new Object[] {
smsSendStatus.getSendstatus(),
smsSendStatus.getSendtime(),
smsSendStatus.getSmsid(),
smsSendStatus.getMobile()
})
> 0) return true;
else return false;
}
public boolean urlAddSendStatus(SmsSendStatus smsSendStatus) {
// JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
String sql = "insert into smssendstatus( smsid,mobile,sendstatus,sendtime) values (?,?,?,?)";
if (jdbcTemplate.update(
sql,
new Object[] {
smsSendStatus.getSmsid(),
smsSendStatus.getMobile(),
smsSendStatus.getSendstatus(),
smsSendStatus.getSendtime()
})
> 0) return true;
else return false;
}