datawindow java[1]

/*/////////////////////////////////////////////////////////////////////////
 *
 *  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 leftbutt