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 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){  	
  		//Aclearcase/" target="_blank" >ccept 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