S2Dao has the following features:

• O/R mapping without a XML document

  Many current O/R mapping framework depends on XML to hold large amount of information.
  S2Dao does not require XML. O/R mapping is accomplished by just adding metadate to Java source code.

• Does not require JDBC knowledge

  Java applications use JDBC to connect to a database.
  When using S2Dao, database connections are handled by S2Dao. Developers are able to connect to a database without knowing intricate details of JDBC api. It is not necessary to write codes to connect and disconnect from the database.

• SQL programmers and Java programmers can work separately on what they know the best

  S2Dao is able to read SQL commands written in external files. These SQL commands may be tested using tools like Oracle SQL*Plus. Java mappings are written as comments in these files. Thus, these SQL commands can still be executed. Files which contain SQL commands with Java codes in comments are called 2 way SQL. It is also possible to map with Java read in by S2Dao.
  As stated, SQL commands are written in external files separately from Java logic programming files. This allows SQL programmers to work independently from Java logic programmers which results in shortening the overall development schedule.

• Automatic generation of SQL commands

  If Java method names are named in a prescribed manner, it is possible to generate SQL commands.
  In most circumstances, generated SQL command will suffice, but in cases of complex SQL commands or when SQL command needs to be customized, SQL commands should be written manually.

• Separation of interface and implementation

  By just defining interfaces, it is possible to apply Aspect and to generate SQL commands.

document

• S2Dao

Issue Tracking

• JIRA

download

• S2Dao 1.0.51 (with S2Dao Tiger)
• S2Pager Examples 1.0.51