package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?service.StuClass;

/**
?*?
?*?@author?Tracy?Shang
?*?數(shù)據(jù)庫(kù)操作類(lèi)
?*/
public?class?DBcmd?{

	

	/**
	?*?聯(lián)接數(shù)據(jù)庫(kù)
	?*?@return
	?*/
	//?TODO:數(shù)據(jù)庫(kù)連接
//		private?static?Connection?connectDB（）?{
//			String?JDriver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;//?SQL數(shù)據(jù)庫(kù)引擎
//
//			String?connectDB?=?“jdbc:sqlserver://210.45.165.217:1433;DatabaseName=ScoreDB“;//?數(shù)據(jù)源注意IP地址和端口號(hào)，數(shù)據(jù)庫(kù)名字!!!
//
//			try?{
//
//				Class.forName（JDriver）;//?加載數(shù)據(jù)庫(kù)引擎，返回給定字符串名的類(lèi)
//
//			}?catch?（ClassNotFoundException?e）?{
//
//				e.printStackTrace（）;
//
//				System.out.println（“加載數(shù)據(jù)庫(kù)引擎失敗“）;
//
//				System.exit（0）;
//
//			}
//
//			System.out.println（“數(shù)據(jù)庫(kù)驅(qū)動(dòng)成功“）;
//
//			try?{
//
//				String?user?=?“sa“;//?你自己創(chuàng)建的用戶名字和密碼!!!!!!!!!!!!
//
//				String?password?=?“123“;
//
//				Connection?con?=?DriverManager.getConnection（connectDB?user
//
//				password）;//?連接數(shù)據(jù)庫(kù)對(duì)象
//
//				System.out.println（“連接數(shù)據(jù)庫(kù)成功“）;
//				return?con;
//			}?catch?（Exception?e）?{
//				//?數(shù)據(jù)庫(kù)驅(qū)動(dòng)類(lèi)異常處理
//				System.out.println（“Sorrycan‘t?find?the?Driver!“）;
//				e.printStackTrace（）;
//				return?null;
//
//			}?
//		}
//	
	private?static?Connection?connectDB（）?{
		//?聲明Connection對(duì)象
		Connection?con?=?null;
		//?驅(qū)動(dòng)程序名
		String?driver?=?“com.mysql.jdbc.Driver“;
		//?URL指向要訪問(wèn)的數(shù)據(jù)庫(kù)名mydata
		String?url?=?“jdbc:mysql://localhost:3306/scoredb“;
		//?MySQL配置時(shí)的用戶名
		String?user?=?“root“;
		//?MySQL配置時(shí)的密碼
		String?password?=?“1234“;
		//?遍歷查詢結(jié)果集
		try?{
			//?加載驅(qū)動(dòng)程序
			Class.forName（driver）;
			//?1.getConnection（）方法，連接MySQL數(shù)據(jù)庫(kù)！！
			con?=?DriverManager.getConnection（url?user?password）;
			if?（!con.isClosed（））
				System.out.println（“Succeeded?connecting?to?the?Database!“）;
		}?catch?（Exception?e）?{
			//?數(shù)據(jù)庫(kù)驅(qū)動(dòng)類(lèi)異常處理
			System.out.println（“Sorrycan‘t?find?the?Driver!“）;
			e.printStackTrace（）;

		}?finally?{
			return?con;
		}

	}

	//?TODO:查詢數(shù)據(jù)
	public?static?List?queryClass（）?{

		List?result?=?new?ArrayList（）;

		try?{
			Connection?con?=?connectDB（）;
			if?（con?==?null）?{
				return?null;
			}
			//?2.創(chuàng)建statement類(lèi)對(duì)象，用來(lái)執(zhí)行SQL語(yǔ)句！！
			Statement?statement;
			statement?=?con.createStatement（）;

			//?要執(zhí)行的SQL語(yǔ)句
			String?sql?=?“select?*?from?class“;
			//?3.ResultSet類(lèi)，用來(lái)存放獲取的結(jié)果集！！
			ResultSet?rs?=?statement.executeQuery（sql）;

			while?（rs.next（））?{
				StuClass?cl?=?new?StuClass（）;
				//?獲取stuname這列數(shù)據(jù)
				cl.setClassNo（rs.getString（“classNo“））;
				//?獲取stuid這列數(shù)據(jù)
				cl.setClassName（rs.getString（“className“））;
				cl.setClassNum（rs.getInt（“classNum“））;

				cl.setInstitute（rs.getString（“institute“））;
				cl.setGrade（rs.getInt（“grade“））;

				//?輸出結(jié)果
				System.out.println（cl.toString（））;
				result.add（cl）;
			}
			rs.close（）;
			con.close（）;
		}?cat

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

?????文件????????577??2018-06-28?12:16??DBApp1\.classpath

?????文件????????382??2018-06-28?12:16??DBApp1\.project

?????文件????????598??2018-06-28?12:16??DBApp1\.settings\org.eclipse.jdt.core.prefs

?????文件???????3825??2018-06-28?12:16??DBApp1\bin\dao\DBcmd.class

?????文件???????2063??2018-06-28?12:16??DBApp1\bin\service\StuClass.class

?????文件????????696??2018-06-28?12:16??DBApp1\bin\utils\Utils.class

?????文件???????2622??2018-06-28?12:16??DBApp1\bin\view\AddInfoframe.class

?????文件????????795??2018-06-28?12:16??DBApp1\bin\view\Mainframe$1.class

?????文件???????4083??2018-06-28?12:16??DBApp1\bin\view\Mainframe.class

?????文件?????459094??2018-06-28?12:16??DBApp1\lib\mysql-connector-java-3.1.14-bin.jar

?????文件?????893229??2018-06-28?12:16??DBApp1\lib\sqljdbc41.jar

?????文件???????4595??2018-06-28?12:16??DBApp1\src\dao\DBcmd.java

?????文件???????1639??2018-06-28?12:16??DBApp1\src\service\StuClass.java

?????文件????????488??2018-06-28?12:16??DBApp1\src\utils\Utils.java

?????文件???????1508??2018-06-28?12:16??DBApp1\src\view\AddInfoframe.java

?????文件???????3136??2018-06-28?12:16??DBApp1\src\view\Mainframe.java

?????文件????2401254??2018-06-28?12:11??數(shù)據(jù)庫(kù)網(wǎng)上書(shū)店.docx

?????目錄??????????0??2018-06-28?12:16??DBApp1\bin\dao

?????目錄??????????0??2018-06-28?12:16??DBApp1\bin\service

?????目錄??????????0??2018-06-28?12:16??DBApp1\bin\utils

?????目錄??????????0??2018-06-28?12:16??DBApp1\bin\view

?????目錄??????????0??2018-06-28?12:16??DBApp1\src\dao

?????目錄??????????0??2018-06-28?12:16??DBApp1\src\service

?????目錄??????????0??2018-06-28?12:16??DBApp1\src\utils

?????目錄??????????0??2018-06-28?12:16??DBApp1\src\view

?????目錄??????????0??2018-06-28?12:16??DBApp1\.settings

?????目錄??????????0??2018-06-28?12:16??DBApp1\bin

?????目錄??????????0??2018-06-28?12:16??DBApp1\lib

?????目錄??????????0??2018-06-28?12:16??DBApp1\src

?????目錄??????????0??2018-06-28?12:16??DBApp1

............此處省略3個(gè)文件信息