HP OSMS Blueprint: Database Server on HP ProLiant Servers with MySQL and SLES10

Context localCtx = (Context) initCtx.lookup("java:comp/env");
myDataSource = (DataSource)localCtx.lookup(dsName);
con = myDataSource.getConnection();
preStmt = con.prepareStatement("INSERT INTO employee(depno,name,cardnumber) values(?,?,?)");
preStmt.setInt(1,99);
preStmt.setString(2,"Peter");
preStmt.setInt(3,99999);
preStmt.executeUpdate();
}catch (SQLException s){
out.println("<h1>SQL Error:"+s.getMessage()+"</h1>");
}finally{
try{
preStmt.close();
con.close();
}catch(Exception e){
out.println("Can NOT close db connection: "+e.getMessage());
}finally{
preStmt=null;
con=null;
}
}
%>
<%
//read database
try{
initCtx = new InitialContext();
Context localCtx = (Context) initCtx.lookup("java:comp/env");
myDataSource = (DataSource)localCtx.lookup(dsName);
con = myDataSource.getConnection();
preStmt = con.prepareStatement("SELECT id,depno,name,cardnumber FROM employee LIMIT ?");
preStmt.setInt(1,100);
searchResult = preStmt.executeQuery();
ResultSetMetaData sqlRstMetaData = searchResult.getMetaData();
int numColumns = sqlRstMetaData.getColumnCount();
for (int i=0;i<numColumns ;i++ ){
tableHead.append("<th><b>").append(sqlRstMetaData.getColumnName(i+1)).append("</b></th>");
}
while (searchResult.next()){
tableData.append("<tr>");
for (int i=0;i<numColumns ;i++ ){
String data = searchResult.getString(i+1);
data = (data!=null)?data:"" ;
data = (data.length()>0)?data:"_";
tableData.append("<td>"+data+"</td>") ;
}
tableData.append("</tr>\n");
}
}catch (SQLException s){
out.println("<h1>SQL Error:"+s.getMessage()+"</h1>");
}finally{
try{
preStmt.close();
con.close();
}catch(Exception e){
out.println("Can NOT close db connection: "+e.getMessage());
}finally{
preStmt=null;
con=null;
}
}
%>
<hr/>
<b>List of Employee Records</b>
<table border="1" cellspacing="0" cellpadding="4">
<tr><%=tableHead.toString()%></tr>
<tr><%=tableData.toString()%></tr>
</table>
</body>
</html>
34