J2SE-JDBC 資料庫select篇

Statement stmt = null;
stmt = conn.createStatement();
//從meetingatschool table 去select
//executeQuery()方法則是用於SELECT等查詢資料庫的SQL
//會傳回ResultSet物件，代表變更或查詢的結果，查詢的結果會是一筆一筆的資料
ResultSet result = stmt.executeQuery( "SELECT * FROM meetingatschool");
//使用查詢到的結果之欄位順序來顯示
//next()來移動至下一筆資料，它會傳回 true 或 false表示是否有下一筆資料
//由於我meetingatschool table存的型別是int 因此 我用getInt來取得資料
while(result.next()) {
System.out.print(" "+result.getInt(1) + "\t");
//這個地方 我是要拿來比較大小用
general=new Integer(result.getInt(1));
System.out.print(" "+result.getInt(2) + "\t");
meeting=new Integer(result.getInt(2));
System.out.print(" "+result.getInt(3) + "\t" );
vibration=new Integer(result.getInt(3));
System.out.println(" "+result.getInt(4) + "\t");
outdoor=new Integer(result.getInt(4));
}