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.util.Map;
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 UserIDParameterSetter implements SQLParameterSetter {
37:
38: private static UserIDParameterSetter setterInstance = new UserIDParameterSetter();
39:
40: public static UserIDParameterSetter 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: Map userInfo = (Map) req.getAttribute(PortletRequest.USER_INFO);
48: if (userInfo != null) {
49: String userIdStr = (String) userInfo.get("user.id");
50: if (userIdStr != null) {
51: st.setInt(pos, Integer.parseInt(userIdStr));
52: return;
53: }
54: }
55: st.setString(pos, null);
56: }
57:
58: }
|