Java链接到数据库sqlite

链接数据库调用connect方法

退出链接调用exit方法

使用的数据库是sqlite

import java.sql.DriverManager;
import java.sql.SQLException;

public class ControlConstants {
    static final String JDBC_DRIVER = "org.sqlite.JDBC";
    static final String DB_URL = "jdbc:sqlite:dbname.db";

    static Connection conn = null;
    static Statement stmt = null;
    static ResultSet rs = null;

    /**
     * 链接到数据库
     * @return
     */
    public static boolean connect() {
        try {
            Class.forName(StaticConstants.JDBC_DRIVER);
            conn = DriverManager.getConnection(StaticConstants.DB_URL);
            stmt = conn.createStatement();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            return false;
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        }
        return true;
    }


    /**
     * 退出链接
     */
    public static void exit() {
        try {
            if (rs != null) {
                rs.close();
            }
            if (stmt != null) {
                stmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}