Thank you for your reply Rob Spoor
DAO class:
public class loginDAO {
private
String userName;
private String passWord;
public loginDAO(String name, String pass){
this.userName = name;
this.passWord = pass;
}
public boolean validateUser() throws SQLException, ClassNotFoundException {
String url = "jdbc:oracle:thin:@kris-PC:1521:orcl";
//int id = 0;
Connection con = null;
PreparedStatement stmt = null;
//Statement stmt = null;
//ResultSet rs = null;
boolean flag = false;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String query = "select username,password from loginuser where username = ? and password= ?"; //= ? and password = ?";
con = DriverManager.getConnection(url,"scott","tiger");
//stmt = con.createStatement();
stmt = con.prepareStatement(query);
stmt.setString(1, userName);
stmt.setString(2, passWord);
ResultSet rs = stmt.executeQuery();
if(rs.next() == true){
System.out.println("you are in true");
flag = true;
}else{
System.out.println("you are in false");
flag = false;
}
}catch(SQLException e){
System.out.println("++++++"+e.getMessage());
}
System.out.println(flag);
return flag;
}
}
Action class:
public class LoginAction extends Action {
/*
* Generated Methods
*/
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
* @throws Exception
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws Exception {
LoginForm loginForm = (LoginForm)form;// TODO Auto-generated method stub
String userID = loginForm.getUserName();
String pass = loginForm.getPassWord();
loginDAO ld = new loginDAO(userID,pass);
boolean isLogin = ld.validateUser();
if(isLogin == true){
return mapping.findForward("sucess");
}else{
return mapping.findForward("failure");
}
}
}
please go through my code. i could not able to enter into if (rs.next())condition.
could you please let me know the reason and how can i enter into if loop?? plaese let me know asap
I want to do server side login validation so if you guys have any code please share with me
thanking you in advace.
