seach1.java

利用JAVA和Access做成一个学生信息管理系统

package com.yanjun;
import java.sql.*;
import java.util.*;
public class seach1
{
  public static ArrayList getTable(String sname)//管理员信息
  {
     ArrayList list = new ArrayList();   
     String URL="jdbc:odbc:yanjun";
     int time;
     String tmpstr="";
     try{
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection con=DriverManager.getConnection(URL);
       DatabaseMetaData dma=con.getMetaData();
       Statement stmt=con.createStatement();
       String sql="select class.cname,class.time from class , SC where SC.sname='"+sname+"'  and SC.cn=class.cname";
       ResultSet rs=stmt.executeQuery(sql);
       while(rs.next()){
       tmpstr=rs.getString(1);
       time=rs.getInt(2);
       list.add(new classes(tmpstr,time));
       }
       rs.close();
       con.close();
  }
  catch(SQLException ex)
  {
	  return null;
  }
  catch(java.lang.Exception ex)
  {
	  return null;
   }
  return list;
}

public static ArrayList getTable2(String sname)
  {
     ArrayList list = new ArrayList();   
     String URL="jdbc:odbc:yanjun";
     int time;
     String tmpstr="";
     try{
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection con=DriverManager.getConnection(URL);
       DatabaseMetaData dma=con.getMetaData();
       Statement stmt=con.createStatement();
       String sql="select cname,time from class where teacher='"+sname+"'";
       ResultSet rs=stmt.executeQuery(sql);
       while(rs.next()){
       tmpstr=rs.getString(1);
       time=rs.getInt(2);
       list.add(new classes(tmpstr,time));
       }
       rs.close();
       con.close();
  }
  catch(SQLException ex)
  {
	  return null;
  }
  catch(java.lang.Exception ex)
  {
	  return null;
   }
  return list;
}

}