Skip to content

H
h2database
切换分支/标签
查找文件
Normal viewHistoryPermalink
quickstartText.html 3.6 KB
Newer Older
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
1 2 3 4 5 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- 
Copyright 2004-2006 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html). 
Initial Developer: H2 Group
-->
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
6 
<html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
7 
Quickstart
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
8 
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
9 10 11 12 13 
<script type="text/javascript" src="navigation.js"></script>
</head><body onload="frameMe();">
<table class="content"><tr class="content"><td class="content"><div class="contentDiv">

<h1>Quickstart</h1>
Thomas Mueller's avatar
--no commit message
bcee1719
 
Thomas Mueller committed
14 15 16 17 
<a href="#embedding">
    Embedding H2 in an Application</a><br />
<a href="#h2_console">
    The H2 Console Application</a><br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
18
Thomas Mueller's avatar
--no commit message
bcee1719
 
Thomas Mueller committed
19 20 21 22 23 24 25 26 27 28 29 30 
<br /><a name="embedding"></a>
<h2>Embedding H2 in an Application</h2>

This database can be used in embedded mode, or in server mode. To use it in embedded mode, you need to:

<ul>
<li>Add <code>h2.jar</code> to the classpath
</li><li>Use the JDBC driver class: <code>org.h2.Driver</code>
</li><li>The database URL <code>jdbc:h2:~/test</code> opens the database 'test' in your user home directory
</ul>

<br /><a name="h2_console"></a>
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
31 32 
<h2>The H2 Console Application</h2>
The Console lets you access a SQL database using a browser interface.
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
33 34 35 
<br />
<img src="console.png" alt="Web Browser - H2 Console Server - H2 Database" />
<br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
36 37 38 39 40 41 42 43 44 45 46 47 
If you don't have Windows XP, or if something does not work as expected, 
please see the detailed description in the <a href="tutorial.html">Tutorial</a>.

<h3>Step-by-Step</h3>

<h4>Installation</h4>
Install the software using the Windows Installer (if you did not yet do that).

<h4>Start the Console</h4>
Click <span class="button">Start</span>, 
<span class="button">All Programs</span>, 
<span class="button">H2</span>, and
Thomas Mueller's avatar
--no commit message
b09fd536
 
Thomas Mueller committed
48 
<span class="button">H2 Console (Command Line)</span>:<br />
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
49 50 51 
<img class="screenshot" src="quickstart-1.png" alt="screenshot: start H2 Console" /><br />
A new console window appears:<br />
<img class="screenshot" src="quickstart-2.png" alt="screenshot: H2 Running" /><br />
Thomas Mueller's avatar
--no commit message
a2a2f8ca
 
Thomas Mueller committed
52 
  Also, a new browser page should open with the URL <a href="http://localhost:8082" target="_blank">http://localhost:8082</a>.
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
53 54 55 56 
You may get a security warning from the firewall. If you don't want other computers in the network to access the database 
on your machine, you can let the firewall block these connections. Only local connections are required at this time.

<h4>Login</h4>
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
57 58 
Select <span class="button">Generic H2</span> and click <span class="button">Connect</span>:<br />
    <img class="screenshot" src="quickstart-3.png" alt="screenshot: Login screen" /><br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
59 60 61 
    You are now logged in.

<h4>Sample</h4>
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
62 63 64 
Click on the <span class="button">Sample SQL Script</span>:<br />
    <img class="screenshot" src="quickstart-4.png" alt="screenshot: click on the sample SQL script" /><br />
     The SQL commands appear in the command area.<br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
65 66 

<h4>Execute</h4>
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
67 68 
Click <span class="button">Run</span>:<br />
<img class="screenshot" src="quickstart-5.png" alt="screenshot: click Run" /><br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
69 
On the left side, a new entry TEST is added below the database icon.
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
70 71 
The operations and results of the statements are shown below the script.<br />
<img class="screenshot" src="quickstart-6.png" alt="screenshot: see the result" /><br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
72 73 

<h4>Disconnect</h4>
Thomas Mueller's avatar
--no commit message
b492f851
 
Thomas Mueller committed
74 75 
Click on <span class="button">Disconnect</span>:<br />
<img src="icon_disconnect.gif" alt="Disconnect icon" /><br />
Thomas Mueller's avatar
--no commit message
23c4f01c
 
Thomas Mueller committed
76 77 78 79 80 81 82 
to close the database.

<h4>End</h4>
Close the console window.
For more information, see the <a href="tutorial.html">Tutorial</a>.

</div></td></tr></table></body></html>