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

 

//student

import java.sql.*;

 

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)

       {

              this.id = id;

       }

 

       public String getName()

       {

              return name;

       }

 

       public void setName(String name)

       {

              this.name = name;

       }

 

       public int getMath()

       {

              return math;

       }

 

       public void setMath(int math)

       {

              this.math = math;

       }

 

       public int getEnglish()

       {

              return english;

       }

 

       public void setEnglish(int english)

       {

              this.english = english;

       }

 

       public int getJava()

       {

              return java;

       }

 

       public void setJava(int java)

       {

              this.java = java;

       }

 

       public int getComputer()

       {

              return computer;

       }

 

       public void setComputer(int computer)

       {

              this.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 = "sun.jdbc.odbc.JdbcOdbcDriver";

              String conStr = "jdbc:odbc:student";

              Connection con = null;

              Statement stmt = null;

              ResultSet rs = null;

              Class.forName(DBDriver);

              con = DriverManager.getConnection(conStr, "student", "123");

              stmt = con.createStatement();

              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";

              System.out.print(s);

              int choice = Keyboard.getInteger();

              switch (choice)

              {

 

                     // 添加学生

                     case 1:

                            System.out.print("请输入学生信息\n");

                            System.out.print("学号:");

                            id = Keyboard.getString();

                            System.out.print("姓名:");

                            name = Keyboard.getString();

                            System.out.print("数学:");

                            math = Keyboard.getInteger();

                            System.out.print("英语:");

                            english = Keyboard.getInteger();

                            System.out.print("JAVA:");

                            java = Keyboard.getInteger();

                            System.out.print("计算机:");

                            computer = Keyboard.getInteger();

                            stmt.executeUpdate("insert into lxh1 values('" + id + "','"

                                          + name + "','" + math + "','" + english + "','" + java

                                          + "','" + computer + "')");

                            System.out.println("\n添加完成。");

                            break;

 

                     // 更改成绩

                     case 2:

 

                                   System.out.println("请输入要改的学生学号：");

                                   cid = Keyboard.getString();

                                   System.out.println("数学：");

                                   math = Keyboard.getInteger();

                                   System.out.println("英语：");

                                   english = Keyboard.getInteger();

                                   System.out.println("JAVA：");

                                   java = Keyboard.getInteger();

                                   System.out.println("计算机：");

                                   computer = Keyboard.getInteger();

                                   stmt.executeUpdate("update lxh1 set math='" + math + "',english='"

                                                 + english + "',java='" + java + "',computer='" + computer

                                                 + "' where sno=" + cid + "");

                                   System.out.println("\n修改完成");

                                   break;

 

 

                     // 删除指定学生

                     case 3:

                            System.out.println("请输入要改的学生学号：");

                            cid = Keyboard.getString();

                            stmt.executeUpdate("delete from lxh1 where sno=" + cid + "");

                            System.out.println("\n删除完成");

                            break;

 

                     // 显示指定学生

                     case 4:

                            System.out.println("请输入查找的学生学号：");

                            cid = Keyboard.getString();

                            System.out.println("\n" + cid

                                          + "号学生信息\n\n学号\t姓名\t数学\t英语\tJAVA\t计算机\t");

                            rs = stmt.executeQuery("select * from lxh1 where sno=" + cid

                                          + "");

                            while (rs.next())

                            {

                                   System.out.println(rs.getInt("sno") + "\t"

                                                 + rs.getString("sname") + "\t" + rs.getString("math")

                                                 + "\t" + rs.getString("english") + "\t"

                                                 + rs.getString("java") + "\t"

                                                 + rs.getString("computer") + "\t");

                            }

                           

                            break;

 

                     case 5:

                            // 输出全部信息

                            System.out.println("\n全部学生信息\n\n学号\t姓名\t数学\t英语\tJAVA\t计算机\t平均成绩");

                            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");

                                   System.out.println(rs.getString("sno") + "\t"

                                                 + rs.getString("sname") + "\t" + a + "\t" + b + "\t"

                                                 + c + "\t" + d + "\t" + ((a + b + c + d) / 4));

                            }

                            ;

 

                            // 输出平均分

                            System.out.println("\n各科平均分\n\n数学\t英语\tJAVA\t计算机\t");

                            rs = stmt

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

                            while (rs.next())

                            {

                                   System.out.println(rs.getInt(1) + "\t" + rs.getInt(2) + "\t"

                                                 + rs.getInt(3) + "\t" + rs.getInt(4));

                            }

                            ;

 

                            // 输出最高分

                            System.out.println("\n各科最高分\n\n数学\t英语\tJAVA\t计算机\t");

                            rs = stmt.executeQuery("select max(math),max(english),max(java),max(computer) from lxh1");

                            while (rs.next())

                            {

                                   System.out.println(rs.getInt(1) + "\t" + rs.getInt(2) + "\t"

                                                 + rs.getInt(3) + "\t" + rs.getInt(4));

                            }

                            ;

 

                            // 输出最低分

                            System.out.println("\n各科最低分\n\n数学\t英语\tJAVA\t计算机\t");

                            rs = stmt

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

                            while (rs.next())

                            {

                                   System.out.println(rs.getInt(1) + "\t" + rs.getInt(2) + "\t"

                                                 + rs.getInt(3) + "\t" + rs.getInt(4));

                            }

                            ;

                            break;

 

                     case 0:

                            break;

 

                     default:

                            System.out.println("感谢您的使用,再见!");

              }

              ;

              stmt.close();

              con.close();

       }

}