blocks|key|1045723|text|H2+console+application怎么样？|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1045724|entityMap|0|LINK|mutability|MUTABLE|url|http://www.h2database.com/html/quickstart.html#h2_console^0|0|M|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

How about the <a href="http://www.h2database.com/html/quickstart.html#h2_console" rel="noreferrer">H2 console application</a>?

blocks|key|1260649|text|我使用sql-workbench来处理H2和任何其他我必须处理的数据库管理系统，这让我笑了:-)|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1260650|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sql-workbench.net/^0|3|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I use <a href="http://www.sql-workbench.net/" rel="noreferrer">sql-workbench</a> for working with H2 and any other DBMS I have to deal with and it makes me smile :-)

blocks|key|1260696|text|我想建议DBEAVER+.it是基于eclipse的，它支持更好的数据处理。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1260697|entityMap|0|LINK|mutability|MUTABLE|url|http://dbeaver.jkiss.org/^0|4|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I would like to suggest <a href="http://dbeaver.jkiss.org/" rel="noreferrer">DBEAVER</a> .it is based on eclipse and supports better data handling

blocks|key|1260668|text|一个讨论发现的here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1260669|引用托马斯·穆勒的话：|1260670|http://www.dbsolo.com/|1260671|http://www.minq.se/products/dbvis/|1260672|http://executequery.org/index.jsp|1260673|http://sqldeveloper.solyp.com/index.html|1260674|http://sql-workbench.net/index.html|1260675|http://www.squirrelsql.org/|1260676|entityMap|0|LINK|mutability|MUTABLE|url|https://groups.google.com/forum/#!msg/h2-database/0tFdTh6bZkk/_vcScTArZtcJ|1|2|3|4|5|6^0|7|4|0|0|0|0|M|1|0|0|Y|2|0|0|X|3|0|0|14|4|0|0|Z|5|0|0|R|6|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|H|3|I|5|6|7|1E|8|@]|9|@$A|1F|B|1G|1|1H]]|C|$]]|$1|J|3|K|5|6|7|1I|8|@]|9|@$A|1J|B|1K|1|1L]]|C|$]]|$1|L|3|M|5|6|7|1M|8|@]|9|@$A|1N|B|1O|1|1P]]|C|$]]|$1|N|3|O|5|6|7|1Q|8|@]|9|@$A|1R|B|1S|1|1T]]|C|$]]|$1|P|3|Q|5|6|7|1U|8|@]|9|@$A|1V|B|1W|1|1X]]|C|$]]|$1|R|3|-4|5|6|7|1Y|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]|Z|$5|U|V|W|C|$X|G]]|10|$5|U|V|W|C|$X|I]]|11|$5|U|V|W|C|$X|K]]|12|$5|U|V|W|C|$X|M]]|13|$5|U|V|W|C|$X|O]]|14|$5|U|V|W|C|$X|Q]]]]

one discuss found <a href="https://groups.google.com/forum/#!msg/h2-database/0tFdTh6bZkk/_vcScTArZtcJ" rel="noreferrer">here</a>

quote from Thomas Mueller: 
 <a href="http://www.dbsolo.com/" rel="noreferrer">http://www.dbsolo.com/</a> 
 <a href="http://www.minq.se/products/dbvis/" rel="noreferrer">http://www.minq.se/products/dbvis/</a> 
 <a href="http://executequery.org/index.jsp" rel="noreferrer">http://executequery.org/index.jsp</a> 
 <a href="http://sqldeveloper.solyp.com/index.html" rel="noreferrer">http://sqldeveloper.solyp.com/index.html</a> 
 <a href="http://sql-workbench.net/index.html" rel="noreferrer">http://sql-workbench.net/index.html</a> 
 <a href="http://www.squirrelsql.org/" rel="noreferrer">http://www.squirrelsql.org/</a>

blocks|key|1045833|text|还有一个内置的shell客户端，非常方便。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1045834|java+-cp+h2*.jar+org.h2.tools.Shell|code-block|syntax|javascript|1045835|http://opensource-soa.blogspot.com.au/2009/03/how-to-use-h2-shell.html|offset|length|1045836|$+java+-cp+h2.jar+org.h2.tools.Shell+-help
Interactive+command+line+tool+to+access+a+database+using+JDBC.
Usage:+java+org.h2.tools.Shell+<options>
Options+are+case+sensitive.+Supported+options+are:
[-help]+or+[-?]++++++++Print+the+list+of+options
[-url+"<url>"]+++++++++The+database+URL+(jdbc:h2:...)
[-user+<user>]+++++++++The+user+name
[-password+<pwd>]++++++The+password
[-driver+<class>]++++++The+JDBC+driver+class+to+use+(not+required+in+most+cases)
[-sql+"<statements>"]++Execute+the+SQL+statements+and+exit
[-properties+"<dir>"]++Load+the+server+properties+from+this+directory
If+special+characters+don't+work+as+expected,+you+may+need+to+use
+-Dfile.encoding=UTF-8+(Mac+OS+X)+or+CP850+(Windows).
See+also+http://h2database.com/javadoc/org/h2/tools/Shell.html|1045837|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1Y|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@$I|W|J|X|1|Y]]|A|$]]|$1|K|3|L|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|H]]]]

There's a shell client built in too which is handy.

<pre><code>java -cp h2*.jar org.h2.tools.Shell
</code></pre>

<a href="http://opensource-soa.blogspot.com.au/2009/03/how-to-use-h2-shell.html" rel="noreferrer">http://opensource-soa.blogspot.com.au/2009/03/how-to-use-h2-shell.html</a>

<pre><code>$ java -cp h2.jar org.h2.tools.Shell -help
Interactive command line tool to access a database using JDBC.
Usage: java org.h2.tools.Shell &lt;options&gt;
Options are case sensitive. Supported options are:
[-help] or [-?] Print the list of options
[-url "&lt;url&gt;"] The database URL (jdbc:h2:...)
[-user &lt;user&gt;] The user name
[-password &lt;pwd&gt;] The password
[-driver &lt;class&gt;] The JDBC driver class to use (not required in most cases)
[-sql "&lt;statements&gt;"] Execute the SQL statements and exit
[-properties "&lt;dir&gt;"] Load the server properties from this directory
If special characters don't work as expected, you may need to use
 -Dfile.encoding=UTF-8 (Mac OS X) or CP850 (Windows).
See also http://h2database.com/javadoc/org/h2/tools/Shell.html
</code></pre>

blocks|key|1260617|text|我还没有用过它，但RazorSQL+looks相当不错。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1260618|entityMap|0|LINK|mutability|MUTABLE|url|http://www.razorsql.com/screen_shots.html|1|http://www.razorsql.com/images/razorsql/main45.png^0|9|8|0|I|5|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

I haven't used it, but <a href="http://www.razorsql.com/screen_shots.html" rel="nofollow noreferrer">RazorSQL</a> <a href="http://www.razorsql.com/images/razorsql/main45.png" rel="nofollow noreferrer">looks</a> pretty good.

blocks|key|1045809|text|我推荐Jetbrain的集成开发环境:+DataGrip+https://www.jetbrains.com/datagrip/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1045810|entityMap|0|LINK|mutability|MUTABLE|url|https://www.jetbrains.com/datagrip/^0|T|Z|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I would suggest Jetbrain's IDE: DataGrip <a href="https://www.jetbrains.com/datagrip/" rel="nofollow">https://www.jetbrains.com/datagrip/</a>

blocks|key|1045846|text|如果您在spring中将其作为嵌入式数据库运行，我将使用以下配置在主应用程序运行时启用内置web客户端：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1045847|
<bean+id="h2Server"+class="org.h2.tools.Server"+factory-method="createTcpServer"+init-method="start"+destroy-method="stop"+depends-on="h2WebServer">
++++<constructor-arg+value="-tcp,-tcpAllowOthers,-tcpPort,9092"/>
</bean>
<bean+id="h2WebServer"+class="org.h2.tools.Server"+factory-method="createWebServer"+init-method="start"+destroy-method="stop">
++++<constructor-arg+value="-web,-webAllowOthers,-webPort,8082"/>
</bean>|code-block|syntax|javascript|1045848|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are running it as an embedded database in spring I use the following configuration to enable the built in web client when the main app is running:

<pre><code>&lt;!-- Run H2 web server within application that will access the same in-memory database --&gt;
&lt;bean id="h2Server" class="org.h2.tools.Server" factory-method="createTcpServer" init-method="start" destroy-method="stop" depends-on="h2WebServer"&gt;
 &lt;constructor-arg value="-tcp,-tcpAllowOthers,-tcpPort,9092"/&gt;
&lt;/bean&gt;
&lt;bean id="h2WebServer" class="org.h2.tools.Server" factory-method="createWebServer" init-method="start" destroy-method="stop"&gt;
 &lt;constructor-arg value="-web,-webAllowOthers,-webPort,8082"/&gt;
&lt;/bean&gt;
</code></pre>

blocks|key|1260751|text|我经常使用DbVisualizer来管理H2-db。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1260752|有一个免费的版本：|1260753|https://www.dbvis.com/download/|offset|length|1260754|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|V|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

I use DbVisualizer a lot for H2-db administration. 

There exists a free version:

<a href="https://www.dbvis.com/download/" rel="nofollow">https://www.dbvis.com/download/</a>

How to use <a href="http://www.h2database.com/" rel="noreferrer">H2 database</a>'s integrated managment frontend?

For operations such as create table, alter table, add column, and so on.

Frontend tool to manage H2 database

如何使用的集成管理前端？用于create table、alter table、add column等操作。

问用于管理H2数据库的前端工具
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于管理H2数据库的前端工具EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于管理H2数据库的前端工具
EN