package?com.qiz.controller;

import?java.sql.*;

public?class?JdbcHelper?{

	static?String?DriverName?=?“com.mysql.jdbc.Driver“;
	static?String?DbName?=?“test“;
	static?String?UserName?=?“root“;
	static?String?Password?=?“213321“;
	static?String?url?=?“jdbc:mysql://127.0.0.1:3306/“?+?DbName;

	public?static?Connection?getConn（）?throws?ClassNotFoundException
			SQLException?{
		Class.forName（DriverName）;
		Connection?conn;
		conn?=?DriverManager.getConnection（url?UserName?Password）;
		return?conn;
	}

	public?static?ResultSet?execSql（String?sql）?throws?ClassNotFoundException
			SQLException?{
		Connection?conn?=?getConn（）;
		Statement?st?=?conn.createStatement（）;
		ResultSet?rs?=?st.executeQuery（sql）;
		return?rs;
	}
	
	
	
	public?static?int?getColCount（Res

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

?????文件????????476??2011-11-28?18:31??Qiz\.classpath

?????文件????????379??2011-11-25?16:13??Qiz\.project

?????文件????????629??2011-11-25?16:13??Qiz\.settings\org.eclipse.jdt.core.prefs

?????文件?????328330??2011-11-25?16:40??Qiz\alloy.jar

?????文件???????5500??2011-11-28?23:47??Qiz\bin\com\qiz\controller\Qiz.class

?????文件???????1480??2011-11-28?22:05??Qiz\bin\com\qiz\model\Student.class

?????文件???????1251??2011-11-29?00:37??Qiz\bin\com\qiz\view\Mainframe$1.class

?????文件???????3518??2011-11-29?00:37??Qiz\bin\com\qiz\view\Mainframe.class

?????文件???????5419??2011-11-29?00:36??Qiz\bin\com\qiz\view\P_Add.class

?????文件????????281??2011-11-28?18:31??Qiz\bin\com\qiz\view\P_Delete.class

?????文件???????2090??2011-11-29?00:35??Qiz\bin\com\qiz\view\P_List.class

?????文件???????2817??2011-11-29?00:35??Qiz\bin\com\qiz\view\P_Select.class

?????文件????????281??2011-11-28?18:31??Qiz\bin\com\qiz\view\P_Update.class

?????文件???????1828??2011-11-29?00:34??Qiz\bin\com\qiz\view\P_Welcome.class

?????文件???????3830??2011-11-28?23:47??Qiz\src\com\qiz\controller\Qiz.java

?????文件????????958??2011-11-28?22:05??Qiz\src\com\qiz\model\Student.java

?????文件???????6414??2011-11-29?00:37??Qiz\src\com\qiz\view\Mainframe.java

?????文件???????8555??2011-11-29?00:36??Qiz\src\com\qiz\view\P_Add.java

?????文件????????165??2011-11-25?17:07??Qiz\src\com\qiz\view\P_Delete.java

?????文件???????1920??2011-11-29?00:35??Qiz\src\com\qiz\view\P_List.java

?????文件???????4079??2011-11-29?00:35??Qiz\src\com\qiz\view\P_Select.java

?????文件????????165??2011-11-25?17:07??Qiz\src\com\qiz\view\P_Update.java

?????文件???????1305??2011-11-29?00:34??Qiz\src\com\qiz\view\P_Welcome.java

?????目錄??????????0??2011-11-28?18:33??Qiz\bin\com\qiz\controller

?????目錄??????????0??2011-11-28?18:31??Qiz\bin\com\qiz\model

?????目錄??????????0??2011-11-29?00:30??Qiz\bin\com\qiz\view

?????目錄??????????0??2011-11-28?18:33??Qiz\src\com\qiz\controller

?????目錄??????????0??2011-11-25?16:37??Qiz\src\com\qiz\model

?????目錄??????????0??2011-11-29?00:30??Qiz\src\com\qiz\view

?????目錄??????????0??2011-11-28?18:31??Qiz\bin\com\qiz

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