Single Table Maintenance
There are some cases that you might need to do single table CRUD (Create, Read, Update, Delete) 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.ajDBCreateRecord: Insert new records into a table.
2.ajDBReadRecord: Retrieves records from a table or a view based on some filter criteria. Sorting and paging can be set.
3.ajDBCountRecord: Returns the number of records in a table or a view that match some filtering criteria.
4.ajDBUpdateRecord: Updates specified records in a table based on some filtering criteria.
5.ajDBMergeRecord: Updates or inserts the record in a 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.ajDBDeleteRecord: Deletes records from a table based on some filtering criteria.
These single table maintenance extended functions support MySQL, MSSQL, PostgreSQL and Oracle table.