Java Reference
In-Depth Information
}
public void setTableName(String tableName){
this.tableName = tableName;
}
public void setSQLQuery(String SQLQuery){
this.SQLQuery = SQLQuery;
}
public void processDocument() throws XbeansException{
try{
document = new DocumentImpl();
if(databaseName.length()>0&&tableName.length()>0){
String d = databaseName.toUpperCase();
String t = tableName.toUpperCase();
Element root = (Element)document.createElement(t);
document.appendChild (root);
root.setAttribute("DBNAME",d);
appendDataNodes();
}
else{
throw new XbeansException("SQLQueryBean",
null,"DBName/TableName Undefined",null);
}
DOMEvent domEvt = new DOMEvent(this,document);
DOMListener.documentReady(domEvt);
}
catch (Exception e){
e.printStackTrace();
}
}
public void appendDataNodes() {
String url = "jdbc:odbc:"+databaseName;
if(SQLQuery==null)SQLQuery="SELECT * FROM "+tableName;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"user","pwd");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQLQuery);
Search WWH ::




Custom Search