/*

         * 返回接口状态码

         * */

        public static String getHttpCode(String url) {

            String code = null;

            try {

                URL u = new URL(url);

                URLConnection uc = u.openConnection();

                HttpURLConnection huc = (HttpURLConnection)uc;

                code = new Integer(huc.getResponseCode()).toString();

            } catch (Exception e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

            return code;

        }

        /*

         * 3个参数

         * */

        public static String getJson(String base_url, String para1, String value1, String para2, String value2, String para3, String value3) {

            String url = base_url + para1 + "=" + value1 + "&"

                                  + para2 + "=" + value2 + "&"

                                  + para3 + "=" + value3;

            String result = "";

            String code = getHttpCode(url);

            if(!code.startsWith("2")) {

                result = "*******接口的状态码为："+code+"*******"+url;

            }else {

                StringBuilder json = new StringBuilder();

                try {

                    URL u = new URL(url);

                    URLConnection uc = u.openConnection();

                    BufferedReader bd = new BufferedReader(new InputStreamReader(uc.getInputStream(),"UTF-8"));

                    String s = null;

                    while((s=bd.readLine())!=null) {

                        json.append(s);

                    }

                    bd.close();

                } catch (Exception e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                result = json.toString();

            }

            return result;

        }

        public static String getJsonValue(String json, String name){

            String s = null;

            JSONObject jobj = JSONObject.fromObject(json);

            //JSONObject jobj = JSONObject.fromObject("{'total':'0','message':'用户编号不能为空','data':'','code':'2','rows':''}");

            Iterator it = jobj.keys();

            while(it.hasNext()){

                String key = it.next().toString();

                String value = jobj.getString(key);

                if(key.equals(name)) {

                    s = value.trim();

                }

            }

            return s;

        } 

        public static String getJsonValue(String json,String jdate, String name){

            JSONObject jobj = JSONObject.fromObject(json);

            JSONObject dataList=jobj.getJSONObject(jdate);

            String balance =dataList.getString(name);

            return balance;

        } 

    /*获取jsonArray*/

    public static String getJsonArray(String json, String arr_name, int index) {

        JSONObject jobj = JSONObject.fromObject(json);

        JSONArray childs= jobj.getJSONArray(arr_name);

        JSONObject job = childs.getJSONObject(index);

        return job.toString();

    }

static void getVo(){

        String result = HttpClientUtil.httpGet("http://127.0.0.1:8080/test/vo?id=100");

        JSONObject jsonObject = JSONObject.parseObject(result);

        JSONObject userObject = jsonObject.getJSONObject("user");

        Object object = userObject.get("mobile");

        System.out.println("mobile="+object);

        //获取json中message的string值

        String message = jsonObject.getString("message");

        System.out.println(message);

        //获取json中code的int值

        int code = jsonObject.getIntValue("code");

        System.out.println(code);

        //获取json数组

        JSONArray jsonArray = jsonObject.getJSONArray("users");

        JSONObject userJson = jsonArray.getJSONObject(1);

        System.out.println(userJson.get("id"));

    }

        public static List<String> connectSqlList(String sql,String userNum, String col) {

            String url = "jdbc:mysql://172.16.30.209:3306/a_test";

            String name = "gmsd";

            Connection con = null;

            ResultSet rs = null;

            String rssql = null;

            List<String> list = new ArrayList<String>();

             try {

                Class.forName("com.mysql.jdbc.Driver").newInstance();

                con = DriverManager.getConnection(url,name,"dlnu1234");

                PreparedStatement pst = con.prepareStatement(sql);

                pst.setString(1, userNum);

                rs = pst.executeQuery();

                while(rs.next()) {

                    rssql = rs.getString(col);

                    list.add(rssql);

                }

            } catch (Exception e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            } finally {

                try {

                    rs.close();

                    con.close();

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

            }

             return list;

        }