MS Access通过Java代码返回空记录集(MS Access returning empty recordset through Java code)

 我试图检索一个简单的查询结果来检查我的连接是否正常工作。 连接成功，但只返回空记录集。 有问题的行标有评论 
 
 以下是我的代码 
 
             package ActualProject;
             import java.io.FileInputStream;
             import java.io.FileNotFoundException;
             import java.io.IOException;
             import java.sql.*;

             import net.ucanaccess.jdbc.*;
             import org.apache.poi.ss.usermodel.Row;
             import org.apache.poi.ss.usermodel.Sheet;
             import org.apache.poi.xssf.usermodel.XSSFWorkbook;

             public class MainClass {
             static String strURL = null;
             public MainClass() {
                        }

public static void main(String[] args) {

    String strUserDir = System.getProperty("user.dir");
    String strProjectPath = strUserDir.replaceAll("ActualProject", "");
    String strDataPath = strProjectPath + "Data\\Data.xlsx";
    String TestCaseDescription = null;
    String strTestCaseName = null;


    String TestCaseSheetPath = strProjectPath + "ActualProject\\TestCaseSheet\\TestCaseSheet.mdb";

    //Code to read TestCaseSheet
    try
    {
         Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");


        System.setProperty("DUCANACCESS_HOME","C:/Users/mindurka/
        Downloads/Selenium3.4/UCanAccess-4.0.2-bin/UCanAccess-4.0.2-bin");

         String connURL = "jdbc:ucanaccess://"+TestCaseSheetPath;
         Connection objAccessCon = DriverManager.getConnection(connURL);
         DriverManager.getConnection(connURL1);
         Statement objRS = objAccessCon.createStatement();

    //           String strEnvQuery = "Select * from Env where Use = 'No'";
         String strEnvQuery = "Select * from Env";
         objRS.executeQuery(strEnvQuery);
         ResultSet objEnvRS = objRS.getResultSet();


         while(objEnvRS.next())
         {
             strURL = objEnvRS.getString("URL");
             String strQuery = "Select * from TestCaseSheet where Execute = 'Yes'";
             objRS.execute(strQuery);
             ResultSet RS = objRS.getResultSet();
             if(RS != null)
             {
                 while (RS.next()) 
                {
                     TestCaseDescription = RS.getString("TestCaseDescription");
                     strTestCaseName = RS.getString("TestCaseName");
                     FileInputStream objFIS = new FileInputStream(strDataPath);
                     XSSFWorkbook objDataWB = new XSSFWorkbook(objFIS);
                     Sheet objActiveSheet = objDataWB.getSheet("RegDetails");

                     for(int intRowCounter = 0 ; intRowCounter < objActiveSheet.getLastRowNum(); intRowCounter++)
                     {
                         Row objRow = objActiveSheet.getRow(intRowCounter);
                         for(int intColumnCounter = 0; intColumnCounter < objRow.getLastCellNum(); intColumnCounter++)
                         {
                             System.out.println("Row=="+ intRowCounter + "Column =="+ intColumnCounter);
                         }
                     }

                     objActiveSheet= null;
                     //objRow = null;
                    objRS.close();
                    RS.close();
                    objAccessCon.close();

                }
             }
             else
             {
                 System.out.println("No testcases selected for execution");
             }




        }


    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally{

    }


}

}
 
 Java版本：8 Eclipse版本：Neon MS Access版本：2007 
 
 请让我知道是否需要其他细节。 编辑评论：添加MSAccessScreenshot文件的屏幕截图 

I am trying to retrieve results of a simple query to check if my connection is working or not. The connection is successful but there is only empty recordset returned. The problematic line is marked by a comment
 
Below is my code
 
             package ActualProject;
             import java.io.FileInputStream;
             import java.io.FileNotFoundException;
             import java.io.IOException;
             import java.sql.*;

             import net.ucanaccess.jdbc.*;
             import org.apache.poi.ss.usermodel.Row;
             import org.apache.poi.ss.usermodel.Sheet;
             import org.apache.poi.xssf.usermodel.XSSFWorkbook;

             public class MainClass {
             static String strURL = null;
             public MainClass() {
                        }

public static void main(String[] args) {

    String strUserDir = System.getProperty("user.dir");
    String strProjectPath = strUserDir.replaceAll("ActualProject", "");
    String strDataPath = strProjectPath + "Data\\Data.xlsx";
    String TestCaseDescription = null;
    String strTestCaseName = null;


    String TestCaseSheetPath = strProjectPath + "ActualProject\\TestCaseSheet\\TestCaseSheet.mdb";

    //Code to read TestCaseSheet
    try
    {
         Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");


        System.setProperty("DUCANACCESS_HOME","C:/Users/mindurka/
        Downloads/Selenium3.4/UCanAccess-4.0.2-bin/UCanAccess-4.0.2-bin");

         String connURL = "jdbc:ucanaccess://"+TestCaseSheetPath;
         Connection objAccessCon = DriverManager.getConnection(connURL);
         DriverManager.getConnection(connURL1);
         Statement objRS = objAccessCon.createStatement();

    //           String strEnvQuery = "Select * from Env where Use = 'No'";
         String strEnvQuery = "Select * from Env";
         objRS.executeQuery(strEnvQuery);
         ResultSet objEnvRS = objRS.getResultSet();


         while(objEnvRS.next())
         {
             strURL = objEnvRS.getString("URL");
             String strQuery = "Select * from TestCaseSheet where Execute = 'Yes'";
             objRS.execute(strQuery);
             ResultSet RS = objRS.getResultSet();
             if(RS != null)
             {
                 while (RS.next()) 
                {
                     TestCaseDescription = RS.getString("TestCaseDescription");
                     strTestCaseName = RS.getString("TestCaseName");
                     FileInputStream objFIS = new FileInputStream(strDataPath);
                     XSSFWorkbook objDataWB = new XSSFWorkbook(objFIS);
                     Sheet objActiveSheet = objDataWB.getSheet("RegDetails");

                     for(int intRowCounter = 0 ; intRowCounter < objActiveSheet.getLastRowNum(); intRowCounter++)
                     {
                         Row objRow = objActiveSheet.getRow(intRowCounter);
                         for(int intColumnCounter = 0; intColumnCounter < objRow.getLastCellNum(); intColumnCounter++)
                         {
                             System.out.println("Row=="+ intRowCounter + "Column =="+ intColumnCounter);
                         }
                     }

                     objActiveSheet= null;
                     //objRow = null;
                    objRS.close();
                    RS.close();
                    objAccessCon.close();

                }
             }
             else
             {
                 System.out.println("No testcases selected for execution");
             }




        }


    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally{

    }


}

}
 
Java version: 8 Eclipse version: Neon MS Access version: 2007
 
Please let me know if any other details are required. Edited comment: Adding the screenshot of the fileMSAccessScreenshot

原文：https://stackoverflow.com/questions/43897194