宠物商店Java web 源码

课堂Java web，教学使用的宠物商店，部分资源有修改，大部分类与JSP以完善

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class JDBCDelete {

	/**
	 * @param args
	 */
	public static void main（String[] args） throws Exception {
		// TODO Auto-generated method stub

		
		
		Class.forName（“com.mysql.jdbc.Driver“）.newInstance（）;
		Connection coon = DriverManager.getConnection（“jdbc:mysql://localhost:3306/petstore?useUnicode=true&characterEncoding=UTF-8““petstoreapp““123“）;
	
		PreparedStatement pst = coon.prepareStatement（“delete from inventory  where itemid = ?“）;
		pst.setString（1 “EST-30“）;
		
		int i = pst.executeUpdate（）;
		
		System.out.println（“删除“ + i + “行“）;
		
		pst.close（）;
		coon.close（）;
		
	}

}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-11-02 07:54  LYF\
     文件        1294  2018-11-02 07:54  LYF\.classpath
     文件         276  2018-11-02 07:54  LYF\.mymetadata
     文件        1744  2018-11-02 07:54  LYF\.project
     目录           0  2018-11-02 07:54  LYF\.settings\
     文件         500  2018-11-02 07:54  LYF\.settings\.jsdtscope
     文件         382  2018-11-02 07:54  LYF\.settings\com.genuitec.eclipse.migration.prefs
     文件         364  2018-11-02 07:54  LYF\.settings\org.eclipse.jdt.core.prefs
     文件         529  2018-11-02 07:54  LYF\.settings\org.eclipse.wst.common.component
     文件         412  2018-11-02 07:54  LYF\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2018-11-02 07:54  LYF\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2018-11-02 07:54  LYF\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2018-11-02 07:54  LYF\src\
     目录           0  2018-11-02 07:54  LYF\src\dao\
     文件         537  2018-11-02 07:54  LYF\src\dao\baseDao.java
     文件        2339  2018-11-02 07:54  LYF\src\dao\CategoryDao.java
     文件        2278  2018-11-02 07:54  LYF\src\dao\InventoryDao.java
     文件        3420  2018-11-02 07:54  LYF\src\dao\ItemDao.java
     文件        2703  2018-11-02 07:54  LYF\src\dao\ProductDao.java
     文件        2719  2018-11-02 07:54  LYF\src\dao\SupplierDao.java
     文件         593  2018-11-02 07:54  LYF\src\dao\TestCategoryDao.java
     文件         554  2018-11-02 07:54  LYF\src\dao\TestInventoryDao.java
     文件        1118  2018-11-02 07:54  LYF\src\dao\TestItemDao.java
     文件         740  2018-11-02 07:54  LYF\src\dao\TestProductDao.java
     文件         502  2018-11-02 07:54  LYF\src\dao\TestSupplierDao.java
     文件        1422  2018-11-02 07:54  LYF\src\dao\UserDao.java
     目录           0  2018-11-02 07:54  LYF\src\domain\
     文件         837  2018-11-02 07:54  LYF\src\domain\Category.java
     文件         622  2018-11-02 07:54  LYF\src\domain\Inventory.java
     文件        2652  2018-11-02 07:54  LYF\src\domain\Item.java
     文件        1119  2018-11-02 07:54  LYF\src\domain\Product.java
............此处省略106个文件信息