public boolean sendmsdb(Map<String, Object> map) {
    String insert =
        "insert into vgop.msm_upload(msm_id,msm_content,msm_state,msm_date,msm_phonenum) "
            + "values('100860470009',?,0,?,?)";

    Connection conn = DataBaseJdbc.getDB2Connection();
    PreparedStatement stmt = null;
    try {
      stmt = conn.prepareStatement(insert);
      stmt.setString(1, map.get("send_ms").toString());
      stmt.setString(2, map.get("create_time").toString());
      stmt.setString(3, map.get("phone_no").toString());
      int i = stmt.executeUpdate();
      log.info("插入vgop 短信表条数 :" + i);
      if (i > 0) {
        return true;
      }
    } catch (Exception e) {
      log.error("创建数据库查询对象出错=" + e.getMessage());
    } finally {
      try {
        stmt.close();
        conn.close();
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    }
    return false;
  }
  @Override
  public String shortMessageCodeSend(Map<String, Object> map) {
    map.put("create_time", DateUtil.getNowDateStr());
    map.put("sendCode", DateUtil.getNowDateStr2() + RandomUtil.getRandom());
    String resultms = (String) map.get("sendCode");

    String isql = "短信表";
    try {
      String r = insertShortMessageCode(map);
      if (r.equals("N")) {
        resultms = "F";
      } else {
        map.put("status", "2"); // 插入成功,修改目前状态已经为2的数据
        sendMessageDao.updateAfterSendMessageStatus(map);
      }
      Connection con = DataBaseJdbc.getDB2Connection();
      if (con != null) {
        Statement stmt = con.createStatement();
        int i = stmt.executeUpdate(isql);
        if (i < 1) {
          resultms = "F";
        }
      } else {
        resultms = "F";
      }
    } catch (Exception e) {
      log.error("cc=" + e.getMessage());
      resultms = "E";
    }
    return resultms;
  }