package?com.member.dao;

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

public?class?baseDao?{
	public?static?final?String?driver=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	public?static?final?String?url=“jdbc:sqlserver://localhost:1433;databaseName=MemberInfo“;
	public?static?final?String?user=“sa“;
	public?static?final?String?pass=“sa“;
	
	/**
	?*?得到數據庫連接
	?*?@return
	?*/
	public?static?Connection?getConn（）{
		Connection?conn=null;
		try{
			Class.forName（driver）;
			conn=DriverManager.getConnection（url?user?pass）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
		return?conn;
	}
	
	/**
	?*?關閉釋放資源
	?*?@param?conn
	?*?@param?pstmt
	?*?@param?rs
	?*/
	public?static?void?c

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-08-19?16:59??20110717ACCPS2考試\
?????文件??????117235??2011-08-19?16:45??20110717ACCPS2考試\20110717?筆試+答案.doc
?????文件??????381952??2011-08-08?21:32??20110717ACCPS2考試\20110717機試.doc
?????目錄???????????0??2011-08-19?16:58??20110717ACCPS2考試\機試答案\
?????目錄???????????0??2011-08-08?15:07??20110717ACCPS2考試\機試答案\DB\
?????文件?????2097152??2011-08-08?17:21??20110717ACCPS2考試\機試答案\DB\MemberInfo.mdf
?????文件?????1048576??2011-08-08?17:21??20110717ACCPS2考試\機試答案\DB\MemberInfo_log.ldf
?????目錄???????????0??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\
?????文件?????????432??2011-08-08?15:26??20110717ACCPS2考試\機試答案\MemberManagement\.classpath
?????目錄???????????0??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\.myeclipse\
?????文件?????????321??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\.mymetadata
?????文件????????1289??2011-08-08?16:13??20110717ACCPS2考試\機試答案\MemberManagement\.project
?????目錄???????????0??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\.settings\
?????文件?????????330??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2011-08-08?15:22??20110717ACCPS2考試\機試答案\MemberManagement\src\
?????目錄???????????0??2011-08-08?15:22??20110717ACCPS2考試\機試答案\MemberManagement\src\com\
?????目錄???????????0??2011-08-08?15:54??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\
?????目錄???????????0??2011-08-08?15:29??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\dao\
?????文件????????1238??2011-08-08?15:28??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\dao\baseDao.java
?????文件????????2404??2011-08-08?16:02??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\dao\MemberDao.java
?????目錄???????????0??2011-08-08?15:23??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\entity\
?????文件????????1258??2011-08-08?15:57??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\entity\Member.java
?????目錄???????????0??2011-08-08?15:54??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\test\
?????文件?????????368??2011-08-08?16:01??20110717ACCPS2考試\機試答案\MemberManagement\src\com\member\test\test.java
?????目錄???????????0??2011-08-08?17:14??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\
?????文件????????2517??2011-08-08?17:14??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\add.jsp
?????文件????????1770??2011-08-08?16:15??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\index.jsp
?????文件????????1656??2011-08-08?17:16??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\manage.jsp
?????目錄???????????0??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\meta-INF\
?????文件??????????36??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2011-08-08?15:21??20110717ACCPS2考試\機試答案\MemberManagement\WebRoot\WEB-INF\
............此處省略13個文件信息