/*/////////////////////////////////////////////////////////////////////////
*
* 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 datawindow
private JDataWindowControl dwcActual;
//The powerbuilder library path (where dataobjects are stored)
private final String LIBRERIA = new String("C:\PB7\java.pbl");
//Transaction objetc for database connection
private Transaction trans;
//Contructor
public JDataWindow() {
//New datawindow control
dwcActual = 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
