＜1＞java idea打包jar MySQLdriver加载失败解决

 

public boolean OpenDB(String str){
    boolean b_return = false;
    try{
        url = "jdbc:ucanaccess://" + str;
        conn = DriverManager.getConnection(url316);
        st = conn316.createStatement();
        b_return = true;
    }catch(Exception e){
        conn = null;
        st = null;
        rs = null;
    }
    return b_return;
}

这段代码如果打包成jar之后打开数据库会显示No Driver

解决办法如下：

        加入这段代码  Class.forName(驱动包);

public boolean OpenDB(String str){
    boolean b_return = false;
    try{
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        url = "jdbc:ucanaccess://" + str;
        conn = DriverManager.getConnection(url316);
        st = conn316.createStatement();
        b_return = true;
    }catch(Exception e){
        conn = null;
        st = null;
        rs = null;
    }
    return b_return;
}