hsqldb起步-2
学习和部署 h2 database 算了, h2 database 是 hsqldb 的作者后来的又一力作,更好用,更高效
?
1.hsqldb 有如下功能:
?
核心:
??? HyperSQL RDBMS Engine (HSQLDB)
??? HyperSQL JDBC Driver
?
扩展:
??? Database Manager (GUI database access tool, with Swing and AWT versions)
??? Sql Tool (command line database access tool) - sqltool.jar
?
?
2.启动gui
?
方式a:
设置环境变量后
bat方式启动:
方式b:
双击hsqldb.jar,更爽
?
3.hsqldb三种数据保存方式:
->内存
->文件
->jar中
?
若file则生成这些文件:
?
6.当最后一个连接关闭,则关闭数据库.[我也不太明白??]
(datecol - 7 DAY) > CURRENT_DATE are optimised to use indexes when it is possible, while the equivalent function calls are not optimised.The OTHER type is for storage of Java objects. If your objects are large, serialize them in your application and store them as BLOB in the database.
The ARRAY type supports all base types except LOB and OTHER types. ARRAY data objects are held in memory while being processed. It is therefore not recommended to store more than about a thousand objects in an ARRAY in normal operations with disk based databases. For specialised applications, use ARRAY with as many elements as your memory allocation can support.
9.关于SA
This user is automatically created with a new database and has the DBA role. Initially, the password for this user is an empty string. After connecting to the new database as this user, it is possible to change the password, create other users and created new schema objects. The SA user can be dropped by another user that has the DBA role.
?
10.
学习和部署 h2 database 算了, h2 database 是 hsqldb 的作者后来的又一力作,更好用,更高效
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
