public int validateEmail(String emailId) throws Exception {
// TODO Auto-generated method stub
logger.info("In validateEmail Data Access Layer");
int result = 0;
NewUserBean usrBean = new NewUserBean();
Connection cn = null;
String validEmail = "";
try {
logger.info("In Try Method For Validating Data");
String Query = SQLConstant.CHECK_EMAIL;
logger.debug("Sql Select Email Query ----> " + Query);
DBHandler dbHandler = new DBHandler();
cn = dbHandler.getConnection();
PreparedStatement st = cn.prepareStatement(Query);
st.setString(1, emailId);
ResultSet rs = st.executeQuery();
while (rs.next()) {
validEmail = rs.getString(1);
}
if (rs != null) {
if (validEmail != null && validEmail != "") {
logger.info("Setting Result If Email Is Present");
result = 1;
}
rs.close();
}
} catch (Exception e) {
logger.error("Error occured ---> " + e);
e.printStackTrace();
throw e;
} finally {
try {
DBHandler.closeConnection(cn);
} catch (Exception ex) {
logger.error("Error occured ---> " + ex);
ex.printStackTrace();
}
}
return result;
}
public int insertUser(NewUserBean usrbean) throws Exception {
logger.info("In checkUserName Data Access Layer");
int result = 0;
Connection cn = null;
try {
logger.info("In Try Method While Inserting Data");
DBHandler dbHandler = new DBHandler();
cn = dbHandler.getConnection();
cn.setAutoCommit(false);
String Query = SQLConstant.INSERT_NEW_USER;
logger.debug("Sql Insert User Query ----> " + Query);
PreparedStatement pst = cn.prepareStatement(Query);
pst.setString(1, usrbean.getName().trim());
pst.setString(2, usrbean.getLastname().trim());
pst.setString(3, usrbean.getEmailId().trim());
pst.setString(4, usrbean.getOtp());
pst.setString(5, usrbean.getPassword());
pst.execute();
cn.commit();
result = 1;
} catch (Exception e) {
logger.error("Error occured ---> " + e);
cn.rollback();
e.printStackTrace();
result = -1;
throw e;
} finally {
try {
DBHandler.closeConnection(cn);
} catch (Exception ex) {
logger.error("Error occured ---> " + ex);
ex.printStackTrace();
}
}
return result;
}