the skeleton for wiki

[wuyichen24]

• Build connection
• Mapping
  • Create table
  • Create java class
  • Type mapping
• CRUD operations
  • Create (Insert)
  • Read (Query)
  • Update
  • Delete
• Expression
  • Simple / Compound
  • Combine expression: And, Or
  • Available Operators
    • EQUAL
    • NOT_EQUAL
    • GREATER_THAN
    • LESS_THAN
    • GREATER_THAN_EQUAL
    • LESS_THAN_EQUAL
    • STARTS_WITH
    • ENDS_WITH
    • CONTAINS
    • IN

[wuyichen24]

Build connection

This project currently only supports MySQL. More database suites will be added into this project.

This project is using jpropertiesorm to retrieve the parameters from the external configuration file and populate into the configuration class. For example:

MysqlDbConfig dbConfig   = new MysqlDbConfig("config/MysqlDb.properties").initialize();

After grabbing values from the external configuration file, you can pass the object of the configuration class into the constructor of the database-specific DAO (Data Access Object). This level of DAO is database-specific and you can also create an application DAO in the lower level for handling application-specific business logic.

MysqlEntityManagerDao dao = new MysqlEntityManagerDao(dbConfig);

After initializing this DAO, you can use it to execute CRUD operation.