Oracle insert大字符串方法

最新推荐文章于 2023-12-29 20:04:24 发布

原创最新推荐文章于 2023-12-29 20:04:24 发布 · 841 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#insert #oracle #exception #string

本文介绍了一种在Oracle数据库中处理大字符串的方法，包括插入和更新操作。通过将大字符串拆分成较小的部分并使用适当的流处理方式，确保了数据能够正确地被存储。

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