package chapter17;

import java.sql.*;

public class example6
{
	public static void main(String args[ ])
	{
		String strQuery="SELECT * FROM StudentInfo";
		Connection conn;
		Statement stat;
		ResultSet rs;
		ResultSetMetaData rsmd;
		String sSID,sName,sSex,sClass;
		Date dBirth;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn=DriverManager.getConnection("jdbc:odbc:Student","sa","");
			stat=conn.createStatement();
			rs=stat.executeQuery(strQuery);
			rsmd=rs.getMetaData();
			for(int i=1;i<=rsmd.getColumnCount();i++)
			{
				System.out.print(rsmd.getColumnName(i)+" ");
			}
			System.out.println("\n----------------------------------------");
			while(rs.next())
			{
				sSID=rs.getString(1);
				sName=rs.getString(2);
				sSex=rs.getString(3);
				dBirth=rs.getDate(4);
				sClass=rs.getString(5);
				System.out.println(sSID+" "+sName+" "+sSex+" "+dBirth+" "+sClass);
			}
			rs.close();
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}
	}
}