http://www.jexp.ru/index.php?action=history&feed=atom&title=Java_Tutorial%2FDatabase%2FLong_Text 2026-04-23T00:32:44Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.jexp.ru/index.php?title=Java_Tutorial/Database/Long_Text&diff=4774&oldid=prev 2010-06-01T05:05:53Z

<p>1 версия</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 05:05, 1 июня 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

Admin http://www.jexp.ru/index.php?title=Java_Tutorial/Database/Long_Text&diff=4773&oldid=prev 2010-05-31T17:44:27Z

<p></p> <p><b>Новая страница</b></p><div>== Get a Long Text Column/Field from a Database ==<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;java&quot;&gt;<br /> public static String getLargerString(ResultSet rs, int columnIndex) throws SQLException {<br /> InputStream in = null;<br /> int BUFFER_SIZE = 1024;<br /> try {<br /> in = rs.getAsciiStream(columnIndex);<br /> if (in == null) {<br /> return &quot;&quot;;<br /> }<br /> byte[] arr = new byte[BUFFER_SIZE];<br /> StringBuffer buffer = new StringBuffer();<br /> int numRead = in.read(arr);<br /> while (numRead != -1) {<br /> buffer.append(new String(arr, 0, numRead));<br /> numRead = in.read(arr);<br /> }<br /> return buffer.toString();<br /> } catch (Exception e) {<br /> e.printStackTrace();<br /> throw new SQLException(e.getMessage());<br /> }<br /> }&lt;/source&gt;<br /> <br /> <br /> &lt;!-- end source code --&gt;<br /> <br /> <br /> <br /> <br /> <br /> == How do you Store a Long Text Field in a Database? ==<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;java&quot;&gt;<br /> public static void setLongString(PreparedStatement pstmt, int parameterIndex, String data)<br /> throws Exception {<br /> // possibly a long string<br /> pstmt.setAsciiStream(parameterIndex, new ByteArrayInputStream(data.getBytes()), data.length());<br /> }&lt;/source&gt;<br /> <br /> <br /> &lt;!-- end source code --&gt;</div>