| Name : | "+ ht.get("imgname").toString()+" | "); out.println("|
|---|---|---|
| Color : | "+ht.get("color").toString()+" | "); out.println("|
| Type : | "+ht.get("type").toString()+" | "); out.println("|
| "); out.println(" |
Images
| Name : | "+ ht.get("imgname").toString()+" | "); out.println("|
|---|---|---|
| Color : | "+ht.get("color").toString()+" | "); out.println("|
| Type : | "+ht.get("type").toString()+" | "); out.println("|
| "); out.println(" |
![](\"http://class-server.npac.syr.edu:3768/cps616spring99-docs/cy99xfq/accessaries/bluebackarrow.gif\"){kind=small}
");
out.println("");
out.println("");
out.flush();
return true;
} catch (Exception ex) {
System.err.println("printPageFooter->error display..." );
ex.printStackTrace();
return false;
}
}
/**
*
* This is an important method which uses
* IBM Parser to parse the XML file
* store data values into a vector of hashtables.
*
*/
private Vector getXMLvalues(String fname) {
Vector vec = new Vector();
Hashtable ht = new Hashtable();
try {
FileInputStream is = new FileInputStream(fname);
Parser parser = new Parser(fname);
Document doc = parser.readStream(is);
if(parser.getNumberOfErrors()>0) {
System.exit(1);
}
Node root = doc.getDocumentElement();
String attribute;
for(Node child= root.getFirstChild(); child!=null; child= child.getNextSibling()) {
ht.put("imgname", ((Element)child).getAttribute("imgname"));
ht.put("color", ((Element)child).getAttribute("color"));
ht.put("type", ((Element)child).getAttribute("type"));
ht.put("url", ((Element)child).getAttribute("url"));
vec.addElement(ht.clone());
ht.clear();
}
}catch(Exception e) {
System.out.println(e.getMessage());
System.out.println("Exception inside getXMLvalues...");
}
return vec;
}
/**
*
* Access Database.
*
*/
private String getSQLstring(HttpServletRequest req) {
String tmpstr = "select * from images_table where ";
StringBuffer strbuf = new StringBuffer();
if(!(imgname.trim().equals(""))) {
strbuf.append("upper(imgname)=upper('"+(req.getParameter("imgname")).trim()+"') and ");
}else {
strbuf.append("imgname like '%' and ");
}
if(!(color.trim().equals(""))) {
strbuf.append("upper(color)=upper('"+(req.getParameter("color")).trim()+"') and ");
}else {
strbuf.append("color like '%' and ");
}
if(!(type.trim().equals(""))) {
strbuf.append("upper(type)=upper('"+(req.getParameter("type")).trim()+"') and ");
}else {
strbuf.append("type like '%' and ");
}
if(!(url.trim().equals(""))) {
strbuf.append("upper(url)=upper('"+(req.getParameter("url")).trim()+"');");
}else {
strbuf.append("url like '%'");
}
tmpstr = tmpstr + strbuf.toString();
if(tmpstr == null || tmpstr.equals("") ) return noneLabel;
else return tmpstr;
}
private String get(String key, Hashtable ht){ //Check keyword field, subsitute null field with " "
if(ht.get(key) != null)
return ht.get(key).toString();
else
return " ";
}
public Connection conn;
private void open() { //Open the connection to DB
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection
("jdbc:oracle:thin:@carver.npac.syr.edu:1521:europe", "xjqiu", "judy");
System.out.println("Connection Open");
}
catch (Exception e) { System.err.println("Error connection: " + e);}
}
private int getMaxId(String sql) { //Get the Maxium id from records returned
int i = 0;
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if(rs == null) return -1;
rs.next();
i = rs.getInt("max(id)");
rs.close();
stmt.close();
}catch(Exception e) {
e.printStackTrace(System.out);
return -1;
}
return i;
}
private int executeSQL(String sql) { // Execute Query operation by input sql string
int i = -1;
try {
Statement stmt = conn.createStatement();
stmt.execute(sql);
i = 1;
stmt.close();
}catch(Exception e) {
System.out.println("Exception in updating record");
e.printStackTrace(System.out);
}
return i;
}
private Vector getRecords(String sql) {//Return all records that matches the given name/phone field
Vector vec = new Vector();
Hashtable ht = new Hashtable();
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
ht.put("id",new Integer(rs.getInt("id")));
ht.put("imgname",rs.getString("imgname"));
ht.put("color",rs.getString("color"));
ht.put("type",rs.getString("type"));
ht.put("url",rs.getString("url"));
vec.addElement(ht.clone());
System.out.println("Hashtable inside getRec = "+ht);
ht.clear();
}
rs.close();
stmt.close();
}catch(Exception e) {
System.out.println(e.getMessage());
System.out.println("Exception inside getRecords...");
}
return vec;
}
private void close() { //Close connection to DB
try {
conn.close();
System.out.println("Connection Closed");
}
catch (Exception e) {System.err.println("Error in closing dbase");}
}
}//end of class