批量更新和插入报错：超出游标的范围总结

本文主要是介绍批量更新和插入报错：超出游标的范围总结，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

批量更新和插入报错：超出游标的范围

解决方案就是将preparement 放在外面，代码如下：

String querySql = "SELECT RID FROM " + dbTableName + " WHERE tab_name = ?";
PreparedStatement queryPreparedStatement = conn.prepareStatement(querySql);
String updateSql = "UPDATE " + dbTableName + " SET tab_name_en = ?, is_virtual = ?, col_data_dt = ? WHERE tab_name = ?" ;
PreparedStatement updatePreparedStatement = conn.prepareStatement(updateSql);
String insertSql = "INSERT INTO " + dbTableName + "(rid, tab_name, tab_name_en, is_virtual, col_data_dt, tab_type) VALUES (?, ?, ?, ?, ?, ?)";
PreparedStatement insertPreparedStatement = conn.prepareStatement(insertSql);

这篇关于批量更新和插入报错：超出游标的范围总结的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---