/*
Connection con = null;
try
{
Context initCtx=new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/Test");
con=ds.getConnection();
Statement stmt = con.createStatement();
String sql_select = "select * from test.news";
ResultSet rs = stmt.executeQuery(sql_select);
while( rs.next() )
{
out.print(rs.getString("title")+"<br>");
}
}
finally
{
if (con != null)
con.close();
}
*/
Connection con = null;
try
{
Context initCtx=new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/Test");
con=ds.getConnection();
Statement stmt = con.createStatement();
String sql_select = "select * from test.news";
ResultSet rs = stmt.executeQuery(sql_select);
while( rs.next() )
{
out.print(rs.getString("title")+"<br>");
}
}
finally
{
if (con != null)
con.close();
}
*/