利用正则表达式，分割地址至省市县，更新MySQL数据库数据

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public static void main(String[] args){
    
    Connection conn = DBUtil.getConn();
    List<String> lists=new ArrayList<String>();
    String city=null;
    String str=new String();
    String str1=new String();
   // String str1=new String();
    try {
        Statement state = conn.createStatement();

        ResultSet rs = state.executeQuery("select 详细地域,id from c_2");
        while(rs.next()) {
            //如果有结果，是认为是通过验证了
            str=rs.getString("详细地域");
            System.out.println(str);
            str1=rs.getString("id");
            
            if (str != null)
            {
                String newStr=addressResolution(str);
                System.out.println(newStr);
                update_city(newStr,str1);
            }
 }
    } catch (Exception e)
    {
        e.printStackTrace();
    }
    }
    
    public static String addressResolution(String address){
        String regex="(?<province>[^省]+省|[^自治区]+自治区|.+市)(?<city>[^自治州]+自治州|.+区划|[^市]+市|.+区)?(?<county>[^市]+市|[^县]+县|[^旗]+旗|.+区)?(?<town>[^区]+区|.+镇)?(?<village>.*)";
        Matcher m=Pattern.compile(regex).matcher(address);
        String province=null,city=null,county=null;
        String str="";
        while(m.find()){
            province=m.group("province");
            city=m.group("city");
            county=m.group("county");
            if(province.equals("北京市"))
            {
                str = province + city;
                //System.out.println(str);
            }else if(province.equals("天津市"))
            {
                str = province + city;
            }else {
                str = province + city + county;
                //System.out.println(str);
            }
        }
        return str;
    }
    public static void update_city(String newStr,String str1) {

           // String sql = "update kejichengguo1 set diyu ='"+city+"' where  wanchengdanwei ='"+value+"'";
            String sql = "update c_2 set 详细地域 ='"+newStr+"' where  id ='"+str1+"'";
            Connection conn = DBUtil.getConn();
            Statement state = null;
            try {
                state = conn.createStatement();
                state.executeUpdate(sql);
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
                DBUtil.close(state, conn);
            }
        }