<%@page contentType="text/html"%> <%@include file="/include/checkUser.jspf" %> <%@page import="java.sql.*" %> <%@page import="duffy.ifoundya.ifoundyaDBBean" %> <% // This page will eventually be the location to do all phone management. %> <% // eg. add/modify phone records. %> IFoundYa - Phone Management

My Phones

<% // Need to have this page read the phones from the Database.%> <% // First we will get the session object and pull out the username attribute. %> <% // We will then user the username as the key to query for phones in the phones table. %> <% // What ever phone records match, we will display in the select. %> <% Statement stmt = db.getStatement(); // statement to interface with DB // Query to retrieve the db records for the phones for this user. ResultSet rset = stmt.executeQuery("select phonenumber from phones where username = '" + userName + "'" ); %>

You have the following phones registered with us.

Click on the "Add Phone" button to add another phone to your account.