交互的数据库是H2
package org.roy.db;
import java.util.Properties;
import org.h2.command.CommandInterface;
import org.h2.engine.ConnectionInfo;
import org.h2.engine.Engine;
import org.h2.engine.Session;
import org.h2.result.ResultInterface;
import org.h2.value.Value;
public class H2API {
public static String CreatTable = "create table test(id int primary key, name varchar(255))";
public static String Insert = "insert into test values(1, 'Hello')";
public static String Query = "select * from test";
public static void main(String[] args) {
//建立连接
ConnectionInfo ci = new ConnectionInfo("jdbc:h2:mem:test", new Properties());
Engine sessionfactory = new Engine();
Session session = sessionfactory.createSession(ci);
CommandInterface command = null;
// 建表
command = session.prepareCommand(CreatTable, 100);
command.executeUpdate();
command.close();
// 插入数据
command = session.prepareCommand(Insert, 100);
command.executeUpdate();
command.close();
// 查询
command = session.prepareCommand(Query, 100);
ResultInterface result = command.executeQuery(100, false);
command.close();
while (result.next()) {
Value[] list = result.currentRow();
System.out.println(list[0]+" "+list[1]);
}
}
}
执行结果: