java - 如何创建基于 ActionResolver 的 jdbc sqlite 连接？

Question

我已按照维基 (https://code.google.com/archive/p/libgdx-users/wikis/SQLite.wiki) 上的说明进行操作，但我不确定如何实际使用数据库连接。我看过 http://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm 的 jdbc 教程。我想我被困在连接上了。

解析器代码

public interface ActionResolver {
public Connection getConnection();
}

public class DesktopActionResolver implements ActionResolver {
public Connection getConnection() {
    String url = "jdbc:sqlite:db.sqlite";
    try {
        Class.forName("org.sqlite.JDBC");
        return DriverManager.getConnection(url);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return null;
}
}

public class AndroidActionResolver implements ActionResolver {

Handler uiThread;
Context appContext;

public AndroidActionResolver(Context appContext) {
    uiThread = new Handler();
    this.appContext = appContext;
}

@Override
public Connection getConnection() {
    String url = "jdbc:sqldroid:/data/data/com.myapp/databases/db.sqlite";
    try {
        Class.forName("org.sqldroid.SQLDroidDriver").newInstance();
        return DriverManager.getConnection(url);
    } catch (InstantiationException e) {
        Log.e("sql", e.getMessage());
    } catch (IllegalAccessException e) {
        Log.e("sql", e.getMessage());
    } catch (ClassNotFoundException e) {
        Log.e("sql", e.getMessage());
    } catch (SQLException e) {
        Log.e("sql", e.getMessage());
    }
    return null;
}
}

jdbc教程有

conn = DriverManager.getConnection(DB_URL,USER,PASS);

有人可以解释或指出有关如何使用 ActionResolvers 连接的正确方向吗？

为了让 conn 在我的其余代码中可用，我需要做什么？

我觉得应该是这样的

连接conn = ActionResolver.getConnection();

但事实并非如此。

Answer 1

经过反复试验和大量阅读后，我已经开始使用它了。这是代码

我的游戏.java

public class MyGame extends Game {
    public ActionResolver actionResolver;

    public MyGame(ActionResolver actionResolver) {
        super();
        this.actionResolver = actionResolver;
    }

    public void create() {
        Connection conn = actionResolver.getConnection();
        try {
            Statement statment = conn.createStatement();
            ResultSet resultSet = statment.executeQuery("select * from items");
            while (resultSet.next())
            {
                System.out.println(resultSet.getString("name"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

安卓启动器.java改变

initialize(new MyGame(), config);

到

initialize(new MyGame(new AndroidActionResolver(this.getBaseContext())), config);

DesktopLauncher.java改变

new LwjglApplication(new MyGame(), config);

到

new LwjglApplication(new MyGame(new DesktopActionResolver()), config);