java oracle insert_Oracle insert大字符串方法

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);

}

posted on 2008-08-26 22:06 猪 阅读(630) 评论(0)  编辑  收藏