1、/studentimport java.sql.*;public 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)th
2、is.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 co
3、mputer;public void setComputer(int computer)puter = computer;public static void main(String args) throws ExceptionString 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;Sta
4、tement stmt = null;ResultSet rs = null;Class.forName(DBDriver);con = DriverManager.getConnection(conStr, “student“, “123“);stmt = con.createStatement();String s = “nnttt 学 生 成 绩nntt 1 新 增ntt 2 更 改ntt 3 删 除ntt 4 查 找ntt 5 显 示ntt 0 退 出nn“;System.out.print(s);int choice = Keyboard.getInteger();switch (c
5、hoice)/ 添加学生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
6、.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.g
7、etString();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 + “,engli
8、sh=“+ 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;/ 显示指定学生c
9、ase 4:System.out.println(“请输入查找的学生学号： “);cid = Keyboard.getString();System.out.println(“n“ + cid+ “号学生信息nn 学号t 姓名t 数学t 英语tJAVAt 计算机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.getStrin
10、g(“math“)+ “t“ + rs.getString(“english“) + “t“+ rs.getString(“java“) + “t“+ rs.getString(“computer“) + “t“);break;case 5:/ 输出全部信息System.out.println(“n 全部学生信息nn 学号t 姓名t 数学t 英语tJAVAt计算机t 平均成绩“);rs = stmt.executeQuery(“select * from lxh1 order by math desc“);while (rs.next()int a = rs.getInt(“math“);in
11、t 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 各科平均分nn 数学t 英语tJAVAt 计算机t“);rs = stmt.executeQuery(“
12、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 各科最高分nn 数学t 英语tJAVAt 计算机t“);rs = stmt.executeQuery(“select max(math),max(english),max(java),max
13、(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 各科最低分nn 数学t 英语tJAVAt 计算机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();
