未设置java sql异常参数 [英] java sql exception parameter not set
本文介绍了未设置java sql异常参数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试从具有2个参数的表的数据库中获取数据, 当我尝试执行此代码时,出现错误:参数未设置. 我认为这是一个小错误,但我找不到. 问题可能出在2个参数,我以前从未使用过2个.谁能帮我吗?
I am trying to get data from a database in a table with 2 where parameters, When i try to execute this code it gives the error: Parameter not set. I think it is a small mistake but I can't find it. The problem could be with the 2 where parameters, i never used 2 before. Can anyone help me?
public static void tabelVullen(int Kaartnummer,int Datum){
Connection con;
try {
con = DriverManager.getConnection(DB, "", "");
PreparedStatement s = con.prepareStatement("Select Kaartnummer, Datum, Maaltijd, Prijs FROM Logbestanden WHERE Kaartnummer=? AND Datum=?");
s.setInt(1, Kaartnummer);
rset = s.executeQuery();
while(rset.next()){
String[] Logboek = new String[4];
Logboek[0]=rset.getString("Kaartnummer");
Logboek[1]=rset.getString("Datum");
Logboek[2]=rset.getString("Maaltijd");
Logboek[3]=rset.getString("Prijs");
model.addRow(Logboek);
}
s.close();
con.close();
} catch (SQLException e) {
System.out.println("Error LogbestandenWeergeven: " + e);
}
}
这是错误
Error LogbestandenWeergeven: net.ucanaccess.jdbc.UcanaccessSQLException: Parameter not set
推荐答案
您只需要为Datum值提供第二个参数即可.
You just need to supply a second parameter for the Datum value:
PreparedStatement s = con.prepareStatement("Select Kaartnummer, Datum, Maaltijd, Prijs FROM Logbestanden WHERE Kaartnummer=? AND Datum=?");
s.setInt(1, Kaartnummer);
s.setInt(2, Datum); // this is what you are missing
rset = s.executeQuery();
这篇关于未设置java sql异常参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文