当前位置:我的异常网» Java Web开发 » while/if嵌套有关问题或者什么原因麻烦高手看下,
while/if嵌套有关问题或者什么原因麻烦高手看下,
www.myexceptions.net 网友分享于:2013-02-27 浏览:17次
求助:while/if嵌套问题或者什么原因麻烦高手看下,急!!!!!!
zhuce2
String username=request.getParameter( "username ");
String cardno=request.getParameter( "cardno ");
String password=request.getParameter( "password ");
String sex=request.getParameter( "sex ");
String question=request.getParameter( "question ");
String answer=request.getParameter( "answer ");
String email=request.getParameter( "email ");
String qq=request.getParameter( "qq ");
if(username==null||cardno==null||password==null||sex==null||question==null||answer==null||email==null||qq==null){
%>
注册失败!因为注册项不能为空!
}
else{
byte b[]=sex.getBytes( "ISO-8859-1 ");
sex=new String(b);
byte c[]=question.getBytes( "ISO-8859-1 ");
question=new String(c);
byte d[]=answer.getBytes( "ISO-8859-1 ");
answer=new String(d);
CONTROLDB con=new CONTROLDB();
String sql2= "select * from user ";
int i=0;
int j=0;
ResultSet rs=con.executeQuery(sql2);
while(rs.next()){
if((rs.getString( "username ")).equals(username)){
i=1;
}
if((rs.getString( "cardno ")).equals(cardno)){j=1;}
}
if(i==0){ if(j==0){
String sql= "insert into user(username,password,sex,question,answer,email,qq,cardno) values( ' "+username+ " ', ' "+password+ " ', ' "+sex+ " ', ' "+question+ " ', ' "+answer+ " ', ' "+email+ " ', ' "+qq+ " ', ' "+cardno+ " ') ";
con.executeUpdate(sql);
con.close();
response.sendRedirect( "register.jsp ");
}
}
else if(i==1){
%>
用户名已经存在!注册失败!
}
else {
%>
卡号已经存在!注册失败!
}
}
%>
文章评论