import java.sql.*;

class JdbcOdbc 
{
	JdbcOdbc() throws Exception
	{
		String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
		String url = "Jdbc:Odbc:PMS";
		Class.forName(driver);
		Connection con = DriverManager.getConnection(url,"","");
		Statement stmt = con.createStatement();
		//stmt.executeUpdated("CREATE TABLE Alunos(nome, numero)");
		ResultSet rs = stmt.executeQuery("SELECT * FROM SIS");
		
		ImprimeResultSet(rs);
		
		while (rs.next())
		{
		   System.out.println("Nome:" + rs.getString(1) + "\t" + rs.getString(2));
		//ou
		//   System.out.println("Nome:" + rs.getString("nome"));
		}
		//ResultSetMetaData rsmd = rs.getMetaData();
		//int numCols = rsmd.getColumnCount();
		rs.close();
		stmt.close();
		con.close();
	}
	
	public static void main(String args[]) throws Exception
	{
		new JdbcOdbc();		
	}
	
	void ImprimeResultSet(ResultSet res) throws Exception 
	{
		ResultSetMetaData rsmd = res.getMetaData();
		int nCol = rsmd.getColumnCount();
		StringBuffer linha = new StringBuffer();
		StringBuffer coluna = new StringBuffer();
		/* Imprime Cabeçalho */
		for (int i=1;i<=nCol;i++)
		{
			coluna.append(rsmd.getColumnName(i));
			int tamCol = rsmd.getColumnDisplaySize(i);
			coluna.setLength(tamCol);
			linha.append(coluna.toString());
			coluna.setLength(0);
			linha.append("\t");
		}
		linha.append("\n");
		System.out.println (linha);
		
		linha.delete(0,linha.length() -1);
		while (res.next())
		{
			for (int i=1;i<=nCol;i++)
			{
				int tamCol = rsmd.getColumnDisplaySize(i);
				linha.append (res.getString(i));
				linha.append ("\t");
			}
			System.out.println (linha);
			linha.delete(0,linha.length() -1);
		}

	}
	
}