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個文件信息