/** * first of all,login the oracle's sqlplus with your userName and password* in this sample* SID = oracle * userName = jiaoxue * password = jiaoxue*......
int c;
while ((c=in.read())!=-1) {
out.write(c);
}
in.close();
out.close();
}
con.commit();
} catch (Exception e) {
e.printStackTrace();
try {if(con!=null){con.rollback();}} catch (SQLException e1) {e1.printStackTrace();}
} finally {
releaseResource(con,stmt,rs,defaultCommit);
}
}
/********************************************************************************
* 字符串和clob之间的转换 *
********************************************************************************/
public static void insertStringIntoClob(){
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
boolean defaultCommit = true;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.254:1521:oracle", "jiaoxue","jiaoxue");
defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
stmt = con.createStatement();
stmt.executeUpdate("insert into testclob (id, name, clobattr) values (1, 'clobname1', empty_clob())");
rs = stmt.executeQuery("select clobattr from testclob where ID=1 for update");
if (rs.next()) {
oracle.sql.CLOB clob = (oracle.sql.CLOB) rs.getClob("CLOBATTR");
Writer outStream = clob.getCharacterOutputStream();
char[] data = "我是一个字符串，我将被用来检验oracle的clob对象的插入，读取和修改功能的实现".toCharArray();
outStream.write(data,0,data.length);
outStream.flush();
outStream.close();
}
con.commit();
} catch (Exception e) {
e.printStackTrace();
try {if(con!=null){con.rollback();}} catch (SQLException e1) {e1.printStackTrace();}
} finally {
releaseResource(con,stmt,rs,defaultCommit);
}
}
public static void getStringFromClob(){
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
boolean defaultCommit = true;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.254:1521:oracle", "jiaoxue","jiaoxue");
defaultCommit = con.getAutoCommit();
con.setAutoCommit(false);
stmt = con.createStatement();
6/10 首页 上一页 4 5 6 7 8 9 下一页 尾页 |
