CIMOT – SQL v.1_0

TUTORIAL

 

PREVIOUS <       > NEXT

 

 

6.       ADVANCE MYSQL USER PANEL

 

Java recognize every SQL Query as a String of a Statement, every String Statement have each characteristic and use, and it need a certain Method to Execute each String Statement. There are several Method in Java to Execute SQL String Statement.

 

CIMOT-SQL v.1_0 actually provide you 2 Method to Execute your SQL String Statement, which are execute.Query(String s) and executeUpdate(String s) , their use is for:

 

 

execute.Query(String s)

to Executes the given SQL statement, which returns a single ResultSet object. e.g. SELECT* statement.

 

executeUpdate(String s)

to Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

 

Note: strongly recommended this is for advance MySQL USERS who already very often using mysql client console, because every syntax need to provide by users , CIMOT_SQL v.1_0 not provide any MySQL keyword in this case, only help to connect to MySQL server and to process any given String Statement.

 

 

6.1   EXECUTE QUERY

 

To use execute.Query(String s) method use the YELLOW text field in For Advance Users Panel, just insert your complete syntax then press ENTER, if succeed internal window will appear , showing your syntax result

 

 

For example if you  prefer to use  this option instead of using Tabbed Panes, the original MySQL syntax to Show Tables is:

 

mysql>show tables;

 

In CIMOT-SQL v.1_0:

 

	show tables

 

                                                                              Then press ENTER

 

 

 

 

 

 

 

6.2   EXECUTE UPDATE

 

To use execute.Update(String s) method use the PINK text field in For Advance Users Panel, just insert your complete syntax then press ENTER, if succeed internal window WILL  NOT appear , CIMOT-SQL v.1_0 can not show  your syntax result, since CIMOT-SQL v.1_0 can not read separately every single of word of syntax in the text field, in order to see your syntax result you must use the Host Manager Tabbed Panes, Database Manager Tabbed Panes, Tables Manager Tabbed Panes or Field Manager Tabbed Panes.

 

 

For example if you  prefer to use  this option instead of using Tabbed Panes, the original MySQL syntax to Delete Table is:

 

mysql>drop table potatochips;

 

In CIMOT-SQL v.1_0:

 

	drop table potatochips

 

                                                                              Then press ENTER

 

 

 

 

PREVIOUS <       > NEXT