import?java.sql.*;
/**
?*?@author?Administrator
?*/
public?class?SubjoinDate?{

	String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=master“;
	String?username?=?“sa“;
	String?password?=?““;
	private?Connection?con?=?null;
	private?Statement?stmt?=?null;
	private?ResultSet?rs?=?null;

	public?SubjoinDate（）?{?//?通過構造方法加載數據庫驅動
		try?{
			Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;
		}?catch?（Exception?ex）?{
			System.out.println（“數據庫加載失敗“）;
		}
	}

????public?boolean?Connection（）?{????????//創建數據庫連接
????????try?{
????????????con?=?DriverManager.getConnection（url?username?password）;

????????}?catch?（SQLException?e）?{
????????????System.out.println（e.getMessage（））;
????????????System.out.println（“creatConnectionerror!“）;
????????}
????????return?true;
????}

????//對數據庫的查詢操作
????public?ResultSet?selectStatic（String?sql）?throws?SQLException?{
?????????ResultSet?rs=null;
????????if?（con?==?null）?{
????????????Connection（）;
????????}
??

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:53??.classpath
?????文件?????????379??2015-08-28?13:53??.project
?????文件?????????629??2015-08-28?13:53??.settings\org.eclipse.jdt.core.prefs
?????文件????????2963??2015-08-28?13:53??bin\SubjoinDate.class
?????文件?????????707??2015-08-28?13:53??bin\Subjoinframe$1.class
?????文件?????????664??2015-08-28?13:53??bin\Subjoinframe$2.class
?????文件?????????666??2015-08-28?13:53??bin\Subjoinframe$3.class
?????文件?????????666??2015-08-28?13:53??bin\Subjoinframe$4.class
?????文件????????4190??2015-08-28?13:53??bin\Subjoinframe.class
?????文件??????294726??2015-08-28?13:53??lib\jtds-1.2.2.jar
?????文件????????2479??2015-08-28?13:53??src\SubjoinDate.java
?????文件????????5014??2015-08-28?13:53??src\Subjoinframe.java