Examples of SampleDB

org.apache.empire.jsf2.websample.db.SampleDB

org.apache.empire.samples.cxf.wssample.server.db.SampleDB

 This file contains the definition of the data model in Java. The SampleDB data model consists of two tables and a foreign key relation. The tables are defined as nested classes here, but you may put the in separate files if you want. PLEASE NOTE THE NAMING CONVENTION: Since all tables, views and columns are declared as "final" constants they are all in upper case. We recommend using a prefix of T_ for tables and C_ for columns in order to keep them togehter when listed in your IDE's code completition. There is no need to stick to this convention but it makes life just another little bit easier. You may declare other database tables or views in the same way.

org.apache.empire.samples.spring.db.SampleDB

 This file contains the definition of the data model in Java. The SampleDB data model consists of two tables and a foreign key relation. The tables are defined as nested classes here, but you may put the in separate files if you want. PLEASE NOTE THE NAMING CONVENTION: Since all tables, views and columns are declared as "final" constants they are all in upper case. We recommend using a prefix of T_ for tables and C_ for columns in order to keep them together when listed in your IDE's code completion. There is no need to stick to this convention but it makes life just another little bit easier. You may declare other database tables or views in the same way.

org.apache.empire.struts2.websample.db.SampleDB

Examples of org.apache.empire.struts2.websample.db.SampleDB

    
    public Options getDepartments()
    {
        if (departments==null)
        {
            SampleDB db = getDatabase();
            DBCommand cmd = db.createCommand();
            cmd.select(db.T_DEPARTMENTS.C_DEPARTMENT_ID);
            cmd.select(db.T_DEPARTMENTS.C_NAME);
            cmd.orderBy(db.T_DEPARTMENTS.C_NAME.asc());
            departments = db.queryOptionList(cmd.getSelect(), getConnection());
        }
        return departments;
    }

View Full Code Here

Examples of org.apache.empire.struts2.websample.db.SampleDB

        return doList();
    }


    public String doList()
    {
        SampleDB db = getDatabase();
        SampleDB.Employees EMP = db.T_EMPLOYEES;
        SampleDB.Departments DEP = db.T_DEPARTMENTS;
        
        DBCommand cmd = db.createCommand();
        cmd.select(EMP.C_EMPLOYEE_ID);
        cmd.select(C_FULL_NAME, EMP.C_GENDER, EMP.C_DATE_OF_BIRTH);
        cmd.select(C_DEPARTMENT);
        cmd.join  (DEP.C_DEPARTMENT_ID, EMP.C_DEPARTMENT_ID);

View Full Code Here

Examples of org.apache.empire.struts2.websample.db.SampleDB

    
    @Override
    public Options getFieldOptions(DBColumn column)
    {
        if (column.equals(T.C_DEPARTMENT_ID)) {
            SampleDB db = (SampleDB)getDatabase();
            DBCommand cmd = db.createCommand();
            cmd.select(db.T_DEPARTMENTS.C_DEPARTMENT_ID);
            cmd.select(db.T_DEPARTMENTS.C_NAME);
            return db.queryOptionList(cmd.getSelect(), context.getConnection());
        }
        // base class implementation
        return super.getFieldOptions(column);
    }

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.