import java.sql.*;
public class example01 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
System.out.print(e);
}
try{
con = DriverManager.getConnection("jdbc:odbc:my","","");
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM goods WHERE price>300000");
while(rs.next()){
String number = rs.getString(1);
String name = rs.getString(2);
Date date = rs.getDate("madeTime");
double price = rs.getDouble("price");
System.out.printf("%-4s",number);
System.out.printf("%-6s",name);
System.out.printf("%-15s",date.toString());
System.out.printf("%6s\n",price);
}
con.close();
}
catch(SQLException e){
System.out.println(e);
}
}
}
java.sql.SQLException: [Microsoft][ODBC Microsoft Access 驱动程序] 不是有效的账户名称或密码。
这是怎么回事，求指点，谢谢了！
