📄 in10_db_page.htm
字号:
<p class="MsoNormal"><span lang="EN-US">
if(search==null)search="UNsearch";</span></p>
<p class="MsoNormal"><span lang="EN-US">
if(expression==null)expression="";</span></p>
<p class="MsoNormal"><span lang="EN-US">
expression=toChinese(expression); //</span><span style="font-family: 宋体">处理中文问题</span><span lang="EN-US">,</span><span style="font-family: 宋体">实现编码转换</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">
if("delete".equals(action)) //</span><span style="font-family: 宋体">删除记录操作</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US">
m_dbListDAO.removeID(expression);</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">
if("update".equals(action)||"insert".equals(action)) //</span><span style="font-family: 宋体">更新、添加记录操作</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> dbList m_dbList= new
dbList(); </span></p>
<p class="MsoNormal"><span lang="EN-US"> //<update></span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">序号</span><span lang="EN-US">(m_dbListForm.get</span><span style="font-family: 宋体">序号</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">(m_dbListForm.get</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> m_dbList.set</span><span style="font-family: 宋体">备注</span><span lang="EN-US">(m_dbListForm.get</span><span style="font-family: 宋体">备注</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</update></span></p>
<p class="MsoNormal"><span lang="EN-US">
if("update".equals(action)) //</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">
m_dbListDAO.update(m_dbList,expression);</span></p>
<p class="MsoNormal"><span lang="EN-US">
if("insert".equals(action)) //</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">
m_dbListDAO.create(m_dbList);</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"> //<sqlstr></span></p>
<p class="MsoNormal"><span lang="EN-US"> String sql="SELECT *
FROM dbo.Test";</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</sqlstr></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> ////SQL</span><span style="font-family: 宋体">字符处理</span></p>
<p class="MsoNormal"><span lang="EN-US">
if("search".equals(search))</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<search></span></p>
<p class="MsoNormal"><span lang="EN-US"> sql+=" where ";</span></p>
<p class="MsoNormal"><span lang="EN-US"> sql+="</span><span style="font-family: 宋体">序号</span><span lang="EN-US">";</span></p>
<p class="MsoNormal"><span lang="EN-US"> sql+="=";</span></p>
<p class="MsoNormal"><span lang="EN-US">
if("NULL".equals(expression)||"".equals(expression))</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US">
sql+=m_dbListForm .get</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"> else</span></p>
<p class="MsoNormal"><span lang="EN-US"> {</span></p>
<p class="MsoNormal"><span lang="EN-US">
sql+=expression;</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"> sql+="";</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</search></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><b>
<span lang="EN-US" style="font-family:黑体"> //<分页></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
m_dbListDAO.setLength(10);//设置每页显示记录数</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
int ipage;//当前页</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
try </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> {</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
String page=request.getParameter("page");//分页参数,读取请求的当前页</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
ipage=java.lang.Integer.parseInt(page,10);</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> }</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
catch (Exception e) </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> {</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
ipage=m_dbListForm.getPage();</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> }
</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
if(ipage<1)ipage=1;</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
Collection col = m_dbListDAO.findSQL(sql,ipage);//通过DAO对象查询数据</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
request.setAttribute("dbList",col); //保存数据 </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
String pagestr=m_dbListDAO.getPagestr(ipage);//分页字符串,分页内容</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
String s_find,str;</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
if(!"search".equals(search))
//查找和全部显示两个不同的操作,其分页字符串不同,在此进行处理。如果是全部显示则去掉"search=search&"</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> {</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
s_find="search=search&";</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
while(pagestr.indexOf(s_find)!=-1)</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
{</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
str=pagestr.substring(0,pagestr.indexOf(s_find));</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
str+=pagestr.substring(pagestr.indexOf(s_find)+s_find.length(),pagestr.length());</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
pagestr=str;</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
}</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体"> }</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
m_dbListForm.setPagestr(pagestr); </span></b></p>
<p class="MsoNormal"><b><s
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -