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

  • 大小: 2.61MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2023-10-27
  • 語言: Java
  • 標簽: 購物車??

資源簡介

Java web 購物車idea工程ServletCartDemo mysql-connector-java-5.1.7-bin.jar導入到tomcat的lib目錄下面

資源截圖

代碼片段和文件信息 

package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;

import?util.DBHelper;

import?entity.Items;

//商品的業務邏輯類
public?class?ItemsDAO?{

	//?獲得所有的商品信息
	public?ArrayList?getAllItems（）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		ArrayList?list?=?new?ArrayList（）;?//?商品集合
		try?{
			conn?=?DBHelper.getConnection（）;
			String?sql?=?“select?*?from?items;“;?//?SQL語句
			stmt?=?conn.prepareStatement（sql）;
			rs?=?stmt.executeQuery（）;
			while?（rs.next（））?{
				Items?item?=?new?Items（）;
				item.setId（rs.getInt（“id“））;
				item.setName（rs.getString（“name“））;
				item.setCity（rs.getString（“city“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getInt（“price“））;
				item.setPicture（rs.getString（“picture“））;
				list.add（item）;//?把一個商品加入集合
			}
			return?list;?//?返回集合。
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放數據集對象
			if?（rs?!=?null）?{
				try?{
					rs.close（）;
					rs?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
			//?釋放語句對象
			if?（stmt?!=?null）?{
				try?{
					stmt.close（）;
					stmt?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
		}

	}

	//?根據商品編號獲得商品資料
	public?Items?getItemsById（int?id）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBHelper.getConnection（）;
			String?sql?=?“select?*?from?items?where?id=?;“;?//?SQL語句
			stmt?=?conn.prepareStatement（sql）;
			stmt.setInt（1?id）;
			rs?=?stmt.executeQuery（）;
			if?（rs.next（））?{
				Items?item?=?new?Items（）;
				item.setId（rs.getInt（“id“））;
				item.setName（rs.getString（“name“））;
				item.setCity（rs.getString（“city“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getInt（“price“））;
				item.setPicture（rs.getString（“picture“））;
				return?item;
			}?else?{
				return?null;
			}

		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放數據集對象
			if?（rs?!=?null）?{
				try?{
					rs.close（）;
					rs?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
			//?釋放語句對象
			if?（stmt?!=?null）?{
				try?{
					stmt.close（）;
					stmt?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}

		}
	}
	//獲取最近瀏覽的前五條商品信息
	public?ArrayList?getViewList（String?list）
	{
		System.out.println（“list:“+list）;
		ArrayList?itemlist?=?new?ArrayList（）;
		int?iCount=5;?//每次返回前五條記錄
		if（list!=null&&list.length（）>0）
		{
		????String[]?arr?=?list.split（“__“）;//list.split（““）
		????System.out.println（“arr.length=“+arr.length）;
		????//如果商品記錄大于等于5條
		????if（arr.length>=5）
		????{
		???????for（int?i=arr.length-1;i>=arr.length-iCount;i--）
		???????{
		????	??itemlist.add（getItemsById（Integer.parseInt（

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-03-01?16:54??ServletCartDemo\
?????目錄???????????0??2018-03-01?16:54??ServletCartDemo\.idea\
?????目錄???????????0??2018-03-01?15:28??ServletCartDemo\.idea\artifacts\
?????文件?????????535??2018-03-01?15:28??ServletCartDemo\.idea\artifacts\ServletCartDemo_war_exploded.xml
?????目錄???????????0??2018-03-01?16:09??ServletCartDemo\.idea\dataSources\
?????文件???????67016??2018-03-01?16:09??ServletCartDemo\.idea\dataSources\608c5be3-fbc4-45bd-a8c6-ffb5c7de3e75.xml
?????文件?????????835??2018-03-01?16:09??ServletCartDemo\.idea\dataSources.local.xml
?????文件?????????897??2018-03-01?16:09??ServletCartDemo\.idea\dataSources.xml
?????目錄???????????0??2018-03-01?16:54??ServletCartDemo\.idea\inspectionProfiles\
?????目錄???????????0??2018-03-01?16:31??ServletCartDemo\.idea\libraries\
?????文件?????????374??2018-03-01?16:31??ServletCartDemo\.idea\libraries\mysql_connector_java_5_1_13_bin.xml
?????文件?????????273??2018-03-01?16:17??ServletCartDemo\.idea\misc.xml
?????文件?????????270??2018-03-01?15:28??ServletCartDemo\.idea\modules.xml
?????文件???????36908??2018-03-01?16:54??ServletCartDemo\.idea\workspace.xml
?????文件????????1012??2018-03-01?16:39??ServletCartDemo\ServletCartDemo.iml
?????目錄???????????0??2018-03-01?16:43??ServletCartDemo\WEB-INF\
?????目錄???????????0??2018-03-01?16:54??ServletCartDemo\WEB-INF\classes\
?????目錄???????????0??2018-03-01?16:31??ServletCartDemo\WEB-INF\lib\
?????文件?????1429539??2018-02-28?17:23??ServletCartDemo\WEB-INF\lib\mysql-connector-java-5.1.13-bin.jar
?????文件?????????758??2018-03-01?16:43??ServletCartDemo\WEB-INF\web.xml
?????目錄???????????0??2018-03-01?15:51??ServletCartDemo\out\
?????目錄???????????0??2018-03-01?15:51??ServletCartDemo\out\artifacts\
?????目錄???????????0??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\
?????目錄???????????0??2018-03-01?16:43??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\
?????目錄???????????0??2018-03-01?15:51??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\
?????目錄???????????0??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\dao\
?????文件????????5197??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\dao\ItemsDAO.class
?????目錄???????????0??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\entity\
?????文件????????3753??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\entity\Cart.class
?????文件????????2386??2018-03-01?16:36??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\entity\Items.class
?????目錄???????????0??2018-03-01?16:50??ServletCartDemo\out\artifacts\ServletCartDemo_war_exploded\WEB-INF\classes\servlet\
............此處省略173個文件信息

評論

共有 條評論