publicbooleanupdateDB(Stringsql,String[]paras){booleanb=true;try{ps=ct.prepareStatement(sql);for(inti=0;i
public boolean updateDB(String sql,String [] paras){
boolean b = true;
try {
ps = ct.prepareStatement(sql);
for(int i=0;i
ps.setString(i+1, paras[i]);
}
ps.executeUpdate();
} catch (SQLException e) {
b = false;
e.printStackTrace();
} finally {
close();
}
return b;
}
public boolean insertByDiet(String [] paras){
String sql;
boolean b=false;
try{
sql = "insert into record(cId,bId,mId,borrowDate,returnDate) values(?,?,?,?,?)";
b=updateDB(sql, paras); //更新成功返回true,所以插入成功返回true
}catch(Exception e){
e.printStackTrace();
}
return b;
}
String[]paras1={cid,bid,mid, bdate, rdate};
b=insertByDiet(paras1);
执行的时候,在ps = ct.prepareStatement(sql);这里报错,显示的错误是General error
展开