JAVA解析DBF文件方案

public JavaDBFReader(String read) { readFile = read; try { //源文件 br = new BufferedReader(new InputStreamReader(new FileInputStream( readFile))); } catch (Exception e) { e.printStackTrace(); }
//
pre.setString(1,data[4]);
//
pre.setString(2,data[5]);
pre.executeUpdate();
pre.close();
String
sql
=
"insert
into
fwsk_fpcgl_bd
(SWJG_DM,BS_NSRSBH,BSYF,FPDM,FPHM,GF_NSRSBH,XF_NSRSBH,JE,SE,KPRQ," +
data[9] + ",to_date('" + data[10] +
"','yyyy-mm-dd'),'" + data[11] + "','" + data[12] +
"',to_date('"
+ data[16] + "','yyyy-mm-dd'),'" + data[20] + "','" +
//
rs = pre.executeQuery();
//
if (rs != null) {
//
while (rs.next()) {
//
cktsqysh += rs.getString("NSRSBH") + ",";
//
}
//
}
InputStream inputStream = new FileInputStream(readFile); // take dbf file as program argument
import java.sql.PreparedStatement; import org.springframework.context.ApplicationContext; import com.zhuhai.ctasejb.EjbIni; import java.util.Properties; import javax.naming.Context; import javax.naming.InitialContext; import javax.sql.DataSource; import java.sql.Connection; import org.springframework.context.support.FileSystemXmlApplicationContext; import java.sql.*;
public class JavaDBFReader { //中文编码问题 private String getStrByCharToByte(String str) { byte[] temp = new byte[str.length()]; for (int i = 0; i < str.length(); i++) { temp[i] = (byte) (str.charAt(i)); } return new String(temp); } private Connection conn = null; private static Context context; private BufferedReader br; private String readFile; static Logger logger = Logger.getLogger("pub.readtxtfile");
"' and FPHM= '" + data[5] + "' ";
//String del ="delete from fwsk_fpcgl_bd where FPDM= ? and FPHM= ? ";
//conn.runUpdate(del);
pre = conn.prepareStatement(del);
Object[] rowObjects;
int[] skipIndex = {2, 13, 14, 15, 17, 18, 19, 21, 22, 24, 26}; while ((rowObjects = reader.nextRecord()) != null) {
String[] data = new String[rowObjects.length];
data[23] + "',"
+ data[25] + ")";
pre = conn.prepareStatement(sql);
try { if (pre.executeUpdate() == 1) { line++; //System.out.println("line="+line); pre.close(); } if (line == count) { logMsg = "共" + count + "条数据,全部成功导入"; } else { logMsg = "共" + count + "条数据,有" + (count - line) + "条数据未成功导入"; }
(*.dbf)};DBQ=" + filePath + ";","",""); sql = "select * from " + fileName; psDbf = connDbf.prepareStatement(sql); rsDbf = psDbf.executeQuery();
//按行解析 dbf 文件
" ZFBZ,BDBZ,BSSJ,BLBZ,FP_LB,SL) values ('" + data[0] +
"','" + data[1] + "'," + data[3] + ",'" + data[4] +
"','" + data[5] + "','"
+ data[6] + "','" + data[7] + "'," + data[8] + "," +
package com.zhuhai.impdata;
import com.linuxense.javadbf.*; import java.io.*; import com.zhuhai.db.conn.dbConnect; import java.sql.ResultSet; import org.apache.log4j.Logger; import java.util.Date; import java.text.SimpleDateFormat; import java.sql.Statement;
}
private String readDbf() { String logMsg = ""; String strsql = ""; double doufpje = 0.00; int count =0;
//dbConnect conn = null; PreparedStatement pre = null; ResultSet rs = null;
for (int i = 0; i < rowObjects.length; i++) {
String temp = "";
if (i < skipIndex.length && i == skipIndex[i]) {
continue;
}
if (rowObjects[i] != null) {
if (i == 10 || i == 16) {
}
}
data[i] = temp.trim();
}
//System.out.println("data[7] = "+data[7]+"?");
//
int boo = 0;
//
boo = cktsqysh.indexOf(data[7]);
// if (boo != -1) {
count++;
String del = "delete from fwsk_fpcgl_bd where FPDM= '" + data[4] +
//下面这种是不用装驱动就能解析的 Connection connDbf = null; PreparedStatement psDbf = null; ResultSet rsDbf = null; //一个目录名称，下面存放ＤＢＦ文件 String filePath = "D:/temp"; //一个ＤＢＦ文件夹，实际文件名称为 tbUser.dbf，这里做为表名不用扩展名就可以 String fileName = "tbUser"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connDbf = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft dBase Driver