| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
jopen
12年前发布

Android平台的SQLite驱动 SQLDroid

SQLDroid 是 Android 平台上的 SQLite 数据库 JDBC 驱动程序。可以让开发人员用熟悉的方式来操作SQLite 数据库和方便将其它项目,移植到Android平台中。

示例代码:    // your datapath is /data/data/$package/  // e.g. "/data/data/com.lemadi.robotanks.android"    // note that if you want to put it in $datapath/databases/  // the way Activity.openOrCreateDatabase does it,  // you have to create the databases subfolder if not already there    String url = "jdbc:sqldroid:" + getDataPath() + "/main.sqlite";  Connection con = DriverManager.getConnection(url);    con.createStatement().execute("CREATE TABLE MYTABLE (id INT, name CHAR(200))");                                       try {          con.createStatement().execute("CREATE TABLE MYTABLE (id INT, name CHAR(200))");          con.createStatement().execute("CREATE TABLE HIGH_SCORES (level VARCHAR, name CHAR, time INT, timestamp INT)");  } catch (SQLException e1) {          System.out.println("error creating table: i guess they were already there");  }    con.createStatement().execute("INSERT INTO MYTABLE (id, name) VALUES (100, 'klm')");                   PreparedStatement ps = con.prepareStatement("INSERT INTO MYTABLE (id, name) VALUES (?, ?)");    ps.setInt(1, (int)(Math.random() * 100));  ps.setString(2, "you're " + new Integer((int)(Math.random()*1000)).toString() + " years old.");  ps.executeUpdate();                                            ResultSet rs = con.createStatement().executeQuery("SELECT id, name FROM MYTABLE ORDER BY name");                           while(rs.next()) {          System.out.println("test row: " + rs.getInt(1) + " = " + rs.getString(2));          System.out.println("test row string: " + rs.getInt("id") + " = " + rs.getString("name"));  }                           rs.close();        // this method demonstrates the limited Metadata functionality:    private static boolean tableExists(String tableName) {          ResultSet rs = con.getMetaData().getTables(null, null, tableName, null);          // rs.next() returns true is there is 1 or more rows          return rs.next();  }

项目主页:http://www.open-open.com/lib/view/home/1341990038260

 本文由用户 jopen 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
 转载本站原创文章,请注明出处,并保留原始链接、图片水印。
 本站是一个以用户分享为主的开源技术平台,欢迎各类分享!
 本文地址:https://www.open-open.com/lib/view/open1341990038260.html
SQLite 数据库服务器