h2.rar_MyEclipse Java_h2_h2 jsp_java h2

package org; 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; public class H2Start { private Server server; private String port = "8082"; private String dbDir = "./database/h2db"; private String user = "root"; private String password = "123456"; 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 useH2() { try { Class.forName("org.h2.Driver"); Connection conn = DriverManager.getConnection("jdbc:h2:" + dbDir, user, password); Statement stat = conn.createStatement(); // insert data // stat.execute("CREATE TABLE TEST(NAME VARCHAR)"); stat.execute("CREATE TABLE `t_user` (`id` int(4) NOT NULL AUTO_INCREMENT,`name` varchar(32) DEFAULT NULL,`sex` int(2) DEFAULT NULL,PRIMARY KEY (`id`))"); // for(int i=2;i<1000;i++) // stat.execute("INSERT INTO TEST VALUES('"+i+"',"+"'Hello World')"); // stat.execute("INSERT INTO TEST VALUES('Hello World')"); // use data ResultSet result = stat.executeQuery("select name from test "); int i = 1; while (result.next()) { System.out.println(i++ + ":" + result.getString("name")); } result.close(); stat.close(); conn.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { H2Start h2 = new H2Start(); h2.startServer(); h2.useH2(); h2.stopServer(); System.out.println("==END=="); } }