txt到数据库数据传输(国外英语资料).docVIP

txt到数据库数据传输(国外英语资料) Import the data from the TXT file to the database implementation method Text file dbo_m_chth.txt, the data format is as follows: CHCDHB, CHCDTH 1011102, F671911 1011103, F691911 1011104, F681911 1011106, F601907 · · · · Among them, the first line: CHCDHB, CHCDTH for header name, are not required to import the Oracle database, from the second line of the following data import table in the database: RPS. RPP_CONV_TEST0, table has two fields: (BP_CD, TH_CD). You can do it in two ways. First, simple: use an Oracles built-in SQL server tool. Step 1. Create a control file input.ctl, and you can put it in the C inventory. Its content is as follows: the LOAD DATA INFILE C: \ dbo_M_CHTH TXT INTO TABLE RPS. RPP_CONV_TEST0 FIELDS TERMINATED BY , (BP_CD TH_CD) 2. Run the CMD command, enter the following command line, and enter the implementation: SQLLDR userid = RPS/RPS @ RPPBJ control = C: \ input CTL: SQLLDR userid = username/password @ database service name control = absolute path and file name Specific execution results can check automatically generate the Log file to record. No longer here. Second, write Java applications. I posted all my code and comments, as follows: package jp. Co. Import the Java. IO. BufferedReader; Import the Java. IO. The File; Import the Java. IO. FileReader; Import the Java. SQL. Connection; Import of Java, SQL PreparedStatement; Public class CodeChange {public static void txtToDB (String file_path_name) throws Exception {String file_nameTag = ; String table_name = ; String filed1 = ; String filed2 = ; String filed_content = ; Boolean isFistLine = true; Int count_num = 0; / / Log the number of records that are displayed when the Log is written. The Connection the db = null; / / New connection object db. PreparedStatement STMT = null; PreparedStatement stmt1 = null; LogWriter Errlog = new LogWriter (true); / / LogWriter: the function that writes the Log. LogWriter InfLog = new LogWriter (); InfLog. WriteLog ( コ ー ド variations i