Skip to content

A Java based small software for school course grades statistics. Mainly for database learning.

Notifications You must be signed in to change notification settings

CaptainCandy/Database

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Database

Final project for this course. Readme.md is for Mr.Zhou.

注意

  • 首先用无参构造函数初始化,然后向JScrolPane中添加表格,使用setViewportView(component)

"select top 5 SC.S_id as ID, S.s_name as Name, " + "sum(SC.score * Course.credit)/sum(Course.credit) as gpa " + "from Student as S, SC, Course where S.S_id = SC.S_id and " + "Course.C_id = SC.C_id group by SC.S_id, S.S_name having min(SC.score) >= 60 order by gpa;";

About

A Java based small software for school course grades statistics. Mainly for database learning.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Java 100.0%