package?com.order.util;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;
public?class?MySQLConn?{
????Connection?conn?=?null;
????
public?Connection?getConnection（）?{
????try?{
????????Class.forName（“com.mysql.jdbc.Driver“）;?//加載MySQL數據庫驅動
????????String?url?=?“jdbc:mysql://localhost:3306/db_database21“;???//定義與連接數據庫的url
????????String?user?=?“root“;???????????//定義連接數據庫的用戶名???
????????String?passWord?=?“111“;????????//定義連接數據庫的密碼
????????conn?=?DriverManager.getConnection（url?user?passWord）;????//連接連接
????}?catch?（Exception?e）?{
????????e.printStackTrace（）;
????}
????return?conn;
}????
????//?定義按指定按指定條件降序查詢數據方法????

public?List?getOrderDesc（）?{
????List?list?=?new?ArrayList（）;?//?定義用于保存返回值的List集合
????conn?=?getConnection（）;?//?獲取數據庫連接
????try?{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????310??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
?????文件????????3297??2015-08-28?13:52??bin\com\order\util\MySQLConn.class
?????文件????????1676??2015-08-28?13:52??bin\com\order\util\Student.class
?????文件??????802721??2015-08-28?13:52??lib\mysql-connector-java-5.1.20-bin.jar
?????文件????????2227??2015-08-28?13:52??src\com\order\util\MySQLConn.java
?????文件????????1218??2015-08-28?13:52??src\com\order\util\Student.java