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); }
oracle insert方法,Oracle insert大字符串方法
最新推荐文章于 2024-01-09 13:00:00 发布