package?comm;

import?java.sql.*;

public?class?ConnectionManager?{
	private?static?final?String?DRIVER=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?URL=“jdbc:sqlserver://localhost:1433;DatabaseName=books“;
	private?static?final?String?UNAME=“sa“;
	private?static?final?String?UPASS=“123456“;
	public?static?Connection?getCon（）?throws?SQLException{
		Connection?con=null;
		try?{
			Class.forName（DRIVER）;
			con=DriverManager.getConnection（URLUNAMEUPASS）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		return?con;
	}
	public?static?void?allClose（Connection?conPreparedStatement?pstmtResultSet?rs）{
		
			try?{
				if（rs!=null）{
					rs.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
			try?{
				if（pstmt!=null）{
					pstmt.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
			try?{
				if（con!=null）{
					con.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
	}
}

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

?????文件??????????0??2010-08-02?08:55??網(wǎng)上書店\.metadata\.lock

?????文件?????264259??2010-08-05?09:12??網(wǎng)上書店\.metadata\.log

?????文件?????????80??2010-08-04?21:35??網(wǎng)上書店\.metadata\.plugins\com.genuitec.eclipse.desktop\dialog_settings.xml

?????文件???????1663??2010-08-02?12:03??網(wǎng)上書店\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\ConnectionProfiles.xml

?????文件??????17026??2010-08-02?12:03??網(wǎng)上書店\.metadata\.plugins\com.genuitec.eclipse.sqlexplorer\SQLDrivers.xml

?????文件???????3403??2010-08-03?12:26??網(wǎng)上書店\.metadata\.plugins\com.genuitec.eclipse.templates\velocity.log

?????文件??????19775??2010-08-05?09:11??網(wǎng)上書店\.metadata\.plugins\com.genuitec.eclipse.webdesigner3\staticbindings_5.5.0.css

?????文件??????????0??2010-08-02?08:55??網(wǎng)上書店\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log

?????文件????????652??2010-08-02?11:48??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\1\80c5d6d5e89d001f1705b661b00c51c7

?????文件???????1012??2010-08-02?14:25??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\1\d0ee14c2fe9d001f1dd2b403827e70e8

?????文件???????3158??2010-08-03?11:09??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\10\102c3e29af9e001f138ed7e75befeff2

?????文件???????5036??2010-08-03?09:06??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\10\2083a37a9b9e001f138ed7e75befeff2

?????文件???????5048??2010-08-03?09:07??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\10\906656ab9b9e001f138ed7e75befeff2

?????文件??????????0??2010-08-03?21:07??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\10\b076da0a009f001f11f4bcbc86a67957

?????文件???????1778??2010-08-02?11:43??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\12\a0694314e89d001f1705b661b00c51c7

?????文件???????1317??2010-08-02?10:19??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\13\508181d3dc9d001f12b6e9ba0fca6ffc

?????文件???????7222??2010-08-03?09:24??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\14\60029c90a59e001f138ed7e75befeff2

?????文件???????4903??2010-08-04?17:04??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\14\707a09d4a79f001f1ebdbd1f94234226

?????文件???????4849??2010-08-03?09:29??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\14\d0b3b9bed89e001f1187881d42200785

?????文件???????2934??2010-08-03?11:17??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\15\c058c2bfad9e001f138ed7e75befeff2

?????文件???????4424??2010-08-03?10:07??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\16\506849d4a49e001f138ed7e75befeff2

?????文件????????585??2010-08-03?10:19??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\16\70427448a79e001f138ed7e75befeff2

?????文件???????2290??2010-08-03?09:24??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\16\80ea10da9d9e001f138ed7e75befeff2

?????文件???????4852??2010-08-02?15:14??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\16\d0d782eb059e001f1dd2b403827e70e8

?????文件????????860??2010-08-02?11:51??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\18\3071f4f5ea9d001f1705b661b00c51c7

?????文件???????1280??2010-08-03?21:10??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\19\50bc6085009f001f11f4bcbc86a67957

?????文件???????1307??2010-08-03?11:42??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\19\50f5861db49e001f138ed7e75befeff2

?????文件???????1539??2010-08-02?14:09??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\19\f0205893fc9d001f1dd2b403827e70e8

?????文件????????754??2010-08-02?11:50??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\1a\408c9526e99d001f1705b661b00c51c7

?????文件???????1413??2010-08-02?15:26??網(wǎng)上書店\.metadata\.plugins\org.eclipse.core.resources\.history\1c\b022ed95079e001f1dd2b403827e70e8

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