oraclequestiondao.properties

来自「基于STRUTS的网络调查应用」· PROPERTIES 代码 · 共 6 行

insert = insert into TEST_QUESTION(ID, TEXT, EXPLANATION,ID_CATEGORY) values(?,?,?,?)
delete = delete from TEST_QUESTION where ID = ?
select.one = select ID, TEXT, EXPLANATION,ID_CATEGORY from TEST_QUESTION where ID = ?
select.all = select ID, TEXT, EXPLANATION,ID_CATEGORY from TEST_QUESTION
update = update TEST_QUESTION set TEXT=?, EXPLANATION=?, ID_CATEGORY=? where ID = ?
select.answer = select A.ID, A.TEXT, A.EXPLANATION, A.ID_CATEGORY from TEST_QUESTION A, TEST_ANSWER B WHERE A.ID=B.ID_QUESTION AND B.ID = ?