和处理常见属性大致相同,不同点在于大文本的输入借助于java中io流从读取,然后作为参数传递进去。
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
/**
* 存入和读取大文本
* @author Neuclil
*
*/
public class ClobText {
/**
* @param args
* @throws SQLException
* @throws FileNotFoundException
*/
public static void main(String[] args) throws FileNotFoundException, SQLException {
// TODO Auto-generated method stub
create();
}
static void create() throws SQLException, FileNotFoundException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = JdbcUtil.getConnection();
String sql = "insert into text values(1 ,?)";
ps = (PreparedStatement) conn.prepareStatement(sql);
<span style="color:#ff0000;"> File file = new File("src/JdbcUtil.java");
Reader reader = new BufferedReader(new FileReader(file));
ps.setCharacterStream(1, reader, (int)file.length());</span>
int count = ps.executeUpdate();
System.out.println(count + " row affected");
try {
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
} finally {
JdbcUtil.free(rs, ps, conn);
}
}
}