站内搜索: 请输入搜索关键词

当前页面: JAVA 编程资料牛鼻论坛Java & J2SE 技术区→没法写入数据库,而且也不报错,请高手指教啊!!!!!~~谢谢

没法写入数据库,而且也不报错,请高手指教啊!!!!!~~谢谢

发表新主题   回复此主题

第1楼 2008-01-25 03:49 kaoru1120 写道:

没法写入数据库,而且也不报错,请高手指教啊!!!!!~~谢谢

我用java写的程序,用Access连接,odbc都配好了,运行的时候也不出错,可是数据就是不写入,也显示不出来,我是初学,所以大部分代码都是按书上写的,可还是写不进去,希望高手可指教一下,不胜感激!!!!

public void jButton2_actionPerformed(ActionEvent e)throws SQLException {
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connectionStr="jdbc:odbc:db1";
Connection con = null;
Statement stmt = null;
String i=null;
try {Class.forName(DBDriver);
con = DriverManager.getConnection(connectionStr, "", "");
stmt= con.createStatement();
String n= jTextField2.getText();
//String sex=(String)jComboBox1.getSelectedItem();
String id= jTextField3.getText();
String d= jTextField1.getText();
// String type= jTextField5.getText();
i="insert into inf(name,id,date) values('" +n+ "','" +id+"','" +d+"')";
stmt.executeUpdate(i);
stmt.close();
con.close();
}catch(Exception ex1) {ex1.printStackTrace(); }

JOptionPane.showMessageDialog(null,"信息输入成功!", "用户提示",
JOptionPane.INFORMATION_MESSAGE);
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
//jTextField4.setText("");
}

我运行过后出现的是D:\jbuilder\jdk1.5\bin\javaw -classpath "D:\Java\sheji\classes;D:\jbuilder\lib\dx.jar;D:\jbuilder\lib\beandt.jar;D:\jbuilder\jdk1.5\lib\dt.jar;D:\jbuilder\jdk1.5\lib\jconsole.jar;D:\jbuilder\jdk1.5\lib\tools.jar;D:\jbuilder\jdk1.5\lib\htmlconverter.jar;D:\jbuilder\jdk1.5\jre\lib\im\thaiim.jar;D:\jbuilder\jdk1.5\jre\lib\im\indicim.jar;D:\jbuilder\jdk1.5\jre\lib\rt.jar;D:\jbuilder\jdk1.5\jre\lib\plugin.jar;D:\jbuilder\jdk1.5\jre\lib\ext\sunjce_provider.jar;D:\jbuilder\jdk1.5\jre\lib\ext\sunpkcs11.jar;D:\jbuilder\jdk1.5\jre\lib\ext\localedata.jar;D:\jbuilder\jdk1.5\jre\lib\ext\dnsns.jar;D:\jbuilder\jdk1.5\jre\lib\jsse.jar;D:\jbuilder\jdk1.5\jre\lib\charsets.jar;D:\jbuilder\jdk1.5\jre\lib\javaws.jar;D:\jbuilder\jdk1.5\jre\lib\jce.jar;D:\jbuilder\jdk1.5\jre\lib\deploy.jar" sheji.Application2
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at sheji.Frame1.jButton2_actionPerformed(Frame1.java:196)
at sheji.Frame1_jButton2_actionAdapter.actionPerformed(Frame1.java:221)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
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(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
这些是什么意思 有什么问题,怎么看出问题的可以简单的说一下吗?谢谢了 !!

第2楼 2013-08-31 12:44 Robot :

没法写入数据库,而且也不报错,请高手指教啊!!!!!~~谢谢 相关


第3楼 2008-02-24 17:00 deathknight 写道:

回复: 没法写入数据库,而且也不报错,请高手指教啊!!!!!~~谢谢

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。

先从你的SQL语句开始吧

发表新主题   回复此主题