private static void read() {
/**
* 读取
*/
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = JdbcUtil.getConnection();
String sql = "select * from news where id = ?;";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, 2);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
Clob clob = rs.getClob("context");
Reader reader = clob.getCharacterStream();
FileWriter writer = new FileWriter("d:/url2.txt");
char[] buf = new char[512];
int len=0;
while((len=reader.read(buf))!=-1){
writer.write(buf, 0, len);
}
writer.close();
reader.close();
}
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
JdbcUtil.close(stmt, conn);
}
}
private static void write() {
/**
* 写入
*/
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = JdbcUtil.getConnection();
String sql = "insert into news(title,context) values(?,?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, "这是一个url url url url~~~~~");
/**
* 读取本地文件
*/
InputStreamReader reader=new InputStreamReader(new FileInputStream("d:/url.txt"),"gbk");
stmt.setClob(2, reader);
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} finally {
JdbcUtil.close(stmt, conn);
}
}