link.java

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

//确认用户的程序
package com.yanjun; 
import java.net.URL.*;
import java.sql.*;
import javax.swing.*; 
import java.awt.*;
import java.awt.event.*;
import javax.swing.event.*;

public class link
{
  public static boolean check(String sname,String password)//管理员信息
  {
  	String URL="jdbc:odbc:yanjun";
  	try{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection(URL);
        DatabaseMetaData dma=con.getMetaData();
        Statement stmt=con.createStatement();
        ResultSet rs=stmt.executeQuery("select password from Admin where" +"(ID='"+sname+"')");
        int i;
        String tmpstr="";
        ResultSetMetaData rsmd=rs.getMetaData();
        int numCols=rsmd.getColumnCount();
       while(rs.next()){
       for(i=1;i<=numCols;i++){
       tmpstr=rs.getString(i);
       if(tmpstr.equals(password))
       {
        rs.close();
        con.close();
        return true;
       }
       }
	   System.out.println("");
       }
   rs.close();
   con.close();
   return false;
  }
  catch(SQLException ex)
  {
  	   return false;
  }
  catch(java.lang.Exception ex){return false;}//学生信息
  }
  public static boolean check1(String sname,String password)
  {
  	String URL="jdbc:odbc:yanjun";
  	try{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection(URL);
        DatabaseMetaData dma=con.getMetaData();
        Statement stmt=con.createStatement();
        ResultSet rs=stmt.executeQuery("select password from student where" +"(ID='"+sname+"')");
        int i;
        String tmpstr="";
        ResultSetMetaData rsmd=rs.getMetaData();
        int numCols=rsmd.getColumnCount();
       while(rs.next()){
       for(i=1;i<=numCols;i++){
       tmpstr=rs.getString(i);
       if(tmpstr.equals(password))
       {
        rs.close();
        con.close();
        return true;
       }
       }
	   System.out.println("");
       }
   rs.close();
   con.close();
   return false;
  }
  catch(SQLException ex)
  {
  	   return false;
  }
  catch(java.lang.Exception ex){return false;}
  }
  public static boolean check2(String sname,String password)//教师信息
  {
  	String URL="jdbc:odbc:yanjun";
  	try{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection(URL);
        DatabaseMetaData dma=con.getMetaData();
        Statement stmt=con.createStatement();
        ResultSet rs=stmt.executeQuery("select password from teacher where" +"(ID='"+sname+"')");
        int i;
        String tmpstr="";
        ResultSetMetaData rsmd=rs.getMetaData();
        int numCols=rsmd.getColumnCount();
       while(rs.next()){
       for(i=1;i<=numCols;i++){
       tmpstr=rs.getString(i);
       if(tmpstr.equals(password))
       {
        rs.close();
        con.close();
        return true;
       }
       }
	   System.out.println("");
       }
   rs.close();
   con.close();
   return false;
  }
  catch(SQLException ex)
  {
  	   return false;
  }
  catch(java.lang.Exception ex){return false;}
  }
}