运行project的.jar文件时SQLite数据库未连接

Question

   public Connection connect1() {
    try {

        Class.forName("org.sqlite.JDBC");
    } catch (ClassNotFoundException ex) {
        Logger.getLogger(SQLiteJDBCDriverConnection.class.getName()).log(Level.SEVERE, null, ex);
    }
    String url = "jdbc:sqlite:SaeedGoldCastingDB.sqlite";
    Connection conn = null;
    try {
        conn = DriverManager.getConnection(url);
    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }
    return conn;
}

run:

代码如下：

public class SQLiteJDBCDriverConnection {
     /**
     * Connect to a sample database
     */
    public String rate=null;
    public String date=null;


 public Connection connect1() {
    try {
        // SQLite connection string
        Class.forName("org.sqlite.JDBC");
    } catch (ClassNotFoundException ex) {
        Logger.getLogger(SQLiteJDBCDriverConnection.class.getName()).log(Level.SEVERE, null, ex);
    }
    String url = "jdbc:sqlite:C:\\Users\\Hashmi\\Documents\\NetBeansProjects\\Goldsmith-Billing-and-database\\src\\SourceFolder\\SaeedGoldCastingDB.sqlite";
    Connection conn = null;
    try {
        conn = DriverManager.getConnection(url);
    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }
    return conn;
}
  public boolean Login(Login l){

   String idLogin = null ;
   String password = null;
   char[] pass = l.jPasswordField1.getPassword();
  String passString = new String(pass);
   String sql = "SELECT idLogin , password from Login where idLogin like '%"+l.jTextField_idLogin.getText()+"%';";
    try (Connection conn = this.connect1();
         Statement stmt  = conn.createStatement();
         ResultSet rs    = stmt.executeQuery(sql)){
        // loop through the result set
        while (rs.next()) {
          idLogin=rs.getString("idLogin");
          password=rs.getString("password");
         }
          if(idLogin.matches(l.jTextField_idLogin.getText() ) && password.matches(passString))
            return true;
           else
               return false;

    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }
    return false;
 }
  public void UpdateLogin(String idLogin,String password){

     String sql = "UPDATE Login SET password=? WHERE idLogin like '%"+idLogin+"%';";
  try (Connection conn = this.connect1();
         PreparedStatement pstmt = conn.prepareStatement(sql))
    {

              pstmt.setString(1,password);
              pstmt.executeUpdate();

    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }

      }     
   public void insertLogin(String idLogin,String password){

     String sql = "insert into Login(idLogin,password)values(?,?);";
  try (Connection conn = this.connect1();
         PreparedStatement pstmt = conn.prepareStatement(sql))
    {

              pstmt.setString(1,idLogin);
              pstmt.setString(2,password);
              pstmt.executeUpdate();



    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }

      }     
  public boolean userCheck(Settings s){

   String idLogin = null ;
   String password = null;
   char[] pass = s.jPasswordField_OldPassword.getPassword();
   String passString = new String(pass);
   String sql = "SELECT idLogin , password from Login where idLogin like '%"+s.jTextField_useName1.getText()+"%';";
    try (Connection conn = this.connect1();
         Statement stmt  = conn.createStatement();
         ResultSet rs    = stmt.executeQuery(sql)){
        // loop through the result set



            while (rs.next())
                 {
                  idLogin=rs.getString("idLogin");
                  password=rs.getString("password");
                 }

                 if(idLogin.matches(s.jTextField_useName1.getText() ) && password.matches(passString))
            return true;
           else
               return false;




    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }
    return false;
 }

Answer 1

使用SQLite数据库文件的相对路径：

jdbc:sqlite:SaeedGoldCastingDB.sqlite

根据saeedgoldcastingdb.sqlite文件的实际位置，Java在执行程序时可能找不到它。

请改用绝对路径。