处理文本
存储大文本
create table mytext(
id int primary key auto_increment,
content longtext
)
存储
File file = new File("JdbcUtils1.java");
FileReader fr = new FileReader(file);
pst.setCharacterStream(1, fr, (int) (file.length()));
获取:
Reader r = rs.getCharacterStream("content");
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Reader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MyTextTest {
public static void main(String[] args) throws Exception {
// setText();
getText();
}
// 存储文件
public static void setTe