?? filetomysql.java
字號:
import java.sql.*;
public class FileToMysql {
public static void main(String[] args) {
Connection conn;
Statement stmt;
int s;
// ResultSet res;
try{
// Class.forName("com.mysql.jdbc.Driver");
//建立到MySQL的連接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/first",
"root", "123");
//執行SQL語句
stmt = conn.createStatement();
String filename="E:\\\\student.txt";
String tablename="snw";
//stmt.executeUpdate("LOAD DATA INFILE\""+filename+"\"INTO TABLE"+tablename);
//if the file is comma-separated,use this statement
s=stmt.executeUpdate("LOAD DATA INFILE \""+filename+"\"INTO TABLE"+tablename+"FIELDS TERMINATED BY','");
//if the file is terminated by \r\n,use this statement
//stmt.executeUpdate("LOAD DATA INFILE \""+filename+"\"INTO TABLE"+tablename+"FIELDS TERMINATED BY'\\r\\n'");
System.out.print(s);
}catch(SQLException e){
e.getErrorCode();
e.getMessage();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -