filetomysql.java

来自「jfreechart的示例文件」· Java 代码 · 共 34 行

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();
			
		}
			
	}

}