在创建表时代表一个SQLite错误

我正在开发一个将用户事件存储在数据库中的应用程序.为此,我使用SQLite进行存储,但是当我执行查询时,它会抛出错误. 以下是我点击添加按钮时触发操作的代码: -

add.addActionListener(new ActionListener() {
   @Override
   public void actionPerformed(ActionEvent evt) {
     Log.p(dateLabel.getText().toString());
     //if((dateLabel.getText() == null) && (eventArea.getText() == null) && (descriptionArea.getText() == null)){
     if ((dateLabel.getText() == "") || (eventArea.getText() == "") || (descriptionArea.getText() == "")) {
      Dialog.show("Required field", "Please fill all the fields", "OK", "");
     }
     //}
     else {

      Label date1 = new Label("Event Date:- ");
      Label dateLabel1 = new Label(dateLabel.getText());
      Label event1 = new Label("Event:- ");
      Label eventArea1 = new Label(eventArea.getText());
      Label description1 = new Label("Event Description:- ");
      Label descriptionArea1 = new Label(descriptionArea.getText());

      Container container1 = TableLayout.encloseIn(2, date1, dateLabel1, event1, eventArea1, description1, descriptionArea1);
      container1.setUIID("container");

      saveEvent.add(container1);

      ToastBar.showMessage("Event successfull saved", FontImage.MATERIAL_SAVE, 4000);

      //Databse Working


      try {
       db = Display.getInstance().openOrCreate("Events.db");
       cur = db.executeQuery("CREATE TABLE 'calendar' ('Date' DATE NOT NULL,'Event' VARCHAR(250) NOT NULL,'Description' VARCHAR(500) NOT NULL);");

       String[] values = new String[] {
        dateLabel.getText(), eventArea.getText(), descriptionArea.getText()
       };

       db.execute("INSERT INTO data('Date','Event','Description') VALUES(?,?,?)", values);

       Button database = new Button("Database");
       calendar.add(database);
       database.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent evt) {
         try {
          cur = db.executeQuery("SELECT * FROM data");
          int columns = cur.getColumnCount();
          DataEvent.removeAll();

          if (columns > 0) {
           boolean next = cur.next();
           if (next) {
            ArrayList  data = new ArrayList <> ();
            String[] columnNames = new String[columns];
            for (int iter = 0; iter 

应用程序抛出的错误如下: - 

java.sql.SQLException: Query does not return results
    at org.sqlite.PrepStmt.executeQuery(PrepStmt.java:104)
    at com.codename1.impl.javase.SEDatabase.executeQuery(SEDatabase.java:172)
    at com.pivotal.calendar.Calender$4.actionPerformed(Calender.java:211)
    at com.codename1.ui.util.EventDispatcher.fireActionEvent(EventDispatcher.java:349)
    at com.codename1.ui.Button.fireActionEvent(Button.java:435)
    at com.codename1.ui.Button.released(Button.java:467)
    at com.codename1.ui.Button.pointerReleased(Button.java:566)
    at com.codename1.ui.Form.pointerReleased(Form.java:2642)
    at com.codename1.ui.Form.pointerReleased(Form.java:2578)
    at com.codename1.ui.Component.pointerReleased(Component.java:3266)
    at com.codename1.ui.Display.handleEvent(Display.java:2025)
    at com.codename1.ui.Display.edtLoopImpl(Display.java:1070)
    at com.codename1.ui.Display.mainEDTLoop(Display.java:999)
    at com.codename1.ui.RunnableWrapper.run(RunnableWrapper.java:120)
    at com.codename1.impl.CodenameOneThread.run(CodenameOneThread.java:176)
java.io.IOException: Query does not return results
    at com.codename1.impl.javase.SEDatabase.executeQuery(SEDatabase.java:176)
    at com.pivotal.calendar.Calender$4.actionPerformed(Calender.java:211)
    at com.codename1.ui.util.EventDispatcher.fireActionEvent(EventDispatcher.java:349)
    at com.codename1.ui.Button.fireActionEvent(Button.java:435)
    at com.codename1.ui.Button.released(Button.java:467)
    at com.codename1.ui.Button.pointerReleased(Button.java:566)
    at com.codename1.ui.Form.pointerReleased(Form.java:2642)
    at com.codename1.ui.Form.pointerReleased(Form.java:2578)
    at com.codename1.ui.Component.pointerReleased(Component.java:3266)
    at com.codename1.ui.Display.handleEvent(Display.java:2025)
    at com.codename1.ui.Display.edtLoopImpl(Display.java:1070)
    at com.codename1.ui.Display.mainEDTLoop(Display.java:999)
    at com.codename1.ui.RunnableWrapper.run(RunnableWrapper.java:120)
    at com.codename1.impl.CodenameOneThread.run(CodenameOneThread.java:176)

    

  




  
  
  

    

      

        Eric O&＃39;Conne..
         5
      
      
你需要打电话,而不是要求db.executeQuery()你的CREATE TABLE陈述db.execute().


1> Eric O&＃39;Conne..：
你需要打电话,而不是要求db.executeQuery()你的CREATE TABLE陈述db.execute().