package lianjie;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import lianjie.Dbutil;
public class Chashuju {
public static void readTxtFile(String filePath){
Connection conn=null;
try {
String encoding="GBK";
File file=new File(filePath);
if(file.isFile() && file.exists()){ //判断文件是否存在
InputStreamReader read = new InputStreamReader(
new FileInputStream(file),encoding);//考虑到编码格式
BufferedReader bufferedReader = new BufferedReader(read);
String lineTxt = null;
int i=0;
while((lineTxt = bufferedReader.readLine()) != null){
System.out.println(lineTxt);
i++;
try{
conn= Dbutil.getConnection();
String sql = "insert into www values(?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,lineTxt.replaceAll(" ",""));
ps.execute();
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException("添加失败",e);
}finally {
Dbutil.close(conn);
}
}
read.close();
}else{
System.out.println("找不到指定的文件");
}
} catch (Exception e) {
System.out.println("读取文件内容出错");
e.printStackTrace();
}
}
public static void main(String argv[]){
String filePath = "E://新项目//预测.txt";
readTxtFile(filePath);
}
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import lianjie.Dbutil;
public class Chashuju {
public static void readTxtFile(String filePath){
Connection conn=null;
try {
String encoding="GBK";
File file=new File(filePath);
if(file.isFile() && file.exists()){ //判断文件是否存在
InputStreamReader read = new InputStreamReader(
new FileInputStream(file),encoding);//考虑到编码格式
BufferedReader bufferedReader = new BufferedReader(read);
String lineTxt = null;
int i=0;
while((lineTxt = bufferedReader.readLine()) != null){
System.out.println(lineTxt);
i++;
try{
conn= Dbutil.getConnection();
String sql = "insert into www values(?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,lineTxt.replaceAll(" ",""));
ps.execute();
}catch(SQLException e){
e.printStackTrace();
throw new RuntimeException("添加失败",e);
}finally {
Dbutil.close(conn);
}
}
read.close();
}else{
System.out.println("找不到指定的文件");
}
} catch (Exception e) {
System.out.println("读取文件内容出错");
e.printStackTrace();
}
}
public static void main(String argv[]){
String filePath = "E://新项目//预测.txt";
readTxtFile(filePath);
}
}
连接数据库的代码
package lianjie;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Dbutil {
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection("jdbc:mysql://192.168.0.103:3306/data?useUnicode=true&characterEncoding=utf-8","root","123456");
}
public static void close(Connection conn) {
if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}