server 2000 的数据库插入异常?是怎么回事?_Java相关

server 2000 的数据库插入异常?是怎么回事?

插入sql语句是
String str_insert="insert into Company_produce values('"+produce_name.getText()+"',"+produce_num.getText()+","+produce_price.getText()+","+produce_date.getText()+","+produce_add.getText()+")";
插入对话框如下

数据表设计如下:

运行出现的异常如下:
[Microsoft][ODBC SQL Server Driver][SQL Server]列名 '电脑' 无效。
Exception occurred during event dispatching:
java.lang.NullPointerException
at Produce_manager_Dialog.actionPerformed(Company.java:346)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:153)
at java.awt.Dialog$1.run(Dialog.java:515)
at java.awt.Dialog.show(Dialog.java:536)
at Company.actionPerformed(Company.java:65)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

搜索更多相关的解决方案: 数据库 server

----------------解决方案--------------------------------------------------------
补充一下数据表的内容,
产品名称 varchar
产品代号 int
产品价格 int
进货日期 datatime
产品库存 varchar
产品生产地 varchar
----------------解决方案--------------------------------------------------------
String str_insert="insert into Company_produce values('"+produce_name.getText()+"',"+produce_num.getText()+","+produce_price.getText()+","+produce_date.getText()+","+produce_add.getText()+")";

把2个单引号去掉
----------------解决方案--------------------------------------------------------
呵呵,问题解决了,
谢谢你啊.
----------------解决方案--------------------------------------------------------
比较马虎,怎么说后面的格式肯定是对的啊!
----------------解决方案--------------------------------------------------------