java sqllite使用

如何使用Java SQLite

1. 流程图

flowchart TD
    A(创建SQLite数据库) --> B(连接数据库)
    B --> C(创建表)
    C --> D(插入数据)
    D --> E(查询数据)

2. 步骤及代码示例

步骤	操作
1	创建SQLite数据库
2	连接数据库
3	创建表
4	插入数据
5	查询数据

步骤1：创建SQLite数据库

// 导入SQLite包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class CreateDatabase {
    public static void main(String[] args) {
        Connection conn = null;
        try {
            // 连接SQLite数据库，如果不存在则会创建数据库文件
            conn = DriverManager.getConnection("jdbc:sqlite:test.db");
            System.out.println("数据库创建成功");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}

步骤2：连接数据库

// 导入SQLite包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectDatabase {
    public static void main(String[] args) {
        Connection conn = null;
        try {
            // 连接到数据库
            conn = DriverManager.getConnection("jdbc:sqlite:test.db");
            System.out.println("连接数据库成功");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}

步骤3：创建表

// 导入SQLite包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class CreateTable {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        try {
            // 连接到数据库
            conn = DriverManager.getConnection("jdbc:sqlite:test.db");
            stmt = conn.createStatement();
            String sql = "CREATE TABLE IF NOT EXISTS users (\n"
                    + " id INTEGER PRIMARY KEY,\n"
                    + " name TEXT NOT NULL,\n"
                    + " age INTEGER\n"
                    + ");";
            stmt.execute(sql);
            System.out.println("表创建成功");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}

步骤4：插入数据

// 导入SQLite包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class InsertData {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        try {
            conn = DriverManager.getConnection("jdbc:sqlite:test.db");
            stmt = conn.createStatement();
            String sql = "INSERT INTO users (name, age) VALUES ('Alice', 25);";
            stmt.executeUpdate(sql);
            System.out.println("数据插入成功");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}

步骤5：查询数据

// 导入SQLite包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SelectData {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        try {
            conn = DriverManager.getConnection("jdbc:sqlite:test.db");
            stmt = conn.createStatement();
            String sql = "SELECT * FROM users;";
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                System.out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name") + ", Age: " + rs.getInt("age"));
            }
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }
}

3. Gannt图

gantt
    title Java SQLite使用甘特图
    section 创建数据库
    创建数据库 : done, a1,