/* Sample basic Servlet/Oracle ,http://www.exzilla.net/, Jan3,2000 */ // package myPackage; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; public class HowToOracleServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("Text/html"); PrintWriter out = response.getWriter(); out.println(""); out.println("Simple Servlet/Oracle Query Example "); out.println(""); out.println("
"); out.println("Employees"); out.println("

"); Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:fuju", "scott", "tiger"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM scott.Emp"); //Print start of table and column headers out.println(""); out.println(""); out.println(" "); //Loop through results of query. while(rs.next()) { out.println(""); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(" "); out.println(""); } out.println("
IDNAMESURNAMESALARYSTARTDATE
" + rs.getString("EMPNO") + "" + rs.getString("ENAME") + "" + rs.getString("JOB") + "" + rs.getInt("SAL") + "" + rs.getString("HIREDATE") + "
"); } catch(SQLException e) { out.println("SQLException: " + e.getMessage() + "
"); while((e = e.getNextException()) != null) out.println(e.getMessage() + "
"); } catch(ClassNotFoundException e) { out.println("ClassNotFoundException: " + e.getMessage() + "
"); } finally { //Clean up resources, close the connection. if(conn != null) { try { conn.close(); } catch (Exception ignored) {} } } out.println("
"); out.println(""); out.println(""); } }