dbquery.java

来自「java写的源码」· Java 代码 · 共 32 行

package DBlab;
import java.sql.*;


public class DBQuery {
	
	DBQuery(){};
	
	public void Query(){
		try{ 
			Connection conn = JDBConnection.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from BOOKINFO");
			ResultSetMetaData meta = rs.getMetaData();
			int nCol = meta.getColumnCount();
			while(rs.next()){
				for(int i = 1;i <= nCol;i++){
					System.out.print(rs.getObject(i)+" ");
				}
				System.out.println();
			}
			rs.close();
			stmt.close();
			conn.close();
		}catch(SQLException e){
			e.printStackTrace();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}