public boolean addSendStatus(SmsSendStatus smsSendStatus) {
// JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
String sql =
"insert into smssendstatus( mainid,mobile,sendtype,sendcount) values (?,?,?,?)"; // @8.28
if (jdbcTemplate.update(
sql, new Object[] {smsSendStatus.getMainid(), smsSendStatus.getMobile(), "0", 0})
> 0) return true;
else return false;
}
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 updateSendStatusSuc(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 smsid=? , sendtime=? where mainid=? and mobile=?";
if (jdbcTemplate.update(
sql,
new Object[] {
smsSendStatus.getSmsid(),
sdf.format(new java.util.Date()),
smsSendStatus.getMainid(),
smsSendStatus.getMobile()
})
> 0) return true;
else return false;
}
