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个啊 困惑 请指点 谢谢
{ 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个啊 困惑 请指点 谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货