void save_actionPerformed(ActionEvent e) {
    String query=" UPDATE CompanyInfo SET"+
              "CompanyName='"+comname.getText()+
              "',Address='"+address.getText()+
              "',Responsor='"+responsor.getText()+
              "',Tel='"+phone.getText()+
              "',Mobile='"+mobile.getText()+
              "',HomePage='"+homepage.getText()+
              "',Email='"+email.getText()+
              "',FaRen='"+lawer1.getText()+
              "',Introduction='"+jTextArea1.getText()+"'";        try{          Statement statement=connection.createStatement();          int result=statement.executeUpdate(query);          if(result==1){
            JOptionPane.showConfirmDialog(this,"恭喜,修改成功,祝贺您^_^");
          }
          }catch(SQLException sqlex){
          sqlex.printStackTrace();
        }
  }我用的是Jbuilder9.0,系统有如下例外提示:
      java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。 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 工资管理专家.CompanyInfo.save_actionPerformed(CompanyInfo.java:220) at 工资管理专家.CompanyInfo_save_actionAdapter.actionPerformed(CompanyInfo.java:264) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.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(BasicButtonListener.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(EventDispatchThread.java:197) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)  不知道是什么原因,以上代码中关于数据库的字段和access中的字段顺序完全一致,请诸位大侠指点迷津。