sqlite：如何在内存中使用

这就是我现在所拥有的

//sq lite driver
        Class.forName("org.sqlite.JDBC");
        //database path,if it's new data base it will be created in project folder
        con = DriverManager.getConnection("jdbc:sqlite:mydb.db");

         Statement stat = con.createStatement(); 

        stat.executeUpdate("drop table if exists weights");

        //creating table
       stat.executeUpdate("create table weights(id integer,"
       + "firstName varchar(30)," + "age INT," + "sex varchar(15),"
       + "weight INT," + "height INT,"
       + "idealweight INT,primary key (id));");

现在我应该把这个语句[“：memory：”]放在内存中存储我的数据,数据应该保存直到我删除它.

谢谢

解决方法

con = DriverManager.getConnection("jdbc:sqlite::memory:");

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!