connectionservice.java

use MVC bean with 3-tiers

package usermanager.communication.database;

import java.sql.*;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class ConnectionService {
	public static Connection getConnection() throws NamingException, SQLException {
		DataSource ds = (DataSource) new InitialContext().lookup("jdbc/j2ee_MyDatasource");
		Connection con = ds.getConnection();
		return con;
	}
}