import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Selection extends HttpServlet
{
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("Text/html");
PrintWriter out = response.getWriter();
//creates the html page with Simple Oracle Example title and Student heading
out.println("");
out.println("Simple Oracle Example");
out.println("");
out.println("");
out.println("Student");
out.println("
");
Connection conn = null;
try
{
//load the oracle driver
Class.forName("oracle.jdbc.driver.OracleDriver");//Oracle driver
//connect to the database
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:databasename","sqlpluslogin","sqlpluspassword");
//create a statement object
Statement stmt = conn.createStatement();
//execute select statement(to get records from the table student)
ResultSet rs = stmt.executeQuery("SELECT * FROM Student");
//Print start of table and column headers
out.println("");
out.println("| ID | NAME |
|---|
");
//Loop through results of query.
while(rs.next())
{
out.println("");
out.println("| " + rs.getString(1) + " | ");
out.println("" + rs.getString(2) + " | ");
out.println("
");
}
out.println("
");
}
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("");
}
}