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.PreparedStatement;
25: import java.sql.SQLException;
26: import java.sql.Types;
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 PreferenceParameterSetter implements SQLParameterSetter {
37:
38: private String ppsPrefName = null;
39: private int ppsParamType;
40:
41: public PreferenceParameterSetter(String prefName, int paramType) {
42: ppsPrefName = prefName;
43: ppsParamType = paramType;
44: }
45:
46: public void setSQLParameter(String paramName, int pos,
47: PreparedStatement st, Connection conn, PortletRequest req)
48: throws SQLException {
49:
50: String prefValue = req.getPreferences().getValue(ppsPrefName,
51: null);
52:
53: switch (ppsParamType) {
54: case Types.INTEGER:
55: case Types.DECIMAL:
56: DBParamUtil.setSQLInt(prefValue, st, pos);
57: break;
58: case Types.FLOAT:
59: DBParamUtil.setSQLFloat(prefValue, st, pos);
60: break;
61: case Types.DOUBLE:
62: DBParamUtil.setSQLDouble(prefValue, st, pos);
63: break;
64: case Types.VARCHAR:
65: st.setString(pos, prefValue);
66: break;
67: case Types.BOOLEAN:
68: DBParamUtil.setSQLBoolean(prefValue, st, pos);
69: break;
70: case Types.DATE:
71: DBParamUtil.setSQLDate(prefValue, st, pos, req.getLocale());
72: break;
73: case Types.TIMESTAMP:
74: DBParamUtil.setSQLDate(prefValue, st, pos, req.getLocale());
75: break;
76: default:
77: st.setString(pos, prefValue);
78:
79: }
80:
81: }
82:
83: }
|