首页 > 代码库 > Java连接sqlite数据库

Java连接sqlite数据库

  在java中使用sqlite,先下载sqlite的jdbc驱动 sqlite-jdbc-3.7.2.jar,在Myeclipse中添加到Build Path中,然后就可以在项目中使用。

package cn.hitech.sqlite;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SqliteDemo {
    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            Class.forName("org.sqlite.JDBC");
            try {
                connection = DriverManager.getConnection("jdbc:sqlite:unit.db");
                statement = connection.createStatement();
                // statement.execute("insert into uinit(uid,uname) values(1,‘adam‘");
                resultSet = statement.executeQuery("select * from uinit");
                while (resultSet.next()) {
                    System.out.println("编号:" + resultSet.getString(1));
                    System.out.println("姓名:" + resultSet.getString(2));
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                resultSet = null;
            }
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                connection = null;
            }
        }
    }
}