import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Signup extends HttpServlet
{
Connection con = null;
Statement st,st1,st2;
ResultSet rs,rs1;
PreparedStatement ps;
private ServletOutputStream sos;
private String s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11,s12;
int fc=0;
public void init(ServletConfig sc)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
doPost(req,res);
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
{
try
{
con = DriverManager.getConnection("jdbc:odbc:globalleafs","user","password");
st = con.createStatement();
sos = res.getOutputStream();
s1 = req.getParameter("T1");
s2 = req.getParameter("T2");
s3 = req.getParameter("T3");
s4 = req.getParameter("T4");
s5 = req.getParameter("T5");
s6 = req.getParameter("T6");
s7 = req.getParameter("T7");
s8 = req.getParameter("T8");
s9 = req.getParameter("T9");
s10 = req.getParameter("T10");
s11 = req.getParameter("T11");
st2=con.createStatement();
rs1=st2.executeQuery("select max(slno)+1 from Register");
if(rs1.next())
{
fc=rs1.getInt(1);
}
//st2.close();
//rs1.close();
rs = st.executeQuery("select * from Register where username='"+s9+"' ");
sos.println("");
sos.println("Globalleafs- SignUp");
sos.println("");
sos.println("");
if(rs.next())
{
sos.println("Sorry the user already exists
");
printContent();
}
else if(s10 == null || s11 == null || !(s10.equals(s11)))
{
sos.println("Please type both the passwords same
");
printContent();
}
else
{
//sos.println("insert into Register values("+fc+",'"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"',"+s6+","+s7+",'"+s8+"','"+s9+"','"+s10+"','"+s11+"')");
int x = st.executeUpdate("insert into Register values("+fc+",'"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"',"+s6+","+s7+",'"+s8+"','"+s9+"','"+s10+"','"+s11+"')");
//sos.println("");
sos.println("Registered Successfully");
sos.println("");
}
//sos.println("");
sos.println("");
st.close();
//sos.println("st is closed");
//con.close();
rs.close();
//sos.println(" rs is closed");
}
catch(Exception e)
{
//System.out.println(e);
e.printStackTrace();
try{
res.sendRedirect("http://www.globalleafs.com/Error.html");
}catch(Exception ex){ex.printStackTrace();}
}
}
public void printContent() throws java.io.IOException
{
sos.println("");
sos.println("Globalleafs- SignUp");
sos.println("");
sos.println("Globalleafs.com Sign-Up Page
");
sos.println("");
sos.println("
");
sos.println("© 2002 www.globalleafs.com All Rights reserved
");
sos.println("The use of this Web site constitutes acceptance of globalleafs.com's
");
sos.println("Terms and Conditions");
sos.println("and Privacy Policy");
sos.println("
");
sos.println("");
}
//sos.println("");
}