ngo signup

package mypack;

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DisplayServlet extends HttpServlet
{

	public void doGet( HttpServletRequest request , HttpServletResponse response ) throws IOException,ServletException
	{
		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 id = request.getParameter("id");
			String required = request.getParameter("required");
			String password = request.getParameter("password");
			String website = request.getParameter("website");

			PreparedStatement ps = con.PreparedStatement("insert into users values(?,?,?,?,?)");
			ps.setString(1,id);
			ps.setString(2,name);
			ps.setString(3,password);
			ps.setString(4,required);
			ps.setString(5,website);

			if(!userExists(id,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 id,Connection con)
	{
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("select * from users where id="+id);

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