📄 javaȦ
字号:
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>public ResultSet
getRs(String sql)throws SQLException<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>try<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>创建连接。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>conn=DBPool.getPool("Database").getConnection();<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>创建声明。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>stmt=conn.createStatement();<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>取得记录集。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>rs=stmt.executeQuery(sql);<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span><span style="mso-spacerun:
yes"> </span>catch(Exception e)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>抛出异常。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>System.err.println(e);<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>返回记录集。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>return rs;<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>//----------------------------------------------------------------<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>方法名</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'>:next<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>参数</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'>:<span style="mso-spacerun: yes"> </span></span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>空。</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>返回</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'>:<span style="mso-spacerun: yes"> </span></span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>空。</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>功能描述</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'>:</span><span style='font-family:新宋体;
mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:
Arial'>指针移动到下一个记录。</span><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>创建</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'>:<span style="mso-spacerun: yes"> </span>08/21/01<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>// </span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>修改</span><span lang=EN-US style='font-family:Arial;
mso-fareast-font-family:新宋体'>:<span style="mso-spacerun: yes">
</span>09/12/01<span style="mso-spacerun: yes"> </span><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>//------------------------------------------------------------------<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>public boolean next()throws
SQLException<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>try<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>检测记录集是否为空。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>if(
rs==null )<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>throw new SQLException( "</span><span style='font-family:新宋体;
mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:
Arial'>记录集为空</span><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'>." ) ;<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span><span
style="mso-spacerun: yes"> </span>catch(Exception e)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>抛出异常。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes">
</span>System.err.println(e);<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>//</span><span
style='font-family:新宋体;mso-ascii-font-family:Arial;mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial'>移动指针并返回。</span><span lang=EN-US style='font-family:
Arial;mso-fareast-font-family:新宋体'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>return rs.next()
;<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><span style="mso-spacerun: yes"> </span>}<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
新宋体'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:Arial;mso-fareast-font-family:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -