如题,这个什么问题?
insert into (abc)(a_NAME,aSYS_VERSION,a_RUNTIME) values(?,?,?)
用的是java ,prepareStatement
报错java.sql.SQLException: Parameter index out of range (0 < 1 )
ps = conn.prepareStatement(sql);
for (int i = 1; i <= mValue.size(); i++) {
String inX = mValue.get(i).toString();
if (isType.isFloat(inX, "+")) {
ps.setFloat(i, Float.parseFloat(inX));
System.out.println(inX + "是浮点<br>");
} else if (isType.isNum(inX, "+")) {
ps.setInt(i, Integer.parseInt(inX));
System.out.println(inX + "是整数<BR>");
} else if (isType.isValidDate(inX)) {
String newtime = (String) inX;
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date dateA = format.parse(newtime);
ps.setDate(i, (java.sql.Date) dateA);
System.out.println(inX + "是时间<BR>");
} else {
ps.setString(i, inX);//是字符串
System.out.println(inX + "是字符串<BR>");
}
//ps.addBatch();
System.out.println("inx:" + inX);
}