Patent ID: 9348944
Filing Date: 2016-05-24
CPC Classification: G06F,G06Q,H04M

Claim Text:
1. A computer implemented method comprising: creating, by a computer-based system for building queries, an empty value object, wherein the empty value object comprises a plurality of variables corresponding to fields in a database table; populating, by the computer-based system, the value object with values of a database record; sending, by the computer-based system, the value object to an appropriate method in a proxy based on an action to be performed, wherein the appropriate method comprises at least one of add/update, get records, or delete; sending, by the computer-based system and from the proxy, the value object to a database layer, wherein the database layer determines a name of the value object using reflection; determining, by the computer-based system, a name of the database table based on the name of the value object; building, by the computer-based system, a parameterized query in real time based on the fields, wherein the parameterized query eliminates SQL injection risks; executing, by the computer-based system, the query; providing, by the computer-based system, a template for results of the query; returning, by the computer-based system, the results of the query to the proxy; wherein, in response to the appropriate method being get records, the proxy creates a result value object that matches a structure of a record returned by the query and populates the result value object with data in the record returned by the query, and wherein, in response to the appropriate method being add/update, a record ID of the record returned by the query is returned to the proxy; and assigning, by the computer-based system and using reflection, the results of the query into the result value object.