slyxtq1314 2015-01-09 02:46 采纳率: 0%
浏览 2965

哪位大神帮忙解决一下Keyboard cannot be resolved的问题

具体代码如下
package Students;
import java.sql.*;
import java.util.ArrayList;
public class Test
{
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();
   }

}

  • 写回答

2条回答 默认 最新

  • WorldMobile 2015-01-09 04:58
    关注

    应该是引入的Jar包不全引起的

    评论

报告相同问题?

悬赏问题

  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能