mapbean.java

THIS IS A FINANCIAL BANK APPLICATION

package Pcrd.Subscription.DB;

import java.sql.Connection;
import java.sql.SQLException;

import javax.annotation.Resource;
import javax.naming.NamingException;
import javax.sql.DataSource;

import Pcrd.Subscription.DB.ProcessManager;
import Pcrd.Subscription.DB.ProcessManagerBean;

public class MapBean {

	
	@Resource(name="java:/SubDS", mappedName="java:/SubDS", type=DataSource.class)

	private DataSource ds;



	     public Connection getConnection() {

	           try {

	                 Connection conn = ds.getConnection();

	                 return conn;                 

	           } catch (SQLException ex) {

	                 ex.printStackTrace();

	           }return null;

	     }
	     public String tests(){
	    	
	    	 ProcessManager b=new ProcessManagerBean();
	 		//b.GET_ACCOUNT_INFO("12457");
	 		try {
				b.GET_CARD_INFO("carte23");
			} catch (NamingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	    	
	    	 return("");
	     }
}