database.java

THIS IS A FINANCIAL BANK APPLICATION

		String p_code_reponse=null;
		DATE p_datcrt=null;
		String p_codbqe=null;
		String p_prp_bqecpt=null;
		String p_codagence=null;
		String p_nomprenom=null;
		String p_adrs1=null;
		String p_adrs2=null;
		String p_adrs3=null;
		DATE p_datdebut=null;
		DATE p_datfin =null;
		String p_etat=null;
		CHAR p_etatlsn=null;
		String p_ribport=null;
		CHAR p_vip=null;
		CHAR p_renew=null;
		String p_typcrt=null;
		String p_typecarte=null;
		String p_catsoc=null;
		String p_nordr=null;
		CHAR p_upstat=null;
		String p_titre=null;
		String p_ville=null;
        Connection con = null;
        OracleCallableStatement oraPreStat=null;
        
        try {
        	
            con = new DataBase().connection();
            oraPreStat = (oracle.jdbc.OracleCallableStatement) con.prepareCall("BEGIN :25 := PCRD_BMCE_JAVA_TOOLS.GET_CARD_INFO(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24);END;");
            
            oraPreStat.setString(1,p_card_number);
            oraPreStat.registerOutParameter(25,OracleTypes.INTEGER);
            
            oraPreStat.registerOutParameter(2,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(3,OracleTypes.DATE);
            oraPreStat.registerOutParameter(4,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(5,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(6,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(7,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(8,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(9,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(10,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(11,OracleTypes.DATE);
            oraPreStat.registerOutParameter(12,OracleTypes.DATE);
            oraPreStat.registerOutParameter(13,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(14,OracleTypes.CHAR);
            oraPreStat.registerOutParameter(15,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(16,OracleTypes.CHAR);
            oraPreStat.registerOutParameter(17,OracleTypes.CHAR);
            oraPreStat.registerOutParameter(18,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(19,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(20,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(21,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(22,OracleTypes.CHAR);
            oraPreStat.registerOutParameter(23,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(24,OracleTypes.VARCHAR);
            
            oraPreStat.executeUpdate();
            

            p_code_reponse = (String) oraPreStat.getString(2);
            p_datcrt= oraPreStat.getDATE(3);
            p_codbqe=(String) oraPreStat.getString(4);
            p_prp_bqecpt =(String) oraPreStat.getString(5);
            p_codagence= (String) oraPreStat.getString(6);
            p_nomprenom=(String) oraPreStat.getString(7);
            p_adrs1=(String) oraPreStat.getString(8);
            p_adrs2=(String) oraPreStat.getString(9);
            p_adrs3=(String) oraPreStat.getString(10);
            p_datdebut=oraPreStat.getDATE(11);
            p_datfin =oraPreStat.getDATE(12);
            p_etat =(String) oraPreStat.getString(13);
            p_etatlsn=oraPreStat.getCHAR(14);
            p_ribport=(String) oraPreStat.getString(15);
            p_vip =oraPreStat.getCHAR(16);
            p_renew=oraPreStat.getCHAR(17);
            p_typcrt=(String) oraPreStat.getString(18);
            p_typecarte=(String) oraPreStat.getString(19);
            p_catsoc=(String) oraPreStat.getString(20);
            p_nordr=(String) oraPreStat.getString(21);
            p_upstat=oraPreStat.getCHAR(22);
            p_titre=(String) oraPreStat.getString(23);
            p_ville =(String) oraPreStat.getString(24);
            returnVal =oraPreStat.getInt(25);
            System.out.println("La valeur de retour est: "+returnVal);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            try { con.close(); } 
            catch (Exception e) {
            e.printStackTrace();}}
        /*
         * remplire la liste de retour
         */
/*		List<String> retour=new ArrayList<String>();
		retour.add(""+returnVal);
		retour.add(p_code_reponse);
		retour.add(p_datcrt.toString());
		retour.add(p_codbqe);
		retour.add(p_prp_bqecpt);
		retour.add(p_codagence);
		retour.add(p_nomprenom );
		retour.add(p_adrs1);
		retour.add(p_adrs2);
		retour.add(p_adrs3);
		retour.add(p_datdebut.toString());
		retour.add(p_datfin.toString());
		retour.add(p_etat);
		retour.add(p_etatlsn.toString());
		retour.add(p_ribport);
		retour.add(p_vip.toString());
		retour.add(p_renew.toString());
		retour.add(p_typcrt);
		retour.add(p_typecarte);
		retour.add(p_catsoc);
		retour.add(p_nordr);
		retour.add(p_upstat.toString());
		retour.add(p_titre);
		retour.add(p_ville);
		
		return retour;
		
	}
	
	public static List<String> GET_CARD_LIST(String  p_account_number){
		
		int returnVal=-3;
		String p_code_reponse=null;
		NUMBER p_nombre_carte = null;
		String p_card_number_1=null;
		String p_card_number_2 =null;
		String p_card_number_3=null;
		String p_card_number_4=null;
		String p_card_number_5=null;
		Connection con = null;
        OracleCallableStatement oraPreStat=null;
        
        try {
        	
            con = new DataBase().connection();
            oraPreStat = (oracle.jdbc.OracleCallableStatement) con.prepareCall("BEGIN :1 := PCRD_BMCE_JAVA_TOOLS.GET_CARD_LIST(:2,:3,:4,:5,:6,:7,:8,:9);END;");
            oraPreStat.setString(2,p_account_number);
            oraPreStat.registerOutParameter(1,OracleTypes.INTEGER);
            
            oraPreStat.registerOutParameter(3,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(4,OracleTypes.NUMBER);
            oraPreStat.registerOutParameter(5,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(6,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(7,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(8,OracleTypes.VARCHAR);
            oraPreStat.registerOutParameter(9,OracleTypes.VARCHAR);
            
            oraPreStat.executeUpdate();
            
            p_code_reponse = (String) oraPreStat.getString(3);
            p_nombre_carte=oraPreStat.getNUMBER(4);
            p_card_number_1= (String) oraPreStat.getString(5);
            p_card_number_2= (String) oraPreStat.getString(6);
            p_card_number_3= (String) oraPreStat.getString(7);
            p_card_number_4= (String) oraPreStat.getString(8);
            p_card_number_5= (String) oraPreStat.getString(9);
            returnVal=oraPreStat.getInt(1);
           
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            try { con.close(); } 
            catch (Exception e) {
            e.printStackTrace();}}
        List<String> retour=new ArrayList<String>();
        retour.add(""+returnVal);
        retour.add(""+p_nombre_carte);
        retour.add(p_card_number_1);
        retour.add(p_card_number_2);
        retour.add(p_card_number_3);
        retour.add(p_card_number_4);
        retour.add(p_card_number_5);
        System.out.println("le retour est :"+retour.get(0));
        return retour;
	}
*/
}