private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
String sr = jTextField1.getText();
String sr1 = jTextField2.getText();
String sr2 = jTextField3.getText();
String sr3 = jTextField4.getText();
String sr4 = jTextField5.getText();
String sr5 = jTextField6.getText();
String sr6 = jTextField7.getText();
String sr7 = jTextField8.getText();
String sr8 = jTextField9.getText();
Util.getConnection();
PreparedStatement stt = null;
Connection conn = null;
conn = Util.getConnection();
String sql = "insert into Product(ProductId,ProductName,ProductAuther,ProductPublish,ProductPublishDate,ProductCategory,ProductLocation,ProductSupplier,ProductStandard) values(?,?,?,?,?,?,?,?,?,)";
//'"+ sr+"','"+ sr1+"','"+ sr2+"','"+ sr3+"','"+ sr4+"','"+ sr5+"','"+ sr6+"','"+ sr7+"','"+ sr8+"'
try {
stt = conn.prepareStatement(sql);
stt.setString(1, sr);
stt.setString(2, sr1);
stt.setString(3, sr2);
stt.setString(4, sr3);
stt.setString(5, sr4);
stt.setString(6, sr5);
stt.setString(7, sr6);
stt.setString(8, sr7);
stt.setString(9, sr8);
stt.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
boolean bo1 = false;
if (sr.isEmpty() && sr1.isEmpty() && sr2.isEmpty() && sr3.isEmpty()
&& sr4.isEmpty()&& sr5.isEmpty()&& sr6.isEmpty()
&& sr7.isEmpty()&& sr8.isEmpty()) {
bo1 = true;
JOptionPane.showMessageDialog(null, "添加失败!");
} else {
JOptionPane.showMessageDialog(null, "添加成功!");
}
// jTextField1.setText(null);
// jTextField2.setText(null);
// jTextField3.setText(null);
// jTextField4.setText(null);
// jTextField5.setText(null);
// jTextField6.setText(null);
// jTextField7.setText(null);
// jTextField8.setText(null);
// jTextField9.setText(null);
}
之后出java.sql.SQLException: ORA-00936: 缺失表达式
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at shangpinguanli.product.jButton1MouseClicked(product.java:385)
at shangpinguanli.product.access$0(product.java:357)
at shangpinguanli.product$1.mouseClicked(product.java:82)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:253)
at java.awt.Component.processMouseEvent(Component.java:6219)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4229)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
这个错误 求大神~