public DBConnect() {
System.out.println("Plz enter username and password:");
Scanner sc = new Scanner(System.in);
loadDriver();
connect(sc.next(), sc.next());
}
public User retrieveFromDB(Long id) {
User user = new User();
UserDetail userdetails = new UserDetail();
Address addr = new Address();
List<EducationDetails> education = new ArrayList<EducationDetails>();
List<CarrerDetail> career = new ArrayList<CarrerDetail>();
OtherDetails otherDetail = new OtherDetails();
user.setId(id);
try {
Connection con = DBConnect.connect();
PreparedStatement stmt = con.prepareStatement(DbQueries.SELECT_USER_BY_ID);
stmt.setLong(1, id);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
user.setEmail(rs.getString(2));
user.setPassword(rs.getString(3));
}
stmt = con.prepareStatement(DbQueries.SELECT_USERDETAILS);
stmt.setLong(1, id);
ResultSet rs1 = stmt.executeQuery();
while (rs1.next()) {
userdetails.setFirstName(rs1.getString(3));
userdetails.setLastName(rs1.getString(4));
userdetails.setDob(rs1.getDate(5));
userdetails.setMobile(rs1.getString(6));
userdetails.setFatherName(rs1.getString(7));
userdetails.setCarrerObjective(rs1.getString(8));
user.setFlag(true);
break;
}
user.setFlag(false);
stmt = con.prepareStatement(DbQueries.SELECT_ADDRESS);
stmt.setLong(1, id);
ResultSet rs2 = stmt.executeQuery();
while (rs2.next()) {
addr.setCity(rs2.getString(3));
addr.setState(rs2.getString(4));
addr.setLine(rs2.getString(5));
userdetails.setAddress(addr);
user.setFlag(true);
break;
}
user.setFlag(false);
stmt = con.prepareStatement(DbQueries.SELECT_EDUCATION);
stmt.setLong(1, id);
ResultSet rs3 = stmt.executeQuery();
while (rs3.next()) {
EducationDetails edu = new EducationDetails();
edu.setCollegeName(rs3.getString(3));
edu.setStartYear(rs3.getDate(4));
edu.setEndYear(rs3.getDate(5));
edu.setPercentage(rs3.getString(6));
education.add(edu);
user.setFlag(true);
}
user.setFlag(false);
userdetails.setEducation(education);
stmt = con.prepareStatement(DbQueries.SELECT_CAREER);
stmt.setLong(1, id);
ResultSet rs4 = stmt.executeQuery();
while (rs4.next()) {
CarrerDetail car = new CarrerDetail();
car.setCompanyName(rs4.getString(3));
car.setDesignation(rs4.getString(4));
car.setFrom(rs4.getDate(5));
car.setTo(rs4.getDate(6));
career.add(car);
user.setFlag(true);
}
user.setFlag(false);
userdetails.setExperience(career);
stmt = con.prepareStatement(DbQueries.SELECT_OTHERDETAIL);
stmt.setLong(1, id);
ResultSet rs5 = stmt.executeQuery();
while (rs5.next()) {
otherDetail.setLanguage(rs5.getString(3));
otherDetail.setExtraCurrAct(rs5.getString(4));
userdetails.setOtherDetail(otherDetail);
user.setFlag(true);
break;
}
user.setUserDetail(userdetails);
} catch (Exception e) {
e.printStackTrace();
}
return user;
}
