package dataimport;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import log.Log;
public class Insert_Data {
/**
* @param args
*/
String url = "jdbc:oracle:thin:@";
String userName = null;
String password = null;
Driver driver = null;
public static Connection connection = null;
public static Log log=new Log();
PreparedStatement stmt=null;
PreparedStatement stmt1=null;
/**
* @param args
* filepath-txt:数据文件路径
* confile_path:配置文件路径
*/
public void txtToDb(String file_path,String confile_path){
String table_name="liuc_test";
int count_row=0;//行数记录
try
{
//先链接数据库
Connection ct=getConnect(confile_path);
if (ct!=null){
System.out.println("链接数据库成功!!!");
/*
Statement sm=ct.createStatement();
//执行 sql
语句得到数据集
ResultSet rs=sm.executeQuery("select * from liuc_test");
//循环打印
while(rs.next())
{
System.out.println();
System.out.print("用户 id:"+rs.getInt(1)+" ");
System.out.print("用户名:"+rs.getString(2)+" ");
System.out.print("密码:"+rs.getString(3)+" ");
System.out.println();
}