package?y2javaee.xmal1.common;

import?java.sql.*;

public?class?DBConnection?{
	
	private?static?Connection?conn;

	private?static?final?String?DRIVER_CLASS?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;

	private?static?final?String?DATAbase_URL?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=addressBook“;

	private?static?final?String?DATAbase_USRE?=?“sa“;

	private?static?final?String?DATAbase_PASSWORD?=?“120010“;

	/**
	?*?返回連接
	?*?
	?*?@return?Connection
	?*/
	public?static?Connection?getConnection（）?{

		try?{
			Class.forName（DRIVER_CLASS）;
			conn?=?DriverManager.getConnection（DATAbase_URL
					DATAbase_USRE?DATAbase_PASSWORD）;

		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}

		return?conn;
	}

	/**
	?*?關閉數據庫連接
	?*?
	?*/
	public?static?void?closeConnection（）{
		try{
			if（conn!=null）
				conn.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	/**
	?*?關閉Statement對象
	?*?
	?*?@param?stm
	?*/
	public?static?void?closeStatement（Statement?stm）{
		try{
			if（stm!=null）
				stm.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	/**
	?*?關閉PreparedStatement對象
	?*?
	?*?@param?ps
	?*/
	public?static?void?closeStatement（PreparedStatement?ps）{
		try{
			if（ps!=null）
				ps.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	/**
	?*?關閉ResultSet結果集對象
	?*?
	?*?@param?rs
	?*/
	public?static?void?closeResultSet（ResultSet?rs）{
		try{
			if（rs!=null）
				rs.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
}

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

????..A.SH.??????5632??2007-09-21?09:51??在線通訊錄\PPT\Thumbs.db

?????文件????6825984??2008-01-04?17:30??在線通訊錄\PPT\在線通訊錄系統V1.0.ppt

?????文件????????553??2007-09-20?22:24??在線通訊錄\Source\addressBook\.classpath

?????文件????????306??2007-09-20?22:24??在線通訊錄\Source\addressBook\.mymetadata

?????文件???????1229??2007-09-19?16:33??在線通訊錄\Source\addressBook\.project

?????文件????????123??2007-09-20?08:44??在線通訊錄\Source\addressBook\.settings\org.eclipse.core.resources.prefs

?????文件???????1606??2007-09-30?15:03??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\common\DBConnection.java

?????文件????????237??2007-09-30?15:04??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\common\Validate.java

?????文件???????2633??2007-09-20?23:31??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\entity\Book.java

?????文件???????1320??2007-09-20?23:35??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\entity\Users.java

?????文件???????4121??2007-09-30?15:13??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\operation\BookBo.java

?????文件???????1296??2007-09-30?15:14??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\operation\UserBo.java

?????文件???????2947??2007-09-30?15:16??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\servlet\AddServlet.java

?????文件???????1573??2007-09-30?15:19??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\servlet\DeleteServlet.java

?????文件???????1718??2007-09-30?15:22??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\servlet\LoginServlet.java

?????文件???????1890??2007-09-30?15:27??在線通訊錄\Source\addressBook\src\y2javaee\xmal1\servlet\SelectServlet.java

?????文件???????7530??2007-11-07?09:52??在線通訊錄\Source\addressBook\WebRoot\addBook.jsp

?????文件????????722??2007-09-19?22:44??在線通訊錄\Source\addressBook\WebRoot\banner.html

?????文件???????4351??2007-11-07?09:50??在線通訊錄\Source\addressBook\WebRoot\bookContent.jsp

?????文件????????475??2007-09-20?08:43??在線通訊錄\Source\addressBook\WebRoot\foot.jsp

?????文件???????8237??2007-08-23?12:14??在線通訊錄\Source\addressBook\WebRoot\image\flower\bg.jpg

?????文件???????3819??2007-08-23?12:14??在線通訊錄\Source\addressBook\WebRoot\image\flower\m_bg.jpg

?????文件??????16621??2007-08-23?12:14??在線通訊錄\Source\addressBook\WebRoot\image\flower\m_tl.jpg

????..A.SH.?????14848??2007-09-20?00:23??在線通訊錄\Source\addressBook\WebRoot\image\flower\Thumbs.db

?????文件???????4750??2007-08-23?12:14??在線通訊錄\Source\addressBook\WebRoot\image\flower\tl.jpg

?????文件??????10233??2007-09-20?00:19??在線通訊錄\Source\addressBook\WebRoot\image\flower\tr.jpg

?????文件???????3764??2007-05-30?14:50??在線通訊錄\Source\addressBook\WebRoot\image\image001_2007-05-10-13-34-19-727_2007-05-30-14-50-44-173.jpg

?????文件???????4056??2007-05-30?14:52??在線通訊錄\Source\addressBook\WebRoot\image\image001_2007-05-30-14-52-37-355.jpg

?????文件???????1152??2007-09-19?23:56??在線通訊錄\Source\addressBook\WebRoot\image\notebook\dl.gif

?????文件???????1365??2007-09-19?23:56??在線通訊錄\Source\addressBook\WebRoot\image\notebook\dr.gif

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