查询.java

学生管理系统

package guanlixitong;

import java.sql.*;

public class 查询 {
  Student stu = new Student();
  public 查询() {}
 boolean bool = false;
  public boolean search(int number) {

    String str = "jdbc:odbc:yangAcess";
    Connection con;

    String sSelect = "select * from yang1 ";
    ResultSet rs;
    ResultSetMetaData rsmd;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection(str);
      Statement stmt = con.createStatement();
      rs = stmt.executeQuery(sSelect);
      rsmd = rs.getMetaData();
      int i = rsmd.getColumnCount();
      while (rs.next()) {
        stu.姓名 = rs.getString("姓名");
        stu.性别 = rs.getString("性别");
        stu.成绩1 = rs.getInt("成绩1");
        stu.成绩2 = rs.getInt("成绩2");
        stu.成绩3 = rs.getInt("成绩3");
        stu.成绩4 = rs.getInt("成绩4");
        stu.成绩5 = rs.getInt("成绩5");

        stu.学号 = rs.getInt("学号");
        stu.平均成绩=(stu.成绩1+stu.成绩2+stu.成绩3+stu.成绩4+stu.成绩5)/5.0;
        if (stu.学号 == number) {

          bool = true;
          break;
        }
      }
      con.close();
      stmt.close();
    }
    catch (Exception e) {}
    return bool;
  }
}