com.fufang.testcase.ep.supplierapi.SaveOrUpdateAll.java Source code

Introduction

Here is the source code for com.fufang.testcase.ep.supplierapi.SaveOrUpdateAll.java

Source

package com.fufang.testcase.ep.supplierapi;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import org.apache.http.client.ClientProtocolException;
import org.testng.annotations.AfterTest;
import org.testng.annotations.Test;

import com.fufang.utils.HttpUtils;
import com.fufang.utils.JsonUtils;
import com.fufang.utils.RedisUtils;
import com.fufang.utils.SqlUtils;

import junit.framework.Assert;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import redis.clients.jedis.Jedis;

public class SaveOrUpdateAll {

    /*   String dbUrl = "172.16.86.44";
       String dbName = "gspdev";
       String dbUserName = "gspadmin";
       String dbPassword = "gspadmin01";
       Connection con;*/

    String dbUrl = "123.56.40.199";
    String dbName = "gsp";
    String dbUserName = "sa";
    String dbPassword = "1qaz@WSX";
    Connection con;

    String matCode = "YP7777";

    String url = "http://123.56.242.250/ffcloud-epscm/pullMaterial/saveOrUpdateAll.do";

    //????
    @Test
    public void saveMed() throws ClientProtocolException, IOException, SQLException {

        //json
        Map<String, String> data = new HashMap<String, String>();
        data.put("barcode", "????004");
        data.put("matcode", matCode);
        data.put("batchNum", "?004");
        data.put("name", "??004");
        data.put("commonName", "??004");
        data.put("spec", "004");
        data.put("unit", "??004");
        data.put("dosage", "004");
        data.put("licenseNum", "?004");
        data.put("manufName", "004");
        data.put("prodPlace", "?004");
        data.put("productDate", "2012-12-12");
        data.put("validDate", "2013-12-13");
        data.put("retailPrice", "14.4");
        data.put("zhongbao", "4");
        data.put("createPerson", "?004");
        data.put("sellState", "y");
        data.put("manufNameAbbr", "");
        data.put("is_kcbxs", "");
        data.put("price", "14.4");
        data.put("storeNum", "100");

        JSONArray dataArray = JSONArray.fromObject(data);
        JSONObject params = new JSONObject();
        params.put("key", "875FC66B-0422-4E0A-B0CE-F1C47BF3E1B5");
        params.put("data", dataArray);
        String sParams = params.toString();
        JsonUtils.printJson(sParams);//?json

        String resultContent = HttpUtils.httpPostJson(url, sParams);
        System.out.println(" - " + resultContent);

        JSONObject jsonObject = JSONObject.fromObject(resultContent);
        String code = jsonObject.getString("code");
        JSONObject responseData = jsonObject.getJSONObject("data");
        String result = responseData.getString("result");
        String dataCode = responseData.getString("code");

        Assert.assertEquals("000000", code);
        Assert.assertEquals("??????", result);
        Assert.assertEquals("SUCCESS", dataCode);

        SqlUtils c = new SqlUtils();
        con = c.sqlSConnection(dbUrl, dbName, dbUserName, dbPassword);

        //??
        try {
            Statement statement = con.createStatement();
            String querySql = "SELECT * FROM [wit_selection].[zc_sumMaterial] where matcode = '" + matCode + "'";
            ResultSet resultSet = statement.executeQuery(querySql);
            //resultSet.absolute(1);

            while (resultSet.next()) {
                String barcode = resultSet.getString("barcode");
                System.out.println(barcode);

                Assert.assertEquals(barcode, "????004");
                //??
            }
            String querySqlP = "SELECT * FROM [wit_selection].[zc_sumPriceAndNum] where matcode = '" + matCode
                    + "'";
            ResultSet resultSetP = statement.executeQuery(querySqlP);
            while (resultSetP.next()) {
                double price = resultSetP.getDouble("price");
                System.out.println(price);
                Assert.assertEquals(14.4, price);
                //??
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //??
    @Test
    public void updateMed() throws ClientProtocolException, IOException, SQLException {

        Map<String, String> data = new HashMap<String, String>();
        data.put("barcode", "????005");
        data.put("matcode", matCode);
        data.put("batchNum", "?005");
        data.put("name", "??005");
        data.put("commonName", "??005");
        data.put("spec", "005");
        data.put("unit", "??005");
        data.put("dosage", "005");
        data.put("licenseNum", "?005");
        data.put("manufName", "005");
        data.put("prodPlace", "?005");
        data.put("productDate", "2012-12-15");
        data.put("validDate", "2013-12-15");
        data.put("retailPrice", "15.5");
        data.put("zhongbao", "5");
        data.put("createPerson", "?005");
        data.put("sellState", "n");
        data.put("manufNameAbbr", "");
        data.put("is_kcbxs", "?");
        data.put("price", "5.5");
        data.put("storeNum", "150");

        JSONArray dataArray = JSONArray.fromObject(data);
        JSONObject params = new JSONObject();
        params.put("key", "875FC66B-0422-4E0A-B0CE-F1C47BF3E1B5");
        params.put("data", dataArray);
        String sParams = params.toString();
        JsonUtils.printJson(sParams);

        String resultContent = HttpUtils.httpPostJson(url, sParams);
        System.out.println(" - " + resultContent);

        JSONObject jsonObject = JSONObject.fromObject(resultContent);
        String code = jsonObject.getString("code");
        JSONObject responseData = jsonObject.getJSONObject("data");
        String result = responseData.getString("result");
        String dataCode = responseData.getString("code");

        Assert.assertEquals("000000", code);
        Assert.assertEquals("??????", result);
        Assert.assertEquals("SUCCESS", dataCode);

        SqlUtils c = new SqlUtils();
        con = c.sqlSConnection(dbUrl, dbName, dbUserName, dbPassword);

        try {
            Statement statement = con.createStatement();
            String querySqlM = "SELECT * FROM [wit_selection].[zc_sumMaterial] where matcode = '" + matCode + "'";
            ResultSet resultSetM = statement.executeQuery(querySqlM);
            while (resultSetM.next()) {
                String barcode = resultSetM.getString("barcode");
                System.out.println(barcode);
                Assert.assertEquals(barcode, "????005");
                //??
            }

            String querySqlP = "SELECT * FROM [wit_selection].[zc_sumPriceAndNum] where matcode = '" + matCode
                    + "'";
            ResultSet resultSetP = statement.executeQuery(querySqlP);
            while (resultSetP.next()) {
                double price = resultSetP.getDouble("price");
                System.out.println(price);
                Assert.assertEquals(5.5, price);
                //??
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //?redis
    @AfterTest
    public void deleteMed() throws SQLException {
        try {
            String deleteSql = "DELETE FROM [wit_selection].[zc_sumMaterial] where matcode = '" + matCode + "'";
            String deleteSqlP = "DELETE FROM [wit_selection].[zc_sumPriceAndNum] where matcode = '" + matCode + "'";
            PreparedStatement pStatement = con.prepareStatement(deleteSql);
            PreparedStatement pStatementP = con.prepareStatement(deleteSqlP);
            pStatement.executeUpdate();
            pStatementP.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }

        RedisUtils rc = new RedisUtils();
        Jedis jedis = rc.redisConn();

        try {
            jedis.hdel("MATERIAL_MATCODE_SUPPLIERID", "YP7777|66");
            jedis.hdel("PRISTOR_MATCODE_SUPPLIERID", "YP7777|66");
            if (jedis.hget("MATERIAL_MATCODE_SUPPLIERID", "YP7777|66") == null
                    && jedis.hget("PRISTOR_MATCODE_SUPPLIERID", "YP7777|66") == null) {
                System.out.println("delete redis success");
            } else {
                System.out.println("delete redis fail");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}