📄 in10_db_page.htm
字号:
<p class="MsoNormal"><span lang="EN-US"> rowCount=rs.getRow();</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> int offset=1;</span></p>
<p class="MsoNormal"><span lang="EN-US"> int pagesize=getLength();</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(getLength()<1)</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> pagesize=rowCount;</span></p>
<p class="MsoNormal"><span lang="EN-US"> pageCount=1;</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> else</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US">
pageCount=rowCount/getLength()+((rowCount%getLength())>0?1:0);</span></p>
<p class="MsoNormal"><span lang="EN-US">
offset=(ipage-1)*getLength()+1;</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(offset<1)offset=1;</span></p>
<p class="MsoNormal"><span lang="EN-US">
if(offset>rowCount)offset=rowCount; </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> } </span></p>
<p class="MsoNormal"><span lang="EN-US"> rs.absolute(offset);</span></p>
<p class="MsoNormal"><span lang="EN-US"> for(int
i=0;i<pagesize&&offset<rowCount+1;i++,offset++) { </span></p>
<p class="MsoNormal"><span lang="EN-US"> dbList m_dbList= new dbList();
</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<find></span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">序号</span><span lang="EN-US">(rs.getInt(1));</span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">(rs.getString(2));</span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">备注</span><span lang="EN-US">(rs.getString(3));</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</find></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> rs.next();</span></p>
<p class="MsoNormal"><span lang="EN-US"> list.add(m_dbList);</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> return list;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> } catch (SQLException e) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> //e.printStackTrace();</span></p>
<p class="MsoNormal"><span lang="EN-US"> //throw new
RuntimeException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> return list;</span></p>
<p class="MsoNormal"><span lang="EN-US"> } finally {</span></p>
<p class="MsoNormal"><span lang="EN-US"> try {</span></p>
<p class="MsoNormal"><span lang="EN-US"> if (ps != null)</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.close();</span></p>
<p class="MsoNormal"><span lang="EN-US"> if (rs != null)</span></p>
<p class="MsoNormal"><span lang="EN-US"> rs.close();</span></p>
<p class="MsoNormal"><span lang="EN-US"> } catch (SQLException e) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> e.printStackTrace();</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new
RuntimeException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">}</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">dbListAction.java</span><span style="font-family: 宋体">文件：</span></p>
<p class="MsoNormal"><span lang="EN-US"> <b> </b></span><b><span style="font-family: 宋体">在</span><span lang="EN-US" style="font-family:黑体"><分页></分页>之间的代码是实现数据库分页显示的代码。</span></b></p>
<p class="MsoNormal"><b><span style="font-family:黑体">。。。。。。。。。。<span lang="EN-US">(省略)</span></span></b></p>
<p class="MsoNormal"><span lang="EN-US">public final class dbListAction extends
Action </span></p>
<p class="MsoNormal"><span lang="EN-US">{</span></p>
<p class="MsoNormal"><span lang="EN-US"> // </span>
<span style="font-family: 宋体">变量定义：</span></p>
<p class="MsoNormal"><span lang="EN-US"> private Log log =
LogFactory.getLog("org.apache.struts.webapp.Example");</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> private ConnectionPool pool;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> public dbListAction() {</span></p>
<p class="MsoNormal"><span lang="EN-US"> pool =
ConnectionPool.getInstance();</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> //</span><span style="font-family: 宋体">函数定义：</span></p>
<p class="MsoNormal"><span lang="EN-US"> public ActionForward
execute(ActionMapping mapping,</span></p>
<p class="MsoNormal"><span lang="EN-US"> ActionForm
form,</span></p>
<p class="MsoNormal"><span lang="EN-US">
HttpServletRequest request,</span></p>
<p class="MsoNormal"><span lang="EN-US">
HttpServletResponse response)</span></p>
<p class="MsoNormal"><span lang="EN-US"> throws Exception </span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> // Extract attributes and
parameters we will need</span></p>
<p class="MsoNormal"><span lang="EN-US"> Locale locale =
getLocale(request);</span></p>
<p class="MsoNormal"><span lang="EN-US"> MessageResources messages =
getResources(request);</span></p>
<p class="MsoNormal"><span lang="EN-US"> HttpSession session =
request.getSession();</span></p>
<p class="MsoNormal"><span lang="EN-US"> dbListForm m_dbListForm =
(dbListForm) form;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> Connection con = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> try </span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> con =
pool.getConnection();</span></p>
<p class="MsoNormal"><span lang="EN-US"> dbListDAO m_dbListDAO =
new dbListDAO(con); //</span><span style="font-family: 宋体">定义</span><span lang="EN-US">DAO</span><span style="font-family: 宋体">对象，用于实现数据库的各种操作</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> String
action=request.getParameter("action"); //</span><span style="font-family: 宋体">动作类型</span><span lang="EN-US">
</span></p>
<p class="MsoNormal"><span lang="EN-US"> String
search=request.getParameter("search"); //</span><span style="font-family: 宋体">数据库查找方式</span></p>
<p class="MsoNormal"><span lang="EN-US"> String
expression=request.getParameter("expression"); //</span><span style="font-family: 宋体">参数，这里用于保存记录（行）的</span><span lang="EN-US">ID</span><span style="font-family: 宋体">数据</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">
if(action==null)action="find";</span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -