难道不是这样写:select aa,bb,cc from aa,不过好像你的odbc的数据源没写好,好像是这样的,我记得:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"myLogin", "myPassword");
//String url = "jdbc:odbc:Fred";
//String myLogin= "username";
//String myPassword= "password";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"myLogin", "myPassword");
//String url = "jdbc:odbc:Fred";
//String myLogin= "username";
//String myPassword= "password";
public static void main(String args[])
{
try{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(sDBDriver);
Connection conn=DriverManager.getConnection("jdbc:odbc:exceltest");
Statement stmt=conn.createStatement();
String sqlstr="Select * From [Sheet1$]";
//或者写成String sqlstr="Select * From aa.[Sheet1$]"; ResultSet rs=stmt.executeQuery(sqlstr);
while(rs.next())
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}