package?dao;

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

public?class?baseDao?{

	private?static?final?String?DRIVER?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?URL?=?“jdbc:sqlserver://localhost:1433;databaseName=phone“;
	private?static?final?String?USER?=?“sa“;
	private?static?final?String?PWD?=?““;

	public?Connection?getConn（）?{
		Connection?conn?=?null;
		try?{
			Class.forName（DRIVER）;
			conn?=?DriverManager.getConnection（URL?USER?PWD）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}
		return?conn;
	}

	public?void?closeAll（Connection?conn?Statement?stmt?ResultSet?rs）?{
		try?{
			if?（rs!=null）?{
????????????????rs.close（）;
			}
			if?（stmt!=null）?{
????????????????stmt.close（）;
			}
			if?（conn!=null）?{
????????????????conn.close（）;
			}
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}
	}
}

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

?????文件????1048576??2012-08-25?21:14??phone_log.ldf

?????文件????????432??2012-08-25?20:27??phoneAdmin\.classpath

?????文件????????303??2012-08-25?20:26??phoneAdmin\.mymetadata

?????文件???????1228??2012-08-25?21:06??phoneAdmin\.project

?????文件????????981??2012-08-25?21:04??phoneAdmin\src\dao\baseDao.java

?????文件???????1543??2012-08-25?21:10??phoneAdmin\src\dao\PhoneDao.java

?????文件???????1128??2012-08-25?21:04??phoneAdmin\src\entity\PhoneEntity.java

?????文件???????1311??2012-08-25?21:05??phoneAdmin\WebRoot\dodelete.jsp

?????文件???????2294??2012-08-25?21:12??phoneAdmin\WebRoot\index.jsp

?????文件?????????39??2012-08-25?20:26??phoneAdmin\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1319??2012-08-25?21:04??phoneAdmin\WebRoot\WEB-INF\classes\dao\baseDao.class

?????文件???????2326??2012-08-25?21:10??phoneAdmin\WebRoot\WEB-INF\classes\dao\PhoneDao.class

?????文件???????1542??2012-08-25?21:04??phoneAdmin\WebRoot\WEB-INF\classes\entity\PhoneEntity.class

?????文件?????583286??2012-08-25?20:27??phoneAdmin\WebRoot\WEB-INF\lib\sqljdbc.jar

?????文件????????381??2012-08-25?20:26??phoneAdmin\WebRoot\WEB-INF\web.xml

?????文件????3145728??2012-08-25?21:14??phone.mdf

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\WEB-INF\classes\dao

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\WEB-INF\classes\entity

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\WEB-INF\classes

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\WEB-INF\lib

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\src\dao

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\src\entity

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\meta-INF

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot\WEB-INF

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\.myeclipse

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\src

?????目錄??????????0??2012-11-26?18:03??phoneAdmin\WebRoot

?????目錄??????????0??2012-11-26?18:03??phoneAdmin

-----------?---------??----------?-----??----

??????????????4792417????????????????????28

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