package?com.cdd.util;

import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;

public?class?BetweenUtil?{
????//?獲取數據庫連接
????private?Connection?conn;
????
????public?Connection?getConn（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database21“;?//?連接數據庫URL
????????String?userName?=?“sa“;?//?連接數據庫的用戶名
????????String?passWord?=?““;?//?連接數據庫密碼
????????try?{
????????????conn?=?DriverManager.getConnection（url?userName?passWord）;?//?獲取數據庫連接
????????????if?（conn?!=?null）?{
????????????}
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?conn;?//?返回Connection對象
????}
????
????//?定義按指定按指定條件降序查詢數據方法
????
public?List?getGrade（）?{
????List?list?=?new?ArrayList（）;?//?定義用于保存返回值的List集合
????conn?=?getConn（）

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:52??.classpath
?????文件?????????379??2015-08-28?13:52??.project
?????文件?????????629??2015-08-28?13:52??.settings\org.eclipse.jdt.core.prefs
?????文件????????3134??2015-08-28?13:52??bin\com\cdd\util\BetweenUtil.class
?????文件????????1851??2015-08-28?13:52??bin\com\cdd\util\Grade.class
?????文件??????294726??2015-08-28?13:52??lib\jtds-1.2.2.jar
?????文件????????2200??2015-08-28?13:52??src\com\cdd\util\BetweenUtil.java
?????文件????????1372??2015-08-28?13:52??src\com\cdd\util\Grade.java