package?model;

import?java.sql.*;

public?class?Dao?{
	public?static?Connection?con=null;
	public?static?ResultSet?rs=null;
	public?static?PreparedStatement?pst=null;
	public?static?Statement?st=null;
	
	public??Connection?getConnection（）?throws?SQLException
	{	
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
		????con=DriverManager.getConnection（“jdbc:oracle:thin:@localhost:1521:Daniel“?“scott“?“tiger“）;
		????return?con;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?自動生成?catch?塊
			e.printStackTrace（）;
			return?null;
		}
		
	}
	public?void?preparedStatement（String?sql）?throws?SQLException
	{
		con=getConnection（）;
		pst=con.prepareStatement（sql）;
		
	}
	public?void?setInt（int?idint?value）?throws?SQLException
	{	
		pst.setInt（id?value）

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

?????文件????????774??2007-11-29?10:36??小型購物網站\小型購物網站\代碼\business\.classpath

?????文件????????297??2007-12-18?20:33??小型購物網站\小型購物網站\代碼\business\.mymetadata

?????文件???????1226??2007-11-22?16:32??小型購物網站\小型購物網站\代碼\business\.project

?????文件????????101??2007-12-11?11:19??小型購物網站\小型購物網站\代碼\business\.settings\org.eclipse.core.resources.prefs

?????文件???????2089??2007-12-01?10:47??小型購物網站\小型購物網站\代碼\business\src\model\Dao.java

?????文件???????1696??2007-12-01?10:46??小型購物網站\小型購物網站\代碼\business\src\model\Good.java

?????文件???????5402??2007-12-11?08:59??小型購物網站\小型購物網站\代碼\business\src\model\GoodDao.java

?????文件???????1201??2007-12-02?10:53??小型購物網站\小型購物網站\代碼\business\src\model\SendMail.java

?????文件???????1282??2007-11-29?00:41??小型購物網站\小型購物網站\代碼\business\src\model\Upload.java

?????文件???????2038??2007-11-29?13:15??小型購物網站\小型購物網站\代碼\business\src\model\UploadDao.java

?????文件????????881??2007-10-08?17:03??小型購物網站\小型購物網站\代碼\business\src\model\User.java

?????文件???????3372??2007-12-02?19:53??小型購物網站\小型購物網站\代碼\business\src\model\UserDao.java

?????文件???????2204??2007-11-29?14:38??小型購物網站\小型購物網站\代碼\business\src\servlet\Bike.java

?????文件???????1675??2007-11-26?17:01??小型購物網站\小型購物網站\代碼\business\src\servlet\Business.java

?????文件???????2056??2007-11-26?17:36??小型購物網站\小型購物網站\代碼\business\src\servlet\BuyGood.java

?????文件???????1896??2007-12-02?11:10??小型購物網站\小型購物網站\代碼\business\src\servlet\Check.java

?????文件???????1768??2007-11-26?17:03??小型購物網站\小型購物網站\代碼\business\src\servlet\DeleteBuy.java

?????文件???????2287??2007-12-02?19:15??小型購物網站\小型購物網站\代碼\business\src\servlet\DeleteFile.java

?????文件???????1763??2007-12-01?11:47??小型購物網站\小型購物網站\代碼\business\src\servlet\DeleteGood.java

?????文件???????1932??2007-11-29?14:24??小型購物網站\小型購物網站\代碼\business\src\servlet\DeleteSessionGood.java

?????文件???????1956??2007-11-26?13:05??小型購物網站\小型購物網站\代碼\business\src\servlet\doEdit.java

?????文件???????3234??2007-12-02?19:30??小型購物網站\小型購物網站\代碼\business\src\servlet\doUpload.java

?????文件???????2019??2007-11-29?13:20??小型購物網站\小型購物網站\代碼\business\src\servlet\Download.java

?????文件???????1794??2007-11-26?16:44??小型購物網站\小型購物網站\代碼\business\src\servlet\EditGood.java

?????文件???????2000??2007-12-02?20:05??小型購物網站\小型購物網站\代碼\business\src\servlet\EditPwd.java

?????文件???????2025??2007-11-28?23:52??小型購物網站\小型購物網站\代碼\business\src\servlet\Ide.java

?????文件???????1661??2007-11-27?18:45??小型購物網站\小型購物網站\代碼\business\src\servlet\Index.java

?????文件???????2395??2007-11-29?15:01??小型購物網站\小型購物網站\代碼\business\src\servlet\InsertSessionGood.java

?????文件???????2667??2007-12-13?09:12??小型購物網站\小型購物網站\代碼\business\src\servlet\Login.java

?????文件???????1813??2007-11-27?16:50??小型購物網站\小型購物網站\代碼\business\src\servlet\Mail.java

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