SQLite和processing
星期六, 5月 30th, 2009
今天试了一下sqliteJDBC,在eclipse以及processing环境下都用了一下。
sqlite是一个很强大的桌面数据库，类似于access和javadb…现在说说再如何在processing环境下使用
1.下载sqliteJDBC
2.processing新建项目,代码如下
import java.sql.*;
void setup() {
size(100,100);
noLoop();
try {
Class.forName("org.sqlite.JDBC");
String dbFileName = dataPath("test.db");
println("opening: " + dbFileName);
Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbFileName);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM tb01 LIMIT 10");
while (rs.next()) {
String provider = rs.getString("un");
String route_name = rs.getString("pw");
println("username: " + provider);
println("password: " + route_name);
}
conn.close();
}
catch(Exception e) {
e.printStackTrace();
}
}
void draw() {
}
void setup() {
size(100,100);
noLoop();
try {
Class.forName("org.sqlite.JDBC");
String dbFileName = dataPath("test.db");
println("opening: " + dbFileName);
Connection conn = DriverManager.getConnection("jdbc:sqlite:"+dbFileName);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM tb01 LIMIT 10");
while (rs.next()) {
String provider = rs.getString("un");
String route_name = rs.getString("pw");
println("username: " + provider);
println("password: " + route_name);
}
conn.close();
}
catch(Exception e) {
e.printStackTrace();
}
}
void draw() {
}
3.点击sketch-add file 把下载好的sqliteJDBC.jar文件放入sketch文件夹。
4.在sketch文件夹内新建data文件夹存放数据库之用。
参考a quick note on using sqlite in processing