package dbms;
import java.sql.*;
import entity.*;
public class Verification {

	
	//驗證管理員合法性
	 public static boolean isLegal(Admin admin) throws Exception{
		
		
		 boolean isRight =false;
		 String str=new String("select * from administrator where adminNo=? and adminPass=?"); 
		 Connection conn =DBConnection.createConn();
		 PreparedStatement pstmt=conn.prepareStatement(str);
		 
		 pstmt.setString(1, admin.getNo());
		 pstmt.setString(2, admin.getPassword());
		 
		 ResultSet rs=pstmt.executeQuery();
		  if(rs.next()){
			  
			  isRight=true;
			  admin.setName(rs.getString("adminName"));
		}
		  
		  rs.close();
		  pstmt.close();
		  conn.close();
		  return isRight;
		
		
		 
	}
//	驗證教師合法性
	 public static boolean   isLegal(Teacher teacher)throws Exception{
			
		 boolean isRight =false;
		 String str=new String("select * from teacher where teachNo=? and teachPassword=?"); 
		 Connection conn =DBConnection.createConn();
		 PreparedStatement pstmt=conn.prepareStatement(str);
		 
		 pstmt.setString(1, teacher.getNo());
		 pstmt.setString(2, teacher.getPassword());
		 
		 ResultSet rs=pstmt.executeQuery();
		  if(rs.next()){
			  
			  isRight=true;
			  teacher.setName(rs.getString("teachName"));
			  teacher.setDepartmentNo(rs.getString("departmentNo"));
			  teacher.setAddr(rs.getString("teachAddr"));
			  teacher.setPhone(rs.getString("teachPhone"));
			  teacher.setPhotoName(rs.getString("teachPhotoName"));
		}
		  rs.close();
		  pstmt.close();
		  conn.close();
		  
		  return isRight;
	}
//	驗證學生合法性
	 public static boolean   isLegal(Student std)throws Exception{
			
		 boolean isRight =false;
		 String str=new String("select * from student where stuUnifiedNo=? and  stdPass=?"); 
		 Connection conn =DBConnection.createConn();
		 PreparedStatement pstmt=conn.prepareStatement(str);
		 
		 pstmt.setString(1, std.getUnifiedNo());
		 pstmt.setString(2, std.getPassword());
		 
		 ResultSet rs=pstmt.executeQuery();
		  if(rs.next()){
			  
			     isRight=true;
			  std.setName(rs.getString("stdName"));
			  std.setClassNo(rs.getString("ClassNo"));
			  std.setNo(rs.getString("stuNo"));
			  std.setSex(rs.getString("stdSex"));
			  std.setAddr(rs.getString("stdAddr"));
			  std.setPhone(rs.getString("stdPhone"));
			  std.setGrade(rs.getString("stdGrade"));
			  std.setAntecedent(rs.getString("stdAntecedent"));
			  std.setEnterTime(rs.getString("stdEnterTime"));
			  std.setPhotoName(rs.getString("photoName"));
			  std.setJcDescription(rs.getString("JCDescription"));
			  std.setXjInfor(rs.getString("XJInfor"));
			  std.setWhereToGo(rs.getString("whereToGo"));
		}
		  rs.close();
		  pstmt.close();
		  conn.close();
		  
		  return isRight;
	}
}