- //首先创建一个 sqlite 数据库
- sqliteλ sqlite3 user.db
- SQLite version 3.7.3
- Enter ".help" for instructions
- Enter SQL statements terminated with a ";"
- sqlite> .header on
- sqlite> select * from users;
- id|name|age
- 1|Joe|24
- 2|redraiment|24
- 3|Kewell|30
- sqlite> .quit
- sqliteλ
- //JS 封装 JDBC
- var with_connection = function(url) {
- var connection = java.sql.DriverManager.getConnection(url);
- for (var argc = 1; argc < arguments.length; argc++) {
- arguments[argc].call(connection);
- }
- connection.close();
- };
- var with_query = function(sql, fn) {
- return function() {
- var call = this.prepareStatement(sql);
- var rs = call.executeQuery();
- var meta = rs.getMetaData();
- var list = [];
- while (rs.next()) {
- var o = {};
- for (var i = 1; i <= meta.getColumnCount(); i++) {
- o[meta.getColumnName(i)] = rs.getObject(i);
- }
- list.push(o);
- }
- rs.close();
- call.close();
- return fn(list);
- };
- };
- //使用-读取表信息
- new org.sqlite.JDBC();
- with_connection(
- 'jdbc:sqlite:user.db',
- with_query('select * from users', function(rs) {
- for (var row = 0; row < rs.length; row++) {
- for (var columnName in rs[row]) {
- printf('%s => %s\\n', columnName, rs[row][columnName]);
- }
- print('\\n');
- }
- })
- );
- //执行结果
- sqliteλ jrunscript -cp "$CLASSPATH:$PWD/sqlite-jdbc-3.7.2.jar" jdbc.js
- id => 1
- name => Joe
- age => 24
- id => 2
- name => redraiment
- age => 24
- id => 3
- name => Kewell
- age => 30
- sqliteλ
- //该片段来自于http://www.codesnippet.cn/detail/220720134739.html
来源: http://www.codesnippet.cn/detail/220720134739.html