我正在使用下面的代码:
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 (未知源)
发布于 2017-08-04 06:52:20
“‘check”是一个保留的关键字,所以代码失败了,尝试使用一个不是关键字的名称应该可以解决这个问题。
https://stackoverflow.com/questions/45499308
复制相似问题