package data;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.sql.CLOB;
public class Snippet {
public String getStudentById() {
Connection conn = null;
Statement stmt = null;
try {
conn = OracleJDBCUtils.getConnection();
stmt = conn.createStatement();
CLOB clob = oracle.sql.CLOB.createTemporary(conn, false,oracle.sql.CLOB.DURATION_SESSION);
clob.putString(1, "");
String Sql1 = "update Y_PRODUCT set content=? where id=5477";
PreparedStatement pst = conn.prepareStatement(Sql1);
pst.setClob(1, clob);
pst.executeUpdate();
pst.close();
conn.commit();
System.out.println("chengg ");
} catch (SQLException e) {
e.printStackTrace();
} finally {
OracleJDBCUtils.releaseResource(conn, stmt, null);
}
return "aaa";
}
public static void main(String[] args) {
String studentById = new Snippet().getStudentById();
System.out.println(studentById);
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.sql.CLOB;
public class Snippet {
public String getStudentById() {
Connection conn = null;
Statement stmt = null;
try {
conn = OracleJDBCUtils.getConnection();
stmt = conn.createStatement();
CLOB clob = oracle.sql.CLOB.createTemporary(conn, false,oracle.sql.CLOB.DURATION_SESSION);
clob.putString(1, "");
String Sql1 = "update Y_PRODUCT set content=? where id=5477";
PreparedStatement pst = conn.prepareStatement(Sql1);
pst.setClob(1, clob);
pst.executeUpdate();
pst.close();
conn.commit();
System.out.println("chengg ");
} catch (SQLException e) {
e.printStackTrace();
} finally {
OracleJDBCUtils.releaseResource(conn, stmt, null);
}
return "aaa";
}
public static void main(String[] args) {
String studentById = new Snippet().getStudentById();
System.out.println(studentById);
}
}