H2数据库

来源：互联网发布：如何恢复u盘数据恢复编辑：程序博客网时间：2024/04/27 21:56

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.Timestamp;import java.util.Date;  public class TestH2 { /** * @param args */public static void main(String[] args) {try { //driver for H2 db get from http://www.h2database.comClass.forName("org.h2.Driver"); //create database on memoryConnection con = DriverManager.getConnection("jdbc:h2:mem:mytest", "sa", "");//Connection con = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/test",  "sa", ""); Statement stat = con.createStatement(); //create tablestat.execute("CREATE TABLE ACTIVITY (ID INTEGER, STARTTIME datetime, ENDTIME datetime,  ACTIVITY_NAME VARCHAR(200),  PRIMARY KEY (ID))"); //prepared statementPreparedStatement prep = con.prepareStatement("INSERT INTO ACTIVITY (ID, STARTTIME, ENDTIME, ACTIVITY_NAME) VALUES (?,?,?,?)"); //insert 10 row datafor (int i = 0; i<10; i++){prep.setLong(1, i);prep.setTimestamp(2, new Timestamp(System.currentTimeMillis()));prep.setTimestamp(3, new Timestamp(System.currentTimeMillis()));prep.setString(4, "Activity-" + i); //batch insertprep.addBatch();}con.setAutoCommit(false);prep.executeBatch();con.setAutoCommit(true);   //query to databasetry {ResultSet rs = stat.executeQuery("Select STARTTIME, ENDTIME, ACTIVITY_NAME from ACTIVITY");while (rs.next()) { Date start = rs.getTimestamp(1);Date end = rs.getTimestamp(2);String activityName = rs.getString(3); //print query result to consoleSystem.out.println("activity: " + activityName);System.out.println("start: " + start);System.out.println("end: " + end);System.out.println("--------------------------");}rs.close();} catch (SQLException e) {e.printStackTrace();} //close connectioncon.close();} catch (Exception e) {e.printStackTrace();} } }

输出：

--------------------------
activity: Activity-8
start: 2013-06-20 15:51:50.451
end: 2013-06-20 15:51:50.451
--------------------------
activity: Activity-9
start: 2013-06-20 15:51:50.451
end: 2013-06-20 15:51:50.451
--------------------------

原文：http://www.ayukucode.org/create-table-insert-query-with-jdbc-and-h2-database/

源代码：http://pan.baidu.com/share/link?shareid=3141153069&uk=3878681452