appserver/tests/appserv-tests/devtests/connector/v3/securitymapweb/web/index.jsp

<%--

    Copyright (c) 2018 Oracle and/or its affiliates. All rights reserved.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

--%>

<%@ page import="javax.naming.*,java.sql.*,javax.sql.*" %>

<%
        Connection conn = null;
        String userName = request.getUserPrincipal().getName();
        try {
            InitialContext initialContext = new InitialContext();
            DataSource ds =
                (DataSource) initialContext.lookup("java:comp/env/jdbc/DS");

            conn = (Connection) ds.getConnection();

            System.out.println(" got the connection : " + conn);

            System.out.println("** insert " + userName + " into securitymapwebdb");

            PreparedStatement prepStmt =
                conn.prepareStatement("insert into securitymapwebdb values(?)");

            prepStmt.setString(1, userName);

            prepStmt.executeUpdate();


        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException(e);
        } finally {
            try {
                if (conn != null)
                    conn.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        out.println("done - " + userName);
%>