Single Table Maintenance
There are some cases that you might need to do single table CRUD maintenance. AlchemyJ can help you to achieve this without writing any SQL Statement. By utilizing one of the following extended functions, you can implement a single table CRUD operation easily.
1.ajCreateRec: Insert new records into a single table.
2.ajReadRec: Read the records from a single table and display the retrieved results in excel, filtering criteria, sorting and page break can be applied when reading the records.
3.ajCountRec: Return the number of records in a single table, filtering criteria can be applied when counting the matched records.
4.ajUpdateRec: Update the specified records in a single table, filtering criteria can be applied when updating the specified records.
5.ajMergeRec: Update or insert the record in a single table. For example, when using this function to process a user record in a user table, if the user record exists in the user table, it will update the user record in the table. If the user does not exist in user table, it will insert the user record into the user table.
6.ajDeleteRec: Delete the records from a single table, filtering criteria can be applied so as to delete the specified records from the table.
The single table maintenance can support MySQL, MSSQL and Oracle table.