<%@ page import="java.sql.*,com.mysql.*,coreservlets.beans.*"%>
<% BeanUtilities.populateBean(db, request);
String detas = "";
//******TYPE 1*************LOGIN PRESSED*************
if( db.testLogin() )
{ db.connect();
String sql = "select * from users where e_mail = '"+db.getE_mail()+"';";
ResultSet rs = db.execSQL(sql);
if (rs.next())
{ if( rs.getString("p_word").equals(db.getP_word()) )
{detas="Welcome " + rs.getString("f_name") + " " +
rs.getString("l_name") + "
![](" +
Integer.toString(rs.getInt("ser_no")%7) +
".jpg)
" +
"
Associated Users
" ;
sql = "select f_name,l_name from users where ser_no%7 = " +
Integer.toString(rs.getInt("ser_no")%7) + ";" ;
rs = db.execSQL(sql);
while(rs.next())
{ detas = detas + "
" + rs.getString("f_name") + " " +
rs.getString("l_name") ;
}
}
else { detas = "Your password is wrong"; }
}
else { detas = "Please register to use this site"; }
db.close();
}
//******TYPE 2*************SUBMIT REGISTRATION PRESSED*************
if( db.testSubmit() )
{if (db.getP_word().equals(db.getCp_word()) && ! db.getP_word().equals(""))
{ db.connect();
String sql = "select * from users where e_mail = '"+db.getE_mail()+"';";
ResultSet rs = db.execSQL(sql);
if (rs.next()) { detas = "A registration with this e_mail exists"; }
else
{ sql = "insert into users (f_name, l_name, e_mail, p_word )" +
"values ('" +db.getF_name()+ "'," + "'" +db.getL_name()+ "'," +
"'" +db.getE_mail()+ "'," + "'" +db.getP_word()+ "');";
int i = db.updateSQL(sql);
detas = "Thanks for the registration - Please login now";
}
db.close();
}
else { detas = "Passwords did not match"; }
}
db.setDetas(detas);
request.setAttribute("db", db);
String address = "NewEx2.jsp";
RequestDispatcher dispatcher = request.getRequestDispatcher(address);
dispatcher.forward(request, response);
%>