<%@ page language="java" import="java.sql.*" %>
<%
String uid=request.getParameter("uid");
String pass=request.getParameter("pass");
String mail=request.getParameter("mail");
String coll=request.getParameter("coll");
String dep=request.getParameter("dep");
String utype=request.getParameter("utype");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orads","scott","tiger");
Statement st=con.createStatement();
String sql="select userid from WBMSlogin where userid='"+uid+"'";
System.out.println(" Query : "+sql);
ResultSet rs=st.executeQuery(sql);
if(rs.next())
{
out.println(" User ( "+uid+" ) already present
");
out.println(" Please Choose another Name
");
out.println("Create New User");
}
else
{
sql="insert into WBMSlogin values('"+uid+"','"+pass+"','"+mail+"','"+coll+"','"+dep+"','"+utype+"')";
int n=st.executeUpdate(sql);
if(n>0)
{
out.println(" User ( "+uid+" ) Created
");
out.println("");
out.println("");
}
else
{
out.println(" User ( "+uid+" ) Can't be Created
");
}
}
}catch(Exception e)
{
out.println(e);
}
%>