<%
Connection con;
Statement stmt;
ResultSet rs;
Context initCtx=new InitialContext();
Context envCtx=(Context)initCtx.lookup("java:comp/env");
DataSource ds=(DataSource)envCtx.lookup("jdbc/RD");
con=ds.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("SELECT * FROM BugList");%>
Connection con;
Statement stmt;
ResultSet rs;
Context initCtx=new InitialContext();
Context envCtx=(Context)initCtx.lookup("java:comp/env");
DataSource ds=(DataSource)envCtx.lookup("jdbc/RD");
con=ds.getConnection();
stmt=con.createStatement();
rs=stmt.executeQuery("SELECT * FROM BugList");%>
<sql:query var="orderItems" dataSource="jdbc/RD">
SELECT * FROM BugList where BugNo=?
<sql:param value="${param.BugNo}" />
</sql:query>