用java編寫的學(xué)生成績管理系統(tǒng)代碼

1、/studentpublic class Studentprivate 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) this.id = id;public String getName() return name;public void setName(String name) = name;

2、 public int getMath()return math;public void setMath(int math) this.math = math; public int getEnglish()con = DriverManager.getConnection(conStr, "student", "123");stmt = con.createStatement();String s = "nnttt學(xué) 生 成 績nntt 1 新 增ntt 2 更 改ntt 3 刪 除ntt 4 查 找ntt 5 顯 示ntt 0 退 出nn&

3、quot;int choice = Keyboard.getInteger();switch (choice)/ 添加學(xué)生case 1:id = Keyboard.getString();name = Keyboard.getString();math = Keyboard.getInteger();english = Keyboard.getInteger();java = Keyboard.getInteger();computer = Keyboard.getInteger();stmt.executeUpdate("insert into lxh1 values('&

4、quot; + id + "','"+ name + "','" + math + "','" + english + "','" + java+ "','" + computer + "')");break;/ 更改成績case 2:cid = Keyboard.getString();math = Keyboard.getInteger();english = Keyboard.get

5、Integer();java = Keyboard.getInteger();computer = Keyboard.getInteger();stmt.executeUpdate("update lxh1 set math='" + math + "',english='"+ english + "',java='" + java + "',computer='" + computer + "' where sno=" + cid

6、 + "");break;/ 刪除指定學(xué)生case 3:cid = Keyboard.getString();stmt.executeUpdate("delete from lxh1 where sno=" + cid + "");break;/ 顯示指定學(xué)生case 4:cid = Keyboard.getString();+ "號學(xué)生信息nn學(xué)號t姓名t數(shù)學(xué)t英語tJAVAt計算機t"); rs = stmt.executeQuery("select * from lxh1 where sno=&qu

7、ot; + cid+ "");while (rs.next()+ rs.getString("sname") + "t" + rs.getString("math") + "t" + rs.getString("english") + "t"+ rs.getString("java") + "t"+ rs.getString("computer") + "t");break;c

8、ase 5:/ 輸出全部信息rs = stmt.executeQuery("select * from lxh1 order by math desc");while (rs.next()int a = rs.getInt("math");int b = rs.getInt("english");int c = rs.getInt("java");int d = rs.getInt("computer");+ rs.getString("sname") + "t&q

9、uot; + a + "t" + b + "t"+ c + "t" + d + "t" + (a + b + c + d) / 4);/ 輸出平均分.executeQuery("selectavg(math),avg(english),avg(java),avg(computer) from lxh1");while (rs.next()+ rs.getInt(3) + "t" + rs.getInt(4);/ 輸出最高分rs = stmt.executeQuery("select max(math),max(english),max(java),max(computer) from lxh1");while (rs.next()+ rs.getInt(3) + "t" + rs.getInt(4);/ 輸出最低分.executeQuery("s