📄 dealrereg.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="shop.logBean"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%!
public String codeString(String s){
String str=s;
try{
byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}catch(Exception e){return str;}
}
%>
<%
if(session.isNew()){
response.sendRedirect("index.jsp");
}
else {
%>
<jsp:useBean id="log" class="shop.logBean" scope="session"/>
<%
String islog=log.getIslog();
if(!islog.equals("true")){
response.sendRedirect("index.jsp");
}
else{
String id,name,pwd,pwdr,sex,mail,addr,call,intr,oldpwd;
//get input
id=log.getId();
name=request.getParameter("name");
if(name==null)name="";
name=codeString(name);
oldpwd=request.getParameter("oldpwd");
if(oldpwd==null)oldpwd="";
oldpwd=codeString(oldpwd);
pwd=request.getParameter("pwd");
if(pwd==null)pwd="";
pwd=codeString(pwd);
pwdr=request.getParameter("pwdr");
if(pwdr==null)pwdr="";
pwdr=codeString(pwdr);
sex=request.getParameter("sex");
if(sex==null)sex="";
sex=codeString(sex);
mail=request.getParameter("mail");
if(mail==null)mail="";
mail=codeString(mail);
addr=request.getParameter("addr");
if(addr==null)addr="";
addr=codeString(addr);
call=request.getParameter("call");
if(call==null)call="";
call=codeString(call);
intr=request.getParameter("intr");
if(intr==null)intr="";
intr=codeString(intr);
//check input
if(
name.equals("")||
oldpwd.equals("")||
pwd.equals("")||
pwdr.equals("")||
sex.equals("")||
mail.equals("")||
addr.equals("")||
call.equals("")
){
//out.println("<center><font color=#FF0000>输入不能为空!</font><br></center>");
response.sendRedirect("rereg.jsp");
}
else if(!pwd.equals(pwdr)){
//out.println("<center><font color=#FF0000>两次密码不同!</font><br></center>");
response.sendRedirect("rereg.jsp");
}
else if(mail.indexOf('@',0)==-1||mail.indexOf('.',0)==-1||mail.length()<6){
//out.println("<center><font color=#FF0000>电邮地址有错!</font><br></center>");
response.sendRedirect("rereg.jsp");
}
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:myshop","","");
Statement sql = con.createStatement();
String condition="select * from user where id="+"'"+id+"'";
ResultSet rs=sql.executeQuery(condition);
if(!rs.next()){
con.close();
//out.println("<center><font color=#FF0000>没有这个用户!</font><br></center>");
response.sendRedirect("index.jsp");
}
else{
String temp=rs.getString("pwd");
if(!temp.equals(oldpwd)){
//out.println("<center><font color=#FF0000>密码不正确!</font><br></center>");
response.sendRedirect("rereg.jsp");
}
else{
PreparedStatement pstmt=con.prepareStatement("update user set pwd=? ,sex=? ,name=? ,mail=? ,intr=? ,call=? ,addr=? where id=?");
pstmt.setString(8,id);
pstmt.setString(3,name);
pstmt.setString(1,pwd);
pstmt.setString(2,sex);
pstmt.setString(4,mail);
pstmt.setString(7,addr);
pstmt.setString(6,call);
pstmt.setString(5,intr);
pstmt.executeUpdate();
pstmt.close();
con.close();
//out.println("<center><font color=#FF0000>修改成功!</font><br></center>");
response.sendRedirect("search.jsp");
}
}
}catch(SQLException e){
response.sendRedirect("index.jsp");
}catch(ClassNotFoundException e){
response.sendRedirect("index.jsp");
}
}
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -