rs1.next();
        String s1 = rs1.getString(1);

rs1.first();
        String s1 = rs1.getString(1);

rs1.first();
        String s1 = rs1.getString("Number");

package mypackage;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.Collections;
    import java.util.LinkedList;
    import javax.ws.rs.GET;
    import javax.ws.rs.Path;
    import javax.ws.rs.PathParam;
    import javax.ws.rs.QueryParam;
    import javax.ws.rs.core.Response;

    @Path("/query")
    public class CList {

        private LinkedList<SMember> contacts;

        public CList() {
        contacts = new LinkedList();
        }

        @GET
        @Path("/{CList}")
        public Response addCLocation(@QueryParam("employeeId") String eId) throws SQLException{

            String dataSourceName = "DBname";
            String dbURL = "jdbc:mysql://localhost:3306/" + dataSourceName;
            String result = "";
            Connection con = null;
            PreparedStatement ps0 = null, ps = null;
            ResultSet rs = null, rs1 = null;
            String id = eId;

            try {
                try{
                //Database Connector Driver
                Class.forName("com.mysql.jdbc.Driver");
                //Connection variables: dbPath, userName, password
                con = (Connection)
                        DriverManager.getConnection(dbURL,"someusername","somepassword");
                    System.out.println("We are connected to database");
                    //SQL Statement to Execute
                    System.out.print(id);
                    s = con.prepareStatement("SELECT 1 FROM CList WHERE Number=?");
                                    s.setString(1, eId);
                    rs = s.executeQuery();
                    //Parse SQL Response
                    if(!rs.next()) {
                        SMember sm = new SMember();
                        ps = (PreparedStatement) con.prepareStatement("INSERT
                              INTO Contact_List (Number, First_Name, Last_Name, Phone_Number) " +
              "VALUES (?,?,?,?)");
                        ps.setString(1,sm.getEmployeeID());
                        ps.setString(2,sm.getFirstName());
                        ps.setString(3,sm.getLastName());
                        ps.setString(4,sm.getPhone());
                        ps.executeUpdate();
                                            ps = con.prepareStatement("SELECT Number, First_Name,
                                                Last_Name, Phone_Number FROM CList
                                                WHERE Number=" + eId);
                    rs1 = ps.executeQuery();
                    while(rs1.next()){
                        result = "[Added contact to contact list.
                                                              Number: " + rs1.getString(1) +
                            "][First_Name: " + rs1.getString(2) +
                            "][Last_name: " + rs1.getString(3) +
                            "][Phone_Number: " + rs1.getString(4) +
                             "]n";
                    }
                    }
                    else {
                        result = "[Contact is already on the list]";
                    }
                }
                catch(Exception e) {
                    System.out.println("Can not connect to database");
                    e.printStackTrace();
                }
                finally {
                    //Close Database Connection
                    ps0.close();
                    ps.close();
                    con.close();
                }
            }
            catch(Exception e) {
                System.out.println(e);
            }
           //Return the Result to Browser
           return Response.status(1000).entity(result).build();
        }

ps = (PreparedStatement) con.prepareStatement("INSERT INTO CList (Number, First_Name, Last_Name, Phone_Number) VALUES ('"+sm.getEmployeeID()+"', '"+sm.getFirstName()+"', '"+sm.getLastName()+"', '"+sm.getPhone()+"')", Statement.RETURN_GENERATED_KEYS);

public Response addCLocation(String eId) throws SQLException {

    String dataSourceName = "DBname";
    String dbURL = "jdbc:mysql://localhost:3306/" + dataSourceName;
    String result = "";
    Connection con = null;
    Statement s = null;
    PreparedStatement ps = null;
    ResultSet rs = null, rs1 = null;
    String id = eId;

    try {
      try {
        // Database Connector Driver
        Class.forName("com.mysql.jdbc.Driver");
        // Connection variables: dbPath, userName, password
        con = DriverManager.getConnection(dbURL, "someusername", "somepassword");
        System.out.println("We are connected to database");
        s = con.createStatement();
        // SQL Statement to Execute
        System.out.print(id);
        PreparedStatement alreadyThere = con.prepareStatement("SELECT 1 FROM CList WHERE Number = ?");
        alreadyThere.setString(1, eId);
        System.out.println("0");
        // Parse SQL Response
        int i = 0;
        if (rs.next() == false) {
          SMember sm = new SMember();
          ps = con
              .prepareStatement("INSERT INTO Contact_List (Number, First_Name, Last_Name, Phone_Number) VALUES (?,?,?,?)");
          ps.setString(1, sm.getEmployeeID());
          ps.setString(2, sm.getFirstName());
          ps.setString(3, sm.getLastName());
          ps.setString(4, sm.getPhone());
          ps.executeUpdate();
        }
        else {
          result = "[Contact is already on the list]";
        }
      }
      catch (Exception e) {
        System.out.println("Can not connect to database");
        e.printStackTrace();
      }
      finally {
        // Close Database Connection
        s.close();
        ps.close();
        con.close();
      }
    }
    catch (Exception e) {
      System.out.println(e);
    }
    // Return the Result to Browser
    return Response.status(200).entity(result).build();
  }

rs = s.executeQuery("SELECT 1 FROM CList WHERE Number='id'");

**rs = s.executeQuery("SELECT 1 FROM CList WHERE Number="+id);**

if(rs.next() == false) {
                     SMember sm = new SMember();
                     ps = (PreparedStatement) con.prepareStatement("INSERT
                                         INTO CList (Number, First_Name, Last_Name,
                                         Phone_Number) VALUES ('"+sm.getEmployeeID()+"',
                                         '"+sm.getFirstName()+"', '"+sm.getLastName()+"',
                                               '"+sm.getPhone()+"')",
                                     Statement.RETURN_GENERATED_KEYS);
                     ps.executeUpdate();

**ps = (PreparedStatement) con.prepareStatement("INSERT INTO CList (Number, First_Name, Last_Name,Phone_Number) VALUES (?,?,?,?)",Statement.RETURN_GENERATED_KEYS);
ps.setString(1,sm.getEmployeeID());
ps.setString(2,sm.getFirstName());
ps.setString(3,sm.getLastName());
ps.setString(4,sm.getPhoneNumber());**

{"SELECT * FROM CList WHERE Number="+id}