jdbcsql.java

来自「一个通过odbc链接数据库（mysql）的奖学金评定系统！·」· Java 代码 · 共 20 行

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={"学号","姓名","年级","专业","班级","性别"};
String[] col1={"学号","姓名","平均成绩"};   
String[] col2={"排名","学号","姓名","分数"}; 

}