用java编写的学生成绩管理系统代码

;

public class Student

{

private String id;

private String name;

private int math;

private int english;

private int java;

private int computer;

public String getId()

{

return id;

}

public void setId(String id)

{

= id;

}

public String getName()

{

return name;

}

public void setName(String name)

{

= name;

}

public int getMath()

{

return math;

}

public void setMath(int math)

{

= math;

}

public int getEnglish()

{

return english;

}

public void setEnglish(int english) {

= english;

}

public int getJava()

{

return java;

}

public void setJava(int java)

{

= java;

}

public int getComputer()

{

return computer;

}

public void setComputer(int computer)

{

= computer;

}

public static void main(String[] args) throws Exception {

String id;

String cid;

String name;

int math;

int english;

int java;

int computer;

String DBDriver = "";

String conStr = "jdbc:odbc:student";

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

(DBDriver);

con = (conStr, "student", "123");

stmt = ();

String s = "\n\n\t\t\t学生成绩\n\n\t\t 1 新增\n\t\t 2 更改\n\t\t 3 删除\n\t\t 4 查找\n\t\t 5 显示\n\t\t 0 退出\n\n";

int choice = ();

switch (choice)

{

xecuteQuery("select avg(math),avg(english),avg(java),avg(computer) from lxh1");

while ())

{

+ "\t" + (2) + "\t"

+ (3) + "\t" + (4));

}

;

xecuteQuery("select min(math),min(english),min(java),min(computer) from lxh1");

while ())

{

+ "\t" + (2) + "\t"

+ (3) + "\t" + (4));

}

;

break;

case 0:

break;

default:

"感谢您的使用,再见!");

}

;

();

();

}

}