有赞接口

有赞接口

public class Test {
        private static final String APP_ID = "7edd2c64f8c645516c"; //这里换成你的app_id
	private static final String APP_SECRET = "00fcddd10e5660142f6d5d26acfc66f6"; //这里换成你的app_secret
        public static int b;
   
    public static void main(String[] args) {
        Test test = new Test();
        int a;
        a=test.getsp();
       System.out.println(a);
       getxs();

       
        
        
    }
    public int getsp() {
        String method = "kdt.items.onsale.get";
		HashMap<String, String> params = new HashMap<String, String>();
		//params.put("num_iid", "307342405");
                params.put("fields","num_iid,title,price,created,num");
                params.put("page_size","100");

		Client kdtApiClient;
		HttpResponse response;

		
                Connection ct=null;
		Statement statement=null;
                ResultSet rs=null;
                ResultSet rs1=null;
		
		//String url="jdbc:oracle:thin:@191.168.0.10:1521:orcl";
                String url="jdbc:oracle:thin:@218.56.106.155:1521:orcl";
		String username="lckj";
		String password="lckj7871818";
                try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		//2、得到连接
			ct=DriverManager.getConnection(url,username,password);
			//把事务设为不自动提交
			ct.setAutoCommit(false);
		//3、创建sql对象(Statement/PreparedStatement/CallableStatement)
			statement=ct.createStatement();
                        rs1=statement.executeQuery("truncate table Youzan_SP");
                        
                        kdtApiClient = new Client(APP_ID, APP_SECRET);
			response = kdtApiClient.get(method, params);
			System.out.println("Response Code : " + response.getStatusLine().getStatusCode());
			BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
//                        BufferedWriter writer = new BufferedWriter(new FileWriter(new File("C:\\Users\\Administrator\\Desktop\\file"))); 
			StringBuffer result = new StringBuffer();
                        
                        String line = "";
			while ((line = bufferedReader.readLine()) != null) {
				result.append(line);
//                                strlist.add(line);
//                                writer.append(line);
			}
                        
                        
                        Gson gson = new Gson();
                        java.lang.reflect.Type type=new TypeToken< Map<String,Status>>(){}.getType();
                        Map<String,Status> map = gson.fromJson(result.toString(), type);
                        
                        
                        for (Status v : map.values()) {  
                            b = v.getItems().size();
                            System.out.println("size= " + b);
                            for (int i=0;i<v.getItems().size();i++) {  
                                
//                                rs = statement.executeQuery("insert into Youzan_SP (F1,F2,F3,F4,F5) VALUES (1,1,1,1,1)");
                                
                                rs = statement.executeQuery("insert into Youzan_SP (F1,F2,F3,F4,F5) VALUES ('"+v.getItems().get(i).getnum()+"','"+v.getItems().get(i).getcreated()+"','"+v.getItems().get(i).getnum_iid()+"','"+v.getItems().get(i).gettitle()+"','"+v.getItems().get(i).getprice()+"')");
                            System.out.println("value= " + v.getItems().get(i).getnum());
                             } 
                             }
                        } catch (Exception e) {
			//如果事务中的sql语句中有任何错误则进行回滚操作。
			try {
				ct.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			//关闭资源[先开后关，后开先关]
			if(statement!=null){
				try {
					statement.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				statement=null;
			}
			if(ct!=null){
				try {
					ct.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				ct=null;
			}
		return b;
                }
                
        }
        public static void getxs() {
        String method = "kdt.trades.sold.get";
		

		
                Connection ct=null;
		Statement statement=null;
                ResultSet rs=null;
                ResultSet rs1=null;
                ResultSet rs2=null;
                String nowtime;
                List<String> ret = new ArrayList();
		
		String url="jdbc:oracle:thin:@218.56.106.155:1521:orcl";
                //String url="jdbc:oracle:thin:@191.168.0.10:1521:orcl";
		String username="lckj";
		String password="lckj7871818";
                try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		//2、得到连接
			ct=DriverManager.getConnection(url,username,password);
			//把事务设为不自动提交
			ct.setAutoCommit(false);
		//3、创建sql对象(Statement/PreparedStatement/CallableStatement)
			statement=ct.createStatement();
//                        
                        rs1 = statement.executeQuery("select * from Entity_XSSPXSJL order by F4 desc");
//                        rs1 = statement.executeQuery("select rownum ,xsrq from (select * from Entity_XSSPXSJL order by xsrq desc) where rownum = 1");
//
                        rs1 = statement.executeQuery("select rownum ,F2,F4 from (select * from Entity_XSSPXSJL order by F4 desc) where rownum = 1");
//                       while(rs1.next()){
//                               nowtime = rs1.getString("xsrq");
                               System.out.println(rs1.getString("F4"));
//                               ret.add(rs1.getString("xsrq"));
//
//			}
//                        
//                        nowtime = ret.get(0);
//                        System.out.println(nowtime);
                       
                       

                        HashMap<String, String> params = new HashMap<String, String>();
                        //params.put("num_iid", "307342405");
                        params.put("fields","num_iid,tid,num,receiver_name,receiver_mobile,receiver_address,status_str,consign_time,payment,title");
                        params.put("status" , "WAIT_BUYER_CONFIRM_GOODS");
                        params.put("page_size" , "100");
                        //params.put("start_created" , nowtime);
                        Client kdtApiClient;
                        HttpResponse response;
                        kdtApiClient = new Client(APP_ID, APP_SECRET);
			response = kdtApiClient.get(method, params);
			System.out.println("Response Code : " + response.getStatusLine().getStatusCode());
			BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
                        //BufferedWriter writer = new BufferedWriter(new FileWriter(new File("C:\\Users\\Administrator\\Desktop\\file"))); 
			StringBuffer result = new StringBuffer();
                        
                        String line = "";
			while ((line = bufferedReader.readLine()) != null) {
				result.append(line);
 //                               strlist.add(line);
                                //writer.append(line);
			}
                        //writer.flush();
                        System.out.println(result.toString());
                        
                        
                        Gson gson = new Gson();
                        java.lang.reflect.Type type=new TypeToken< Map<String,Statu>>(){}.getType();
                        Map<String,Statu> map = gson.fromJson(result.toString(), type);
                        
                        for (Statu v : map.values()) {  
                            System.out.println("size= " + v.gettrades().size());
                            for (int i=0;i<v.gettrades().size();i++) {  
                              //rs = statement.executeQuery("insert into Entity_XSSPXSJL (xxrq,xssp,yzbm,xxsl,sjjg,xxjg,shr,lxdh,shdz,spdd,gxzt) VALUES ('"+v.gettrades().get(i).getconsign_time()+"','"+v.gettrades().get(i).gettitle()+"','"+v.gettrades().get(i).getnum_iid()+"','"+v.gettrades().get(i).getnum()+"','"+v.gettrades().get(i).getpayment()+"','"+v.gettrades().get(i).getprice()+"','"+v.gettrades().get(i).getreceiver_name()+"','"+v.gettrades().get(i).getreceiver_address()+"','"+v.gettrades().get(i).getreceiver_mobile()+"','"+v.gettrades().get(i).gettid()+"',0)");  
                            //rs = statement.executeQuery("insert into Youzan_XS (F1,F2,F3,F4,F5) VALUES ('"+v.gettrades().get(i).getnum()+"','"+v.gettrades().get(i).getconsign_time()+"','"+v.gettrades().get(i).getnum_iid()+"','"+v.gettrades().get(i).getreceiver_mobile()+"','"+v.gettrades().get(i).getpayment()+"')");
                            rs = statement.executeQuery("insert into Youzan_XS (F1,F2,F3,F4,F5) VALUES (0,0,0,0,0)");
                            System.out.println("value= " + v.gettrades().get(i).getnum());
                             } 
                             }
                        } catch (Exception e) {
			//如果事务中的sql语句中有任何错误则进行回滚操作。
			try {
				ct.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			//关闭资源[先开后关，后开先关]
			if(statement!=null){
				try {
					statement.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				statement=null;
			}
			if(ct!=null){
				try {
					ct.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
				ct=null;
			}
		}
        }
    
}