java - 错误:java.sql.SQLException:[Microsoft] [ODBC dBASE驱动程序]参数太少。预期1

我正在使用MS Access 2007并尝试​​插入数据，但遇到异常，并且使用[]大括号进行了尝试，但它不起作用。它成功创建了DBF文件，但未生成确切的输出。

           import java.sql.*;

           public class Test
           {
             public static void main(String[] args)
              {
               try
                  {
                     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                     String dataSourceName = "mdbTEST";
                     String dbURL = "jdbc:odbc:" + dataSourceName;
                     Connection con = DriverManager.getConnection(dbURL, "","");

          //  creating a java.sql.Statement so I can run queries

                    Statement s = con.createStatement();
                    s.execute("create table TESTME ( olumn_name integer )");
        // creating a table

       // inserting some data into the table

                    s.execute("insert into TESTME values(3)");

       // selecting the data from the table
                    s.execute("[select column_name from TESTME]");

       //getting any ResultSet that came from our query

                    ResultSet rs = s.getResultSet();
                   if (rs != null)
       // if rs == null, then there is no ResultSet to view

                 while ( rs.next() )
                        {
        /* the next line will get the first column in our current row's ResultSet
        as a String ( getString( columnNumber) ) and output it to the screen */

             System.out.println("[Data from column_name:]" + rs.getString(1) );
                        }

             s.execute("drop table TESTME");
             s.close();
             con.close();
                  }
            catch (Exception err)
                      {
                        System.out.println("ERROR: " + err);
                      }
        }
      }

最佳答案

您的陈述

s.execute("[select column_name from TESTME]");

无法使用，因为Access SQL使用方括号定界表和列名称，因此您的SQL“查询”由一个没有SELECT关键字的名称组成。我建议...

s.execute("SELECT [column_name] FROM [TESTME]");

...但是由于您CREATE TABLE语句中的错字，这可能无法正常工作。尝试这个：

s.execute("SELECT [olumn_name] FROM [TESTME]");

编辑

以下代码对我有用：

import java.sql.*;

public class JDBCQuery {
    public static void main( String args[] )
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\\Users\\Public\\Database1.accdb;");
            Statement s = conn.createStatement();
            s.execute("CREATE TABLE [TESTME] ([column_name] integer)");
            s.execute("INSERT INTO [TESTME] VALUES (3)");
            s.execute("SELECT [column_name] FROM [TESTME]");
            ResultSet rs = s.getResultSet();
            if (rs!=null)
            {
                while (rs.next())
                {
                    System.out.println("Data from column_name: " + rs.getString(1));
                }
            }
            s.execute("DROP TABLE [TESTME]");
            s.close();
            conn.close();
        }
        catch( Exception e ) {
            e.printStackTrace();
        }
    }
}

（请注意，当我运行此代码时，数据库文件Database1.accdb已经存在。）

关于java - 错误:java.sql.SQLException:[Microsoft] [ODBC dBASE驱动程序]参数太少。预期1，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/16188184/