package?it.cn.dao;

import?java.sql.Connection;
import?java.sql.Driver;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.List;

import?javax.sql.DataSource;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanListHandler;
import?org.apache.taglibs.standard.tag.common.sql.DataSourceUtil;

import?it.cn.domain.Product;
import?it.cn.utils.DataSourceUtils;
import?it.cn.utils.JdbcUtils;

public?class?ProductDao?{
????????
	public?Product?findProduct（Product?pro）?{
????????//String?sql?=“select?*?from?product“;
		String?sql?=“select?*?from?product?where?proname=‘“+pro.getProname（）+“‘“;
		System.out.println（“sql:?“?+?sql）;
		System.out.println（“select?pro?“?+?pro.getProname（））;
	????Connection?con?=null;
	????Statement???st?=null;
	????ResultSet???re?=null;
	????try?{
			con?=?JdbcUtils.getConnection（）;
????????????st?=con.createStatement（）;
//			st?=?con.prepareStatement（）;
			//ps?=?con.prepareStatement（sql）;
			//ps.setString（1pro.getProname（））;
			re=st.executeQuery（sql）;
			if（re.next（））{
				System.out.println（“proid“?+?re.getInt（“proid“））;
				Product?p?=?new?Product（）;
				p.setProname（re.getString（“proname“））;
				p.setProprice（re.getString（“proprice“））;
				p.setProaddress（re.getString（“proaddress“））;
				p.setProimage（re.getString（“proimage“））;
				return?p;
			}
			
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			try?{
				re.close（）;
				st.close（）;				
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			
		}
	????
		return?null;
	}

	public?boolean?addProduct（Product?pro）??{
		//?TODO?Auto-generated?method?stub
		String?sql?=?“insert?into?product?values（?????）“;
		Connection?con?=null;
		String?name?=pro.getProname（）;
	
		
		try?{
			con=JdbcUtils.getConnection（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		PreparedStatement?ps?=?null;
		
		try?{
			ps?=?con.prepareStatement（sql）;
			ps.setString（1?null）;
			ps.setString（2?pro.getProname（））;
			ps.setString（3?pro.getProprice（））;
			ps.setString（4?pro.getProaddress（））;
			ps.setString（5?null）;
			ps.executeUpdate（）;
//			System.out.print（pro.getProname（））;
		}?
		
		catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			try?{
				ps.close（）;
			}?catch?（SQLException?e1）?{
				//?TODO?Auto-generated?catch?block
				e1.printStackTrace（）;
			}
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-11-22?18:31??demo\
?????文件?????????655??2016-11-22?18:31??demo\.classpath
?????目錄???????????0??2016-11-20?19:40??demo\.myeclipse\
?????文件?????????285??2016-11-20?19:40??demo\.mymetadata
?????文件????????1747??2016-11-20?20:40??demo\.project
?????目錄???????????0??2016-11-21?16:32??demo\.settings\
?????文件?????????500??2016-11-20?19:40??demo\.settings\.jsdtscope
?????文件??????????72??2016-11-21?16:32??demo\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2016-11-20?19:40??demo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????450??2016-11-20?19:40??demo\.settings\org.eclipse.wst.common.component
?????文件?????????252??2016-11-20?19:40??demo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-11-20?19:40??demo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-11-20?19:40??demo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2016-12-02?17:03??demo\lib\
?????文件????????2850??2016-11-22?18:31??demo\lib\AbsoluteLayout.jar
?????文件??????610790??2016-12-02?17:03??demo\lib\c3p0-0.9.1.2.jar
?????文件??????232019??2016-12-02?17:03??demo\lib\commons-beanutils-1.8.3.jar
?????文件??????160519??2016-12-02?17:03??demo\lib\commons-dbcp-1.4.jar
?????文件???????49572??2016-12-02?17:03??demo\lib\commons-dbutils-1.4.jar
?????文件???????60841??2016-12-02?17:03??demo\lib\commons-logging-1.1.1.jar
?????文件??????100472??2016-12-02?17:03??demo\lib\commons-pool-1.5.6.jar
?????文件???????20682??2016-12-02?17:03??demo\lib\jstl.jar
?????文件??????875339??2016-12-02?17:03??demo\lib\mysql-connector-java-5.1.28-bin.jar
?????文件??????105990??2016-11-25?16:08??demo\lib\servlet-2_5-api.jar
?????文件??????393259??2016-12-02?17:03??demo\lib\standard.jar
?????文件??????118103??2016-11-22?18:31??demo\lib\swing-layout-1.0.3.jar
?????目錄???????????0??2016-12-01?23:17??demo\src\
?????文件?????????321??2016-11-30?23:10??demo\src\c3p0-config.xml
?????目錄???????????0??2016-11-20?21:10??demo\src\it\
?????目錄???????????0??2016-11-25?15:35??demo\src\it\cn\
?????目錄???????????0??2016-11-25?17:59??demo\src\it\cn\dao\
............此處省略91個(gè)文件信息