149dc7614c64c43a658b3ffe4370a4bd4836b1e9.svn-base 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. package com.chinacreator.videoalliance.order.dao;
  2. import com.chinacreator.common.dao.ExecutorDao;
  3. import com.chinacreator.common.exception.BusinessException;
  4. import com.chinacreator.videoalliance.common.util.DataSource;
  5. import com.chinacreator.videoalliance.order.bean.BackShareOrderBean;
  6. import com.chinacreator.videoalliance.order.bean.OrderInfo;
  7. import org.springframework.stereotype.Component;
  8. import java.sql.SQLException;
  9. import java.util.List;
  10. /**
  11. * 后向走能力平台产品
  12. * @author shuchuan.jin
  13. * @date 20200407
  14. */
  15. @Component
  16. public class BackShareOrderDao extends ExecutorDao {
  17. /**
  18. * 保存订购日志
  19. * @param backShareOrder
  20. * @throws SQLException
  21. * @throws BusinessException
  22. */
  23. public void addShareOrderLog(BackShareOrderBean backShareOrder) throws SQLException {
  24. this.getExecutor().insertBean(DataSource.NET3G, "addShareOrderLog", backShareOrder);
  25. }
  26. public List<String> queryShareOrder() throws SQLException {
  27. return getExecutor().queryListWithDBName(String.class, "net3g", "queryShareOrder", new Object[] {});
  28. }
  29. public static void main(String args[]) throws SQLException {
  30. BackShareOrderDao b = new BackShareOrderDao();
  31. List<String> str = b.queryShareOrder();
  32. // BackShareOrderBean bso = new BackShareOrderBean();
  33. // bso.setUserid("18673197465");
  34. // bso.setErrorcode("0");
  35. // bso.setErrorinfo("成功");
  36. // bso.setCpid("kuaishou");
  37. // bso.setSpid("190");
  38. // bso.setInserttime("");
  39. // bso.setRemark("");
  40. // b.addShareOrderLog(bso);
  41. System.out.println(str);
  42. }
  43. }