java - SQL PreparedStatement 中的 Java ArrayIndexOutOfBoundsException - 数组长度为 0?
问题描述
我正在做的 Java/SQL 项目中的特定 PreparedStatement 存在问题。当我调用“编辑”方法(并且只有“编辑”方法)时,我得到一个 ArrayIndexOutOfBoundsException。更令人费解的是,我的索引值是从 1 开始的,而例外是数组的长度为 0。为什么会发生这种情况,如何解决?
在这一行抛出异常:
pstmt.setInt(1, newID);
代码:
public void editPatientSQL(String[] info) {
String sql = "UPDATE Patient SET ID = 'newID', Name = 'name', Phone = 'phone', DoctorID = 'doctorID' WHERE ID = 'oldID'";
int newID, phone, doctorID, oldID;
String name;
newID = Integer.parseInt(info[0]);
name = info[1];
phone = Integer.parseInt(info[2]);
doctorID = Integer.parseInt(info[3]);
oldID = Integer.parseInt(model.getValueAt(selectedRow, 0).toString());
try {
Connection conn = connect();
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, newID);
pstmt.setString(2, name);
pstmt.setInt(3, phone);
pstmt.setInt(4, doctorID);
pstmt.executeUpdate();
pstmt.close();
conn.close();
}catch(SQLException ex) {
System.out.println(ex.getMessage());
}
}
例外:
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0
at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:121)
at org.sqlite.jdbc3.JDBC3PreparedStatement.setInt(JDBC3PreparedStatement.java:324)
at hospitalDatabase.DatabaseGui.editPatientSQL(DatabaseGui.java:490)
at hospitalDatabase.DatabaseGui.actionPerformed(DatabaseGui.java:619)
at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
at java.desktop/java.awt.Component.processMouseEvent(Component.java:6632)
at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
at java.desktop/java.awt.Component.processEvent(Component.java:6397)
at java.desktop/java.awt.Container.processEvent(Container.java:2263)
at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5008)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2762)
at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:389)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:389)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
解决方案
您应该使用问号来指示应在何处插入参数。
String sql = "UPDATE Patient SET ID = ?, Name = ?, Phone = ?, DoctorID = ? WHERE ID = ?";
推荐阅读
- c# - Can I run two TestServers on one environment, with different configs?
- arrays - MS Access VBA 循环停止,没有错误或明显原因
- kubernetes - 如果容器死亡,Kubernetes 会重启多容器 pod
- python - 比较多列上的熊猫数据框并创建主df
- apache-spark - 以有状态的方式处理 Spark 中的网络数据包
- java - 我添加了进度条,我希望它自动隐藏
- css - Hover.css 边框底部效果在 Opera 中无法正常工作
- jenkins - Jenkins:是否可以扩展流水线脚本定义窗口?
- javascript - POST 请求后禁用按钮
- usb - 使用 Roku 的 USB 进行 ECP“查询”命令?