01: /*
02: * (C) Copyright 2006 Nabh Information Systems, Inc.
03: *
04: * All copyright notices regarding Nabh's products MUST remain
05: * intact in the scripts and in the outputted HTML.
06: * This program is free software; you can redistribute it and/or
07: * modify it under the terms of the GNU Lesser General Public License
08: * as published by the Free Software Foundation; either version 2.1
09: * of the License, or (at your option) any later version.
10: *
11: * This program is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14: * GNU Lesser General Public License for more details.
15: *
16: * You should have received a copy of the GNU Lesser General Public License
17: * along with this program; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
19: *
20: */
21: package com.nabhinc.util.db;
22:
23: import java.sql.Connection;
24: import java.sql.Date;
25: import java.sql.PreparedStatement;
26: import java.sql.SQLException;
27:
28: import javax.portlet.PortletRequest;
29:
30: /**
31: *
32: *
33: * @author Padmanabh Dabke
34: * (c) 2006 Nabh Information Systems, Inc. All Rights Reserved.
35: */
36: public class CurrentDateParameterSetter implements SQLParameterSetter {
37:
38: private static CurrentDateParameterSetter setterInstance = new CurrentDateParameterSetter();
39:
40: public static CurrentDateParameterSetter getInstance() {
41: return setterInstance;
42: }
43:
44: public void setSQLParameter(String paramName, int pos,
45: PreparedStatement st, Connection conn, PortletRequest req)
46: throws SQLException {
47: Date dt = new Date(System.currentTimeMillis());
48: st.setDate(pos, dt);
49: }
50:
51: }
|