最新ACCPS2结业考试20110717机试+笔试+答案

20110717北大青鸟ACCPS2结业考试卷，内附机试和笔试的参考答案，是很好的学习资料哦

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