private UserEntity getEntity(ResultSet rs) throws SQLException { UserEntity user = new UserEntity(); user.setId(rs.getString("id")); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); user.setKind(rs.getString("kind")); user.setShortTitle(rs.getString("shortTitle")); user.setSpecialService(rs.getString("specialService")); user.setAuthor(rs.getDouble("Author")); user.setOrigin(rs.getString("origin")); user.setCompanyAddress(rs.getString("companyAddress")); user.setOfficeCompany(rs.getString("officeCompany")); user.setCompanyNumber(rs.getInt("companyNumber")); user.setServicesType(rs.getString("servicesType")); user.setRespectiveIndustries(rs.getString("respectiveIndustries")); user.setCompanyLeader(rs.getString("companyLeader")); user.setTitle(rs.getString("title")); return user; }