1 2 3 4 5 6 7 8 9 | mysql> show tables; +----------------+ | Tables_in_trip | +----------------+ | airline | | airport | | flight | | trip | +----------------+ |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | mysql> desc flight; +----------------------+--------------+------+-----+ | Field | Type | Null | Key | +----------------------+--------------+------+-----+ | id | bigint(20) | NO | PRI | | version | bigint(20) | NO | | | airline_id | bigint(20) | YES | MUL | | arrival_airport_id | bigint(20) | NO | MUL | | arrival_date | datetime | NO | | | departure_airport_id | bigint(20) | NO | MUL | | departure_date | datetime | NO | | | flight_number | varchar(255) | NO | | | trip_id | bigint(20) | YES | MUL | +----------------------+--------------+------+-----+ |
1 2 3 4 | <g:select optionKey="id" from="${Airline.list()}" name="airline.id" value="${flight?.airline?.id}" ></g:select> |
1 2 3 4 5 | <select name="airline.id" id="airline.id" > <option value="1" >UAL - United Airlines</option> <option value="2" >DAL - Delta</option> <option value="3" >COA - Continental</option> </select> |
欢迎光临 电子技术论坛_中国专业的电子工程师学习交流社区-中电网技术论坛 (http://bbs.eccn.com/) | Powered by Discuz! 7.0.0 |