package?com.cn.common;

import?java.sql.*;

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

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

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

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

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

	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（）;
		}
	}

	public?static?void?closeStatement（Statement?stm）{
		try{
			if（stm!=null）
				stm.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}

	public?static?void?closeStatement（PreparedStatement?ps）{
		try{
			if（ps!=null）
				ps.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}

	public?static?void?closeResultSet（ResultSet?rs）{
		try{
			if（rs!=null）
				rs.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????503??2009-04-09?17:21??addressBook\.classpath

?????文件????????306??2009-04-11?11:41??addressBook\.mymetadata

?????文件???????1229??2009-04-09?16:22??addressBook\.project

?????文件??????16282??2009-04-09?17:12??addressBook\WebRoot\addBook.jsp

?????文件??????13744??2009-04-09?17:11??addressBook\WebRoot\bookContent.jsp

?????文件??????12734??2009-04-09?17:04??addressBook\WebRoot\index.jsp

?????文件???????2018??2009-04-09?16:40??addressBook\WebRoot\WEB-INF\web.xml

?????文件?????231949??2009-04-09?17:19??addressBook\WebRoot\WEB-INF\lib\sqljdbc.jar

?????文件???????2998??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\servlet\AddServlet.class

?????文件???????1831??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\servlet\DeleteServlet.class

?????文件???????2201??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\servlet\LoginServlet.class

?????文件???????2342??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\servlet\SelectServlet.class

?????文件???????4518??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\operation\BookBo.class

?????文件???????1960??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\operation\UserBo.class

?????文件???????2433??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\entity\Book.class

?????文件???????1302??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\entity\Users.class

?????文件???????1880??2009-04-09?17:28??addressBook\WebRoot\WEB-INF\classes\com\cn\common\DBConnection.class

?????文件????????436??2009-04-09?17:21??addressBook\WebRoot\WEB-INF\classes\com\cn\common\Validate.class

?????文件?????????39??2009-04-09?15:49??addressBook\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2081??2009-04-09?15:49??addressBook\WebRoot\images\200541116272355477.gif

?????文件???????2924??2009-04-09?15:49??addressBook\WebRoot\images\20054119481077038.gif

?????文件???????2258??2009-04-09?15:49??addressBook\WebRoot\images\200543128129181.gif

?????文件???????3009??2009-04-09?15:49??addressBook\WebRoot\images\2005431324010055.gif

?????文件???????2982??2009-04-09?15:49??addressBook\WebRoot\images\2005431332486265.gif

?????文件???????3254??2009-04-09?15:49??addressBook\WebRoot\images\20054616104170383.gif

?????文件???????2835??2009-04-09?15:49??addressBook\WebRoot\images\20054823114977499.gif

?????文件???????2810??2009-04-09?15:49??addressBook\WebRoot\images\20054823324343994.gif

?????文件???????1906??2009-04-09?15:49??addressBook\WebRoot\images\22_top.jpg

?????文件????????214??2009-04-09?15:49??addressBook\WebRoot\images\234x60.js

?????文件????????808??2009-04-09?15:49??addressBook\WebRoot\images\2e-m-3d.gif

............此處省略88個(gè)文件信息