《轻量级J2EE企业应用实战 Struts+Spring+Hibernate整合开发》ISO

package lee; import java.io.IOException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import javax.naming.InitialContext; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.sql.DataSource; import javax.sql.XADataSource; import javax.transaction.UserTransaction; import java.io.*; import java.util.*; /** * @author yeeku.H.lee kongyeeku@163.com * @version 1.0 * <br>Copyright (C), 2005-2008, yeeku.H.Lee * <br>This program is protected by copyright laws. * <br>Program Name: * <br>Date: */ public class TestServlet extends HttpServlet { InitialContext ic; public void init(ServletConfig config) throws ServletException { super.init(config); try { ic = new InitialContext(); } catch (Exception e) { throw new ServletException(e); } } public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintStream out = new PrintStream(response.getOutputStream()); try { Enumeration l = ic.list(""); while (l.hasMoreElements() ) { System.out.println(l.nextElement()); } System.out.println(ic.lookup("wiggle")); System.out.println(ic.lookup("woggle")); DataSource ds = (DataSource)ic.lookup("jdbc/mydatasource"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from news"); while(rs.next()) { out.println(rs.getString(2)); } } catch (Exception e) { e.printStackTrace(); } } }