91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 2.91MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2023-09-08
  • 語言: Java
  • 標簽:

資源簡介

這是自己摸索做出來的東西,希望大家多多支持哦!!!

資源截圖

代碼片段和文件信息

package?com.wy.dao;

import?java.sql.*;
import?java.util.*;

import?com.wy.tool.JDBConnection;
import?com.wy.domain.AfficheForm;

//對公告信息的操作
public?class?AfficheDao?{
??private?Connection?connection?=?null;?//定義連接的對象
??private?PreparedStatement?ps?=?null;?//定義預準備的對象
??private?JDBConnection?jdbc?=?null;?//定義數據庫連接對象
??public?AfficheDao()?{
????jdbc?=?new?JDBConnection();
????connection?=?jdbc.connection;?//利用構造方法取得數據庫連接
??}

??//刪除的方法
??public?void?deleteAffiche(Integer?id)?{
????try?{
??????ps?=?connection.prepareStatement(“delete?from?tb_affiche?where?id=?“);
??????ps.setInt(1?id.intValue());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}

??//修改的方法
??public?void?updateAffiche(AfficheForm?form)?{
????try?{
??????ps?=?connection.prepareStatement(“update?tb_affiche?set?name=?content=??where?id=?“);
??????ps.setString(1?form.getName());
??????ps.setString(2?form.getContent());
??????ps.setInt(3?form.getId().intValue());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}

//添加的方法
??public?void?insertAffiche(AfficheForm?form)?{
????try?{
??????ps?=?connection.prepareStatement(“insert?into?tb_affiche?values?(??getDate())“);
??????ps.setString(1?form.getName());
??????ps.setString(2?form.getContent());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}

//以數據庫流水號為條件查詢信息
??public?AfficheForm?selectOneAffiche(Integer?id)?{
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement(“select?*?from?tb_affiche?where?id=?“);
??????ps.setInt(1?id.intValue());
??????ResultSet?rs?=?ps.executeQuery();
??????while?(rs.next())?{
????????affiche?=?new?AfficheForm();
????????affiche.setId(Integer.valueOf(rs.getString(1)));
????????affiche.setName(rs.getString(2));
????????affiche.setContent(rs.getString(3));
????????affiche.setIssueTime(rs.getString(4));
??????}
????}
????catch?(SQLException?ex)?{
????}
????return?affiche;
??}

//全部查詢的方法
??public?List?selectAffiche()?{
????List?list?=?new?ArrayList();
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement(“select?*?from?tb_affiche?order?by?id?DESC“);
??????ResultSet?rs?=?ps.executeQuery();
??????while?(rs.next())?{
????????affiche?=?new?AfficheForm();
????????affiche.setId(Integer.valueOf(rs.getString(1)));
????????affiche.setName(rs.getString(2));
????????affiche.setContent(rs.getString(3));
????????affiche.setIssueTime(rs.getString(4));
????????list.add(affiche);
??????}
????}
????catch?(SQLException?ex)?{
????}
????return?list;

??}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????2096??2007-11-26?18:37??03\bg-afficheContent.jsp

?????文件???????2240??2007-11-26?18:37??03\bg-afficheInsert.jsp

?????文件???????3636??2007-11-26?18:37??03\bg-afficheSelect.jsp

?????文件???????2533??2007-11-26?18:37??03\bg-afficheUpdate.jsp

?????文件???????2067??2007-11-26?19:39??03\bg-bigTypeInsert.jsp

?????文件????????392??2007-11-26?18:37??03\bg-bigTypeResult.jsp

?????文件???????3574??2007-11-26?18:37??03\bg-bigTypeSelect.jsp

?????文件????????903??2007-11-26?18:37??03\bg-checkMemberResult.jsp

?????文件????????222??2007-11-26?18:37??03\bg-down.jsp

?????文件???????4763??2007-01-08?11:25??03\bg-goodInsert.jsp

?????文件???????4259??2007-11-26?18:37??03\bg-goodSelect.jsp

?????文件???????3921??2007-11-26?18:37??03\bg-goodSelectBig.jsp

?????文件???????3952??2007-11-26?19:47??03\bg-goodSelectContent.jsp

?????文件???????3935??2007-11-26?18:37??03\bg-goodSelectSmall.jsp

?????文件???????4340??2007-11-26?18:37??03\bg-goodsFreePirce.jsp

?????文件???????3890??2007-11-26?18:37??03\bg-goodsMarkSelect.jsp

?????文件????????390??2007-11-26?18:37??03\bg-goodsResult.jsp

?????文件???????1954??2007-11-26?18:37??03\bg-land.jsp

?????文件????????655??2007-11-26?18:37??03\bg-landResult.jsp

?????文件???????6163??2007-11-26?18:37??03\bg-left.jsp

?????文件???????2351??2007-11-26?18:37??03\bg-linkInsert.jsp

?????文件???????3381??2007-11-26?18:37??03\bg-linkSelect.jsp

?????文件???????2632??2007-11-26?18:37??03\bg-managerInsert.jsp

?????文件???????3878??2007-11-26?20:05??03\bg-managerSelect.jsp

?????文件???????3246??2007-11-26?18:37??03\bg-managerUpdatePassword.jsp

?????文件????????795??2007-11-26?18:37??03\bg-memberSuccess.jsp

?????文件???????3985??2007-11-26?18:37??03\bg-orderContent.jsp

?????文件???????4548??2007-11-26?18:37??03\bg-orderSelect.jsp

?????文件????????401??2007-11-26?18:37??03\bg-resultMember.jsp

?????文件???????2306??2007-11-26?18:37??03\bg-resultTen.jsp

............此處省略203個文件信息

評論

共有 條評論

相關資源