thoerup/traininfoservice/DBConnection.java

package dk.thoerup.traininfoservice;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class DBConnection {
        public static Connection getConnection() throws SQLException{
                try {
                        Context ctx = new InitialContext();
                        DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/android");
                        return ds.getConnection();
                } catch (NamingException e) {
                        throw new SQLException("invalid data source", e);
                }
        }
}
1	package dk.thoerup.traininfoservice;
2
3	import java.sql.Connection;
4	import java.sql.SQLException;
5
6	import javax.naming.Context;
7	import javax.naming.InitialContext;
8	import javax.naming.NamingException;
9	import javax.sql.DataSource;
10
11	public class DBConnection {
12	public static Connection getConnection() throws SQLException{
13	try {
14	Context ctx = new InitialContext();
15	DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/android");
16	return ds.getConnection();
17	} catch (NamingException e) {
18	throw new SQLException("invalid data source", e);
19	}
20	}
21	}