package?com.db;

import?java.sql.DriverManager;
import?java.sql.Connection;
import?java.sql.Statement;
import?java.sql.ResultSet;
import?java.sql.SQLException;


public?class?MyConn?
{
	//private?static?final?String?DB_HOSTNAME?=?“127.0.0.1“;	//服務器的地址（本機上）
	//private?static?final?String?DB_PORT=“3306“;	//數據庫的端口
	private?static?final?String?DB_NAME=“xy“;	//數據庫名
	private?static?final?String?DB_USERNAME=“root“;	//數據庫用戶名
	private?static?final?String?DB_USERPASSWORD=“123456“;	//連接數用戶密碼
	//private?static?final?String?DB_URL=““;	//連接數據庫的url
	
	private?Connection?conn=null;
	private?Statement?st=null;
	private?ResultSet?rs=null;
	//private?PrintWriter?out=null;
	
	public?MyConn（）
	{
		try?{
			Class.forName（“org.gjt.mm.mysql.Driver“）.newInstance（）;		//打開mysql驅動
			//Class.forName（“org.git.mm.mysql.Driver“）.newInstance（）;	//打開mysql驅動
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			//System.out.println（“數據庫中的驅動沒有找到（ClassNotFoundException）“）;
			System.out.println（“數據庫中的驅動沒有找到（ClassNotFoundException）“）;
			e.printStackTrace（）;
		}?catch?（InstantiationException?e）?{
			//?TODO?Auto-generated?catch?block
			//System.out.println（“數據庫中驅動沒有初始化（InstantiationException）“）;
			System.out.println（“數據庫中驅動沒有初始化（InstantiationException）“）;
			e.printStackTrace（）;
		}?catch?（IllegalAccessException?e）?{
			//?TODO?Auto-generated?catch?block
			//System.out.println（“數據訪問權限出錯（IllegalAccessException）“）;
			System.out.println（“數據訪問權限出錯（IllegalAccessException）“）;
			e.printStackTrace（）;
		}
		String?url=“jdbc:mysql://localhost:3306/“+DB_NAME+
				“?useUnicode=true&characterEncoding=GBK“;//初始化url
		try?{
			conn=DriverManager.getConnection（urlDB_USERNAMEDB_USERPASSWORD）;	//創建conn對象
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			//System.out.println（“connection對象連接出錯“）;
			System.out.println（“connection對象連接出錯“）;
			e.printStackTrace（）;
		}
		try?{
			st=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
					ResultSet.CONCUR_UPDATABLE）;	//創建st對象
			//st=conn.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			//System.out.println（“statement對象創建出錯“）;
			System.out.println（“statement對象創建出錯“）;
			e.printStackTrace（）;
		}
	}
	
	public?ResultSet?selectQuery（String?sql）
	{
		//ResultSet?rs=null;
		//rs=null;
		try?{
			rs?=?st.executeQuery（sql）;	//查詢語句
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“查詢語句內部出錯“）;
			e.printStackTrace（）;
		}
		return?rs;
	}
	
	public?int?updateQuery（String?sql）
	{
		int?nResult=0;
		try?{
			nResult?=?st.executeUpdate（sql）;	//更新語句（insert/update/delete）
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“更新語句（insert/update/delete出錯“）;
			e.printStackTrace（）;
		}
		return?nResult;
	}
	
	public?void?closeConn（）	//數據庫操作完后，一定要執行這句話來關閉數據庫
	{
		try?{
			st.close（）;		//關閉st對象
		}?catch?（SQLEx

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

?????文件????????554??2011-02-09?22:47??biyue\.classpath

?????文件????????288??2011-11-30?16:31??biyue\.mymetadata

?????文件???????1223??2010-12-12?17:59??biyue\.project

?????文件???????4257??2011-01-08?23:40??biyue\data.sql

?????文件????????123??2010-12-25?12:02??biyue\doument\class.sql

?????文件???????6299??2011-01-12?22:35??biyue\doument\data.sql

?????文件???????6813??2011-01-21?22:46??biyue\doument\xy.sql

?????文件????????896??2010-12-19?22:16??biyue\doument\論文要求.txt

?????文件???????3863??2010-12-26?18:55??biyue\src\com\db\MyConn.java

?????文件???????2779??2011-02-12?22:48??biyue\WebRoot\admin\index.jsp

?????文件???????6501??2011-02-12?22:48??biyue\WebRoot\admin\left.jsp

?????文件???????3738??2011-02-13?00:09??biyue\WebRoot\admin\login.jsp

?????文件???????3465??2011-02-12?22:48??biyue\WebRoot\admin\logindo.jsp

?????文件???????5653??2011-02-13?18:16??biyue\WebRoot\admin\query\normalinf.jsp

?????文件???????4787??2011-02-13?18:16??biyue\WebRoot\admin\query\stuinf.jsp

?????文件???????1486??2011-02-12?22:49??biyue\WebRoot\admin\right.jsp

?????文件???????5027??2011-02-13?18:16??biyue\WebRoot\admin\secu\uprtch.jsp

?????文件???????3692??2011-02-13?18:16??biyue\WebRoot\admin\secu\uprtchdo.jsp

?????文件???????2533??2011-02-13?18:17??biyue\WebRoot\admin\secu\uprtchdodo.jsp

?????文件???????4966??2011-02-13?18:17??biyue\WebRoot\admin\secu\upsewok.jsp

?????文件???????3701??2011-02-13?18:17??biyue\WebRoot\admin\secu\upsewokdo.jsp

?????文件???????2545??2011-02-13?18:17??biyue\WebRoot\admin\secu\upsewokdodo.jsp

?????文件???????1478??2011-02-12?22:49??biyue\WebRoot\admin\top.jsp

?????文件???????4440??2011-02-13?18:14??biyue\WebRoot\admin\user\upadmin.jsp

?????文件???????2407??2011-02-13?18:14??biyue\WebRoot\admin\user\upadmindo.jsp

?????文件???????4662??2011-02-13?18:15??biyue\WebRoot\admin\user\upnor.jsp

?????文件???????4062??2011-02-13?18:15??biyue\WebRoot\admin\user\upnorup.jsp

?????文件???????2416??2011-02-13?18:15??biyue\WebRoot\admin\user\upnorupdo.jsp

?????文件???????4822??2011-02-13?18:12??biyue\WebRoot\admin\user\upstu.jsp

?????文件???????4374??2011-02-13?18:13??biyue\WebRoot\admin\user\upstuup.jsp

............此處省略251個文件信息