datawindow java
datawindow java /*///////////////////////////////////////////////////////////////////////// * * This is a basic java datawindow example. * I want explaine you how to use a datawindow control for java development. * (its so basic...) * *Autor: * David Arcia 09-09-2002 (david.arcia@softhome.net) *//////////////////////////////////////////////////////////////////////////*/import javax.swing.JOptionPane;import javax.swing.JFrame;import powersoft.datawindow.JDataWindowControl;import powersoft.datawindow.Blob;import powersoft.powerj.db.java_sql.Transaction;public class JDataWindow extends JFrame{//The datawindowprivate JDataWindowControl dwcActual;//The powerbuilder library path (where dataobjects are stored)private final String LIBRERIA = new String("C:\PB7\java.pbl");//Transaction objetc for database connectionprivate Transaction trans; //Contructor public JDataWindow() { //New datawindow controldwcActual = getDataWindow("dw_products",true,true,true);//Not null ?if(dwcActual == null) return; }//ends method/******************************************************************************** * CONNECTION USING POWERSOFT TRANSACTION OBJECT (as SQLCA in PowerBuilder) ********************************************************************************/ //This method connect with database (by example, a oracle database) public boolean setConnect(){ trans = new Transaction(); trans.registerDriver( "oracle.jdbc.driver.OracleDriver" ); trans.setDataSource("jdbc:oracle:thin:@192.168.22.10:1521:FALCON"); trans.setUserID( "rjimenez" ); trans.setPassword( "defalcon" ); //Error ? if(!trans.connect()){ System.err.println("Connection failed."); return false; } return true; }//ends method /******************************************************************************** * JAVA DATAWINDOW'S CREATION ********************************************************************************/ //Create a datawindow public JDataWindowControl getDataWindow(String dataobject){ JDataWindowControl dwc = new JDataWindowControl(); //Assign a datawindow library dwc.setSourceFileName(LIBRERIA); //Assign a datawindow object to the dw control dwc.setDataWindowObjectName(dataobject); //Some properties... dwc.setVScroll( true ); dwc.insertRow(0); //Assign the transaction object to dw dwc.setTransaction(trans); //return object created return dwc; }//ends method //Optional...Method for row selection public void selectRow(int row){ if(row > 0){dwcActual.selectRow(0,false);dwcActual.selectRow(row,true);dwcActual.scrollToRow(row);dwcActual.setRow(row);} }//ends method //Optional... for to make a datawindow editable or not public void setEditable(JDataWindowControl dwc, boolean editar){ //Accept text dwcActual.acceptText(); //get column number int cols = Integer.parseInt(dwc.describe("Datawindow.column.count")); ////////////////////////////////////////////////////////////////////////// String indicador = (editar) ? "1" : "0";////////////////////////////////////////////////////////////////////////// editable = indicador == "1"; //Change the editable porperty for(int cont=1; cont <= cols; cont++){ dwc.modify("#" + cont + ".TabSequence = " + indicador); } }//ends method //Optional... Insert new row to datawindows end. public void getNewRow(){ int row=dwcActual.insertRow(0); selectRow(row); }//final de metodo //Optional... Delete a datawindow row public void deleteRow(){int boton=JOptionPane.showConfirmDialog(null,"Delete actual row ?", "Deleting", JOptionPane.YES_NO_OPTION);if(boton == 0) dwcActual.deleteRow(dwcActual.getRow()); }//Fin de metodo /********************************************************************************* THIS ARE THE DATAWINDOW'S EVENT MANAGERS** The events that support datawindow are clasificated in differents interfaces* according it function.*********************************************************************************Interfaces:MouseListener,FocusListener,DatabaseListener,EditChangedListener,ItemListener,PrintListener,RowChangeListener, etc...Datawindow events:public void leftButtonDoubleClick (MouseEvent event){}public void leftButtonClick (MouseEvent event){}public void leftButtonDown ( MouseEvent event){}public void leftButtonUp ( MouseEvent event){}public void middleButtonClick ( MouseEvent event){}public void middleButtonDoubleClick ( MouseEvent event){}public void mouseMove ( MouseEvent event){}public void rightButtonClick ( MouseEvent event){}public void rightButtonDoubleClick ( MouseEvent event){}public void rightButtonDown ( MouseEvent event){}public void rightButtonUp ( MouseEvent event){}public void getFocus ( FocusEvent event){}public void loseFocus ( FocusEvent event){}public void DBError ( DatabaseEvent event){}public void SQLPreview ( DatabaseEvent event){}public void editChanged ( EditChangedEvent event){}public void itemChanged ( ItemEvent event){}public void itemChangeAccepted ( ItemEvent event){}public void itemError ( ItemEvent event){}public void itemFocusChanged ( ItemEvent event){} public void printEnding ( PrintEvent event){}public void printMarginChanging ( PrintEvent event){}public void printPageStarting ( PrintEvent event){} public void printStarting ( PrintEvent event){}public void retrieveEnd ( RetrieveEvent event){}public void retrieveRow ( RetrieveEvent event){}public void retrieveStart ( RetrieveEvent event){} public void rowChanged ( RowChangeEvent event){}public void rowChanging ( RowChangeEvent event){}etc...********************************************************************************/}//ends classe
