stu.java

北大青鸟的内部测试题（感兴趣的一定要看看哦 ）

package studenttext;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class stu {
    public stu() {
    }
   static  public Connection getConnection(){
        Connection conn = null;
        String url = "jdbc:odbc:accp";
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            try {
                conn = DriverManager.getConnection(url);
//                while(conn!=null){
//                  System.out.println("连接成功...");
//                }
            } catch (SQLException ex1) {
                ex1.printStackTrace();
            }
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }

      return conn;
    }
   static public boolean check_classnumber_stunuber_javatext(String classnumber,String stunumber,int javatext){
      String sql1 = "select * from student where classnumber='"
                    +classnumber+"' and stunumber='"+stunumber+"' and javatext ='"+javatext+"'";
    Statement stm = null;
    try {
        stm = stu.getConnection().createStatement();
    } catch (SQLException ex) {
        ex.printStackTrace();
    }
    try {
        ResultSet rs = stm.executeQuery(sql1);
        while(rs.next()){
         return true;
        }
    } catch (SQLException ex1) {
        ex1.printStackTrace();
    }
    return false;
    }
    public static void main(String args[]){

    }
}