teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問エラー： No value specified for parameter

編集履歴

質問編集履歴

1

書式改善

2017/07/11 07:33

投稿

KasperHekmatyar
KasperHekmatyar

スコア81

test CHANGED
File without changes
test CHANGED
@@ -8,110 +8,110 @@
8
8
 
9
9
  ```
10
10
 
11
+ java.sql.SQLException: No value specified for parameter 9
12
+
13
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
14
+
15
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
16
+
17
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
18
+
19
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
20
+
21
+ at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2566)
22
+
23
+ at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2542)
24
+
25
+ at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2389)
26
+
27
+ at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
28
+
29
+ at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
30
+
31
+ at exercise_jdbc_kihon_enshu_combineRegist.SendSqlOrder.sendSqlOrder(SendSqlOrder.java:82)
32
+
33
+ at exercise_jdbc_kihon_enshu_combineRegist.ReadFile.csv_read(ReadFile.java:44)
34
+
35
+ at exercise_jdbc_kihon_enshu_combineRegist.FileChooser.fileChooser(FileChooser.java:42)
36
+
37
+ at exercise_jdbc_kihon_enshu_combineRegist.UI$2.actionPerformed(UI.java:81)
38
+
39
+ at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
40
+
41
+ at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
42
+
43
+ at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
44
+
45
+ at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
46
+
47
+ at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
48
+
49
+ at java.awt.Component.processMouseEvent(Component.java:6297)
50
+
51
+ at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
52
+
53
+ at java.awt.Component.processEvent(Component.java:6062)
54
+
55
+ at java.awt.Container.processEvent(Container.java:2039)
56
+
57
+ at java.awt.Component.dispatchEventImpl(Component.java:4660)
58
+
59
+ at java.awt.Container.dispatchEventImpl(Container.java:2097)
60
+
61
+ at java.awt.Component.dispatchEvent(Component.java:4488)
62
+
63
+ at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
64
+
65
+ at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
66
+
67
+ at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
68
+
69
+ at java.awt.Container.dispatchEventImpl(Container.java:2083)
70
+
71
+ at java.awt.Window.dispatchEventImpl(Window.java:2489)
72
+
73
+ at java.awt.Component.dispatchEvent(Component.java:4488)
74
+
75
+ at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)
76
+
77
+ at java.awt.EventQueue.access$400(EventQueue.java:81)
78
+
11
- エラーメッセージ
79
+ at java.awt.EventQueue$2.run(EventQueue.java:633)
80
+
81
+ at java.awt.EventQueue$2.run(EventQueue.java:631)
82
+
83
+ at java.security.AccessController.doPrivileged(Native Method)
84
+
85
+ at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
86
+
87
+ at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
88
+
89
+ at java.awt.EventQueue$3.run(EventQueue.java:647)
90
+
91
+ at java.awt.EventQueue$3.run(EventQueue.java:645)
92
+
93
+ at java.security.AccessController.doPrivileged(Native Method)
94
+
95
+ at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
96
+
97
+ at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)
98
+
99
+ at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
100
+
101
+ at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
102
+
103
+ at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
104
+
105
+ at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
106
+
107
+ at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
108
+
109
+ at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
110
+
111
+
12
112
 
13
113
  ```
14
114
 
15
- java.sql.SQLException: No value specified for parameter 9
16
-
17
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
18
-
19
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
20
-
21
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
22
-
23
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
24
-
25
- at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2566)
26
-
27
- at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2542)
28
-
29
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2389)
30
-
31
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
32
-
33
- at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
34
-
35
- at exercise_jdbc_kihon_enshu_combineRegist.SendSqlOrder.sendSqlOrder(SendSqlOrder.java:82)
36
-
37
- at exercise_jdbc_kihon_enshu_combineRegist.ReadFile.csv_read(ReadFile.java:44)
38
-
39
- at exercise_jdbc_kihon_enshu_combineRegist.FileChooser.fileChooser(FileChooser.java:42)
40
-
41
- at exercise_jdbc_kihon_enshu_combineRegist.UI$2.actionPerformed(UI.java:81)
42
-
43
- at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
44
-
45
- at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
46
-
47
- at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
48
-
49
- at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
50
-
51
- at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
52
-
53
- at java.awt.Component.processMouseEvent(Component.java:6297)
54
-
55
- at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
56
-
57
- at java.awt.Component.processEvent(Component.java:6062)
58
-
59
- at java.awt.Container.processEvent(Container.java:2039)
60
-
61
- at java.awt.Component.dispatchEventImpl(Component.java:4660)
62
-
63
- at java.awt.Container.dispatchEventImpl(Container.java:2097)
64
-
65
- at java.awt.Component.dispatchEvent(Component.java:4488)
66
-
67
- at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
68
-
69
- at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
70
-
71
- at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
72
-
73
- at java.awt.Container.dispatchEventImpl(Container.java:2083)
74
-
75
- at java.awt.Window.dispatchEventImpl(Window.java:2489)
76
-
77
- at java.awt.Component.dispatchEvent(Component.java:4488)
78
-
79
- at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)
80
-
81
- at java.awt.EventQueue.access$400(EventQueue.java:81)
82
-
83
- at java.awt.EventQueue$2.run(EventQueue.java:633)
84
-
85
- at java.awt.EventQueue$2.run(EventQueue.java:631)
86
-
87
- at java.security.AccessController.doPrivileged(Native Method)
88
-
89
- at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
90
-
91
- at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
92
-
93
- at java.awt.EventQueue$3.run(EventQueue.java:647)
94
-
95
- at java.awt.EventQueue$3.run(EventQueue.java:645)
96
-
97
- at java.security.AccessController.doPrivileged(Native Method)
98
-
99
- at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
100
-
101
- at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)
102
-
103
- at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
104
-
105
- at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
106
-
107
- at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
108
-
109
- at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
110
-
111
- at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
112
-
113
- at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
114
-
115
115
 
116
116
 
117
117