Create table tbl_bm_questionInf(
id number primary key,
titleContent varchar(40) not null ,
rightAnswer varchar(20) not null,
type int ,
score varchar(40)
);
drop table tbl_bm_answerInf
drop table tbl_bm_questionInf
delete from tbl_bm_questionInfo;
Create table tbl_bm_answerInf(
id number primary key, --序号 答案序号ID
answerContent varchar(40) not null, --答案内容
answerid number references tbl_bm_questionInf(id),
type int --答案类型 1多选 2单选3简答
);
select tbl_bm_questionInf.id,tbl_bm_questionInf.titleContent,tbl_bm_questionInf.score,
tbl_bm_answerInf.answerContent
from tbl_bm_questionInf , tbl_bm_answerInf
where
tbl_bm_questionInf.id=tbl_bm_answerInf.answerid
group by tbl_bm_questionInf.id
id number primary key,
titleContent varchar(40) not null ,
rightAnswer varchar(20) not null,
type int ,
score varchar(40)
);
drop table tbl_bm_answerInf
drop table tbl_bm_questionInf
delete from tbl_bm_questionInfo;
Create table tbl_bm_answerInf(
id number primary key, --序号 答案序号ID
answerContent varchar(40) not null, --答案内容
answerid number references tbl_bm_questionInf(id),
type int --答案类型 1多选 2单选3简答
);
select tbl_bm_questionInf.id,tbl_bm_questionInf.titleContent,tbl_bm_questionInf.score,
tbl_bm_answerInf.answerContent
from tbl_bm_questionInf , tbl_bm_answerInf
where
tbl_bm_questionInf.id=tbl_bm_answerInf.answerid
group by tbl_bm_questionInf.id
解决方案 »
- struts2+hibernate+spring+jasperreport,px,html出现红叉
- 关于POI操作EXCLE表格的问题
- session.load(class,NON_SERIALIZE_VALUE)
- 请求对象与JS脚本
- eclipse下写JSP问题?(http://jakarta.apache.org/struts/tags-bean) cannot be
- 送分的问题!大家积极参加
- 表格组件
- 用Java开发了个WebService,在VB,Delphi下怎么调用啊?
- 应用struts写的这个简单的jsp文件为什么会报错???
- 请问有没有什么工具可以格式化java代码?
- struts标签问题
- 举例 小的测试
你想问什么呢LZ