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