BlackBerry Android runtime中使用SQLite数据库的示例代码

本示例代码展示了在BlackBerry Android runtime环境中如何使用SQLite数据库，包括创建数据库、创建表、插入数据、查询数据等操作。

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

public class SampleDatabase {
    public static void main(String[] args) {
        try {
            // 注册SQLite数据库驱动
            Class.forName("org.sqlite.JDBC");

            // 连接数据库
            Connection connection = DriverManager.getConnection("jdbc:sqlite:data.db");

            // 创建表
            Statement statement = connection.createStatement();
            statement.executeUpdate("CREATE TABLE IF NOT EXISTS CONTACTS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, EMAIL TEXT NOT NULL)");

            // 插入数据
            statement.executeUpdate("INSERT INTO CONTACTS (NAME, EMAIL) VALUES ('张三', 'zhangsan@example.com')");
            statement.executeUpdate("INSERT INTO CONTACTS (NAME, EMAIL) VALUES ('李四', 'lisi@example.com')");
            statement.executeUpdate("INSERT INTO CONTACTS (NAME, EMAIL) VALUES ('王五', 'wangwu@example.com')");

            // 查询数据
            ResultSet resultSet = statement.executeQuery("SELECT * FROM CONTACTS");
            while (resultSet.next()) {
                System.out.println("ID: " + resultSet.getInt("ID"));
                System.out.println("姓名: " + resultSet.getString("NAME"));
                System.out.println("邮箱: " + resultSet.getString("EMAIL"));
            }

            // 关闭资源
            resultSet.close();
            statement.close();
            connection.close();
        } catch (ClassNotFoundException | SQLException | IOException e) {
            e.printStackTrace();
        }
    }
}

免责申明：文章和图片全部来源于公开网络，如有侵权，请通知删除 server@dude6.com