Question

java程序中向oracle插入日期格式报错呀！！ java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 11

String sql = "insert into tbl_vehicleapplication(applicantnumber,applicantname,telephonenumber,areaid,companyid,deptid,applicantleavingdate,planreturndate,destination,usingreason,apptime) values(?,?,?,?,?,?,to_date(?,'YYYY-mm-dd'),to_date(?,'YYYY-mm-dd'),?,?,to_date(?,'YYYY-mm-dd'));";
boolean flog = false;
try {
conn = db.getConnection();
pstmt = conn.prepareStatement(sql);

pstmt.setString(1, tvapp.getApp_number());
System.out.println(tvapp.getApp_number());
pstmt.setString(2, tvapp.getApp_name());
System.out.println(tvapp.getApp_name());
pstmt.setString(3, tvapp.getTel_number());
System.out.println(tvapp.getTel_number());
pstmt.setInt(4,tvapp.getArea_id());
System.out.println(tvapp.getArea_id());
pstmt.setInt(5, tvapp.getCompany_id());
System.out.println(tvapp.getCompany_id());
pstmt.setInt(6, tvapp.getDept_id());
System.out.println(tvapp.getDept_id());
pstmt.setDate(7, tvapp.getApp_leaving_date());
System.out.println(tvapp.getApp_leaving_date());
pstmt.setDate(8, tvapp.getPlan_return_date());
System.out.println(tvapp.getPlan_return_date());
pstmt.setString(9, tvapp.getDestination());
System.out.println(tvapp.getDestination());
pstmt.setString(10, tvapp.getUsing_reason());
System.out.println(tvapp.getUsing_reason());

if(pstmt.executeUpdate()>0){
flog = true;
}

Answer 1

我勒个去 你都没有处理吗？虽然在插入的时候todate但你的参数也要符合日期格式啊？util包里有一个dateformat，sql包里有一个date你转换一下传上去

Answer 2

日期用String类型试试

Answer 3

你赋值 少赋值了一个 第十一个 没有赋值 也就是最后一个

Answer 4

我没查错的话你要给11个？赋值！