救命啊!!!老是报java.lang.StringIndexOutOfBoundsException: String index out of range: 16?????
我在 往SQLSERVER中循环插入1-1000的ID的时候老是报java.lang.StringIndexOutOfBoundsException: String index out of range: 16,代码如下:
try{
// connection= DriverManager.getConnection(url11,user11,password11);
connection.setAutoCommit(false);// 事物处理
for(i=0;i<sl;i++){
SQL="";
SQL="select card from newcard where card='"+qskh+"'";
rs=stmt.executeQuery(SQL);
if((rs!=null)&&(rs.next())){
out.println("<script>alert('卡号[ "+qskh+" ]已存在,请确认你要添加的卡段!');self.history.back();</script>");
}else{
SQL="";
SQL="insert into newcard(onlyid,card,lrfs,cardtype,nj,price,dls,ffsj,fffs,ffr) values('"+getOnlyID()+"','"+qskh+"','"+lrfs+"','"+cardtype+"','"+nj+"','"+price+"','未代理',GETDATE(),'"+fffs+"','"+ddd+"')";
connection= DriverManager.getConnection(url11,user11,password11);
stmt=connection.createStatement();
iTmp=stmt.executeUpdate(SQL);
SQL="";
}
qskh1=qskh1+1;
qskh=String.valueOf(qskh1);
SQL="";
}
if(iTmp>0){
out.println("<script language=javascript >alert('批量添加成功!');self.location.reload('addcard.jsp');</script>");
}else{
out.println("<script language=javascript >alert('批量添加失败,请检查你输入的数据格式是否正确!');self.history.back();</script>");
}
}catch(SQLException e){
out.print(e);
connection.rollback();
}