每日博客

JFinal的架构学习

-- Create table
create table CLASSES
(
  classesid      NUMBER not null,
  classesname    VARCHAR2(20),
  classesaddress VARCHAR2(50)
);
-- Create table
create table STUDENT
(
  studentid   NUMBER not null,
  studentname VARCHAR2(10),
  studentage  NUMBER,
  studentsex  VARCHAR2(2),
  classesid   NUMBER
);
alter table STUDENT
  add constraint FK_CLASSESID foreign key (CLASSESID)
  references CLASSES (CLASSESID);

两个实体类

package com.demo.model;

import com.jfinal.plugin.activerecord.Model;

public class Classes extends Model<Classes> {
    public static final Classes dao = new Classes();
}

package com.demo.model;

import com.jfinal.plugin.activerecord.Model;

public class Student extends Model<Student> {
    public static final Student dao = new Student();

    public Classes getClasses() {
        return Classes.dao.findById(get("classesid"));
    }

}