import com.openbravo.data.loader.DataResultSet; //导入依赖的package包/类
public boolean executeSentence(BaseSentence sent, Object params) {
    
    CardLayout cl = (CardLayout)(getLayout());
    
    try {
        DataResultSet rs = sent.openExec(params);          
        
        if (rs.updateCount() < 0) {
            cl.show(this, "resultset"); 
            
            DataField [] df = rs.getDataField();  

            SQLTableModel sqlresult = new SQLTableModel(df); 

            while (rs.next()) {
                sqlresult.addRow(rs);
            }            
            rs.close();

            sent.closeExec();

            m_jTableResult.setModel(sqlresult);
        } else {
            cl.show(this, "updatecount"); 
            m_txtResulltText.setText("Update count: " + Integer.toString(rs.updateCount()));
            m_txtResulltText.setCaretPosition(0);
       }
        return true;
        
    } catch (BasicException e) {
        cl.show(this, "updatecount"); 
        StringWriter w =  new StringWriter();                    
        e.printStackTrace(new PrintWriter(w));                   
        m_txtResulltText.setText(w.toString());
        m_txtResulltText.setCaretPosition(0);
        // e.printStackTrace();
        return false;
    }
}
 

import com.openbravo.data.loader.DataResultSet; //导入依赖的package包/类
/** Creates new form JPanelSQL */
public JPanelSQL(AppView oApp) {
    m_App = oApp;        
    
    m_aHistory = new ArrayList();
    m_aHistory.add("");
    m_iHistoryIndex = 0;
   
    initComponents();
    
    m_iResultIndex = 0;
    addResultTab();
    
    
    DefaultMutableTreeNode rootnode =  new DefaultMutableTreeNode(AppLocal.APP_NAME);
    
    
    SQLDatabase db = new SQLDatabase(AppLocal.APP_NAME + " - Database.");
    
    try {
        BaseSentence sent = new MetaSentence(m_App.getSession(), "getTables"
                , new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})
                , new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
        DataResultSet rs = sent.openExec( new Object[] {null, null});          
        while (rs.next()) {
            Object[] aTable = (Object[]) rs.getCurrent();
            db.addTable((String) aTable[2]);
        }            
        rs.close();
        sent.closeExec();
        
        sent = new MetaSentence(m_App.getSession(), "getColumns"
                , new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING})
                , new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
        rs = sent.openExec(new Object[] {null, null, null}); 
        while (rs.next()) {
            Object[] aColumn = (Object[]) rs.getCurrent();
            SQLTable t = db.getTable((String) aColumn[2]);
            if (t != null) {
                t.addColumn((String) aColumn[3]);
            }
        }            
        rs.close();
        sent.closeExec();
        
    } catch (BasicException e) {
        // e.printStackTrace();
    }        
   

    DefaultTreeModel tm = new DefaultTreeModel(db);
    
    m_jTreeDB.setModel(tm);
    
    statusButtons();
}