java中使用sqlite
sqlite是一款遵循遵守ACID规范的文件数据库,写点代码尝试体验一下.
示例代码
public static void main(String[] args) throws Exception {
Class.forName("org.sqlite.JDBC");
String dbPath1 = "C:sqlitetest1.db";
initDb1(dbPath1);
}
static void initDb1(String dbPath) throws Exception {
Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbPath);
Statement stat = conn.createStatement();
stat.executeUpdate("create table if not exists stu1(name varchar(20), age int, score int);");
stat.executeUpdate("insert into stu1 values("A1",12,72);");
stat.executeUpdate("insert into stu1 values("A2",13,73);");
stat.executeUpdate("insert into stu1 values("A3",14,74);");
stat.executeUpdate("create table if not exists stu2(name varchar(20), age int, score int);");
stat.executeUpdate("insert into stu2 values("C1",22,72);");
stat.executeUpdate("insert into stu2 values("C2",23,73);");
stat.executeUpdate("insert into stu2 values("C3",24,74);");
ResultSet rs = stat.executeQuery("select s1.name,s2.age,s2.score from stu1 s1,stu2 s2 where s2.score=s1.score ;");
while (rs.next()) {
System.out.println("name = " + rs.getString("name")+" age:"+rs.getInt("age")+" score:"+rs.getInt("score"));
}
rs.close();
stat.close();
conn.close();
}
输出
name = A1 age:22 score:72
name = A2 age:23 score:73
name = A3 age:24 score:74
name = A1 age:22 score:82
name = A3 age:24 score:84