H2 database 操作操作内存表
本例开发工具为 NetBeans,使用b2前提安装jdk.
第一步:在官网下载驱动包 :http://www.h2database.com ,本例版本为: h2-1.4.192.jar
第二步:安装开发工具及jdk
(1) 开发工具为:netbeans 8.0.2
(2) jdk为 1.8.0.25
第三步:建立工程及代码如下
(1) 工程图
(2) 代码如下
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package h2db.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.h2.tools.Server; /** * * @author NorthEastTycoon */ public class H2Demo { private Server server; private String port = "8082"; private static String sourceURL1 = "jdbc:h2:mem:h2db"; private static String sourceURL2 = "jdbc:h2:tcp://192.168.19.1:8082/mem:h2db"; private String user = "sa"; private String password = ""; public void startServer() { try { System.out.println("正在启动h2..."); server = Server.createTcpServer( new String[] { "-tcpPort", port }).start(); } catch (SQLException e) { System.out.println("启动h2出错:" + e.toString()); e.printStackTrace(); throw new RuntimeException(e); } } public void stopServer() { if (server != null) { System.out.println("正在关闭h2..."); server.stop(); System.out.println("关闭成功."); } } public void testH2() { try { // 加载驱动 Class.forName("org.h2.Driver"); // 创建连接 Connection conn = DriverManager.getConnection(sourceURL1,user, password); Statement stat = conn.createStatement(); // 插入数据 stat.execute("CREATE MEMORY Table table_one(NAME VARCHAR)"); stat.execute("INSERT INTO table_one VALUES('this is my first program!')"); // 查询数据 ResultSet result = stat.executeQuery("select name from table_one "); int i = 1; while (result.next()) { System.out.println(i++ + ":" + result.getString("name")); } result.close(); stat.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } public static void main(String[] args) { H2Demo h2 = new H2Demo(); // 开始服务 h2.startServer(); h2.testH2(); // 关闭服务 h2.stopServer(); } }
(3) 输出结果