欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
SQLeonardo
来自开放百科 - 灰狐
（版本间的差异）
(→屏幕截图) |
|||
| （未显示2个用户的3个中间版本） | |||
| 第1行： | 第1行： | ||
| + | {{top news}} | ||
| + | |||
==简介== | ==简介== | ||
SQLeonardo是一个强大易于使用的数据库管理工具。包括： | SQLeonardo是一个强大易于使用的数据库管理工具。包括： | ||
| 第9行： | 第11行： | ||
==功能特性== | ==功能特性== | ||
| − | |||
General | General | ||
| − | |||
* freeware software | * freeware software | ||
* platform-independent | * platform-independent | ||
| 第18行： | 第18行： | ||
Metadata Explorer | Metadata Explorer | ||
| − | |||
* browse database structure as tables, views, keys, indices etc. | * browse database structure as tables, views, keys, indices etc. | ||
* search tables and columns | * search tables and columns | ||
Command Editor | Command Editor | ||
| − | |||
* create, edit, and execute SQL scripts | * create, edit, and execute SQL scripts | ||
* generate insert, update and delete statements through a wizard | * generate insert, update and delete statements through a wizard | ||
Query Builder | Query Builder | ||
| − | |||
* create SQL queries without directly writing SQL | * create SQL queries without directly writing SQL | ||
* joins between tables are automatically created | * joins between tables are automatically created | ||
| 第34行： | 第31行： | ||
Data Grid | Data Grid | ||
| − | |||
* edit tables directly via the data grid | * edit tables directly via the data grid | ||
* generate SQL statements for any change | * generate SQL statements for any change | ||
| 第40行： | 第36行： | ||
* export data as INSERT statements, html, text (user can define separator) | * export data as INSERT statements, html, text (user can define separator) | ||
* import data | * import data | ||
| − | |||
==相关链接== | ==相关链接== | ||
| 第46行： | 第41行： | ||
==屏幕截图== | ==屏幕截图== | ||
| − | + | <gallery perrow=6> | |
| − | + | image:SQLeonardo_screenshpt_1.png | |
| − | + | image:SQLeonardo_screenshpt_2.png | |
| + | image:SQLeonardo_screenshpt_3.png | ||
| + | </gallery> | ||
| − | [[ | + | [[Category:Database]] |
| + | [[Category:Java]] | ||
2010年9月26日 (日) 10:13的最后版本
目录 |
[编辑] 简介
SQLeonardo是一个强大易于使用的数据库管理工具。包括：
- Metadata Explorer 浏览数据库结构如表格，视图，主键,索引；
- Command Editor 创建，修改和执行SQL脚本。通过向导生成insert,update和delete语句；
- Query Builder 创建SQL查询不需要直接写SQL语句，自动创建表格之间的连接。支持union-query和sub-query；
- Data Grid 通过DataGrid直接修改表格，把数据导成INSERT语句等。
支持任何有JDBC驱动的数据库(Oracle,MS SQLServer,MySQL,DB2,Sybase, Firebird,HSQLDB,PostgreSQL,Apache Derby,Mckoi SQL)。
[编辑] 功能特性
General
- freeware software
- platform-independent
- supports multiple concurrent connections
- works with any JDBC compliant database (Oracle, MS SQLServer, MySQL, DB2,Sybase, Firebird, HSQLDB, PostgreSQL, Apache Derby, Mckoi SQL)
Metadata Explorer
- browse database structure as tables, views, keys, indices etc.
- search tables and columns
Command Editor
- create, edit, and execute SQL scripts
- generate insert, update and delete statements through a wizard
Query Builder
- create SQL queries without directly writing SQL
- joins between tables are automatically created
- support union-queries, also sub-queries
Data Grid
- edit tables directly via the data grid
- generate SQL statements for any change
- navigate database through his data (jumping from FK_record to PK_record or vice versa)
- export data as INSERT statements, html, text (user can define separator)
- import data
[编辑] 相关链接
[编辑] 屏幕截图
分享您的观点
