首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >无法用java在sql数据库中写入数据,但读取成功。

无法用java在sql数据库中写入数据,但读取成功。
EN

Stack Overflow用户
提问于 2017-08-04 06:05:57
回答 1查看 152关注 0票数 0

我正在使用下面的代码:

代码语言:javascript
运行
复制
JButton btnEdit = new JButton("Edit");
btnEdit.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent arg0) {

        try{
        String query = "Insert Into check(Name, Password)Values(?,?)";
        PreparedStatement pst = con.prepareStatement(query);
        pst.setString(1, textField.getText());
        pst.setString(2, textField_1.getText());
/*      pst.setString(3, textField_2.getText());
        pst.setString(4, textField_4.getText());
        pst.setString(5, textField_5.getText());
        */

        pst.execute();
        JOptionPane.showMessageDialog(null, "Data Saved");
        pst.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }
});

我从SQL数据库中检索数据,但是每当我尝试插入数据时,我都会在运行时得到错误:

java.sql.SQLException:关键字‘MicrosoftSQL’附近的MicrosoftSQL ServerIncorrect语法。在sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown源)在sun.jdbc.odbc.JdbcOdbc.standardError(未知源)在sun.jdbc.odbc.JdbcOdbc.SQLExecute(未知源)在AdminPanel$2.actionPerformed(AdminPanel.java:184) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)在javax.swing.AbstractButton$Handler.actionPerformed(Unknown源头)在javax.swing.DefaultButtonModel.fireActionPerformed(未知源)在javax.swing.DefaultButtonModel.setPressed(Unknown源)在javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown源)在java.awt.Component.processMouseEvent(未知源)在javax.swing.JComponent.processMouseEvent(Unknown源)在java.awt.Component.processEvent(未知源)在java.awt.Container.processEvent(未知源)在java.awt.Component.dispatchEventImpl(未知源)在java.awt.Container.dispatchEventImpl(未知源)( java.awt.LightweightDispatcher.retargetMouseEvent(Unknown源)在java.awt.Component.dispatchEvent(未知源)在java.awt.LightweightDispatcher.dispatchEvent(Unknown源)在java.awt.Container.dispatchEventImpl(未知源)在java.awt.Window.dispatchEventImpl(未知源)在java.awt.Component.dispatchEvent(未知源)在java.awt.EventQueue.dispatchEventImpl(未知源)(未知源)在java.awt.EventQueue$3.run(未知源)在java.awt.EventQueue$3.运行(未知源)在java.security.AccessController.doPrivileged(Native方法下运行(未知源)在java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)在java.awt.EventQueue$4.运行(未知源)在java.awt.EventQueue$4.运行(未知源)( .security.AccessController.doPrivileged(Native方法)在java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown源)在java.awt.EventQueue.dispatchEvent(未知源)在java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown源(在java.awt.EventDispatchThread.pumpEventsForFilter(Unknown源)在java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown源(在java.awt.EventDispatchThread.pumpEvents(Unknown源)在java.awt.EventDispatchThread.pumpEvents(Unknown源)在java.awt.EventDispatchThread.run (未知源)

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-08-04 06:52:20

“‘check”是一个保留的关键字,所以代码失败了,尝试使用一个不是关键字的名称应该可以解决这个问题。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/45499308

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档