查询值的数目与目标字段中的数目不同
while (rs.next())
{
String temp = "insert into 结果 (A,B,C,D,E,F,G,H,I,J,K) " +
" values( ' " + rs.getString(1) + " ', ' " +
rs.getString(2) + " ' , ' " + rs.getString(3) +
" ', ' " + rs.getString(4) + " ' , ' " +
rs.getString(5) + " ', ' " + rs.getString(6) + " ', ' " +
rs.getString(7) + " ', ' " + rs.getString(8) + " ', ' " +
rs.getString(9) + " ', ' " + rs.getString(10) + " ' ' " +
rs.getString(11) + " ') ";
System.out.println(temp);
sm.addBatch(temp);
}
sm.executeBatch();
结果提示 :
SQLException:[Microsoft][ODBC Microsoft Access Driver] 查询值的数目与目标字段中的数目不同。
都是11个啊 困惑 请指点 谢谢
------解决方案--------------------接分的沙发,呵呵