2nd page yanne naහරි ගියේ නැත්නම් අඩාගෙන වරෙන් හදලා දෙන්නම්
Help... 
2nd page yanne naහරි ගියේ නැත්නම් අඩාගෙන වරෙන් හදලා දෙන්නම්
Help... 
Pissu da ban kisi awlak na.. Thanks 10++
දෙවෙනි page එකට යන්නෙ නෑනෙ.. එකම ලෝඩ් වෙනව ඉවරයක් නැතුව.හරි ගියේ නැත්නම් අඩාගෙන වරෙන් හදලා දෙන්නම්


if(fname.equals("") || lname.equals("") || email.equals("") || uname.equals("") || pwd.equals("") ){
out.println("Fill all the fields");
response.setHeader("refresh","2;url=reg.jsp");
}
else if(!pwd.equals(cpwd)) {
out.println("Comfirmation password is mismatch");
response.setHeader("refresh","2;url=reg.jsp");
}
[COLOR=Red]else if()
{
while(rs1.next()){
if(rs1.getString(4).equals(email)){
out.println("Email already registered,try differenet one");
response.setHeader("refresh","2;url=reg.jsp");
break;}
else if(rs1.getString(5).equals(uname)){
out.println("UserName already registered,try differenet one");
response.setHeader("refresh","2;url=reg.jsp");
break;
}
}
}
[/COLOR]
else{
int i = st.executeUpdate("Insert into table1(first_name,last_name,email,uname,pass,regdate) values('"+ fname +"','"+ lname +"','"+ email +"','"+ uname +"','"+ pwd +"',CURDATE())");
if (i > 0)
response.sendRedirect("welcome.jsp");
}
Kooo Programmersla naddooooooooooo
Kooo Programmersla naddooooooooooo
[COLOR="Red"]bool cond = true;
else[/COLOR]
{
while(rs1.next()){
if(rs1.getString(4).equals(email)){
[COLOR="Red"]cond = false;[/COLOR]
out.println("Email already registered,try differenet one");
response.setHeader("refresh","2;url=reg.jsp");
break;}
else if(rs1.getString(5).equals(uname)){
[COLOR="Red"]cond = false;[/COLOR]
out.println("UserName already registered,try differenet one");
response.setHeader("refresh","2;url=reg.jsp");
break;
}
}
}
[COLOR="Red"]if(cond)[/COLOR]
int i = st.executeUpdate("Insert into table1(first_name,last_name,email,uname,pass,regdate) values('"+ fname +"','"+ lname +"','"+ email +"','"+ uname +"','"+ pwd +"',CURDATE())");
if (i > 0)
response.sendRedirect("welcome.jsp");
Code:bool cond = true; else { while(rs1.next()){ if(rs1.getString(4).equals(email)){ [COLOR="Red"]cond = false;[/COLOR] out.println("Email already registered,try differenet one"); response.setHeader("refresh","2;url=reg.jsp"); break;} else if(rs1.getString(5).equals(uname)){ [COLOR="Red"]cond = false;[/COLOR] out.println("UserName already registered,try differenet one"); response.setHeader("refresh","2;url=reg.jsp"); break; } } } [COLOR="Red"]if(cond)[/COLOR] int i = st.executeUpdate("Insert into table1(first_name,last_name,email,uname,pass,regdate) values('"+ fname +"','"+ lname +"','"+ email +"','"+ uname +"','"+ pwd +"',CURDATE())"); if (i > 0) response.sendRedirect("welcome.jsp");
should work i think

what does rs1 variable represent?
ya ya resultsetshould be a resultset i guess![]()

should work i think
Not WorkingYep that should do it![]()

if(fname.equals("") || lname.equals("") || email.equals("") || uname.equals("") || pwd.equals("") ){
cond = false;
out.println("Fill all the fields");
response.setHeader("refresh","2;url=reg.jsp");
}


ya ya resultset
Not Working
after creating boolean variable first if statement not working and inserting null values to db
Code:if(fname.equals("") || lname.equals("") || email.equals("") || uname.equals("") || pwd.equals("") ){ cond = false; out.println("Fill all the fields"); response.setHeader("refresh","2;url=reg.jsp"); }
so after I did same thing to all if statements.thatz mean I added con=false to all the if statements after that it working properly
macho mn me vidiyatama boolean variable ekak nathuva count value ekak dala kala kalin.ethakotath vada.eth bn mata e vidiya nathuva meka vena karanna vidiyak nadda bn??
ekata vada technical scene ekak nadda bn mekata karanna
anyway thanx machooo![]()

ok macho thanxah yeah should add it for all the if conditions.my bad. otherwise it'll just add the data to the database anyway regardless of the message given to the user. no idea about other ways. easiest way for me is this.![]()


ok macho thanx
In this case if declaring more variables like that what happen to efficiency??
Have any idea about dat??I mean in a large system not like my one![]()
ok thanx machodon't think that will effect the efficiency that much. it's just few lines of code.


