高分送上，用jsp连接sqlserver，将数据插入到数据库，出现java.lang.ArrayIndexOutOfBoundsException异常

Question

是数组下标越界了
将
insertreserv.setString(2,customername);
insertreserv.setString(3,address);
insertreserv.setString(4,city);
insertreserv.setString(5,state);
insertreserv.setString(6,phone);
insertreserv.setString(7,zip);
insertreserv.setInt(10,roomNo);
insertreserv.setFloat(12,roomcharge);
改成
insertreserv.setString(1,customername);
insertreserv.setString(2,address);
insertreserv.setString(3,city);
insertreserv.setString(4,state);
insertreserv.setString(5,phone);
insertreserv.setString(6,zip);
insertreserv.setInt(7,roomNo);
insertreserv.setFloat(8,roomcharge);

Answer 1

是数组下标越界了
将
insertreserv.setString(2,customername);
insertreserv.setString(3,address);
insertreserv.setString(4,city);
insertreserv.setString(5,state);
insertreserv.setString(6,phone);
insertreserv.setString(7,zip);
insertreserv.setInt(10,roomNo);
insertreserv.setFloat(12,roomcharge);
改成
insertreserv.setString(1,customername);
insertreserv.setString(2,address);
insertreserv.setString(3,city);
insertreserv.setString(4,state);
insertreserv.setString(5,phone);
insertreserv.setString(6,zip);
insertreserv.setInt(7,roomNo);
insertreserv.setFloat(8,roomcharge);

Answer 2

insertreserv=con.prepareStatement("insert into reservation(vCustomerName,vAddress,vCity,cState,cPhone,cZip,iRoomNo,mRoomCharge) values(?,?,?,?,?,?,?,?)");
insertreserv.setString(2,customername);
insertreserv.setString(3,address);
insertreserv.setString(4,city);
insertreserv.setString(5,state);
insertreserv.setString(6,phone);
insertreserv.setString(7,zip);
insertreserv.setInt(10,roomNo);
insertreserv.setFloat(12,roomcharge); SET的时候不匹配。
SQL语句没有那么多的参数。