package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?baseDao?{
	public?static?final?String?DRIVER=“com.mysql.jdbc.Driver“;
	public?static?final?String?URL=“jdbc:mysql://localhost:3306/petshop“;
	public?static?final?String?NAME=“root“;
	public?static?final?String?PWD=“root“;
	//獲得連接
	public?static?Connection?getConn（）{
		Connection?conn=null;
			try?{
				Class.forName（DRIVER）;
				conn=?DriverManager.getConnection（URLNAMEPWD）;
			}?catch?（ClassNotFoundException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				System.out.println（“加載驅動失敗“）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		return?conn;
	}
	//關閉連接
	public?static?void?closeAll（Connection?connPreparedStatement?psResultSet?rs）{
	try?{
		if（rs!=null）{
			rs.close（）;
			rs=null;
		}
		if（ps!=null）{
			ps.close（）;
			ps=null;
		}
		if（conn!=null）{
			conn.close（）;
			conn=null;
		}
	}?catch?（SQLException?e）?{
		//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
}

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

?????文件???????1177??2015-12-02?11:53??寵物小成\.classpath

?????文件???????1041??2015-11-29?19:53??寵物小成\.project

?????文件????????567??2015-11-29?19:53??寵物小成\.settings\.jsdtscope

?????文件????????364??2015-11-29?19:53??寵物小成\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2015-11-29?19:54??寵物小成\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-11-29?19:53??寵物小成\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-11-29?19:53??寵物小成\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-11-29?19:53??寵物小成\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1730??2015-12-05?12:06??寵物小成\build\classes\dao\baseDao.class

?????文件???????3300??2015-12-05?12:06??寵物小成\build\classes\dao\MasterDao.class

?????文件???????6920??2015-12-05?14:19??寵物小成\build\classes\dao\PetDao.class

?????文件???????3141??2015-12-05?12:06??寵物小成\build\classes\dao\Pet_typeDao.class

?????文件???????1091??2015-12-05?12:06??寵物小成\build\classes\entity\Master.class

?????文件???????2046??2015-12-05?12:06??寵物小成\build\classes\entity\Pet.class

?????文件????????718??2015-12-05?12:06??寵物小成\build\classes\entity\Pet_type.class

?????文件???????1270??2015-12-05?12:06??寵物小成\build\classes\servlet\AddPetServlet.class

?????文件???????1728??2015-12-05?12:06??寵物小成\build\classes\servlet\AddPetTypeServlet.class

?????文件???????1755??2015-12-05?12:06??寵物小成\build\classes\servlet\CheckNameServlet.class

?????文件???????2127??2015-12-05?12:06??寵物小成\build\classes\servlet\DelAllpetServlet.class

?????文件???????5699??2015-12-05?12:06??寵物小成\build\classes\servlet\DoAddPetServlet.class

?????文件???????1382??2015-12-05?12:06??寵物小成\build\classes\servlet\DoAddPetTypeServlet.class

?????文件???????1548??2015-12-05?12:06??寵物小成\build\classes\servlet\DoDeletePetServlet.class

?????文件???????1553??2015-12-05?12:06??寵物小成\build\classes\servlet\DoDeletePetTypeSerlet.class

?????文件???????3688??2015-12-05?12:06??寵物小成\build\classes\servlet\DonwLoadServlet.class

?????文件???????2452??2015-12-05?12:06??寵物小成\build\classes\servlet\DoUpdatePetServlet.class

?????文件???????1712??2015-12-05?12:06??寵物小成\build\classes\servlet\DoUpdatePetTypeServlet.class

?????文件???????1801??2015-12-05?12:06??寵物小成\build\classes\servlet\IndexServlet.class

?????文件???????1824??2015-12-05?12:06??寵物小成\build\classes\servlet\LingYangPetServlet.class

?????文件???????2143??2015-12-05?13:48??寵物小成\build\classes\servlet\listPetsServlet.class

?????文件???????1678??2015-12-05?12:06??寵物小成\build\classes\servlet\LoginServlet.class

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