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
License change to MPL 2.0 / EPL 1.0
08ec66d2
 
Thomas Mueller committed
3 
Copyright 2004-2014 H2 Group. Multiple-Licensed under the MPL 2.0, 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 
and under the Eclipse Public License, Version 1.0
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 />
Thomas Mueller's avatar
docs
da30c87b
 
Thomas Mueller committed
23 
<h2 id="embedding">Embedding H2 in an Application</h2>
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
24 25 26 27 
<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
Documentation: improved website translation
20294dfb
 
Thomas Mueller committed
28 29 30 
<li>Add the <code>h2*.jar</code> to the classpath (H2 does not have any dependencies)
</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 <code>test</code> in your user home directory
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
31 
</li><li>A new database is automatically created
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
32 33 
</li></ul>
Thomas Mueller's avatar
docs
da30c87b
 
Thomas Mueller committed
34 
<h2 id="h2_console">The H2 Console Application</h2>
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
35 36 37 
<p>
The Console lets you access a SQL database using a browser interface.
<br />
Thomas Mueller's avatar
Documentation; prepare for retina display
e9170d56
 
Thomas Mueller committed
38 39 40 
<img src="images/console-2.png"
    width="535" height="179"
    alt="Web Browser - H2 Console Server - H2 Database" />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
41 42 43 44 45 46 47 48 49 50 51 52 53 54 
<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
55 
Click [Start], [All Programs], [H2], and [H2 Console (Command Line)]:<br />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
56 
<img class="screenshot" src="images/quickstart-1.png" alt="Screenshot: start H2 Console" /><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
57 
A new console window appears:<br />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
58 
<img class="screenshot" src="images/quickstart-2.png" alt="Screenshot: H2 running" /><br />
Thomas Mueller's avatar
Documentation: added notranslate tags
88299ab9
 
Thomas Mueller committed
59 
Also, a new browser page should open with the URL <a href="http://localhost:8082" class="notranslate">http://localhost:8082</a>.
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
60 61 62 63 64 65 
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
66 
Select [Generic H2] and click [Connect]:<br />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
67 
    <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
68 69 70 71 72 
    You are now logged in.
</p>

<h4>Sample</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
73 
Click on the [Sample SQL Script]:<br />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
74 
    <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
75 
    The SQL commands appear in the command area.<br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
76 77 78 79 
</p>

<h4>Execute</h4>
<p>
Thomas Mueller's avatar
--no commit message
502d8756
 
Thomas Mueller committed
80 
Click [Run]<br />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
81 
<img class="screenshot" src="images/quickstart-5.png" alt="Screenshot: click Run" /><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
82 83 
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 />
Thomas Mueller's avatar
Documentation.
b04bfcec
 
Thomas Mueller committed
84 
<img class="screenshot" src="images/quickstart-6.png" alt="Screenshot: see the result" /><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
85 86 87 88 
</p>

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