@Override
  public User getUserDetails(String uname) {
    Connection con = null;
    try {
      con = DBConnectionFactory.getConnection();
      Statement st = con.createStatement();
      String sql =
          "select fname, lname, email, mobile, usertype "
              + "from user_details "
              + "where uname='"
              + uname
              + "'";
      ResultSet rs = st.executeQuery(sql);
      if (rs.next()) {
        User u = new User();
        u.setUname(uname);
        u.setFname(rs.getString(1));
        u.setLname(rs.getString(2));
        u.setEmail(rs.getString(3));
        u.setMobile(rs.getString(4));
        u.setUsertype(rs.getString(5));

        return u;
      }
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      try {
        con.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    return null;
  }
Exemple #2
0
 public User getUser(String user) throws SQLException {
   start();
   rs = stmt.executeQuery("SELECT * FROM userInfo WHERE username = '******'");
   User rtrn = null;
   if (rs.next()) {
     rtrn = new User();
     rtrn.setUserName(rs.getString(1));
     rtrn.setPassWord(rs.getString(2));
     rtrn.setFirstName(rs.getString(3));
     rtrn.setLastName(rs.getString(4));
     rtrn.setEmail(rs.getString(5));
     long number = 0;
     String num = rs.getString(6);
     if (num != null)
       number = Long.parseLong(num.replace("-", "").replace("(", "").replace(")", ""));
     rtrn.setPhoneNumber(number);
     rtrn.setCity(rs.getString(7));
     rtrn.setState(rs.getString(8));
     rtrn.setRating(rs.getInt(9));
   }
   close();
   return rtrn;
 }