没法写入数据库，而且也不报错，请高手指教啊！！！！！~~谢谢
我用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)
这些是什么意思 有什么问题，怎么看出问题的可以简单的说一下吗？谢谢了 !! |