readintodb.java

文本文档中的报表数据转换为数据库中的记录

package ReadToDB;

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import javax.swing.JOptionPane;

import POJO.Test;
import POJO_Action.DB_Test;

public class readIntoDB {

	String line;
	public void init(String filename)
	{
		try {
			BufferedReader in = new BufferedReader(new FileReader(filename));
			try {
				DB_Test db=new DB_Test();
				int count=0;
				line=in.readLine();
				while(line!=null)
				{
					String[] result=line.split("\t");
					Test test=new Test();
					for(int i=0;i<result.length;i++)
					{
						String name=result[0];
						int age=Integer.parseInt(result[1]);
						
						test.setAge(age);
						test.setName(name);
					}
					db.insertTest(test);
					line=in.readLine();
					count++;
					//line=in.readLine();
				}
				JOptionPane.showMessageDialog(null, "写入数据库"+count+"条记录");
			} catch (IOException e) {
				
				e.printStackTrace();
			}
		} catch (FileNotFoundException e) {
			
			e.printStackTrace();
		}
		
		
	}
}