- 论坛徽章:
- 0
|
回复 2# caojiqun
感谢~我想也是这个样子,这个问题我已经处理好了...还有个问题想麻烦下您就是我实现通过读取文件连接数据库也好,或者读取文件数据导入数据库也好,都是在把这些文件放到程序里,我的代码就是下面这个样子
package practice;
import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.util.List;
import java.util.ArrayList;
import java.io.*;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/*read the properties*/
public class DB {
public static void main(String[]args){
String s;
int t = 0;
String[] sa=new String[5];
List data = new ArrayList();
try{
BufferedReader in =new BufferedReader(new FileReader("src/db.properties"));
while((s=in.readLine())!=null){
sa[t] =s.substring(0);
t++;
}
}
catch(FileNotFoundException e){
e.printStackTrace();
}
catch(IOException e){
e.printStackTrace();
}
/*connect the DB*/
String url = "jdbc:mysql://"+sa[0]+":"+sa[1]+"/"+sa[2];
String username = sa[3];
String password = sa[4];
Connection conn = null;
Statement stmt = null;
try{
conn = DriverManager.getConnection(url, username, password);
stmt = conn.createStatement();
}catch (SQLException e1) {
e1.printStackTrace();
}
/*put data in DB*/
File file = new File("D:\\HW3\\HW3\\data\\student.txt");
FileInputStream fis = null;
try {
fis = new FileInputStream(file);
InputStreamReader input = new InputStreamReader(fis);
BufferedReader br = new BufferedReader(input);
String line = null;
String sql = null;
String info[] = null;
String path = file.getAbsolutePath();//得到选择文件的全路径
String fileName = path.substring(path.lastIndexOf("\\")+1, path.lastIndexOf("."));//取得所选文件名
String province = fileName.substring(0,fileName.length()-2);
String cardType = fileName.substring(fileName.length()-2);
try {
while((line = br.readLine())!= null){
info = line.split(",");
sql = sql = "insert into cc(A,B,C)values('"+ info[0] +"','"+info[1]+"','"+info[2]+"')";
stmt.executeUpdate(sql);
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
可是老师有一个要求是要 在命令行里以这样的命令去运行...java -classpath .;mysql-connector-java-5.1.18-bin.jar DB db.properties student.txt vehicle.txt route.txt stop.txt zone.txt
这个怎么实现啊...好郁闷
|
|