public List<cheque> retriveChequeinfo() throws SQLException{
        
        List<cheque> chequeInfo=new ArrayList();
        try{
            databaseConnector=myConnector.getConnection();
            stmnt=(Statement) databaseConnector.createStatement();
            
            SQLQuery="SELECT * FROM familydoctor.cheque";
            dataSet=stmnt.executeQuery(SQLQuery);
          
            while(dataSet.next()){
                chequeID=dataSet.getInt("chequeID");
                bankName=dataSet.getString("bankName");
                inputDate=dataSet.getString("chequeDate");
                chequeAmount=dataSet.getFloat("chequeAmount");
                
                tempCheque=new cheque(chequeID,bankName, inputDate, chequeAmount);
                
                chequeInfo.add(tempCheque);
            }
        }
        
        catch(SQLException e){
            System.out.println(e.getMessage());
        }
        
        finally{
            if(stmnt!=null)
                stmnt.close();
            if(databaseConnector!=null)
                databaseConnector.close();
        }
        
        return chequeInfo;
        }