初学JDBC遇到问题,代码帖出,请高手帮忙指点,谢谢
import java.sql.*;
import java.net.*;


public class Insert{
public static void main(String[] args){
String url= "jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=public;DatabaseName =Northwind ";

//sql语句；
String query = "Select * from firsttable ";

try{

Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");

Connection con = DriverManager.getConnection(url);

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(query);

dispResultSet(rs);

rs.close();

stmt.close();

con.close();
}
catch(SQLException ex){

System.out.println( "\n***SQLException caught***\n ");

while(ex != null){
System.out.println( "SQLState: " + ex.getSQLState());
System.out.println( "Message: " + ex.getMessage());
System.out.println( "Vendor: " + ex.getErrorCode());
ex = ex.getNextException();
System.out.println( " ");
}
}
catch(java.lang.Exception ex){
ex.printStackTrace();
}
}//main

private static void dispResultSet(ResultSet rs) throwsSQLException{
int i;

ResultSetMetaDate rsmd = rs.getMetaDate();

int numCols = rsmd.getColumnCount();

for(i = 1; i <= numCols; i++){
if(i > 1) System.out.print( ", ");
System.out.print(rsmd.getColumnLabel(i));
}//for
System.out.print( " ");
System.out.print( " ");

boolean more = rs.next();

while(more){

for(i = 1;i <= numCols;i++){
if(i > 1)System.out.print( ", ");
System.out.print(rs.getString(i));
}
System.out.println( " ");
more = rs.next();
}//while
}
}


提示错误是:cannot resolve symbol
symbol:class ResultSetMetaDate rsdm = rs.getMetaDate();




[解决办法]
ResultSetMetaDate ？？
是ResultSetMetaData吧！！
[解决办法]
int i;

java.sql.ResultSetMetaData rsmd = rs.getMetaData();

int numCols = rsmd.getColumnCount();

for(i = 1; i <= numCols; i++)
{
if(i > 1)
System.out.print( ", ");

System.out.print(rsmd.getColumnName(i));
}//for
System.out.print( "\n\r ");


boolean more = rs.next();

while(more)
{
for(i = 1;i <= numCols;i++)
{
if(i > 1)
System.out.print( ", ");
System.out.print(rs.getString(i));
}
System.out.println( " ");
more = rs.next();
}//while