UC知道jdbc桥接odbc 访问access数据库出现"参数不足,期待是1"?
来源：百度知道 编辑：UC知道 时间：2024/06/24 13:18:46
import java.sql.*;
public class search_flight
{
public static void main(String args[])
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("trip.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con = DriverManager.getConnection("jdbc:odbc:trip","","");
sql = con.createStatement();
rs = sql.executeQuery("SELECT flightNum,FromCity,ArivCity,flightprice FROM FLIGHTS WHERE flight_numAvail>0");
while(rs.next())
{
String flightNum = rs.getString(1);
String FromCity = rs.getString(2);
String ArivCity = rs.getString(3);
int flightprice = rs.getInt(4);
}
con.close();
}
catch(SQLException e)
{
System.out.println(e);
}
}
}
运行时出现:
java.sql.SQLException:[Microsoft][ODBC Microso
public class search_flight
{
public static void main(String args[])
{
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("trip.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{
con = DriverManager.getConnection("jdbc:odbc:trip","","");
sql = con.createStatement();
rs = sql.executeQuery("SELECT flightNum,FromCity,ArivCity,flightprice FROM FLIGHTS WHERE flight_numAvail>0");
while(rs.next())
{
String flightNum = rs.getString(1);
String FromCity = rs.getString(2);
String ArivCity = rs.getString(3);
int flightprice = rs.getInt(4);
}
con.close();
}
catch(SQLException e)
{
System.out.println(e);
}
}
}
运行时出现:
java.sql.SQLException:[Microsoft][ODBC Microso
SELECT flightNum,FromCity,ArivCity,flightprice FROM FLIGHTS WHERE flight_numAvail>0
把这句SQL放到Access数据库中去执行一下吧，看是报哪个位置的错。
看语句的字段名字是否有错误，或者SQL语句中的参数和表中的字段不对
应。完全是SQL语句的错。和你JAVA代码没有什么关系的。
百度一下，结果很多。
con = DriverManager.getConnection("jdbc:odbc:trip","","");
参数不足，说的是这一句，对照改一下把。
rs.close();
sql.close();
con.close();
出现这样的问题极有可能是查询语句的属性名写错了,仔细检查一下.