class Jdbcsql{

String drv="sun.jdbc.odbc.JdbcOdbcDriver";
String con="jdbc:odbc:gold";
String sql1="select sid,sname,grade,dept,class,gental from student";
	String sql2="select sid1,cid1,scgrade from student_course";
	String sql3="select a.sid1,s.sname,avg(a.scgrade) c from student_course a ,student s where s.sid=a.sid1 group by a.sid1 order by c desc limit 7";
	String sql4="insert into aver select a.sid1,s.sname,avg(a.scgrade) c from student_course a ,student s where s.sid=a.sid1 group by a.sid1 order by c desc limit 7";
	String sql5="CREATE TABLE `se02`.`aver` (  `num` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,  `sid` VARCHAR(45) NOT NULL, `sname` VARCHAR(45) NOT NULL,  `av` VARCHAR(45) NOT NULL,  PRIMARY KEY(`num`))";
	String sql6="drop table aver ";
	String sql7="insert into aver(sid,sname,av) select a.sid1,s.sname,avg(a.scgrade) c from student_course a ,student s where s.sid=a.sid1 group by a.sid1 order by c desc limit 7";
	String sql8="select num,sid,sname,av from aver where num<2  order by av desc ";
	String sql9="select num,sid,sname,av from aver where num>1 and num<4  order by av desc ";
	String sql10="select num,sid,sname,av from aver where num>3 and num<8  order by av desc ";

String[] col={"學(xué)號","姓名","年級","專業(yè)","班級","性別"};
String[] col1={"學(xué)號","姓名","平均成績"};   
String[] col2={"排名","學(xué)號","姓名","分數(shù)"}; 

}