Home / Questions / 157868
Accepted
Henriquez10
Asked: 2020-04-21 11:50:36 +0800 CST 2020-04-21 11:50:36 +0800 CST

用JAVA访问数据库连接

  • 772

您好，不知道为什么连接不上，是因为jackcess那个会过时还是因为我的jdk 1.8的版本？因为我已经JAR UCanAccess通过 netbeans 将 4.0.4 添加到库中

package Frames;
import java.sql.*;
import javax.swing.*;
import java.sql.DriverManager;
/**
 *
* @author 
*/


// creando la clase conexion para conectar a la base de datos en Access
public class Conexion {
static Connection conn = null;
static String driver = "net.ucanaccess.jdbc.UcanaccessDriver";


static String url = "jdbc:ucanaccess://C:\\xxxx\\xxx.accdb";

public static Connection ejecutarConexion(){
    try{
        if(conn==null){
            Class.forName(driver);
            conn = DriverManager.getConnection(url);
            JOptionPane.showMessageDialog(null, "Conectado");

        }
    } catch (Exception ex){
        ex.printStackTrace();
        conn = null;
    }
    return conn;
}


public static void main(String [] args){
    Connection cn= Conexion.ejecutarConexion();
}
}

错误如下：

在此处输入图像描述

java

1 Answers

  1. Best Answer

    错误在于driver您正在使用这个： 

    static String driver = "net.ucanaccess.jdbc.UcanaccessDriver";

    试试这个，它对我有用

    this.controlador="sun.jdbc.odbc.JdbcOdbcDriver";

    你不见了createStatement，但我给你留下了我的连接类的这个例子，让你了解你缺少的部分

    public class connectBD {


private Connection conexion;
private Statement sentencia;
private final String controlador;
private final String nombre_bd;
private final String usuarioBD;
private final String passwordBD;





public connectBD(){

    this.controlador="sun.jdbc.odbc.JdbcOdbcDriver";

    this.nombre_bd="C:\\Users\\Raul\\Documents\\NetBeansProjects\\BD_Access\\Prueba_Java.accdb";

    this.usuarioBD="";

    this.passwordBD="";
}



public boolean EstablecerConexion() throws SQLException{
    try{
        conexion=DriverManager.getConnection("jdbc:ucanaccess://"+this.nombre_bd,this.usuarioBD,this.passwordBD);
    }catch (SQLException e){
         JOptionPane.showMessageDialog(null,"Error al realizar la conexion "+e);
         return false;
    }



    try {
        this.sentencia=this.conexion.createStatement(
        ResultSet.TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_READ_ONLY);
    }

    catch (SQLException e) {
        JOptionPane.showMessageDialog(null,"Error al crear el objeto sentencia "+e);
        return false;

    }

    return true;
}



public ResultSet EjecutarSentencia( String sql) throws SQLException{
    ResultSet rs;
    rs = this.sentencia.executeQuery(sql);
    return rs;
}

}
    • 2