資源簡(jiǎn)介
jsp網(wǎng)頁(yè)超級(jí)給力的。自己期末作業(yè)jsp網(wǎng)頁(yè)超級(jí)給力的。自己期末作業(yè)

代碼片段和文件信息
package?com.etc.dao;
import?java.math.BigDecimal;
import?java.util.List;
import?com.etc.entity.Dele;
import?com.etc.util.DButil;
import?com.etc.util.PageBean;
public?class?Dele_Dao?{
public??int?addDele(Dele?dele){
String?sql=“insert?into?DELE(DE_IDDE_USERDE_CLASSDE_POSTDE_GEO)?values(?????)“;
return?DButil.update(sql?new?object[]{dele.getDE_ID()dele.getDE_USER()dele.getDE_CLASS()dele.getDE_POST()dele.getDE_GEO()});
}
public?static??int?deleteDele(int?DE_ID){
String?sql=“delete?from?DELE?where?DE_ID=?“;
return?DButil.update(sql?new?object[]{DE_ID});
}
public?int?updateDele(Dele?dele){
String?sql=“update?DELE?set?DE_USER=??DE_CLASS=?DE_POST=?DE_GEO=??where?DE_ID=??“;
return?DButil.update(sql?new?object[]{dele.getDE_USER()dele.getDE_CLASS()dele.getDE_POST()dele.getDE_GEO()dele.getDE_ID()});
}
public?Listject[]>findAll(){
String?sql=“select?DE_IDDE_USERDE_CLASSDE_POST?DE_GEO?from?DELE“;
return?DButil.executeQuery(sql?null);
}
public?static?Listject[]>findById(int?DE_ID){
String?sql=“select?DE_IDDE_USERDE_CLASSDE_POST?DE_GEO?from?DELE?where?DE_ID=?“;
return?DButil.executeQuery(sql?new?object[]{DE_ID});
}
public?PageBean?findByPageBean(PageBean?pageBean){
String?sql=“select?DE_IDDE_USERDE_CLASSDE_POST?DE_GEO?from?(select?a.*rownum?rn?from?(select?*?from?DELE??where?rownum<=???order?by?DE_ID)a)?where?rn>=?“;
Listject[]>dele=?DButil.executeQuery(sql?new?object[]{pageBean.getLastRecord()pageBean.getFirstRecord()});
????pageBean.setList(dele);
????return?pageBean;
}
public?PageBean?findByConditionAndPageBean(PageBean?pageBeanString?conditionsql){
String?sql=“select?DE_IDDE_USERDE_CLASSDE_POST?DE_GEO?from(select?a.*rownum?rn?from?(?“+conditionsql+“?)a?where?rownum<=?)?where?rn>=?“;
Listject[]>dele=?DButil.executeQuery(sqlnew?object[]{pageBean.getLastRecord()pageBean.getFirstRecord()});
?pageBean.setList(dele);
????return?pageBean;
}
public?int?getCount()?{
String?sql=“select?count(*)?from?dele“;
Listject[]>dele=DButil.executeQuery(sql?null);
return?((BigDecimal)dele.get(0)[0]).intValue();
}
public?int?getCount(String?sql)?{
Listject[]>list=DButil.executeQuery(sql?null);
return?list.size();
}
????
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????786??2011-04-02?09:03??web\.classpath
?????文件????????282??2011-04-02?16:03??web\.myme
?????文件???????1409??2011-04-02?16:03??web\.project
?????文件????????500??2011-04-02?16:03??web\.settings\.jsdtscope
?????文件???????1286??2011-04-02?16:03??web\.settings\.svn\all-wcprops
?????文件???????1314??2011-04-03?09:22??web\.settings\.svn\entries
?????文件????????500??2011-04-02?16:03??web\.settings\.svn\text-ba
?????文件????????106??2011-04-02?16:03??web\.settings\.svn\text-ba
?????文件????????330??2011-04-02?16:03??web\.settings\.svn\text-ba
?????文件?????????49??2011-04-02?16:03??web\.settings\.svn\text-ba
?????文件??????????6??2011-04-02?16:03??web\.settings\.svn\text-ba
?????文件????????106??2011-04-02?16:03??web\.settings\org.eclipse.core.resources.prefs
?????文件????????330??2011-04-02?16:03??web\.settings\org.eclipse.jdt.core.prefs
?????文件?????????49??2011-04-02?16:03??web\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2011-04-02?16:03??web\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????676??2011-04-02?16:03??web\.svn\all-wcprops
?????文件????????886??2011-04-03?09:22??web\.svn\entries
?????文件????????786??2011-04-02?09:03??web\.svn\text-ba
?????文件????????282??2011-04-02?16:03??web\.svn\text-ba
?????文件???????1409??2011-04-02?16:03??web\.svn\text-ba
?????文件????????157??2011-04-02?16:03??web\src\.svn\all-wcprops
?????文件????????305??2011-04-03?09:22??web\src\.svn\entries
?????文件????????161??2011-04-02?16:03??web\src\com\.svn\all-wcprops
?????文件????????309??2011-04-03?09:22??web\src\com\.svn\entries
?????文件????????165??2011-04-02?16:03??web\src\com\etc\.svn\all-wcprops
?????文件????????362??2011-04-03?09:22??web\src\com\etc\.svn\entries
?????文件???????1542??2011-04-02?16:03??web\src\com\etc\dao\.svn\all-wcprops
?????文件???????1622??2011-04-03?09:22??web\src\com\etc\dao\.svn\entries
?????文件???????2331??2011-04-02?16:03??web\src\com\etc\dao\.svn\text-ba
?????文件???????2693??2011-04-02?16:03??web\src\com\etc\dao\.svn\text-ba
............此處省略829個(gè)文件信息
評(píng)論
共有 條評(píng)論