Oracle insert大字符串方法
try {
conn = getConnection();
pstmt = conn
.prepareStatement("Insert into offidutychk(decno,offino,checkdate,checkcontent) "+
"Values(seq_decno.nextval, ?,?,?)");
pstmt.setString(1, hezhi.getOffino());
pstmt.setDate(2, hezhi.getCheckDate());
pstmt.setCharacterStream(3,
new InputStreamReader(new ByteArrayInputStream(hezhi.getCheckContent().getBytes())), hezhi.getCheckContent().length());
//pstmt.setString(3, hezhi.getCheckContent());
// 判斷插入操作是否成功
if (pstmt.executeUpdate() == 1)
succ = true;
else
succ = false;
} catch (Exception e) {
succ = false;
e.printStackTrace();
} finally {
try {
pstmt.close();
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
closeConnection(conn);
}
Oracle update大字符串方法
Connection conn = null;
PreparedStatement pstmt = null;
int length=hezhi.getCheckContent().length();
String s1="";
String s2="";
if(length>1000){
s1=hezhi.getCheckContent().substring(0,1000);
s2=hezhi.getCheckContent().substring(1000,length);
}else{
s1=hezhi.getCheckContent();
}
try {
conn = getConnection();
pstmt = conn
.prepareStatement("update offidutychk set checkdate=?,checkcontent=?||? "+
"where decno=?");
pstmt.setDate(1, hezhi.getCheckDate());
// pstmt.setCharacterStream(2,
// new InputStreamReader(new ByteArrayInputStream(hezhi.getCheckContent().getBytes())), hezhi.getCheckContent().length());
// //pstmt.setString(2, hezhi.getCheckContent());
pstmt.setString(2, s1);
pstmt.setString(3, s2);
pstmt.setInt(4, hezhi.getDecno());
// 判斷更新操作是否成功
if (pstmt.executeUpdate() == 1)
succ = true;
else
succ = false;
} catch (Exception e) {
succ = false;
e.printStackTrace();
} finally {
try {
pstmt.close();
} catch (Exception e) {
e.printStackTrace();
}
closeConnection(conn);
}