Source code: com/sonoma/database/HTMLReport.java
1 /*
2 * HTMLReport.java
3 *
4 * Created on January 19, 2002, 2:07 PM
5 */
6
7 package com.sonoma.database;
8 import java.sql.ResultSet;
9 import java.sql.ResultSetMetaData;
10 import java.sql.Statement;
11 /**
12 *
13 * @author Administrator
14 * @version
15 */
16 public class HTMLReport extends Object {
17
18 /** Creates new HTMLReport */
19 public HTMLReport() {
20 }
21 public String getReportHTML(String ConnectionString,String SqlStatement, String JDBCDriver){
22 connection mc;
23 ResultSet rs;
24 ResultSetMetaData rsm;
25 StringBuffer sbOut = new StringBuffer();
26 connectionFactory cf = new connectionFactory();
27 if (ConnectionString.length() < 1){
28 ConnectionString = "jdbc:mysql://myhost3:3306/handict?user=royh&password=hoobie";
29 }
30 mc = cf.createConnection(ConnectionString, JDBCDriver);
31 try{
32 rs = getRS(mc,SqlStatement);
33 rsm = rs.getMetaData();
34 int i = 0;
35 while (rs.next()){
36 sbOut.append("<tr>");
37 for(i=1;i<=rsm.getColumnCount();i++){
38 sbOut.append("<td>");
39 sbOut.append((String) rs.getString(i));
40 sbOut.append("</td>");
41 }
42 sbOut.append("</tr>");
43 }
44 rs.close();
45 mc.con.close();
46 return sbOut.toString();
47 }catch(Exception e){
48 e.printStackTrace();
49 }
50 try{
51 mc.con.close();
52 return "";
53 }catch(Exception e){
54 return "";
55 }
56 }
57
58 public String getReportXML(String ConnectionString,String SqlStatement, String JDBCDriver){
59 connection mc;
60 ResultSet rs;
61 ResultSetMetaData rsm;
62 StringBuffer sbOut = new StringBuffer();
63 connectionFactory cf = new connectionFactory();
64 if (ConnectionString.length() < 1){
65 ConnectionString = "jdbc:mysql://myhost3:3306/handict?user=royh&password=hoobie";
66 }
67 mc = cf.createConnection(ConnectionString, JDBCDriver);
68 try{
69 rs = getRS(mc,SqlStatement);
70 rsm = rs.getMetaData();
71 int i = 0;
72 String sColName = "";
73 sbOut.append("<REPORT>");
74 while (rs.next()){
75 sbOut.append("<DATAROW>");
76 for(i=1;i<=rsm.getColumnCount();i++){
77 sColName = rsm.getColumnName(i);
78 sbOut.append("<" + sColName + ">");
79 sbOut.append((String) rs.getString(i));
80 sbOut.append("</" + sColName + ">");
81 }
82 sbOut.append("</DATAROW>");
83 }
84 sbOut.append("</REPORT>");
85 rs.close();
86 mc.con.close();
87 return sbOut.toString();
88 }catch(Exception e){
89 e.printStackTrace();
90 }
91 try{
92 mc.con.close();
93 return "";
94 }catch(Exception e){
95 return "";
96 }
97 }
98
99 private ResultSet getRS(connection cnn, String sqlStatement) throws java.sql.SQLException{
100 Statement st;
101 ResultSet rs;
102 st = cnn.con.createStatement();
103 rs = st.executeQuery(sqlStatement);
104 return rs;
105
106 }
107
108 }