Apache Empire-db
≈ 4 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
Apache Empire-db is a Java library that provides a high level object-oriented API for accessing relational database management systems (RDBMS) through JDBC. Apache Empire-db is open source and provided under the Apache License 2.0 from the Apache Software Foundation. Compared to Object-relational mapping (ORM) or other data persistence solutions such as Hibernate, iBATIS or TopLink Empire-db does not use XML files or Java annotations to provide a mapping of plain (old) Java object (POJO's) to database tables, views and columns. Instead Empire-db uses a Java object model to describe the underlying data model and an API that works almost solely with object references rather than string literals. Empire-db's aim is to provide better software quality and improved maintainability through increased compile-time safety and reduced redundancy of metadata. Additionally applications may benefit from better performance due to full control over SQL statements and their execution by the developer compared to most OR-mapping solutions.
Apache Empire-db is a Java library that provides a high level object-oriented API for accessing relational database management systems (RDBMS) through JDBC. Apache Empire-db is open source and provided under the Apache License 2.0 from the Apache Software Foundation. Compared to Object-relational mapping (ORM) or other data persistence solutions such as Hibernate, iBATIS or TopLink Empire-db does not use XML files or Java annotations to provide a mapping of plain (old) Java object (POJO's) to database tables, views and columns. Instead Empire-db uses a Java object model to describe the underlying data model and an API that works almost solely with object references rather than string literals. Empire-db's aim is to provide better software quality and improved maintainability through increased compile-time safety and reduced redundancy of metadata. Additionally applications may benefit from better performance due to full control over SQL statements and their execution by the developer compared to most OR-mapping solutions. SELECT t1.EMPLOYEE_ID, t1.LASTNAME || ', ' || t1.FIRSTNAME AS NAME, t2.DEPARTMENT FROM (EMPLOYEES t1 INNER JOIN DEPARTMENTS t2 ON t1.DEPARTMENT_ID = t2.DEPARTMENT_ID) WHERE upper(t1.LASTNAME) LIKE upper('Foo%') AND t1.RETIRED=0 ORDER BY t1.LASTNAME, t1.FIRSTNAME This SQL statement can be created using Empire-db's command API using object model references like this: SampleDB db = getDatabase(); // Declare shortcuts (not necessary but convenient) SampleDB.Employees EMP = db.EMPLOYEES; SampleDB.Departments DEP = db.DEPARTMENTS; // Create a command object DBCommand cmd = db.createCommand(); // Select columns cmd.select(EMP.EMPLOYEE_ID); cmd.select(EMP.LASTNAME.append(", ").append(EMP.FIRSTNAME).as("NAME")); cmd.select(DEP.DEPARTMENT); // Join tables cmd.join (EMP.DEPARTMENT_ID, DEP.DEPARTMENT_ID); // Set constraints cmd.where(EMP.LASTNAME.likeUpper("Foo%")); cmd.where(EMP.RETIRED.is(false)); // Set order cmd.orderBy(EMP.LASTNAME); cmd.orderBy(EMP.FIRSTNAME); In order to execute the query and retrieve a list of POJO's holding the query result the following code may be used: // Class definition for target objects public class EmployeeInfo { private int employeeId; private String name; private String department; // Getter's and Setters for all properties // or a public Constructor using fields public get... public set... } // Retrieve employee list using the cmd object created above DBReader reader = new DBReader(); try { reader.open(cmd, getConnection()); List empList = reader.getBeanList(EmployeeInfo.class); } finally { reader.close() } Empire-db also supports field access through object references or obtaining query results as XML.
References
Text derived from https://en.wikipedia.org/w/index.php?oldid=1358134288 under CC BY-SA 4.0; modifications have been made.