xref: /AOO41X/main/odk/examples/DevelopersGuide/Forms/GridFieldValidator.java (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  *  The Contents of this file are made available subject to the terms of
4*cdf0e10cSrcweir  *  the BSD license.
5*cdf0e10cSrcweir  *
6*cdf0e10cSrcweir  *  Copyright 2000, 2010 Oracle and/or its affiliates.
7*cdf0e10cSrcweir  *  All rights reserved.
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  *  Redistribution and use in source and binary forms, with or without
10*cdf0e10cSrcweir  *  modification, are permitted provided that the following conditions
11*cdf0e10cSrcweir  *  are met:
12*cdf0e10cSrcweir  *  1. Redistributions of source code must retain the above copyright
13*cdf0e10cSrcweir  *     notice, this list of conditions and the following disclaimer.
14*cdf0e10cSrcweir  *  2. Redistributions in binary form must reproduce the above copyright
15*cdf0e10cSrcweir  *     notice, this list of conditions and the following disclaimer in the
16*cdf0e10cSrcweir  *     documentation and/or other materials provided with the distribution.
17*cdf0e10cSrcweir  *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
18*cdf0e10cSrcweir  *     contributors may be used to endorse or promote products derived
19*cdf0e10cSrcweir  *     from this software without specific prior written permission.
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
22*cdf0e10cSrcweir  *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
23*cdf0e10cSrcweir  *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
24*cdf0e10cSrcweir  *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
25*cdf0e10cSrcweir  *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
26*cdf0e10cSrcweir  *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
27*cdf0e10cSrcweir  *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
28*cdf0e10cSrcweir  *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
29*cdf0e10cSrcweir  *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
30*cdf0e10cSrcweir  *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
31*cdf0e10cSrcweir  *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
32*cdf0e10cSrcweir  *
33*cdf0e10cSrcweir  *************************************************************************/
34*cdf0e10cSrcweir 
35*cdf0e10cSrcweir /**************************************************************************/
36*cdf0e10cSrcweir import com.sun.star.uno.*;
37*cdf0e10cSrcweir import com.sun.star.beans.*;
38*cdf0e10cSrcweir import com.sun.star.form.*;
39*cdf0e10cSrcweir import com.sun.star.lang.*;
40*cdf0e10cSrcweir import com.sun.star.sdb.*;
41*cdf0e10cSrcweir import com.sun.star.sdbc.*;
42*cdf0e10cSrcweir import com.sun.star.sdbcx.*;
43*cdf0e10cSrcweir import com.sun.star.container.*;
44*cdf0e10cSrcweir import com.sun.star.awt.*;
45*cdf0e10cSrcweir import com.sun.star.task.*;
46*cdf0e10cSrcweir 
47*cdf0e10cSrcweir /**************************************************************************/
48*cdf0e10cSrcweir /** helper class for validating a grid field before it is updated
49*cdf0e10cSrcweir 
50*cdf0e10cSrcweir 	<p>Actually, the mechanism for validating the field is not restricted to
51*cdf0e10cSrcweir 	grid control fields. Instead, it can be used for any bound controls.</p>
52*cdf0e10cSrcweir */
53*cdf0e10cSrcweir class GridFieldValidator implements XUpdateListener
54*cdf0e10cSrcweir {
55*cdf0e10cSrcweir 	private DocumentHelper		m_aDocument;
56*cdf0e10cSrcweir 	private	XComponentContext	m_xCtx;
57*cdf0e10cSrcweir 	private XPropertySet		m_xWatchedColumn;
58*cdf0e10cSrcweir 
59*cdf0e10cSrcweir 	private	boolean			m_bWatching;
60*cdf0e10cSrcweir 
61*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
62*cdf0e10cSrcweir 	public GridFieldValidator( XComponentContext xCtx, XPropertySet xWatchedGridColumn )
63*cdf0e10cSrcweir 	{
64*cdf0e10cSrcweir 		// remember
65*cdf0e10cSrcweir 		m_xCtx = xCtx;
66*cdf0e10cSrcweir 		m_xWatchedColumn = xWatchedGridColumn;
67*cdf0e10cSrcweir 		m_aDocument = DocumentHelper.getDocumentForComponent(xWatchedGridColumn,
68*cdf0e10cSrcweir                                                              xCtx);
69*cdf0e10cSrcweir 
70*cdf0e10cSrcweir 		m_bWatching = false;
71*cdf0e10cSrcweir 	}
72*cdf0e10cSrcweir 
73*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
74*cdf0e10cSrcweir 	public void enableColumnWatch( boolean bEnable )
75*cdf0e10cSrcweir 	{
76*cdf0e10cSrcweir 		if ( bEnable == m_bWatching )
77*cdf0e10cSrcweir 			return;
78*cdf0e10cSrcweir 
79*cdf0e10cSrcweir 		XUpdateBroadcaster xUpdate = (XUpdateBroadcaster)UnoRuntime.queryInterface(
80*cdf0e10cSrcweir 			XUpdateBroadcaster.class, m_xWatchedColumn );
81*cdf0e10cSrcweir 
82*cdf0e10cSrcweir 		if ( bEnable )
83*cdf0e10cSrcweir 			xUpdate.addUpdateListener( this );
84*cdf0e10cSrcweir 		else
85*cdf0e10cSrcweir 			xUpdate.removeUpdateListener( this );
86*cdf0e10cSrcweir 
87*cdf0e10cSrcweir 		m_bWatching = bEnable;
88*cdf0e10cSrcweir 	}
89*cdf0e10cSrcweir 
90*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
91*cdf0e10cSrcweir 	/** shows a message that we can't do several things due to an implementation error
92*cdf0e10cSrcweir 	*/
93*cdf0e10cSrcweir 	private void showInvalidValueMessage( )
94*cdf0e10cSrcweir 	{
95*cdf0e10cSrcweir 		try
96*cdf0e10cSrcweir 		{
97*cdf0e10cSrcweir 			// build the message we want to show
98*cdf0e10cSrcweir 			String sMessage = "The column \"";
99*cdf0e10cSrcweir 			sMessage += FLTools.getLabel( m_xWatchedColumn );
100*cdf0e10cSrcweir 			sMessage += "\" is not allowed to contain empty strings.";
101*cdf0e10cSrcweir 
102*cdf0e10cSrcweir 			SQLContext aError = new SQLContext(
103*cdf0e10cSrcweir 				new String( "Invalid Value Entered" ),
104*cdf0e10cSrcweir 				null,
105*cdf0e10cSrcweir 				new String( "S1000" ),
106*cdf0e10cSrcweir 				0,
107*cdf0e10cSrcweir 				new Any( new Type(), null ),
108*cdf0e10cSrcweir 				sMessage
109*cdf0e10cSrcweir 			);
110*cdf0e10cSrcweir 
111*cdf0e10cSrcweir 			// instantiate an interaction handler who can handle SQLExceptions
112*cdf0e10cSrcweir 			XInteractionHandler xHandler = (XInteractionHandler)UnoRuntime.queryInterface(
113*cdf0e10cSrcweir 				XInteractionHandler.class,
114*cdf0e10cSrcweir                 m_xCtx.getServiceManager().createInstanceWithContext(
115*cdf0e10cSrcweir                     "com.sun.star.task.InteractionHandler", m_xCtx ) );
116*cdf0e10cSrcweir 
117*cdf0e10cSrcweir 			// create a new request and execute it
118*cdf0e10cSrcweir 			InteractionRequest aRequest = new InteractionRequest( aError );
119*cdf0e10cSrcweir 			xHandler.handle( aRequest );
120*cdf0e10cSrcweir 		}
121*cdf0e10cSrcweir 		catch( com.sun.star.uno.Exception e )
122*cdf0e10cSrcweir 		{
123*cdf0e10cSrcweir 			System.out.println(e);
124*cdf0e10cSrcweir 			e.printStackTrace();
125*cdf0e10cSrcweir 		}
126*cdf0e10cSrcweir 	}
127*cdf0e10cSrcweir 
128*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
129*cdf0e10cSrcweir 	// XUpdateListener overridables
130*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
131*cdf0e10cSrcweir     public boolean approveUpdate( EventObject aEvent ) throws com.sun.star.uno.RuntimeException
132*cdf0e10cSrcweir 	{
133*cdf0e10cSrcweir 		boolean bApproved = true;
134*cdf0e10cSrcweir 		try
135*cdf0e10cSrcweir 		{
136*cdf0e10cSrcweir 			// the control model which fired the event
137*cdf0e10cSrcweir 			XPropertySet xSourceProps = UNO.queryPropertySet( aEvent.Source );
138*cdf0e10cSrcweir 
139*cdf0e10cSrcweir 			String sNewText = (String)xSourceProps.getPropertyValue( "Text" );
140*cdf0e10cSrcweir 			if ( 0 == sNewText.length() )
141*cdf0e10cSrcweir 			{
142*cdf0e10cSrcweir 				// say that the value is invalid
143*cdf0e10cSrcweir 				showInvalidValueMessage( );
144*cdf0e10cSrcweir 				bApproved = false;
145*cdf0e10cSrcweir 
146*cdf0e10cSrcweir 				// reset the control value
147*cdf0e10cSrcweir 				// for this, we take the current value from the row set field the control
148*cdf0e10cSrcweir 				// is bound to, and forward it to the control model
149*cdf0e10cSrcweir 				XColumn xBoundColumn = UNO.queryColumn( xSourceProps.getPropertyValue( "BoundField" ) );
150*cdf0e10cSrcweir 				if ( null != xBoundColumn )
151*cdf0e10cSrcweir 				{
152*cdf0e10cSrcweir 					xSourceProps.setPropertyValue( "Text", xBoundColumn.getString() );
153*cdf0e10cSrcweir 				}
154*cdf0e10cSrcweir 			}
155*cdf0e10cSrcweir 		}
156*cdf0e10cSrcweir 		catch( com.sun.star.uno.Exception e )
157*cdf0e10cSrcweir 		{
158*cdf0e10cSrcweir 			System.out.println(e);
159*cdf0e10cSrcweir 			e.printStackTrace();
160*cdf0e10cSrcweir 		}
161*cdf0e10cSrcweir 		return bApproved;
162*cdf0e10cSrcweir 	}
163*cdf0e10cSrcweir 
164*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
165*cdf0e10cSrcweir     public void updated( EventObject aEvent ) throws com.sun.star.uno.RuntimeException
166*cdf0e10cSrcweir 	{
167*cdf0e10cSrcweir 	}
168*cdf0e10cSrcweir 
169*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
170*cdf0e10cSrcweir 	// XEventListener overridables
171*cdf0e10cSrcweir 	/* ------------------------------------------------------------------ */
172*cdf0e10cSrcweir 	public void disposing( EventObject aEvent )
173*cdf0e10cSrcweir 	{
174*cdf0e10cSrcweir 		// not interested in
175*cdf0e10cSrcweir 	}
176*cdf0e10cSrcweir };
177