Suggested case list:
Using timer to refresh a grid
383guest172.69.33.12125nk0uiMay 7, 2020 7:23:47 AMlinkuser model to move item to another listbox
120guest162.158.193.148d0n3krApr 2, 2020 5:28:28 AMlinkDisabled list item row passed to VM-1981
296fatih123160.83.36.13025nk0uiFeb 13, 2018 4:25:44 PMlinkDisabled list item row passed to VM-1981
295fatih123160.83.36.13025nk0uiFeb 13, 2018 4:25:16 PMlinkDisabled list item row passed to VM-1981
294fatih123160.83.36.13225nk0uiFeb 13, 2018 3:30:44 PMlinkgrid sample with ListModel/RowRenderer
816guest80.82.2.1312vah9ajFeb 21, 2017 11:42:21 AMlinkgrid sample with ListModel/RowRenderer
809guest175.98.113.1622vah9ajJan 26, 2017 9:19:33 AMlinkgrid sample with ListModel/RowRenderer
196guest79.185.142.402vah9ajApr 26, 2014 10:53:57 PMlinkgrid sample with ListModel/RowRenderer
195guest79.185.142.402vah9ajApr 26, 2014 10:53:54 PMlinkgrid sample with ListModel/RowRenderer
194guest79.185.142.402vah9ajApr 26, 2014 10:53:51 PMlinkgrid sample with ListModel/RowRenderer
193guest79.185.142.402vah9ajApr 26, 2014 10:53:48 PMlinkgrid sample with ListModel/RowRenderer
192guest79.185.142.402vah9ajApr 26, 2014 10:53:44 PMlinkgrid sample with ListModel/RowRenderer
191guest79.185.142.402vah9ajApr 26, 2014 10:53:40 PMlinkHierarchy table without using ZK PE/EE
1aaknai151.28.135.2131s871daJul 29, 2013 11:02:46 PMlinkgrid sample with ListModel/RowRenderer
128aaknai151.28.135.2132vah9ajJul 29, 2013 7:20:00 PMlinkuser model to move item to another listbox
1TonyQ114.25.109.94d0n3krApr 21, 2012 10:43:27 AMlinkUsing timer to refresh a grid
1TonyQ220.133.44.3725nk0uiFeb 17, 2012 3:17:34 AMlinkFire a event from child iframe
1TonyQ220.133.44.372eupjotFeb 3, 2012 5:04:52 AMlinkTextbox input restriction sample
1TonyQ72.21.245.2431b3nlr0Dec 20, 2011 10:09:10 AMlinkTest web core taglib in ZUL
1TonyQ198.203.175.175ofqkemDec 17, 2011 3:36:08 AMlinkLatest 10 Fiddles :
constraint binding textbox
3guest172.68.151.16220peldaDec 5, 2025 5:08:19 PMlinkAnother new ZK fiddle
2guest172.68.151.16320peldaDec 5, 2025 5:07:51 PMlinkAnother new ZK fiddle
1guest172.68.151.16220peldaDec 5, 2025 5:07:32 PMlinkAnother new ZK fiddle
1peggypeng172.71.154.99364f4neDec 5, 2025 9:24:31 AMlinktooltip example
2guest104.22.23.13rc1ntoDec 4, 2025 2:23:45 PMlinkAnother new ZK fiddle
1guest172.69.134.2277t7602Dec 4, 2025 1:40:46 PMlinkAnother new ZK fiddle
1peggypeng104.22.17.1802df6e3oDec 4, 2025 8:41:29 AMlinkonClose
1peggypeng172.68.87.248j8kd8aDec 3, 2025 4:10:26 AMlinkAnother new ZK fiddle
1peggypeng172.69.134.2271rm7f4eNov 26, 2025 3:31:24 AMlinkZK-5912-Suggestion
2rebeccalai104.22.20.1442qrmiiuNov 26, 2025 2:07:15 AMlinkAnother new ZK fiddle
6guest115.254.63.50105knhiJul 18, 2018 7:54:01 AMlinkresources
index.zulzul<?page id="peMandatemaker" title="eMandate Maker" contentType="text/html;charset=UTF-8"?>
<zk>
<window id="wEcsMandateManualdataentry" apply="TestComposer.java" sclass="expstyle1" width="100%" height="100%" contentStyle="overflow:auto">
<style dynamic="true">
.expstyle1 .z-window-modal-tl, .expstyle1 .z-window-modal-tr, .expstyle1 .z-window-modal-tm,
.expstyle1 .z-window-modal-cl, .expstyle1 .z-window-modal-cr, .expstyle1 .z-window-modal-cm,
.expstyle1 .z-window-modal-bl, .expstyle1 .z-window-modal-br, .expstyle1 .z-window-modal-bm,
.expstyle1 .z-window-modal-hl, .expstyle1 .z-window-modal-hr, .expstyle1 .z-window-modal-hm
{
background: #728C00;
}
.expstyle1 .z-window-modal-header
{
background: #728C00;
}
.expstyle1 .z-textbox
{
text-transform:uppercase;
}
.MyRowHeight tr.z-row,tr.z-listheader
{
height:1px;
line-height:7px;
min-height:1px;
}
</style>
<grid id = "datagrid" height="100%" width="100%" style="overflow-y: scroll;">
<columns>
<column width="15%"/>
<column width="35%"/>
<column width="15%"/>
<column width="35%"/>
</columns>
<rows>
<row visible="false" ><label></label><label id="mandateid" width = "80%"></label></row>
<row><label value="Utility Number:"/><textbox id="utlcodetb" maxlength="18" width = "80%" constraint="/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/: only alphanumeric characters allowed!" /><label value="Utility Name:" /><textbox id="utlnametb" maxlength="100" width = "80%" constraint="/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/: only alphanumeric characters allowed!" /></row>
<row><label value="Account Number:"/><textbox id="acnotb" maxlength="15" width = "80%" constraint="no empty, /[0-9]{15}/ : acount number should be 15 digit!"/><label value="Account Name:"/><textbox id="acnonametb" maxlength="100" width = "80%" constraint="/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/: only alphanumeric characters allowed!"/></row>
<row><label value="Maximum Amount:"/><textbox id="maxamttb" maxlength="15" width = "80%" /><label value="Fixed Amount"/><textbox id="fixamttb" maxlength="15" width = "80%" /></row>
<row><label value="Frequency:"/><combobox id="freqtb" width = "80%" /></row>
<row id = "r2"><label value="Start Date:(dd/mmm/yyyy)"/><textbox id="startdb" width = "80%" /><label value="End Date:(dd/mmm/yyyy)"/><textbox id="enddb" width = "80%" /></row>
<row><label value="Reference Number 1:"/><textbox id="refnum1" maxlength="50" width = "80%" /><label value="Reference Number 2:"/><textbox id="refnum2" maxlength="50" width = "80%" /></row>
<row><label value="Reference Number 3:"/><textbox id="refnum3" maxlength="50" width = "80%" /><label value="Reference Number 4:"/><textbox id="refnum4" maxlength="50" width = "80%" /></row>
<row><label value="Reference Number 5:"/><textbox id="refnum5" maxlength="50" width = "80%" /><label value="Reference Number 6:" /><textbox id="refnum6" maxlength="50" width = "80%" /></row>
<row><label value="Reference Number 7:"/><textbox id="refnum7" maxlength="50" width = "80%"/><label value="Reference Number 8:"/><textbox id="refnum8" maxlength="50" width = "80%" /></row>
<row><label value="" width = "80%"/><label value="" width = "80%"/><label value="" width = "80%"/><div align ="right" width ="80%"><button id="save" label="Accept" width="80px" mold ="trendy"/><button id="cancel" label="Clear" width="80px" mold ="trendy"/></div></row>
</rows>
</grid>
</window>
</zk>TestComposer.javajava
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.Map;
import javax.naming.InitialContext;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;
import org.zkoss.zk.ui.Component;
import org.zkoss.zk.ui.Executions;
import org.zkoss.zk.ui.Sessions;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.event.EventListener;
import org.zkoss.zk.ui.util.GenericForwardComposer;
import org.zkoss.zul.Button;
import org.zkoss.zul.Combobox;
import org.zkoss.zul.Div;
import org.zkoss.zul.Label;
import org.zkoss.zul.Listbox;
import org.zkoss.zul.Listcell;
import org.zkoss.zul.Listitem;
import org.zkoss.zul.North;
import org.zkoss.zul.Panel;
import org.zkoss.zul.Textbox;
import org.zkoss.zul.Window;
import com.imageinfo.eclear.v2.utils.Globals;
@SuppressWarnings("unchecked")
public class TestComposer extends GenericForwardComposer
{
private static final long serialVersionUID = 1L;
Window wEcsMandateManualdataentry;
North north;
Div filterdiv;
Div serchdiv;
Div serchdiv2;
Div savediv;
Panel mdatapanel;
Button save;
Button cancel;
Label msg;
Listitem row1,row2;
Listbox data_grid;
Listbox data_grid2;
Label mandateid;
Textbox utlcodetb;
Textbox utlnametb;
Textbox acnotb;
Textbox acnonametb;
Textbox maxamttb;
Textbox fixamttb;
Combobox freqtb;
Textbox startdb;
Textbox enddb;
Textbox refnum1;
Textbox refnum2;
Textbox refnum3;
Textbox refnum4;
Textbox refnum5;
Textbox refnum6;
Textbox refnum7;
Textbox refnum8;
//HttpSession s ;
String locked_userid = "",curDate = "",sess_usr = "",batch_id = "",acctype = "";
String whereclause = "",transaction_date = "",transaction_dateall = "",actiontype = "",achpath ="";
boolean lockchk = false;
LinkedHashMap<Integer, String> locked_instids = new LinkedHashMap<Integer, String>();
LinkedHashMap<String, String> utilitymap = new LinkedHashMap<String, String>();
LinkedHashMap<String, String> catmap = new LinkedHashMap<String, String>();
public void doAfterCompose(Component comp) throws Exception
{
super.doAfterCompose(comp);
//s = (HttpSession) Sessions.getCurrent().getNativeSession();
//try{s.getAttribute("svalid").toString().toUpperCase();}catch (NullPointerException npe) {Executions.sendRedirect("/invalid.zul");return;}
wEcsMandateManualdataentry.setTitle("ECSMandate Maker");
wEcsMandateManualdataentry.setBorder("normal");
wEcsMandateManualdataentry.setSizable(false);
wEcsMandateManualdataentry.setDraggable("false");
//curDate = s.getAttribute("currentdate").toString();
//sess_usr = (String)s.getAttribute("usern");
//achpath =Globals.getAttribute("EXPORT_ACH_FILES","1",1);
if(!achpath.endsWith("/"))
{
achpath+="/";
}
save.addEventListener("onOK",saveenent);
save.addEventListener("onClick",saveenent);
cancel.addEventListener("onClick",saveenent);
cancel.addEventListener("onOK",saveenent);
maxamttb.setSclass("font-family: Rupee Foradian Standard");
maxamttb.setStyle("text-align: right;");
maxamttb.setWidgetListener("onBind","jQuery('#"+maxamttb.getUuid()+"').autoNumeric('init',{dGroup: 2, aSign: '\u20b9 ', vMax: '99999999999.99'});");
maxamttb.setValue("\u20b9 ");
fixamttb.setSclass("font-family: Rupee Foradian Standard");
fixamttb.setStyle("text-align: right;");
fixamttb.setWidgetListener("onBind","jQuery('#"+fixamttb.getUuid()+"').autoNumeric('init',{dGroup: 2, aSign: '\u20b9 ', vMax: '99999999999.99'});");
fixamttb.setValue("\u20b9 ");
startdb.setWidgetListener("onBind", "jQuery('#"+startdb.getUuid()+"').mask('99/99/2099');");
enddb.setWidgetListener("onBind", "jQuery('#"+enddb.getUuid()+"').mask('99/99/2099');");
freqtb.appendItem("MNTH");
freqtb.setReadonly(true);
}
EventListener saveenent = new EventListener()
{
public void onEvent(Event evt) throws Exception
{
if((evt.getName().equalsIgnoreCase("onOK")||evt.getName().equalsIgnoreCase("onClick")) && evt.getTarget().getId().equalsIgnoreCase("save"))
{
InsertECSMandateInfo();
}
if((evt.getName().equalsIgnoreCase("onOK")||evt.getName().equalsIgnoreCase("onClick")) && evt.getTarget().getId().equalsIgnoreCase("cancel"))
{
clearloaddata();
}
}
};
public void InsertECSMandateInfo()
{
Connection conn =null;
Statement stmt =null;
PreparedStatement stmt1 =null;
String mandate_id ="";
String maxamount ="";
String fixamount ="";
String untilcanceldflag ="";
String fixmax_flag ="";
String startdate ="";
String enddate ="";
try
{
utlcodetb.setConstraint("");
try
{
maxamount =maxamttb.getValue().substring(1).replace(",", "");
System.out.println("maxamount ="+maxamount);
maxamount =maxamount.substring(0,maxamount.indexOf(".")).trim();
}
catch(Exception e){maxamount = "";}
try
{
fixamount =fixamttb.getValue().substring(1).replace(",", "");
System.out.println("fixamount ="+fixamount);
fixamount =fixamount.substring(0,fixamount.indexOf(".")).trim();
}
catch(Exception e){fixamount ="";}
System.out.println("maxamount ="+maxamount +" fixamount = "+fixamount);
if(maxamount == null||maxamount.equalsIgnoreCase(""))
{
fixmax_flag = "F";//fixmaxflag
//amount = maxamount;
}
else if(fixamount == null||fixamount.equalsIgnoreCase(""))
{
fixmax_flag = "M";//fixmaxflag
//amount = collectionamt;
}
else
{
fixmax_flag = "F";//fixmaxflag
}
if((!(maxamount.equalsIgnoreCase("")||(maxamount==null))&&!(fixamount.equalsIgnoreCase("")||fixamount==null)))
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Eiether maxium amount or Fix amount should be entered");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
return ;
}
if((maxamount.equalsIgnoreCase("")||maxamount==null)&&(fixamount.equalsIgnoreCase("")||fixamount==null))
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Both amount can not be left empty");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
return ;
}
if(utlnametb.getValue().equalsIgnoreCase("")||utlnametb.getValue()==null||acnotb.getValue().equalsIgnoreCase("")||acnotb.getValue()==null||startdb.getValue().equalsIgnoreCase("")||startdb.getValue()==null||acnonametb.getValue().equalsIgnoreCase("")||acnonametb.getValue()==null)
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Mandatory fields can not be left blank");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
return ;
}
if(!(utlcodetb.getValue().equalsIgnoreCase("")||utlcodetb.getValue()==null))
{
if(utlcodetb.getValue().length()!=18)
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Utility number should be eighteen digit");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
return ;
}
}
if(acnotb.getValue().length()!=15)
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","account number should be fifteen digit");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
return ;
}
if(!Checkduplicacy(maxamount,fixamount))
{
DataSource ds = (DataSource) new InitialContext(Globals.getICProps()).lookup(Globals.getDSlookup());
conn = ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String insertquery= "Insert into tbl_in_dd_mandate ( mandate_id,utility_code,service_provider_name,debitor_acno,debitor_name,max_amount,collection_amount,start_date,end_date,frequency,mms_ecs_refnum1,mms_ecs_refnum2,mms_ecs_refnum3,mms_ecs_refnum4,mms_ecs_refnum5,mms_ecs_refnum6,mms_ecs_refnum7,mms_ecs_refnum8,action_type,mandate_type,transaction_date,creator ,creator_date,validation_status,chk_flag,del_flag,import_type,until_cancelled_flag,fixmax_flag,user_number) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,(select systimestamp from dual),?,?,?,?,?,?,?)";
stmt1 = conn.prepareStatement(insertquery,ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select to_char(cur_date,'yyddd')||lpad(IN_DD_MANDATE_ID.nextval,16,'0') as mandate_id from tbl_eod_bod_stat");
if (rs.next())
{
mandate_id = rs.getString(1);
}
rs.close();
System.out.println(utlcodetb.getValue());
System.out.println(utlnametb.getValue());
System.out.println(acnotb.getValue());
System.out.println(acnonametb.getValue());
System.out.println(maxamount);
System.out.println(fixamount);
System.out.println(startdb.getValue());
System.out.println(enddb.getValue());
System.out.println(freqtb.getValue());
if(enddb.getValue()==null||enddb.getValue().equalsIgnoreCase(""))
{
untilcanceldflag ="Y";
}
startdate = (new SimpleDateFormat("dd-MMM-yyyy").format(new SimpleDateFormat("dd/MM/yyyy").parse(startdb.getValue()))).toUpperCase();
try
{
enddate =(new SimpleDateFormat("dd-MMM-yyyy").format(new SimpleDateFormat("dd/MM/yyyy").parse(enddb.getValue()))).toUpperCase();
}
catch(Exception e){enddate = "";}
System.out.println("Insert into tbl_in_dd_mandate ( mandate_id,utility_code,service_provider_name,debitor_acno,debitor_name,max_amount,collection_amount,start_date,end_date,frequency,mms_ecs_refnum1,mms_ecs_refnum2,mms_ecs_refnum3,mms_ecs_refnum4,mms_ecs_refnum5,mms_ecs_refnum6,mms_ecs_refnum7,mms_ecs_refnum8,action_type,mandate_type,transaction_date,creator ,creator_date,validation_status,chk_flag,del_flag,import_type,until_cancelled_flag,fixmax_flag)"+
"values ('"+mandate_id+"','"+utlcodetb.getValue()+"','"+utlnametb.getValue()+"','"+acnotb.getValue()+"','"+acnonametb.getValue()+"','"+maxamount+"','"+fixamount+"','"+startdate+"','"+enddate+"','"+freqtb.getValue()+"','"+refnum1.getValue()+"','"+refnum2.getValue()+"','"+refnum3.getValue()+"','"+refnum4.getValue()+"','"+refnum5.getValue()+"','"+refnum6.getValue()+"','"+refnum7.getValue()+"','"+refnum8.getValue()+"','CREATE','ECS MANDATE','"+curDate+"','"+sess_usr+"',(select systimestamp from dual),'1','0','0','MANUAL','"+untilcanceldflag+"','"+fixmax_flag+"')");
//mandate_id,utility_code,service_provider_name,debitor_acno,debitor_name,max_amount,collection_amount,
//start_date,end_date,frequency,mms_ecs_refnum1,mms_ecs_refnum2,mms_ecs_refnum3,mms_ecs_refnum4,mms_ecs_refnum5,mms_ecs_refnum6,mms_ecs_refnum7,mms_ecs_refnum8,action_type,
// mandate_type,transaction_date,creator ,creator_date,validation_status,chk_flag,del_flag,import_type,until_cancelled_flag
stmt1.setString(1, mandate_id);
stmt1.setString(2, utlcodetb.getValue().toUpperCase());
stmt1.setString(3, utlnametb.getValue().toUpperCase());
stmt1.setString(4, acnotb.getValue());
stmt1.setString(5, acnonametb.getValue().toUpperCase());
stmt1.setString(6, maxamount);
stmt1.setString(7, fixamount);
stmt1.setString(8, startdate);
stmt1.setString(9, enddate);
stmt1.setString(10, freqtb.getValue());
stmt1.setString(11, refnum1.getValue().toUpperCase());
stmt1.setString(12, refnum2.getValue().toUpperCase());
stmt1.setString(13, refnum3.getValue().toUpperCase());
stmt1.setString(14, refnum4.getValue().toUpperCase());
stmt1.setString(15, refnum5.getValue().toUpperCase());
stmt1.setString(16, refnum6.getValue().toUpperCase());
stmt1.setString(17, refnum7.getValue().toUpperCase());
stmt1.setString(18, refnum8.getValue().toUpperCase());
stmt1.setString(19, "CREATE");
stmt1.setString(20, "ECS MANDATE");
stmt1.setString(21, curDate);
stmt1.setString(22, sess_usr);
stmt1.setString(23, "4");
stmt1.setString(24, "0");
stmt1.setString(25, "0");
stmt1.setString(26, "MANUAL");
stmt1.setString(27, untilcanceldflag);
stmt1.setString(28, fixmax_flag);
stmt1.setString(29, utlcodetb.getValue().toUpperCase());
stmt1.execute();
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Mandate Info saved successfully.");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
Globals.auditlogit_tran(mandate_id,save.getLabel(),wEcsMandateManualdataentry.getId(),"ECS Mandate Creation Request is Accepted for verification action: ","MMS INWARD");
clearloaddata();
}
else
{
try
{
HashMap<String, String> msgparams = new HashMap<String, String>();
msgparams.put("msgstring","Mandate Info already exists.");
Window win = (Window) Executions.createComponents("MessageBox.zul", null, msgparams);
win.doModal();
}
catch(Exception e)
{
}
}
}
catch (Exception e){e.printStackTrace();}finally{try{if(conn!=null){if(stmt!=null){stmt.close();stmt = null;}if(stmt1!=null){stmt1.close();stmt1 = null;}conn.close();conn = null;}}catch (Exception fe){fe.printStackTrace();}}
}
public boolean Checkduplicacy(String maxamount , String fixamount)
{
Connection conn = null;
PreparedStatement stmt1=null;
try
{
System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>startdb.getValue() ="+startdb.getValue());
System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>enddb.getValue() ="+enddb.getValue());
DataSource ds = (DataSource) new InitialContext(Globals.getICProps()).lookup(Globals.getDSlookup());
conn = ds.getConnection();
String duplicate ="select * from tbl_in_dd_mandate where service_provider_name = ? and debitor_acno =? and debitor_name = ? and nvl(max_amount ,collection_amount) in (?,?) and start_date =?" ;
//System.out.println("select * from tbl_in_dd_mandate where utility_code ='utlcodetb.getValue()' and service_provider_name = 'utlnametb.getValue()' and debitor_acno ='acnotb.getValue()' and max_amount ='maxamttb.getValue()' and collection_amount ='fixamttb.getValue()' and start_date ='startdb.getValue()' and end_date ='enddb.getValue()' and frequency ='freqtb.getValue()'");
stmt1 = conn.prepareStatement(duplicate,ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt1.setString(1, utlnametb.getValue());
stmt1.setString(2, acnotb.getValue());
stmt1.setString(3, acnonametb.getValue());
stmt1.setString(4, maxamount);
stmt1.setString(5, fixamount);
stmt1.setString(6, (new SimpleDateFormat("dd-MMM-yyyy").format(new SimpleDateFormat("dd/MM/yyyy").parse(startdb.getValue()))).toUpperCase());
ResultSet rs = stmt1.executeQuery();
if(rs.next())
{
return true;
}
rs.close();
}
catch (Exception e){e.printStackTrace();} finally{try{if(conn!=null){if(stmt1!=null){stmt1.close();stmt1 = null;}}}catch (Exception fe){fe.printStackTrace();}}
return false;
}
public void clearloaddata()
{
mandateid.setValue("");
utlcodetb.setConstraint("");
utlcodetb.setValue("");
utlcodetb.setConstraint("/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/ : only alphanumeric characters allowed!");
acnotb.setConstraint("");
acnotb.setValue("");
acnotb.setConstraint("no empty, /[0-9]{15}/ : only numbers allowed!");
utlnametb.setConstraint("");
utlnametb.setValue("");
utlnametb.setConstraint("/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/ : only alphanumeric characters allowed!");
acnonametb.setConstraint("");
acnonametb.setValue("");
acnonametb.setConstraint("/^[a-zA-Z0-9]+(([ ][a-zA-Z0-9 ])?[a-zA-Z0-9]*)*$/ : only alphanumeric characters allowed!");
maxamttb.setValue("");
fixamttb.setValue("");
freqtb.setValue("");
startdb.setValue("");
enddb.setValue("");
refnum1.setValue("");
refnum2.setValue("");
refnum3.setValue("");
refnum4.setValue("");
refnum5.setValue("");
refnum6.setValue("");
refnum7.setValue("");
refnum8.setValue("");
}
}