The source code of PantoOraSecure.java:
<![CDATA[
import java.io.* ;
import javax.servlet.* ;
import javax.servlet.http.* ;
import java.sql.* ; // for JDBC
public class PantoOraSecure extends HttpServlet {
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException,
ServletException {
doGet(request,response) ;
}
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException,
ServletException {
response.setContentType("text/html") ;
PrintWriter out = response.getWriter() ;
Furniture.doHeader(out, "List of Pantomimes") ;
out.println("This servlet contacts the Oracle instance"
+" \"CS\" using a username and password from a secure file"
+" and extracts a list of pantomimes"
+" performed in Stirling.<p>") ;
try {
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver) ;
// out.println("Driver loaded.. <br>") ;
}
catch(Exception e) {
out.println("Failed to load driver "+ e.getMessage()) ;
Furniture.doFooter(out) ;
return;
}
String userPass;
try {
BufferedReader userPassIn = new BufferedReader(new FileReader("/home/sbj/servlet/WEB-INF/csoracleauth"));
userPass = userPassIn.readLine(); // Get Oracle username/password string from external file
}
catch (IOException e) {
out.println("Failed to read authorization file "+ e.getMessage()) ;
Furniture.doFooter(out) ;
return;
}
Connection con = null;
try {
String url = "jdbc:oracle:thin:"
+ userPass
+ "@oracle.cs.stir.ac.uk:1521:cs" ;
con = DriverManager.getConnection(url) ;
// out.println("Got connection...<br>");
}
catch(SQLException e) {
out.println("SQLException: " + e.getMessage()) ;
Furniture.doFooter(out) ;
return;
}
try {
Statement stmt = con.createStatement();
String query = "SELECT DISTINCT Season, Title FROM Panto" ;
out.println("The query is:<br><tt>"
+ query + "</tt><p>") ;
ResultSet rs = stmt.executeQuery(query);
int nrows = 0 ;
while (rs.next()) {
nrows++ ;
String year = rs.getString(1) ;
String panto = rs.getString(2) ;
out.println("In " + year + " the panto was " + panto + "<br>") ;
}
out.println("<br>(" + nrows + " pantomimes listed)<br>") ;
stmt.close() ;
}
catch(SQLException e) {
out.println("SQLException: " + e.getMessage()) ;
}
try {
con.close() ;
}
catch(SQLException e) {
out.println("SQLException: " + e.getMessage()) ;
}
Furniture.doFooter(out) ;
} // doGet
} // class
]]>