数据分析练习-3.12进度

今天完成了增加行政区划编码列和规范地域取值，学习了从百度API上根据地名获取准确地址和经度纬度的知识。

以下是学习内容：
部分源代码：

package address;

import address.Getregion;
import address.DBUtil;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class Dao
{

    int num_i=0;
    static List<String> ids=new ArrayList<String>();
    static List<String> names=new ArrayList<String>();
    public static void main(String[] args) {

        //select_co();
       // int i=0;
        
        select_city();
        select_ss();
    }

    public static List<String> select_city()
    {
        Connection conn = DBUtil.getConn();
        List<String> lists=new ArrayList<String>();
        String city=null;
        String str=new String();
        try {
            Statement state = conn.createStatement();

            ResultSet rs = state.executeQuery("select * from kjcg");
            while(rs.next()) {
                //如果有结果，是认为是通过验证了
                str=rs.getString("wcdw");
                String newStr=str;
                int i = str.indexOf(" ");

                if(i!=-1)
                {
                    System.out.println(str);
                    System.out.println(i);
                    newStr = str.substring(0,i);
                    System.out.println(newStr);
                }
               // city=getregion.SELECT(newStr);
                city=Getregion.SELECT1(newStr);
                lists.add(city);
                update_city(city,str);
            }
        } catch (Exception e)
        {
            e.printStackTrace();
        }
        return lists;
    }

  
    public static void update_city(String city,String value) {

       // String sql = "update kejichengguo1 set diyu ='"+city+"' where  wanchengdanwei ='"+value+"'";
        String sql = "update kjcg set xzqhbm ='"+city+"' where  wcdw ='"+value+"'";
        Connection conn = DBUtil.getConn();
        Statement state = null;
        try {
            state = conn.createStatement();
            state.executeUpdate(sql);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.close(state, conn);
        }
    }
    public static List<String> select_ss()
    {
        Connection conn = DBUtil.getConn();
        List<String> lists=new ArrayList<String>();
        String city=null;
        String str=new String();
        try {
            Statement state = conn.createStatement();

            ResultSet rs = state.executeQuery("select * from kjcg");
            while(rs.next()) {
                //如果有结果，是认为是通过验证了
                str=rs.getString("wcdw");
                String newStr=str;
                int i = str.indexOf(" ");

                if(i!=-1)
                {
                    System.out.println(str);
                    System.out.println(i);
                    newStr = str.substring(0,i);
                    System.out.println(newStr);
                }
               // city=getregion.SELECT(newStr);
                city=Getregion.SELECT(newStr);
                lists.add(city);
                update_ss(city,str);
            }
        } catch (Exception e)
        {
            e.printStackTrace();
        }
        return lists;
    }
    public static void update_ss(String city,String value) {

        // String sql = "update kejichengguo1 set diyu ='"+city+"' where  wanchengdanwei ='"+value+"'";
         String sql = "update kjcg set ss ='"+city+"' where  wcdw ='"+value+"'";
         Connection conn = DBUtil.getConn();
         Statement state = null;
         try {
             state = conn.createStatement();
             state.executeUpdate(sql);
         } catch (Exception e) {
             e.printStackTrace();
         } finally {
             DBUtil.close(state, conn);
         }
     }
}

 

 

 运行截图：

数据库中数据展示：

地域规范

 

 行政区划编码

 

 遇到的问题：

根据完成单位名称到百度地图API中获取规范地址和行政编码时，有的完成单位地名在百度地图中找不到，使得返回值为空。