数据库的问题pqds快来

[ggimm]

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:button";
con = DriverManager.getConnection(url, "", "");
stmt = con.createStatement();
String query = "INSERT INTO button(string,component,name) values
('haha','jbutton','xxx')";
stmt.executeUpdate(query);
}
catch(Exception e){
e.printStackTrace();
}
说我INSERT INTO 的语法有问题 可是书都在公司里 网上又没例子帮我看看

[pqds]

String query = "INSERT INTO button(string,component,name) values
('haha','jbutton','xxx')";

你这个sql语句是正确的呀？你直接写
INSERT INTO button(string,component,name) values
('haha','jbutton','xxx')在数据库里可以运行吗？

[pqds]

错误提示是什么？贴出来！

[ggimm]

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语
句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3065)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:
288)
at EveryOne.<init>(MyFrame.java:72)
at EveryOne.<init>(MyFrame.java:68)
at EveryOne.<init>(MyFrame.java:68)
at EveryOne.<init>(MyFrame.java:68)
at EveryOne.<init>(MyFrame.java:68)
at MyFrame$1.actionPerformed(MyFrame.java:23)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
64)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1817)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:419)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
at java.awt.Component.processMouseEvent(Component.java:5134)
at java.awt.Component.processEvent(Component.java:4931)
at java.awt.Container.processEvent(Container.java:1566)
at java.awt.Component.dispatchEventImpl(Component.java:3639)
at java.awt.Container.dispatchEventImpl(Container.java:1623)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
at java.awt.Container.dispatchEventImpl(Container.java:1609)
at java.awt.Window.dispatchEventImpl(Window.java:1590)
at java.awt.Component.dispatchEvent(Component.java:3480)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:197)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)

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

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

[pqds]

你这个sql语句是正确的呀？你直接写
INSERT INTO button(string,component,name) values
('haha','jbutton','xxx')在数据库里可以运行吗？
先在数据库里直接试一下

[Keepers]

string 和 value是两个基本字
,不能使用他作为列名

[pqds]

有没有可呢个String 保留字！

[YuLimin]

1、先在SQL中看是否能够直接插入
2、再到java中来检查