java 文本文件 mysql_Java+MySql文本数据保存与读取的具体实例

package jdbc.text;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class SaveText {

public static void main(String[] args) {

// TODO Auto-generated method stub

try {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException | IllegalAccessException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String user = "root";

String password = "";

String url = "jdbc:mysql://192.168.1.100:3306/luxun?useUnicode=true&characterEncoding=utf-8";

Connection conn = null;

try {

conn = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

PreparedStatement pstat = null;

String insert = "insert into text (id,text) values(?,?)";

try {

pstat = conn.prepareStatement(insert);

pstat.setInt(1, 1);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

File file = new File("/home/cristo/urls1");

FileInputStream in = null;

try {

in = new FileInputStream(file);

try {

pstat.setAsciiStream(2, in, file.length());

pstat.execute();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

package jdbc.text;

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class ReadText {

public static void main(String args[]) {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException | IllegalAccessException

| ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String user="root";

String password="0000";

String url = "jdbc:mysql://192.168.1.100:3306/luxun?useUnicode=true&characterEncoding=utf-8";

Connection conn=null;

try {

conn=DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

PreparedStatement pstat=null;

String sql="select text from text where id =1";

try {

pstat=conn.prepareStatement(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

ResultSet rs=null;

try {

rs=pstat.executeQuery();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

StringBuffer bs=new StringBuffer();

if(rs.next()){

InputStream in=rs.getAsciiStream(1);

BufferedReader read=new BufferedReader(new InputStreamReader(in));

String text;

try {

text = read.readLine();

//System.out.println(text);

while(text!=null){

bs.append(text+"\n");

text=read.readLine();

}

System.out.println(bs.toString());

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}