Tianyue Studio produced
Version 1.2
A multi-threaded database operation management software, using the DBEXPRESS engine to directly operate data, efficient, fast, currently supporting Oracle, MySQL, MSSQLServer (MSSQLServer under Linux). Three databases. Function introduction is as follows:
Multithreading connection Different types of databases, can be encrypted to save common connections; view the various properties of the database table, including fields, index, constraints, triggers, stored procedures, functions, table field annotations, etc .; view data and rows of data tables; You can customize the SQL statement, multi-thread execution, support DDL, DML; addable to the SQL execution result, unified submission save, save the process can be monitored; save the current data or SQL statement to external files, data saves support TXT and XML; view Current database connection session, can perform multi-session KILL operations;
◇ This software includes two versions of Windows and Linux, this is a Windows version.
◇ Software Execute requires support for the corresponding database client.
Overview
1.1 Copyright Notice & License 1.2 Precautions Precautions 1.3 Support for Database 1.4 About Registration 1.5 About Uninstall
2. Connect the database
2.1 Normal connection 2.2 Quick connection 2.3 more connections
3. Data table operation
3.1 View all types of properties in the database 3.2 Viewing various attributes of a single table 3.3 Enter SQL statements to execute 3.4 Data modification mode Add Deletion 3.5 Update Data Submit 3.6 Modify Mode Update Situation 3.7 Increase Wrap Tags 3.8 Six Data
4. Database session management
4.1 View the current database session 4.2 Kill the selected session
5. Learn about DBEXPRESS
5.1 What is DBEXPRESS 5.2 advantage
6. Acknowledgment
Overview
1.1 Copyright Notice & Permit
"DBEXPRESS HIGHOR [High Efficiency Database Manager]", copyright belongs to Odue Studio. Any organization and individuals have not been allowed to be licensed and authorized by Ontalian Studio, and they must not change the content and packaging products of the software.
This "Software Product" is protected by the copyright law and the international treaty provisions and other intellectual property rights laws and treaties. This "software product" only provides license agreements, not for sale. This Agreement grants you the following rights: You can install a copy of this Software Products on a single computer.
1.2 Precautions before installation
Required software environment Windows98 / 2000 / XP / 2003 and Oracle, MySQL, MSSQLServer client, or related class libraries.
1.3 Support for the database
This version supports the three databases of Oracle, MySQL, MSSQLServer, and the specific database version relies on the installed client.
1.4 About registration
This software is registered online by ***. Of course, you can also send MAIL to sh_wwf@263.net to register; registration requires software installation calculations
The machine's machine number, this number is obtained through this software menu "Help / About Registration / User No.". The registration version will get free technical support and upgrade, and the unregistered version can be tried 10 times.
1.5 About Uninstall
If you need to uninstall, you can complete the automatic uninstall via the Add Delete program of the Windows Control Panel.
2. Connect the database
After running the program, after entering the main interface, click on the menu to start / new connections (you can also click on the first shortcut) to create a new connector window.
2.1 Normal connection
The connector window is divided into connection configuration, quick connection, data table, and thread tab. To connect the database you need to enter the connection configuration related items:
[Database]: drop-down box, including Oracle, MySQL, MSSQLServer three database type selection.
[User]: Database User Name. [Password]: Database password.
[Service Name]: Only valid for Oracle, enter the host string created through the client.
[Tank Name]: Only for MySQL, MSSQLServer, enter the database name that you want to be operated, this does not lose all Database on the connected server.
[Host Name]: Only valid for MySQL, MSSQLServer, enter the host name or IP you want to be operated in the database.
Click on the menu action / connect the database or the corresponding shortcut button or F5 key, the program will connect the background database based on the connection, such as successful data sheets connected to the tree structure.
2.2 Quick connection
Quick connections can save the current connection configuration for next time. In a state where the database is connected, click the right button directly to the fast connection, will pop up the quick connection menu:
[Save the current connection]: Start / save the connection configuration with the menu, such as the current database is connected, will pop up the quick connection Name input box, you can save the configuration after customizing the connection name.
[Delete Selected Quick Connection]: Delete the selected connection configuration in the current Quick Connection drop-down box.
[Delete all fast connections]: Delete all fast connection configurations currently saved.
Select a pre-saved connection configuration in a quick connection, the system will automatically fill in the relevant connection configuration, press the F5 key to connect.
2.3 more connection
This system can create a new multiple connections, support simultaneous operation of multiple databases, and does not affect each other independence.
3. Data table operation
3.1 View all kinds of properties of all tables in the database
Right-click on the root node of the tree data sheet, the menu will pop up:
[View Index]: View the index of all tables in the library.
[View Constraint Condition]: View the constraints of all tables in the library. Includes primary links, constraints, primary keys, etc.
[View Trigger]: Does not support MySQL, check the triggers for all tables in the library.
[View Procedure Function]: Do not support mysql, check all stored procedures and functions in the library.
[View Table Note]: Also supports Oracle, view Comments in all tables in the library.
[View Field Note]: Also supports Oracle, view Comments for all fields of all tables in the library.
3.2 View all kinds of properties for single table
◇ The tree data sheet represents a table, click the number in front, will expand the following properties:
[Field Properties]: View the field properties of the table.
[Index]: View the index of the table.
[Constraint Condition]: View the constraints of the table. Includes primary links, constraints, primary keys, etc.
[Partition]: Only Oracle is supported, view the partition of the table.
[Trigger]: Mysql does not support Mysql, see the trigger of the table.
[Table Note]: Only Oracle is supported, view the Comments of the table.
[Field Note]: Only Oracle is only available to view the Comments of all fields of the table.
Click on each attribute to give the result on the current thread tab on the right.
◇ 点 Right click on each node, you will pop up the following menu:
[View Data]: View all the data of the table.
[View Row]: View the number of data in the table.
3.3 Enter SQL statement execution
The SQL Enter the text box on the thread tab, you can enter custom SQL statements, including SELECT, INSERT, DELETE, CREATE, DROP, TRUNCATE, Exec, Show, etc., press F9 or Menu Action / Execute SQL or Flight Button Execution .
SQL statements in the SQL Enter the text box can also be saved to * .sql files. Click on the menu to start / save SQL or the corresponding shortcut button can be saved.
Enter the selected * .sql file into the SQL Enter the text box by menu start / open SQL or the fly button. 3.4 Data modification mode increase
The data queried by the thread tab can enter the modification interface by the open modification mode of the right mole menu. This mode allows you:
[Add]: Insert a data.
[Delete]: Delete the current data.
Modify: You can modify it in the data table.
3.5 Update Data Submit
The increase in modification mode, delete, and change data can be submitted before it can take effect. Submitting a key to the F12 key or click [Submit to Database] for the Right-click menu. If there is no error message, it means successfully submitted. It should be noted that the data modified from the input SQL statement is directly effective without submitting.
3.6 Modify mode update monitoring
Right-click on the last menu [Update Situation Monitor], you can open the modified mode - Submit the update monitor window. This window monitors the update of the F12 key [Submit a modified to database].
3.7 Add Delete Tread Tab
The thread tab of the connector window can be increased, deleted. Open by menu action / new tab (F3 key) and action / delete tab (F4 key) or corresponding quick button. Each connection can create up to 16 threads.
Each tab is renamed. Implemented by clicking the right mole menu at the tab page.
3.8 Some of the data
Menu start / saving data represents saving the data currently queried to an external file. If the current thread tab is not data, save the tree data table data, if there is a saving the data displayed in the table in the table. Save data supports both TXT and XML formats.
4. Database session management
4.1 View the current database session
Menu Administration / Manage Current Database Session You can view the current database session, which users are connected to the current database. It is necessary to pay attention to the database account you use must have this permission.
4.2 Kill the selected session
The [Kill] button on the left side of the interface allows you to kill the selected session, that is, interrupt its session connection. After the mysql session is killed, the session information will also be displayed, but the status has become killed, and the record disappears with the user's exit.
5. Learn about DBEXPRESS
5.1 What is DBEXPRESS
DBEXPRESS is provided by Borland, a set of components, drivers, can match different databases with DLL connecting different databases.
5.2 advantage
Supports Windows and Linux and .NET, high efficiency, fast speed, database version unrelated, is the development trend of the Borland data engine.
6. Acknowledgment
I want to list all people who help me write this software here. People who include trial or inquiry, there are people who help me understand this theme.
Helen Gsbingo Silo Ltone
