editapp1.jsp

来自「个人主页,包括登陆,注册,后台管理.邮件发送等.」· JSP 代码 · 共 33 行

<%@ page language="java" import="java.sql.*"%>
<%
String regno,name,dob,quali,phone,email,city,state,country,resume,address,expi,sscper,interper,gradper,pgper;
regno=request.getParameter("pass");
name=request.getParameter("name");
dob=request.getParameter("dob");
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= "update registration set name='"+name+"',dob='"+dob+"',qualification='"+quali+"',expi='"+expi+"',address='"+address+"',phone='"+phone+"',email='"+email+"',city='"+city+"',state='"+state+"',country='"+country+"',sscper='"+sscper+"',interper='"+interper+"',gradper='"+gradper+"',pgper='"+pgper+"' where pwd="+regno;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:wsm");
Statement st = c.createStatement();
st.executeUpdate(sql);
out.println("Updated");
response.sendRedirect("confirmpage.jsp?mesg=updated successfully");
//response.sendRedirect("userpage.html");
}catch(Exception e )
{
out.println("error:"+e);
}
%>