JAVA实现读取文档进行正则匹配后执行JDBC

最新推荐文章于 2022-08-06 14:19:28 发布

furenjun002323

最新推荐文章于 2022-08-06 14:19:28 发布

阅读量440

点赞数

文章标签： Java JDBC 正则

本文链接：https://blog.csdn.net/furenjun002323/article/details/9855699

版权

import java.io.BufferedReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.List;
import java.util.regex.*;

public class TextReader {
   //BufferedReader br;
   static Pattern pattern = Pattern.compile("^\\夜\\d+路$");//全文检索匹配正则//^\d+路\区间
   //static Pattern pattern = Pattern.compile("^\\d+路\\区间$");//全文检索匹配正则//^\\d+路\\新华支线$
   static ArrayList<String> strList = new ArrayList<String>();//可以换成你想要的存储结构//^\\夜\\d+路$

   public static String getPYString(String str)
    {
          String tempStr = "";
            for(int i=0; i<str.length(); i++) {
                    char c = str.charAt(i);
                    if((int)c >= 33 && (int)c <=126) {//字母和符号原样保留
                            tempStr += String.valueOf(c);
                    }
                    else {//累加拼音声母
                            tempStr += getPYChar( String.valueOf(c) );

                    }
            }
            return tempStr;
    }
    /**
     * 取单个字符的拼音声母
     * @param c //要转换的单个汉字
     * @return String 拼音声母
     */
    public static String getPYChar(String c)
    {
            byte[] array = new byte[2];
            array = String.valueOf(c).getBytes();
            int i = (short)(array[0] - '\0' + 256) * 256 + ((short)(array[1] - '\0' + 256));
            if ( i < 0xB0A1) return "*";
            if ( i < 0xB0C5) return "a";
            if ( i < 0xB2C1) return "b";
            if ( i < 0xB4EE) return "c";
            if ( i < 0xB6EA) return "d";
            if ( i < 0xB7A2) return "e";
            if ( i < 0xB8C1) return "f";
            if ( i < 0xB9FE) return "g";
            if ( i < 0xBBF7) return "h";
            if ( i < 0xBFA6) return "j";
            if ( i < 0xC0AC) return "k";
            if ( i < 0xC2E8) return "l";
            if ( i < 0xC4C3) return "m";
            if ( i < 0xC5B6) return "n";
            if ( i < 0xC5BE) return "o";
            if ( i < 0xC6DA) return "p";
            if ( i < 0xC8BB) return "q";
            if ( i < 0xC8F6) return "r";
            if ( i < 0xCBFA) return "s";
            if ( i < 0xCDDA) return "t";
            if ( i < 0xCEF4) return "w";
            if ( i < 0xD1B9) return "x";
            if ( i < 0xD4D1) return "y";
            if ( i < 0xD7FA) return "z";
            return "*";
    }
   public static void main(String[] args) throws IOException {//JDBC
       PreparedStatement ps = null;
       ResultSet rs = null;
           String connectDB = "jdbc:sqlserver://172.16.255.199:1433;DatabaseName=BUS";
           try {
               Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

               } catch (ClassNotFoundException e) {
                   e.printStackTrace();
                   System.out.println("加载数据库引擎失败");
                   System.exit(0);
               }
           System.out.println("数据库驱动成功");

           String user="sa";
           String password="sa";
           try {
               Connection con = DriverManager.getConnection(connectDB, user, password);
           } catch (SQLException e) {
               e.printStackTrace();
           }
           System.out.println("数据库连接成功");
       //逐行检索文本信息
       BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream("C:/Users/Administrator/Desktop/最新2012哈尔滨公交线路大全.txt")));
       String s;
       while((s = br.readLine())!= null){
           Matcher matcher = pattern.matcher(s);//执行正则校验匹配
           if(matcher.find()){//判断是否满足正则条件
               String t = matcher.group();//将匹配结果存到变量中
               String s1="";
               //去程
               s = br.readLine();
               String[] str=s.split(",");
               for(int i=0;i<str.length;i++){
                   s1 = str[i];
                   System.out.println("-----------"+s1+"------------+++"+ t+s1);
                   System.out.println("==="+getPYString(s1).replaceAll("[\\*,\$,\$]", "") );
                   System.out.println("==="+getPYString(str[i]).toUpperCase().replaceAll("[\\*,\$,\$]", "") );

               }
               //回程
               s = br.readLine();
               String[] str1=s.split(",");
               for(int i=0;i<str1.length;i++){
                   s1 = str1[i];
                   System.out.println("-------"+s1+"-------------"+ t );
                   System.out.println("==="+getPYString(s1).replaceAll("[\\*,\$,\$]", "") );
                   System.out.println("==="+getPYString(str1[i]).toUpperCase().replaceAll("[\\*,\$,\$]", "") );
               }
               String sql = "";

               for(int i =0;i<str.length;i++){
                   sql = "INSERT into BUSSTOP (BUSLINE_NAME,BUSSTOP_NAME,BUSLINE_ID,BUSSTOP_NAMEK,BUSSTOP_NAMEP,BUSSTOP_CITY,BUSSTOP_SORTID)VALUES(";
                   sql += "'"+ t +"',";
                   sql += "'"+ str[i]+"',";
                   sql += "'"+"0"+"',";
                   sql += "'"+getPYString(str[i]).replaceAll("[\\*,\$,\$]", "")+"',";
                   sql += "'"+getPYString(str[i]).toUpperCase().replaceAll("[\\*,\$,\$]", "")+"',";
                   sql +=    "'"+"哈尔滨"+"',";
                   sql += ""+(i+1)+")";





                   Connection con = null;
                   try {
                       con = DriverManager.getConnection(connectDB, user, password);
                   } catch (SQLException e1) {
                       // TODO Auto-generated catch block
                       e1.printStackTrace();
                   }
                       try {
                           ps = con.prepareStatement(sql);
                       } catch (SQLException e) {
                           e.printStackTrace();
                       }
                       try {
                           ps.execute();
                       } catch (SQLException e) {
                           e.printStackTrace();
                       }
               }

           }

       }


   }



}