/**
?*?@（#）DBConnect.java
?*
?*
?*?@author?袁國科
?*?@version?1.00?2009/3/18
?*/

package?student;

import?java.util.*;
import?java.net.*;
import?java.sql.*;

//用于和數據庫建立連接.所連接的數據庫為?Mysql數據庫用戶名為root密碼為空.


public?class?DBConnect?{
???public?DBConnect（）?{
???}
???
???public?Connection?getCon（）?throws?ClassNotFoundException?SQLExeption?{
???	????Connection?con=null;
???	????try?{
???	????	Class.forName（“com.mysql.jdbc.Driver“）;
???	????	//根據實際將這里的localhost改為你的數據庫所在的服務器的地址
???	????	String?URL=“jdbc:mysql://localhost:3306/sushe?user=root&password=“;
???	????	con=DriverManager.getConnection（URL）;
???	????	}?catch?（Exception?e）?{
???	????		e.printStackTrace（）;
???	????	}
???	????	return?con;
???}
???
???//用于根據設定的檢索條件sqlText?查詢數據庫中的數據
???public?ResultSet?DBQuery（

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????750654??2009-03-23?23:33??sushe\JSP網頁的運行流程.bmp

?????文件?????706734??2009-03-23?22:54??sushe\系統功能圖.bmp

?????文件?????927398??2009-03-23?23:00??sushe\系統架構圖.bmp

?????文件???????6165??2009-03-21?19:47??sushe\sushe\addroom.jsp

?????文件???????7376??2009-03-21?19:47??sushe\sushe\addstudent.jsp

?????文件???????1537??2009-03-18?16:37??sushe\sushe\DBConnect.java

?????文件???????2162??2009-03-21?18:07??sushe\sushe\login.jsp

?????文件???????1450??2009-03-21?19:47??sushe\sushe\main.jsp

?????文件???????4404??2009-03-21?19:47??sushe\sushe\query_house.jsp

?????文件???????7711??2009-03-21?19:47??sushe\sushe\query_student.jsp

?????文件????1065472??2009-03-19?13:54??sushe\sushe\sushe_backup

?????文件????1048576??2009-03-18?14:42??sushe\sushe\sushe_Data.MDF

?????文件????1048576??2009-03-18?14:42??sushe\sushe\sushe_Log.LDF

?????文件???????7804??2009-03-21?20:03??sushe\sushe\初學者如何快速入門JSP實例分析.txt

?????文件??????13283??2009-11-01?21:30??sushe\登陸界面.jpg

?????文件??????31454??2009-11-01?21:37??sushe\主窗口.jpg

?????文件??????34510??2009-11-01?21:40??sushe\錄入房間信息.jpg

?????文件??????33937??2009-11-01?21:42??sushe\錄入學生信息.jpg

?????文件??????48632??2009-11-01?21:44??sushe\房間信息查詢.jpg

?????文件??????59723??2009-11-01?21:46??sushe\學生信息查詢.jpg

?????文件?????599552??2009-11-02?20:51??sushe\面向對象編程項目開發報告書.doc

?????文件?????192512??2009-10-26?08:35??sushe\sushe.mdb

?????目錄??????????0??2009-03-22?00:34??sushe\sushe

?????目錄??????????0??2009-10-29?15:03??sushe

-----------?---------??----------?-----??----

??????????????6599622????????????????????24