資源簡介
代碼片段和文件信息
package?com.bean;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Calendar;
import?java.util.List;
import?com.util.Constant;
import?com.util.DBO;
public?class?ComBean?{
private?List?list;
private?ResultSet?rs?=?null;
private?int?EVERYPAGENUM?=?2;
private?int?count?=?-1;
private?int?qq?=?0;
?
//聲明時間變量
String?date1=new?SimpleDateFormat（“yyyy-MM-dd“）.format（Calendar.getInstance（）.getTime（））;
String?date=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）.format（Calendar.getInstance（）.getTime（））;
//分頁查詢所有個人會員
public?void?setEVERYPAGENUM（int?EVERYPAGENUM）{
???? this.EVERYPAGENUM=EVERYPAGENUM;
????}
????public?int?getMessageCount（String?sql）?{?//得到信息總數
???????DBO?dbo=new?DBO（）;
???????dbo.open（）;
????????try?{?
????????????rs?=?dbo.executeQuery（sql）;
????????????rs.next（）;
????????????count?=?rs.getInt（1）;
????????????return?count;
????????}?catch?（SQLException?ex）?{
????????????ex.printStackTrace（）;
????????????return?-1;
????????}?finally?{
????????????dbo.close（）;
????????}
????}
????public?int?getPageCount（）?{?//得到共多少頁（根據每頁要顯示幾條信息）
????????if?（count?%?EVERYPAGENUM?==?0）?{
????????????return?count?/?EVERYPAGENUM;
????????}?else?{
????????????return?count?/?EVERYPAGENUM?+?1;
????????}
????}
????public?List?getMessage（int?pageString?sql2int?rr）?{?//得到每頁要顯示的信息
????????DBO?dbo=new?DBO（）;
????????dbo.open（）;
????????List?list?=?new?ArrayList（）;
????????try?{
????????????rs?=?dbo.executeQuery（sql2）;
????????????for?（int?i?=?0;?i?????????????????rs.next（）;
????????????}
????????????for?（int?t?=?0;?t?????????????????if?（rs.next（））?{
????????????????????qq++;
????????????????????List?list2=new?ArrayList（）;
????????????????????for（int?cc=1;cc<=rr;cc++）{
???????????????????? list2.add（rs.getString（cc））;
????????????????????}
???? list.add（list2）;
????????????????}?else?{
????????????????????break;?//減少空循環的時間
????????????????}
????????????}
????????????return?list;
????????}?catch?（SQLException?ex）?{
????????????ex.printStackTrace（）;
????????????return?null;
????????}?finally?{
????????????dbo.close（）;
????????}
????}
????
public?int?comUp（String?sql）{
DBO?dbo?=?new?DBO（）;
dbo.open（）;
try{
int?i?=?dbo.executeUpdate（sql）;
if（i?==?1）{
return?Constant.SUCCESS;
}
else{
return?Constant.SYSTEM_ERROR;
}
}catch（Exception?e）{
e.printStackTrace（）;
return?Constant.SYSTEM_ERROR;
}finally{
dbo.close（）;
}
}
public?List?getCom（String?sqlint?row）{
//String?sql?=?“select?*?from?bank?where?uid=‘“+uid+“‘?order?by?id?desc?“;
DBO?dbo?=?new?DBO（）;
list?=?new?ArrayList（）;
dbo.open（）;
try{
rs?=?dbo.executeQuery（sql）;
while（rs.next（））{
List?list2?=?new?ArrayList（）;
for（int?i=1;i<=row;i++）{
list2.add（rs.getString（i））;
}
list.add（list?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???24000000??2016-11-30?11:41??558JSP+MYSQL文檔管理系統\JSP文檔管理系統mysql錄像.avi
?????文件???????1730??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.classpath
?????文件????????285??2014-02-25?20:45??558JSP+MYSQL文檔管理系統\wdgl\.myme
?????文件???????1747??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.project
?????文件????????500??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.settings\.jsdtscope
?????文件????????125??2014-02-25?21:07??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.core.resources.prefs
?????文件????????629??2013-06-16?17:26??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.jdt.core.prefs
?????文件????????450??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.wst.common.component
?????文件????????252??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2013-06-16?17:12??558JSP+MYSQL文檔管理系統\wdgl\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????4337??2013-06-16?17:35??558JSP+MYSQL文檔管理系統\wdgl\src\com\bean\ComBean.java
?????文件????????318??2013-06-16?17:33??558JSP+MYSQL文檔管理系統\wdgl\src\com\util\CheckCode.java
?????文件???????1838??2013-06-16?17:33??558JSP+MYSQL文檔管理系統\wdgl\src\com\util\Common.java
?????文件????????533??2013-06-16?17:33??558JSP+MYSQL文檔管理系統\wdgl\src\com\util\Constant.java
?????文件???????2423??2016-11-30?11:35??558JSP+MYSQL文檔管理系統\wdgl\src\com\util\DBO.java
?????文件????????650??2013-06-16?17:33??558JSP+MYSQL文檔管理系統\wdgl\src\com\util\Filter.java
?????文件???????4784??2012-02-20?21:53??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\bx\index.jsp
?????文件???????4407??2012-02-20?19:55??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\cc\add.jsp
?????文件???????3899??2012-02-20?20:05??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\cc\index.jsp
?????文件???????1365??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\css\default.gif
?????文件????????617??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\css\login.css
?????文件???????2884??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\css\public.css
?????文件???????4536??2012-02-29?20:01??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\if
?????文件???????2480??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\if
?????文件???????2987??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\if
?????文件?????389426??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\images\2.jpg
?????文件???????1135??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\images\addNote.gif
?????文件???????5551??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\images\bg.gif
?????文件???????4467??2012-02-20?16:32??558JSP+MYSQL文檔管理系統\wdgl\WebRoot\admin\images\bg_banner_menu.gif
............此處省略165個文件信息
- 上一篇：java視頻上傳，轉碼，截圖，播放實現
- 下一篇：CXF接口所有所需jar包
評論
共有 條評論
川公網安備 51152502000135號