选课系统实验;
数据库结构:
s(sno,sname,sdept)
stc(sno,cno,tno,grade)
tc(tno,cno,term)
t(tno,tname)我现在要用如下查询:select stc.* from stc,tc where stc.tno=tc.tno and stc.cno=tc.cno and tc.term = 3如果我用Hibernate的Criteria来做,需要怎么做呢?
数据库结构:
s(sno,sname,sdept)
stc(sno,cno,tno,grade)
tc(tno,cno,term)
t(tno,tname)我现在要用如下查询:select stc.* from stc,tc where stc.tno=tc.tno and stc.cno=tc.cno and tc.term = 3如果我用Hibernate的Criteria来做,需要怎么做呢?
解决方案 »
- 关于程序性能测试的问题(希望大家都进来看看)
- JSP页面显示数据库里面的数据
- 请教并发访问数据库,访问时间倍增的问题
- 请问tomcat和oracle ias应用服务,能在同一台服务器上一起运行吗?
- 请问重庆朗沃教育的培训质量如何
- webwork和spring如何整合??
- 关于Servlet过滤器的问题?
- struts和tiles组合,其中actionForm(body)做validate()后,只显回body没有header,footer?
- weblogic7的sqlserver的jdbc连接池,应该怎么配置?
- 怎样将servlet部署到sae上
- 问下 JDBC 操作ORACLE数据库返回主键的问题
- Myeclipse8.6开发Struts2,内置tomcat可以成功运行,但是自己装的不行
private String cno;
private String cname;
private String cdept;
private Integer credits;
private Set tcs = new HashSet(0);
private Set stcs = new HashSet(0);
}public class S implements java.io.Serializable {
private String sno;
private Dept dept;
private String sname;
private String sex;
private Integer age;
private String pwd;
private Integer fee;
private Set scs = new HashSet(0);
}
public class Stc implements java.io.Serializable {
private ScId id;
private C c;
private S s;
private T t;
private Integer grade;
private Date stcYear;
}
public class T implements java.io.Serializable {
private String tno;
private Dept dept;
private String tname;
private int tclass;
private String tdescription;
private String pwd;
private Set tcs = new HashSet(0);
private Set stcs = new HashSet(0);
private Set tclasses = new HashSet(0);
}
public class Tc implements java.io.Serializable {
private TcId id;
private C c;
private T t;
private int term;
}