JAVA SQLite
来源:互联网 发布:胜利欧赔数据库下载 编辑:程序博客网 时间:2024/06/08 15:59
http://www.zentus.com/sqlitejdbc/
import java.sql.*;public class Test { public static void main(String[] args) throws Exception { Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db"); Statement stat = conn.createStatement(); stat.executeUpdate("drop table if exists people;"); stat.executeUpdate("create table people (name, occupation);"); PreparedStatement prep = conn.prepareStatement( "insert into people values (?, ?);"); prep.setString(1, "Gandhi"); prep.setString(2, "politics"); prep.addBatch(); prep.setString(1, "Turing"); prep.setString(2, "computers"); prep.addBatch(); prep.setString(1, "Wittgenstein"); prep.setString(2, "smartypants"); prep.addBatch(); conn.setAutoCommit(false); prep.executeBatch(); conn.setAutoCommit(true); ResultSet rs = stat.executeQuery("select * from people;"); while (rs.next()) { System.out.println("name = " + rs.getString("name")); System.out.println("job = " + rs.getString("occupation")); } rs.close(); conn.close(); }}
- SQLite:Java操作SQLite
- sqlite-sqlite接口-Java
- JAVA SQLite
- java+sqlite
- SQLite(二): Java操作SQLite
- Java连接sqlite
- Java 连接 sqlite 问题
- java连接sqlite
- java操作sqlite
- java 连接sqlite
- Java访问sqlite数据库
- 用Java访问SQLite
- java中使用sqlite
- java操作sqlite
- java连接使用sqlite
- SQLite For JAVA
- java Sqlite 事务
- Java使用Sqlite
- Android SDK 目录介绍
- poj3415
- 选择是csdn的权力也是我的权力,本人全面封杀csdn,就此别过
- Swap分区太小 无法休眠 解决方法
- Android 签名详解
- JAVA SQLite
- Eclipse快捷键大全
- Java——this 和 super
- 安装Ubuntu 10.10后Windows XP启动项丢失的完美解决
- Windows XP硬盘安装Ubuntu 10.10双系统图解
- 一步一学Linux与Windows 共享文件Samba
- LABVIEW虚拟示波器
- GridView 中TextView的跑马灯效果
- javase--6线程