摘要:
create table score( SCONO NUMBER(4), STUNO NUMBER(3), COUNO number(4), sco number(3), SCONAME VARCHAR2(8))ALTER TABLE SCORE ADD CONSTRAINT PK_SCONO PRIMARY KEY(SCONO) ALTER TABLE SCORE ADD CONSTRAINT FK_STUNO FOREIGN KEY(STUNO) REFERENCES STUDENT(STUNO)ALTER TABLE SCORE ADD CONSTRAINT FK_COUNO FOREI 阅读全文
摘要:
-----查询-----查询显示学号, 学员姓名,学的成绩-----查询显示比某一个学员年龄大其他的学员信息-----获得100105的学员的年龄----子查询select * from student where stuage>(select stuAge from student where stuno=100105)----笛卡尔积selectstudent.stuNo,stuName,wirtesoc ,courseNo,labsor, student.stuno,score.stuno from student,score where student.stuno=score.s 阅读全文
摘要:
pageContext.setAttribute(); request.setAttribute(); session.setAttribute(); application.setAttribute(); Jsp内置对象: out pageContext request response session application exception config 用EL表达式的指令: <%@ taglib prefix="c" uri="http://java.sun.com/jsf/core" %> EL表达式: El支持运算符: 大 于: 阅读全文