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

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

解决方案就是将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);