package?com.db;
import?java.sql.*;
public?class?DBbase?{
	/*String?url?=?“jdbc:odbc:rent“;
	String?driver?=?“sun.jdbc.odbc.JdbcOdbcDriver“;*/
	String?url?=?“jdbc:sqlserver://localhost:1433;DatabaseName=rent“;
	String?driver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	Connection?con=null;
	public?DBbase（）?{
		try?{
			Class.forName（driver）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}
	public?static?void?main（String?arg[]）{
		DBbase?db=new?DBbase（）;
		db.executeProcedure（）;
	}
????public?String?executeProcedure（）{
????	//String?uid=“200705w1“upwd=“20072007“;
????	String?uid=“admin“upwd=“admin“;
????	try?{
			/*con?=?DriverManager.getConnection（url）;
			CallableStatement?cmd=
				con.prepareCall（“{call?admintest（??）}“）;
			cmd.setString（1?uid）;
			cmd.registerOutParameter（2?java.sql.Types.VARCHAR10）;
			cmd.execute（）;
			upwd=cmd.getString（2）;
			con.close（）;*/
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
		return?upwd;
????}
	public?ResultSet?executeQuery（String?sql）?{
		ResultSet?rs?=?null;
		try?{
		????con?=?DriverManager.getConnection（url“root““admin“）;
			Statement?cmd?=?con.createStatement（）;
			rs?=?cmd.executeQuery（sql）;
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
		return?rs;
	}

	public?void?executeUpdate（String?sql）?{
		try?{
			con?=?DriverManager.getConnection（url“sa““123456“）;
			Statement?cmd?=?con.createStatement（）;
			cmd.executeUpdate（sql）;
			con.close（）;
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
	}
	
????public?int?executeScalor（String?sql）{
????	int?c=0;
????	try{
????		con?=?DriverManager.getConnection（url“root““admin“）;
		????Statement?cmd=con.createStatement（）;?
		????ResultSet?rs=?cmd.executeQuery（sql）;?
		????rs.next（）;???????????????????????????
		????c=rs.getInt（1）;??
		????con.close（）;
		}catch（Exception?ex）{
			ex.printStackTrace（）;
		}
		return?c;
????}
????
????public?object[][]?executeQuery（String?sqlint?rowsint?cols）{
		object[][]?obj=new?object[rows][cols];
		ResultSet?rs=null;
		try{
			con?=?DriverManager.getConnection（url“root““admin“）;
		????Statement?cmd=con.createStatement（）;
		????rs=?cmd.executeQuery（sql）;
		????int?c=0;
		????while（rs.next（））{????????????//給二維數組賦值
		????	
		????	for（int?i=0;i		????		obj[c][i]=rs.getString（i+1）;?//獲取結果集中的字符型數據
		????	}
		????	c++;
		????}
		????con.close（）;
		}catch（Exception?ex）{
			ex.printStackTrace（）;
		}
		
		return?obj;
	}
	public?void?closeConnection（）?{
		try?{
			if?（con!=null&&!con.isClosed（））
				con.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-26?16:09??15?SQLServer\database\
?????文件?????2293760??2010-06-03?13:43??15?SQLServer\database\rent.mdf
?????文件??????573440??2010-06-03?13:43??15?SQLServer\database\rent_log.LDF
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\
?????文件?????????355??2010-06-03?13:43??15?SQLServer\JavaPrj_15?SQLServer\.classpath
?????文件?????????396??2010-06-03?13:43??15?SQLServer\JavaPrj_15?SQLServer\.project
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\bin\
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\bin\com\
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\bin\com\db\
?????文件????????2981??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\db\DBbase.class
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\
?????文件????????4594??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\AddUserFrm.class
?????文件????????1778??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Allmember.class
?????文件????????1742??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\CloseTabIcon.class
?????文件????????2394??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\deleteUserFrm.class
?????文件????????3304??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\JClosableTabbedPane.class
?????文件????????1792??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Latestweekinfo.class
?????文件???????62142??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\login.png
?????文件????????3892??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\LoginFrm.class
?????文件????????5541??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\MainFrm.class
?????文件????????1768??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Notcopyinfo.class
?????文件????????2168??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Notreturninfo.class
?????文件????????1898??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Rentalinfo.class
?????文件????????4633??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Rentframe.class
?????文件????????3725??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\Reserveframe.class
?????文件????????1781??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\titlecopyinfo.class
?????文件????????5668??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\titleframe.class
?????文件????????1832??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\com\view\titleinfo.class
?????目錄???????????0??2013-05-26?16:10??15?SQLServer\JavaPrj_15?SQLServer\bin\config\
?????文件????????3234??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\config\insert.properties
?????文件????????1475??2010-06-03?13:44??15?SQLServer\JavaPrj_15?SQLServer\bin\config\table.properties
............此處省略52個文件信息