java 分割数据库_java 拆分字符串，然后如何让将其写入到数据库（拆分之后为 0000000016 00000 0000000752 00000....... ）...

packageerjinzhi;importjava.io.*;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.Statement;publicclassest{publicstaticvoidmain(String[]args)throwsIOE...

package erjinzhi;

import java.io.*;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class est {

public static void main(String[] args) throws

IOException{

FileInputStream fis = new FileInputStream

("c://rf//1.pdf");

FileOutputStream fos = new FileOutputStream

("c://2.txt");

byte[] buf = new byte[1024*400];

fis.read(buf);

fos.write(buf,116,310);//1210,161

fos.write(buf,30828,89);

fos.close();

fis.close();

String str2 = new String(buf,116,310);

String str3 = new String(buf,30828,89);

String [] s1= str2.split("\\D+");//拆分str2字符串

for(int i=0;i

System.out.println(s1[i]);

}

String [] s2= str3.split("\\D+");//拆分str3字符串

for(int i=0;i

System.out.println(s2[i]);

}

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url="jdbc:odbc:driver={Microsoft Access Driver

(*.mdb)};DBQ=c:/rf/ZB.mdb";

Connection connection=DriverManager.getConnection

(url);

Statement statement = connection.createStatement();

String sql1="insert into xref table([ObjNum],

[ObjBegin],[Generation number], [state])VALUES

('"+aaa.trim().split("\\s")[1]+"','"+aaa.trim().split

("\\s")[2]+"','"+aaa.trim().split("\\s")[3]

+"','"+aaa.trim().split("\\s")[4]+"')";//重点这句不会

，因为拆分之后，有很多组数，不能像上面那样一个一个

statement.executeUpdate(sql1);

connection.close();

statement.close();}

catch(Exception ex){

}finally{

}

}

}

展开