<%
String fac_user_id = request.getParameter("fac_user_id");
String fac_password = request.getParameter("fac_password");
String fac_name = request.getParameter("fac_name");
if(fac_user_id !=null && fac_password !=null)
{
rs=st.executeQuery("select username,password from adminfac where username='"+fac_user_id+"' and password ='"+fac_password+"'");
if(!rs.next())
{
rs = st.executeQuery("select max(id)+1 from adminfac");
rs.next();
int i= rs.getInt(1);
st.executeUpdate("insert into adminfac (id,name, username, password) values ("+i+",'"+ fac_name +"','" +fac_user_id +"','" +fac_password+"')");
response.sendRedirect("faccrtsuc.jsp?fac_user_id="+fac_user_id +"&"+fac_password);
}else
{
%>
User
Id already Exist, Please try with another
<%
}
}
%>
