application1.jsp

个人主页,包括登陆,注册,后台管理.邮件发送等.

<%@ page language="java" import="java.sql.*"%>
<%
String regno,name,day,month,year,quali,phone,email,city,state,country,address,expi,sscper,interper,gradper,pgper;
String sql="";
//regno=request.getParameter("regno");
name=request.getParameter("name");
 day=request.getParameter("day");
 month=request.getParameter("month");
 year=request.getParameter("year"); 
quali=request.getParameter("quali");
sscper=request.getParameter("sscper");
interper=request.getParameter("interper");
gradper=request.getParameter("gradper");
pgper=request.getParameter("pgper");
expi=request.getParameter("expi");
address=request.getParameter("address");
email=request.getParameter("email");
phone=request.getParameter("phone");
city=request.getParameter("city");
state=request.getParameter("state");
country=request.getParameter("country");

//String sql= "insert into registration values( '"+name+"','"+dob+"','"+quali+"',"+expi+"','"+address+"','"+phone+"','"+email+"','"+city+"','"+state+"','"+country+"','"+resume+"')";

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:wsm");
Statement st = c.createStatement();
Statement ang = c.createStatement();
ResultSet rs=ang.executeQuery("select * from nums");
rs.next();
String rno=rs.getString(1);
sql= "insert into registration values( '"+name+"','"+day+"-"+month+"-"+year+"','"+quali+"','"+expi+"','"+address+"','"+phone+"','"+email+"','"+city+"','"+state+"','"+country+"','"+rno+"','"+sscper+"','"+interper+"','"+gradper+"','"+pgper+"')";
out.println(sql);
st.executeUpdate("update nums set  rno=1+"+ rno);
out.println("submitted successfull");
st.executeUpdate(sql);
rs.close();
c.close();


response.sendRedirect("confirmpage.jsp?mesg=submitted  successfully <br> with Regno as: "+ rno);

}catch(Exception e )
{
out.println(e);
}
%>