一段绕过JDBC的数据库交互代码

交互的数据库是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]);
		}
	}
}

执行结果：