@Test
 public void testSendLogAll() throws ParseException, FileNotFoundException {
   UrpayOrderRequest urpay = new UrpayOrderRequest();
   urpay.setDpId("65927470");
   //		urpay.setStartCreated(DateUtils.parseDate("2013-06-23", "yyyy-MM-dd").getTime());
   //		urpay.setEndCreated(DateUtils.parseDate("2013-06-24", "yyyy-MM-dd").getTime());
   //		System.out.println(JackSonMapper.toJsonString(urpay));
   PrintWriter pw = new PrintWriter("f:/a.txt");
   countOrderRepository.getSendLogByTypeAlls(urpay, pw);
   //
   //		for (SendLogDomain sendLogDomain : listPage) {
   //			System.out.println(JackSonMapper.toJsonString(sendLogDomain));
   //		}
 }
  @Test
  public void test() throws ParseException, FileNotFoundException {
    UrpayOrderRequest urpay = new UrpayOrderRequest();
    urpay.setDpId("65927470");
    //		urpay.setStartCreated(DateUtils.parseDate("2013-06-23", "yyyy-MM-dd").getTime());
    //		urpay.setEndCreated(DateUtils.parseDate("2013-06-24", "yyyy-MM-dd").getTime());

    StringBuffer sql = new StringBuffer();
    Map<String, Object> paramMap = new HashMap<String, Object>();
    final Map<String, String> columnNameMap = new LinkedHashMap<String, String>(6);
    final Object[] columnName = construct(columnNameMap, paramMap, sql, urpay);
    System.out.println(columnName);
    System.out.println(sql);
  }