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