oracle00936缺失表达式_ORA-00936: 缺失表达式 这个应该怎么改 跪谢!

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)

这个错误    求大神~

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值