queryapp.java

java课程的资料以及实验的代码

import java.sql.*;

public class QueryApp
{
	public static void main(String[] args)
	{
		ResultSet rs;
		String rowdata="";
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
			Connection con = DriverManager.getConnection("jdbc:odbc:MyDataSource","sa","");
			
			Statement stat = con.createStatement();
			rs = stat.executeQuery("select * from Login");
			
			//ResultSetMetaData对象存放结果集的信息
			ResultSetMetaData rsm = rs.getMetaData();
			int colCount = rsm.getColumnCount();
			
			rowdata = rsm.getColumnName(1).trim();
			for(int i=2;i<=colCount;i++)
			{
				rowdata = rowdata + "  :  " + rsm.getColumnName(i).trim();	
			}
			System.out.println(rowdata);
			
			System.out.println("-------------------------");
			
			while(rs.next())
			{
				rowdata	= rs.getString(1).trim();
				for(int i=2;i<=colCount;i++)
				{
					rowdata = rowdata + "    :    " + rs.getString(i).trim();
				}
				System.out.println(rowdata);
			}
		}
		catch(Exception e)
		{}
	}	
}