Pages

Friday, April 24, 2009

JDBC using JNDI

public class dbConnection {

public void testConnection(){
String sql = "select * from emp"; // query

Connection con = null;
Statement stmt = null;
ResultSet rs = null;

InitialContext cxt = new InitialContext();
DataSource dataSource = (DataSource) cxt.lookup("jdbc/myEmpDB"); // "jdbc/myEmpDB"get JNDI JDBC connection
con = dataSource.getConnection();

// run sql objects
stmt = con.createStatement();
rs = stmt.executeQuery(sql);

while (rs.next()) {
System.out.println("Emp Name : "+rs.getString("employeeName")));
}
}
}

No comments:

Google
 

Java-Struts