求助（连接数据库）为什么会报错？

[t427795737]

jdbc-odbc驱动加载成功
数据库连接成功
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at FoundDemoAccess.main(FoundDemoAccess.java:14)

import java.sql.*;
public class FoundDemoAccess
{
public static void main(String[] args) throws Exception
{
String url = "jdbc:odbc:studentsAccess";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("jdbc-odbc驱动加载成功");
Connection conn = DriverManager.getConnection(url, "", "");
System.out.println("数据库连接成功");
Statement stmt = conn.createStatement();
String sql = "select 编号, 学号, 姓名, 性别, 班级 from studentbase";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3) + " " + rs.getString(4));
}
rs.close();
conn.close();
}
}

[tomsmish]

Properties pro=new Properties();
pro.put("user","");
pro.put("password","");
Driver myDriver = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection myConn=myDriver.connect("jdbc:odbc:DataSource",pro);

试试行不行.

[disconnect]

String sql = "select 编号, 学号, 姓名, 性别, 班级 from studentbase"; //应该是这条sql语句有错,你试下在数据库中执行是成功

[ranshaoweng]

用JDBC,