Java连接sqlite数据库

来源：互联网发布：dir python 编辑：程序博客网时间：2024/05/02 20:38

在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;            }        }    }}

0 0