/*public?class?ConnectionMySQL?{

	
	public?static?void?main（String[]?args）?{
		//?TODO?Auto-generated?method?stub

	}

}*/


import?java.sql.*;

import?javax.naming.*;
import?javax.sql.DataSource;

public?class?ConnectionMySQL?{

	public?static?void?main（String[]?args）{
	????//jdbc連接
		demo（）;
		?
		
	
	}

	
	public?static?void?demo（）{
		try{
			Connection?conn=getConnection（）;
			System.out.println（conn.getClass（）.getName（））;
			String?sql=“select?*?from?dept“;
			PreparedStatement?pstmt=conn.prepareStatement（sql）;
			ResultSet?set=（ResultSet）?pstmt.executeQuery（）;
			
			while（set.next（））{
				//System.out.println（set.getInt（“id“））;
				System.out.println（set.getString（“deptno“））;
			}
			closeConnection（conn）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	
	public?static?Connection?getConnection（）{
		
		String?url?=?“jdbc:mysql://localhost:3306/mydata“;?
		String?username?=?“root“;?
		String?password?=?“5882118“;?
//		加載驅動程序以連接數(shù)據(jù)庫
		Connection?conn=null;
		try?{?
				Class.forName（“com.mysql.jdbc.Driver“?）;?
				System.out.println（“1111111“）;
				conn?=?（Connection）DriverManager.getConnection（url?username?password?）;
				return?conn;
			
		}catch?（ClassNotFoundException?cnfex?）?{?
			System.err.println（?
			“裝載?JDBC/ODBC?驅動程序失敗。“?）;?
			cnfex.printStackTrace（）;
		}catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?null;
	}

	public?static?void?closeConnection（Connection?conn）{
		try?{
			conn.close（）;	
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	
	
	
}

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

?????文件???????1315??2011-05-30?18:54??教務系統(tǒng)?周彬\jsp代碼\.classpath

?????文件????????295??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.mymetadata

?????文件?????????66??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.myumldata

?????文件???????1225??2011-04-26?10:52??教務系統(tǒng)?周彬\jsp代碼\.project

?????文件???????1040??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????120??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.settings\com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs

?????文件????????330??2011-05-30?19:07??教務系統(tǒng)?周彬\jsp代碼\.settings\org.eclipse.jdt.core.prefs

?????文件???????1935??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.settings\org.eclipse.wst.validation.prefs

?????文件????????253??2011-05-30?18:51??教務系統(tǒng)?周彬\jsp代碼\.settings\org.maven.ide.eclipse.prefs

?????文件???????1668??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\ConnectionMySQL.java

?????文件????????186??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\liang.java

?????文件????????976??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\TestMysqlConnection.java

?????文件???????5897??2011-04-26?14:55??教務系統(tǒng)?周彬\jsp代碼\src\base\admin.java

?????文件???????4770??2011-04-26?14:56??教務系統(tǒng)?周彬\jsp代碼\src\base\clas.java

?????文件???????1212??2011-05-16?19:30??教務系統(tǒng)?周彬\jsp代碼\src\base\Code.java

?????文件???????7087??2011-05-02?21:05??教務系統(tǒng)?周彬\jsp代碼\src\base\course.java

?????文件???????1106??2011-05-17?18:05??教務系統(tǒng)?周彬\jsp代碼\src\base\Excel.java

?????文件???????3344??2011-04-26?14:56??教務系統(tǒng)?周彬\jsp代碼\src\base\grade.java

?????文件???????5028??2011-05-15?21:20??教務系統(tǒng)?周彬\jsp代碼\src\base\IncomeItem.java

?????文件???????3745??2011-05-26?17:52??教務系統(tǒng)?周彬\jsp代碼\src\base\JXLExcel.java

?????文件???????6914??2011-05-13?20:31??教務系統(tǒng)?周彬\jsp代碼\src\base\picture.java

?????文件???????5462??2011-05-18?18:28??教務系統(tǒng)?周彬\jsp代碼\src\base\Public.java

?????文件???????2717??2011-04-26?14:57??教務系統(tǒng)?周彬\jsp代碼\src\base\speciality.java

?????文件??????25798??2011-05-31?22:48??教務系統(tǒng)?周彬\jsp代碼\src\base\student.java

?????文件??????17556??2011-05-18?19:15??教務系統(tǒng)?周彬\jsp代碼\src\base\stu_class.java

?????文件???????6433??2011-05-12?20:43??教務系統(tǒng)?周彬\jsp代碼\src\base\teacher.java

?????文件??????13662??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\sims\conn\DBManager.java

?????文件??????10600??2011-05-30?18:42??教務系統(tǒng)?周彬\jsp代碼\src\sims\conn\SQLBean.java

?????文件????????590??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\sims\pub\DataFormat.java

?????文件???????4167??2011-04-26?10:51??教務系統(tǒng)?周彬\jsp代碼\src\sims\pub\Pager.java

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