queryapp.java

来自「J2EE指南」· Java 代码 · 共 49 行

import java.sql.*;
public class QueryApp
{
	public static void main(String args[])
	{
		ResultSet result;
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con=DriverManager.getConnection("jdbc:odbc:mydatabase","user1","");
			Statement stat=con.createStatement();
			result=stat.executeQuery("select * from publishers");
			ResultSetMetaData rsmd=result.getMetaData();
			int colCount=rsmd.getColumnCount();
			String rowdata=rsmd.getColumnName(1).trim();
			for(int i=2;i<=colCount;i++)
			{
				rowdata=rowdata+"   :   "+rsmd.getColumnName(i).trim();
			}
			System.out.println(rowdata);
			System.out.println("--------------------------------------------------------------");
			while(result.next())
			{
				rowdata=result.getString(1).trim();
				
				
				
				for(int i=2;i<=colCount;i++)
				{
					
				    
				    
					rowdata=rowdata+"   :   "+result.getString(i);
					
	                 
                 
				}
				System.out.println(rowdata);
				System.out.println("\n");
			}
		}
	
		catch(Exception e)
		{
			System.out.println("Could not execute the query"+e);
		}
	}
}