Skip to content

H
h2database
切换分支/标签
查找文件
Normal viewHistoryPermalink
quickstart.html 3.7 KB
Newer Older
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
1 2 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Thomas Mueller's avatar
update copyright
84595889
 
Thomas Mueller committed
3 
Copyright 2004-2009 H2 Group. Multiple-Licensed under the H2 License, Version 1.0,
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 
and under the Eclipse Public License, Version 1.0
(http://h2database.com/html/license.html).
Initial Developer: H2 Group
-->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
Quickstart
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
<!-- [search] { -->
<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>
<a href="#embedding">
    Embedding H2 in an Application</a><br />
<a href="#h2_console">
    The H2 Console Application</a><br />

<br /><a name="embedding"></a>
<h2>Embedding H2 in an Application</h2>
<p>
This database can be used in embedded mode, or in server mode. To use it in embedded mode, you need to:
</p>
<ul>
Thomas Mueller's avatar
--no commit message
56c1cf96
 
Thomas Mueller committed
30 
<li>Add the <code>h2*.jar</code> to the classpath (H2 does not have any dependencies)
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
31 32 
</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
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
33 
</li><li>A new database is automatically created
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 
</li></ul>

<br /><a name="h2_console"></a>
<h2>The H2 Console Application</h2>
<p>
The Console lets you access a SQL database using a browser interface.
<br />
<img src="images/console.png" alt="Web Browser - H2 Console Server - H2 Database" />
<br />
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>.
</p>

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

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

<h4>Start the Console</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
56 
Click [Start], [All Programs], [H2], and [H2 Console (Command Line)]:<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
57 58 
<img class="screenshot" src="images/quickstart-1.png" alt="screenshot: start H2 Console" /><br />
A new console window appears:<br />
Thomas Mueller's avatar
Improved docs.
27d7b7d3
 
Thomas Mueller committed
59 
<img class="screenshot" src="images/quickstart-2.png" alt="screenshot: H2 running" /><br />
Thomas Mueller's avatar
indentation
d7b57e07
 
Thomas Mueller committed
60 
Also, a new browser page should open with the URL <a href="http://localhost:8082">http://localhost:8082</a>.
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
61 62 63 64 65 66 
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.
</p>

<h4>Login</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
67 
Select [Generic H2] and click [Connect]:<br />
Thomas Mueller's avatar
Improved docs.
27d7b7d3
 
Thomas Mueller committed
68 
    <img class="screenshot" src="images/quickstart-3.png" alt="screenshot: login" /><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
69 70 71 72 73 
    You are now logged in.
</p>

<h4>Sample</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
74 
Click on the [Sample SQL Script]:<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
75 
    <img class="screenshot" src="images/quickstart-4.png" alt="screenshot: click on the sample SQL script" /><br />
Thomas Mueller's avatar
indentation
d7b57e07
 
Thomas Mueller committed
76 
    The SQL commands appear in the command area.<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
77 78 79 80 
</p>

<h4>Execute</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
81 
Click [Run]<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
82 83 84 85 86 87 88 89 
<img class="screenshot" src="images/quickstart-5.png" alt="screenshot: click Run" /><br />
On the left side, a new entry TEST is added below the database icon.
The operations and results of the statements are shown below the script.<br />
<img class="screenshot" src="images/quickstart-6.png" alt="screenshot: see the result" /><br />
</p>

<h4>Disconnect</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
90 
Click on [Disconnect]:<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
91 
<img src="images/icon_disconnect.gif" alt="Disconnect icon" /><br />
Thomas Mueller's avatar
improve documentation
613ec072
 
Thomas Mueller committed
92 
to close the connection.
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
93 94 95 96 97 98 99 100 101 102 
</p>

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

<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html>