signup

res.setContentType("text/html");
		PrintWriter out = res.getWriter();

		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE" , "system" , "connect");

			String name = request.getParameter("name");
			String userName = request.getParameter("userName");
			String email = request.getParameter("email");
			String password = request.getParameter("password");
			String mobile = request.getParameter("mobile");

			PreparedStatement ps = con.PreparedStatement("insert into users values(?,?,?,?,?)");
			ps.setString(1,userName);
			ps.setString(2,name);
			ps.setString(4,email);
			ps.setString(3,password);
			ps.setString(5,mobile);

			if(!userExists(userName,con))
			{
				int i = ps.executeUpdate();
				if(i>0)
				{
					out.println("Account created")
				}
				HttpSeesion session = request.getSession();
				session.setAttribute("userName",userName);
				res.sendRedirect();
			}
			else
			{
				out.println("account already exists");
			}
		}
		catch(Exception e)
		{}
	}

	boolean userExists(String userName,Connection con)
	{
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("select * from users where username="+userName);

		if(rs.next())
		{
			return true
		}
		else
		{
			return false;
		}
	}