如何用Java连接SQLite?-HowtoconnectSQLitewithJava?

53  

You need to have a SQLite JDBC driver in your classpath.

您需要在类路径中有一个SQLite JDBC驱动程序。

Taro L. Saito (xerial) forked the Zentus project and now maintains it under the name sqlite-jdbc. It bundles the native drivers for major platforms so you don't need to configure them separately.

齐藤太郎(Taro L. Saito, xerial)放弃了Zentus项目，现在以sqlite-jdbc的名义维护它。它将本地驱动程序绑定到主要平台，因此您不需要单独配置它们。

8  

If you are using netbeans Download the sqlitejdbc driver Right click the Libraries folder from the Project window and select Add Library , then click on the Create button enter the Library name (SQLite) and hit OK

如果您正在使用netbeans下载sqlitejdbc驱动程序，请右键单击项目窗口中的Libraries文件夹并选择Add Library，然后单击Create按钮，输入库名称(SQLite)并点击OK。

You have to add the sqlitejdbc driver to the class path , click on the Add Jar/Folder.. button and select the sqlitejdbc file you've downloaded previously Hit OK and you are ready to go !

您必须将sqlitejdbc驱动程序添加到类路径中，单击add Jar/文件夹。按下按钮，选择你下载的sqlitejdbc文件，点击OK，就可以开始了!

7  

If you are using Netbeans using Maven to add library is easier. I have tried using above solutions but it didn't work.

如果您使用的是使用Maven来添加库的Netbeans，那就更容易了。我试过用上面的方法，但没有用。

    
      org.xerial
      sqlite-jdbc
      3.7.2
    

I have added Maven dependency and java.lang.ClassNotFoundException: org.sqlite.JDBC error gone.

我添加了Maven依赖项和java.lang。ClassNotFoundException:org.sqlite。JDBC错误了。

5  

I'm using Eclipse and I copied your code and got the same error. I then opened up the project properties->Java Build Path -> Libraries->Add External JARs... c:\jrun4\lib\sqlitejdbc-v056.jar Worked like a charm. You may need to restart your web server if you've just copied the .jar file.

我正在使用Eclipse，我复制了您的代码并得到了相同的错误。然后我打开了项目属性->Java构建路径->库->添加外部jar…c:\ jrun4 \ lib \ sqlitejdbc-v056。jar工作起来很有魅力。如果您刚刚复制了.jar文件，您可能需要重新启动web服务器。

3  

    import java.sql.ResultSet;
    import java.sql.SQLException;
    import javax.swing.JOptionPane;
    import org.sqlite.SQLiteDataSource;
    import org.sqlite.SQLiteJDBCLoader;

    public class Test {

        public static final boolean Connected() {
            boolean initialize = SQLiteJDBCLoader.initialize();

            SQLiteDataSource dataSource = new SQLiteDataSource();
            dataSource.setUrl("jdbc:sqlite:/home/users.sqlite");
            int i=0;
            try {
                ResultSet executeQuery = dataSource.getConnection()
                        .createStatement().executeQuery("select * from \"Table\"");
                while (executeQuery.next()) {
i++;
                    System.out.println("out: "+executeQuery.getMetaData().getColumnLabel(i));

                }



            } catch (SQLException ex) {
                JOptionPane.showMessageDialog(null, ex);
            }

            return initialize;

        }

1  

cOnnection= DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");

Instead of this put

而不是这把

cOnnection= DriverManager.getConnection("jdbc:sqlite:D:\\testdb");

1  

Hey i have posted a video tutorial on youtube about this, you can check that and you can find here the sample code :

嘿，我在youtube上发布了一个视频教程，你可以查看一下，你可以在这里找到样本代码:

http://myfundatimemachine.blogspot.in/2012/06/database-connection-to-java-application.html

http://myfundatimemachine.blogspot.in/2012/06/database-connection-to-java-application.html

1  

You have to download and add the SQLite JDBC driver to your classpath.
You can download from here https://bitbucket.org/xerial/sqlite-jdbc/downloads

您必须下载并将SQLite JDBC驱动程序添加到类路径中。您可以从这里下载https://bitbucket.org/xerial/sqlite-jdbc/downloads。

If you use Gradle, you will only have to add the SQLite dependency:

如果使用Gradle，则只需要添加SQLite依赖项:

dependencies {
    compile 'org.xerial:sqlite-jdbc:3.8.11.2'
} 

Next thing you have to do is to initialize the driver:

接下来要做的是初始化驱动程序:

try {
    Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException eString) {
    System.err.println("Could not init JDBC driver - driver not found");
}

0  

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;   


public class Connectdatabase {

        Connection con = null;

        public static Connection ConnecrDb(){

            try{
                //String dir = System.getProperty("user.dir");
                Class.forName("org.sqlite.JDBC");
                Connection con = DriverManager.getConnection("jdbc:sqlite:D:\\testdb.db");
                return con;
            }
            catch(ClassNotFoundException | SQLException e){
                JOptionPane.showMessageDialog(null,"Problem with connection of database");
                return null;
            }
        }

    }