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:
Post a Comment