Java错误 - net.ucanaccess.jdbc.UcanaccessSQLException：格式错误的字符串：' [英] Java Error - net.ucanaccess.jdbc.UcanaccessSQLException: malformed string: '

问题描述

我的代码如下：

  package Week11Package; 
  

import java.util.Scanner;
import java.sql。*;

public class dbTest1 {

  static Sc​​anner input = new Scanner（System.in）; 
 static String url; 
 static连接aConnection; 
 static语句aStatement; 
 static boolean gotIt = false; 
 
 public static void main（String [] args）{
 
 dbTest1.initialize（）; 
} 
 public static void initialize（）{
 //建立数据库连接。 
 url =jdbc：odbc：MS Access数据库; DBQ =。// Teams.accdb; 
尝试{
 //为Windows 
加载jdbc  -  odbc桥梁Class.forName（net.ucanaccess.jdbc.UcanaccessDriver）; 
 //创建连接实例
 aConnection = DriverManager.getConnection（jdbc：ucanaccess：///Users/Vince/Desktop/Teams.accdb）; 
 //为此连接创建对象实例
 aStatement = aConnection.createStatement（）; 
 String sqlQuery =SELECT PlayerID，PlayerName，TeamID+ 
FROM PLAYER+'; 
 ResultSet rs = aStatement.executeQuery（sqlQuery）; 
 gotIt = rs.next（）; 
 if（gotIt）{
 System.out.println（Connected to DB& found Data !!!）; 
 System.out.println（你要找哪个玩家ID？）; 
 String stringpID = input.next（）; 
 boolean found = false; 
 while（gotIt）{
 //提取数据
 String pID = rs.getString（1）; 
 if（pID.equals（stringpID））
 found = true; 
 String pName = rs.getString（2）; 
 String tID = rs.getString（3）; 
 System.out.println（pID ++ pName ++ tID）; 
 gotIt = rs.next（）; 
} 
 if（found）
 System.out.println（玩家ws found）; 
} 
 aStatement.close（）; 
 aConnection.close（）; 
} 
 catch（ClassNotFoundException e）{
 System.err.println（e）; 
} 
 catch（SQLException e）{
 System.err.println（e）; 
} 
} 
  

}

感谢任何建议来解决这个错误。

谢谢，
Vince

解决方案

首先，导入您的库（lib文件夹中的jar文件）。 http://sourceforge.net/projects/ucanaccess/files /UCanAccess-2.0.9.1-bin.zip/download

然后检查一下。这可能有帮助。

 连接a = DriverManager.getConnection（jdbc：ucanaccess：// C：\\Users\\ \\\Vince\\Desktop\\Teams.accdb）; 
语句s = a.createStatement（）; 
 String sqlQuery =SELECT PlayerID，PlayerName，TeamID+FROM PLAYER+'; 
 ResultSet rs = s.executeQuery（sqlQuery）; 
 while（rs.next（））{
 System.out.println（Connected to DB& found Data !!!）; 
} 
  

I have an error using uCanaccess to retrieve my database which I have saved in my desktop.

My code is below:

package Week11Package;

import java.util.Scanner; import java.sql.*;

public class dbTest1 {

static Scanner input = new Scanner (System.in);
static String url;
static Connection aConnection;
static Statement aStatement;
static boolean gotIt = false;

public static void main(String[] args) {

    dbTest1.initialize();
}
public static void initialize() {
    //establish the DB connection.
    url = "jdbc:odbc:MS Access Database;DBQ=.//Teams.accdb";
    try {
        //load the jdbc - odbc bridge for Windows
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        //create a connection instance
        aConnection = DriverManager.getConnection("jdbc:ucanaccess:///Users/Vince/Desktop/Teams.accdb");
        //create statement object instance for this connection
        aStatement = aConnection.createStatement();
        String sqlQuery = "SELECT PlayerID, PlayerName, TeamID " +
                    "FROM PLAYER"+"'";
        ResultSet rs = aStatement.executeQuery (sqlQuery);
        gotIt = rs.next();
        if (gotIt) {
            System.out.println("Connected to DB & found Data!!!");
            System.out.println("Which Player ID are you looking for?");
            String stringpID = input.next();
            boolean found = false;
            while(gotIt){
                //extract the data
                String pID = rs.getString (1);
                if (pID.equals(stringpID))
                    found = true;
                String pName = rs.getString (2);
                String tID = rs.getString (3);
                System.out.println(pID+" " +pName+ " "+tID);
                gotIt = rs.next();
            }
            if (found)
                System.out.println("The player ws found");
        }
        aStatement.close();
        aConnection.close();
    }
catch (ClassNotFoundException e) {
        System.err.println(e);
    }
    catch (SQLException e) {
        System.err.println(e);
    } 
}

}

I would appreciate any advice to fix this error.

Thanks, Vince

解决方案

Well, first, import your libraries(the jar files in lib folder). http://sourceforge.net/projects/ucanaccess/files/UCanAccess-2.0.9.1-bin.zip/download

Then check this out. This might help.

Connection a = DriverManager.getConnection("jdbc:ucanaccess://C:\\Users\\Vince\\Desktop\\Teams.accdb");
Statement s = a.createStatement();
String sqlQuery = "SELECT PlayerID, PlayerName, TeamID " + "FROM PLAYER"+"'";
ResultSet rs = s.executeQuery(sqlQuery);
while(rs.next()){
System.out.println("Connected to DB & found Data!!!");
}

这篇关于Java错误 - net.ucanaccess.jdbc.UcanaccessSQLException：格式错误的字符串：'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！