jdbcsql.java

简单的奖学金评定系统

class Jdbcsql{

String drv="sun.jdbc.odbc.JdbcOdbcDriver";
String con="jdbc:odbc:loen";
String sql1="select sid,sname,sdept,sgrade,sclass,sgender from student";
String sql3="select sid,sname,sdept,sgrade,sclass,sgender from student order by sid";
String sql4="select sc.sid,s.sname,avg(score) a  from st_co sc,student s  where s.sid=sc.sid  group by sc.sid  order by a desc ";
String sql7="select c.cid,c.cname,avg(sc.score) a  from st_co sc,course c where c.cid=sc.cid  group by sc.cid  order by a desc";
String sql2="select cid,cname,cgrade from course";
String sql6="select sc.sid,s.sname,avg(score) a  from st_co sc,student s  where s.sid=sc.sid  group by sc.sid  order by a desc limit 7";

String sql11="select s.sid,s.sname,avg(score) a ,h.grade,h.ty,h.amount from st_co sc,student s ,scholarship1 h where s.sid=sc.sid and h.grade=1 group by sc.sid  order by a desc limit 7 ";
String sql12="select s.sid,s.sname,avg(score) a ,h.grade,h.ty,h.amount from st_co sc,student s ,scholarship1 h where s.sid=sc.sid and h.grade=2 group by sc.sid  order by a desc limit 7  ";
String sql13="select s.sid,s.sname,avg(score) a ,h.grade,h.ty,h.amount from st_co sc,student s ,scholarship1 h where s.sid=sc.sid and h.grade=3 group by sc.sid  order by a desc limit 7  ";


String[] col={"学号","姓名","系别","年级","班级","性别"};
String[] col4={"学号","姓名","平均成绩"};      
String[] col3={"学号","姓名","平均成绩","等级","种类","金额"};
String[] col2={"课程号","课程名","学分"};
String[] col1={"课程号","课程名","课程的平均成绩"};
}