简单的java解析文本文件批量导入数据库

package util;

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStreamReader;

import java.io.UnsupportedEncodingException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

/**

* 批量导入数据库

* @author Administrator

*

*/

public class InsertDB {

public Connection getConnection() {

Connection conn = null;

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(

"jdbc:oracle:thin:@****:**:**", "**",

"**");

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public static void main(String[] args) {

InsertDB rt = new InsertDB();

rt.AhPhoneInsert("C:\\Documents and Settings\\Administrator\\桌面\\C.txt");// 参数为你的txt文件路径

}

//数据记录导入

public boolean AhPhoneInsert(String file){

try {

Connection con = getConnection();

PreparedStatement ps = null,ps1=null,ps2=null;

ResultSet rs = null;

BufferedReader br = new BufferedReader(

(new InputStreamReader(new FileInputStream(new File(file)),

"utf-8")));// 编码方式为utf-8，txt保存时编码方式也要选择为utf-8

String line;

try {

String sql ="insert into C values(?)";

try {

con.setAutoCommit(false);

ps = con.prepareStatement(sql);

int n=0;

while ((line = br.readLine()) != null) {

String phone = line.trim();

ps.setString(1, phone);

ps.addBatch();

n++;

if(n>1000){

ps.executeBatch();

n=0;

}

}

ps.executeBatch();

https://www.360docs.net/doc/4c6940493.html,mit();

} catch (SQLException e) {

e.printStackTrace();

}finally{

if(null!=rs){

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null!=ps){

try {

ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null!=ps2){

try {

ps2.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null!=ps1){

try {

ps1.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if(null!=con){

try {

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

} catch (IOException e) {

e.printStackTrace();

}

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

} catch (FileNotFoundException e) {

e.printStackTrace();

}

return true;

}

}