📄 in10_db_page.htm
字号:
<p class="MsoNormal"><span lang="EN-US"><td><bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><bean:write name='dbList' property='</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><bean:write name='dbList' property='</span><span style="font-family: 宋体">备注</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"></tr></span></p>
<p class="MsoNormal"><span lang="EN-US"></logic:notEqual> </span></p>
<p class="MsoNormal"><span lang="EN-US"><logic:equal name='dbListForm'
property='action' value='edit'> </span></p>
<p class="MsoNormal"><span lang="EN-US"><tr></span></p>
<p class="MsoNormal"><span lang="EN-US"><form method='post' name='dbListForm'
action="/DBApp/dbListAction.do?action=</span></p>
<p class="MsoNormal"><span lang="EN-US">
update&search=search&expression=<bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">'
/>"></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><html:text name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><html:text name='dbList' property='</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><html:text name='dbList' property='</span><span style="font-family: 宋体">备注</span><span lang="EN-US">'
/></td></span></p>
<p class="MsoNormal"><span lang="EN-US"></tr></span></p>
<p class="MsoNormal"><span lang="EN-US"></logic:equal> </span></p>
<p class="MsoNormal"><span lang="EN-US"></logic:iterate></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"><tr><td align=middle colSpan=4 ></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"><bean:write
property='pagestr' name='dbListForm' filter='false' /></span></b></p>
<p class="MsoNormal"><span lang="EN-US"></td></tr></span></p>
<p class="MsoNormal"><span lang="EN-US"></tr></span></p>
<p class="MsoNormal"><span lang="EN-US"></table></span></p>
<p class="MsoNormal"><span lang="EN-US"></body></span></p>
<p class="MsoNormal"><span lang="EN-US"></html:html></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
dbListDAO.java文件：</span></b></p>
<p class="MsoNormal"><span style="font-family: 宋体"> 这里定义一个</span><span lang="EN-US">DAO</span><span style="font-family: 宋体">类，用于实现数据加的查找、删除、更新、添加及生成分页字符串等功能。</span><span lang="EN-US">getPagestr(int
ipage)</span><span style="font-family: 宋体">函数用于生成分页字符串，</span><span lang="EN-US">int
ipage</span><span style="font-family: 宋体">参数用于转递当前页码。</span><span lang="EN-US">findSQL(String
sql,int ipage)</span><span style="font-family: 宋体">函数用于查找数据库数据，</span><span lang="EN-US">String
sql</span><span style="font-family: 宋体">参数用于转递</span><span lang="EN-US">SQL</span><span style="font-family: 宋体">查询语句字符串，</span><span lang="EN-US">int
ipage</span><span style="font-family: 宋体">参数用于转递当前页码。</span></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 class dbListDAO {</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> private Connection con;</span></p>
<p class="MsoNormal"><span lang="EN-US"> private int rowCount;</span></p>
<p class="MsoNormal"><span lang="EN-US"> private int pageCount;</span></p>
<p class="MsoNormal"><span lang="EN-US"> private int length; </span></p>
<p class="MsoNormal"><span lang="EN-US"> private String pagestr;</span></p>
<p class="MsoNormal"><span lang="EN-US"> public int getLength() { return
(this.length); }</span></p>
<p class="MsoNormal"><span lang="EN-US"> public void setLength(int length) {
this.length=length; } </span></p>
<p class="MsoNormal"><span lang="EN-US"> public String getPagestr(int ipage)</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> String strPage="";</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(getLength()>0)</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="</span><span style="font-family: 宋体">共</span><span lang="EN-US">";</span></p>
<p class="MsoNormal"><span lang="EN-US">
strPage+=String.valueOf(rowCount);</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="</span><span style="font-family: 宋体">条记录，共</span><span lang="EN-US">";</span></p>
<p class="MsoNormal"><span lang="EN-US">
strPage+=String.valueOf(pageCount);</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="</span><span style="font-family: 宋体">页，当前是第</span><span lang="EN-US">";</span></p>
<p class="MsoNormal"><span lang="EN-US">
strPage+=String.valueOf(ipage);</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="</span><span style="font-family: 宋体">页，</span><span lang="EN-US">
";</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> int istart,iend;</span></p>
<p class="MsoNormal"><span lang="EN-US"> istart=ipage-5;</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(istart<0)
{istart=0;}</span></p>
<p class="MsoNormal"><span lang="EN-US"> iend=istart+10;</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(iend>pageCount)
{iend=pageCount;}</span></p>
<p class="MsoNormal"><span lang="EN-US"> istart=iend-10;</span></p>
<p class="MsoNormal"><span lang="EN-US"> if(istart<0)
{istart=0;}</span></p>
<p class="MsoNormal"><span lang="EN-US"> for(int
i=istart;i<iend;i++)</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="<a
href='dbListAction.do?action=find&search=search&page=";</span></p>
<p class="MsoNormal"><span lang="EN-US">
strPage+=String.valueOf(i+1);</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="'>";</span></p>
<p class="MsoNormal"><span lang="EN-US">
strPage+=String.valueOf(i+1);</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+="</a>";
</span></p>
<p class="MsoNormal"><span lang="EN-US"> strPage+=" ";</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"> this.pagestr=strPage;</span></p>
<p class="MsoNormal"><span lang="EN-US"> return strPage;</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体"> </span><b><span style="font-family: 宋体"> 中间代码与分页无关，固省略。</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> public Collection findSQL(String
sql,int ipage) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> PreparedStatement ps = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> ResultSet rs = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> ArrayList list = new ArrayList();</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"> if (con.isClosed()) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new
IllegalStateException("error.unexpected");</span></p>
<p class="MsoNormal"><span lang="EN-US"> }</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps =
con.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);</span></p>
<p class="MsoNormal"><span lang="EN-US"> rs = ps.executeQuery();</span></p>
<p class="MsoNormal"><span lang="EN-US"> rs.absolute(-1);</span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -