u010509143的专栏

ALTER TABLE t_plan ADD CONSTRAINT main_id_cons FOREIGN KEY (creator_id) REFERENCES t_employee(id);  添加外键; 给t_plan 添加 了 creator_id 到 t_employee 的id

select * from t_apply  where start_time '2014-03-21 13:32:26'

public Page queryUpRoom(RoomModel roomModel, int page, int rows,   String startTime, String endTime) throws Exception {  // ROOM_NAME,t.ROOM_ID,t.ROOM_ADDRESS,t.CONTACT_TEL,t.MAX_NUM  String sql