📄 in9_db.htm
字号:
<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 lang="EN-US"> public dbListDAO(Connection con) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> this.con = con;</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"> public void create(dbList m_dbList)
throws SQLException {</span></p>
<p class="MsoNormal"><span lang="EN-US"> PreparedStatement ps = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<createSQL></span></p>
<p class="MsoNormal"><span lang="EN-US"> String sql = "INSERT INTO dbo.Test
VALUES (?,?,?)";</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</createSQL></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"> //</span><span style="font-family: 宋体">用</span><span lang="EN-US">SQL
Server</span><span style="font-family: 宋体">请加入下行</span><span lang="EN-US">:
</span></p>
<p class="MsoNormal"><span lang="EN-US"> //con.setAutoCommit(true);</span></p>
<p class="MsoNormal"><span lang="EN-US"> //SQL Server</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps = con.prepareStatement(sql);</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<create></span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setInt(1,m_dbList.get</span><span style="font-family: 宋体">序号</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setString(2,m_dbList.get</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setString(3,m_dbList.get</span><span style="font-family: 宋体">备注</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</create></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> if (ps.executeUpdate() != 1) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new SQLException
("error.create.dbList");</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"> </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"> } 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"> } 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"> public void update(dbList
m_dbList,String keyID) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> PreparedStatement ps = null;</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<updateSQL></span></p>
<p class="MsoNormal"><span lang="EN-US"> String sql = "UPDATE dbo.Test SET
</span><span style="font-family: 宋体">序号</span><span lang="EN-US"> = ?,</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">
= ?,</span><span style="font-family: 宋体">备注</span><span lang="EN-US"> = ? WHERE
</span><span style="font-family: 宋体">序号</span><span lang="EN-US"> = ?";</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</updateSQL></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"> //</span><span style="font-family: 宋体">用</span><span lang="EN-US">SQL
Server</span><span style="font-family: 宋体">请加入下行</span><span lang="EN-US">:
</span></p>
<p class="MsoNormal"><span lang="EN-US"> //con.setAutoCommit(true);</span></p>
<p class="MsoNormal"><span lang="EN-US"> //SQL Server</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps = con.prepareStatement(sql);</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<update></span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setInt(1,m_dbList.get</span><span style="font-family: 宋体">序号</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setString(2,m_dbList.get</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">());</span></p>
<p class="MsoNormal"><span lang="EN-US"> ps.setString(3,m_dbList.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"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> ///////////////</span></p>
<p class="MsoNormal"><span lang="EN-US"> //<updatekeyID></span></p>
<p class="MsoNormal"><span lang="EN-US">
ps.setInt(4,java.lang.Integer.parseInt(keyID,10));</span></p>
<p class="MsoNormal"><span lang="EN-US"> //</updatekeyID></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 (ps.executeUpdate() != 1) {</span></p>
<p class="MsoNormal"><span lang="EN-US"> throw new SQLException (</span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -