部分代码如下:
if(re.getConnection()){
String sql="select Userid from Users where Username='"+Username+"'";
System.out.println(sql);
re.query(sql);
//boolean b=re.next();
System.out.println(re.next());
//System.out.println(sql);
if(re.next()){//用户名已存在
System.out.println("4");
w="1";
request.setAttribute("w", w);
request.getRequestDispatcher("../register.jsp").forward(request, response);;
}
else if(w=="0"){//用户名未被占用
System.out.println(uid);
String sql1="insert into Users values('"+uid+"','"+Username+"','"+Realname+"','"+Password+"','"+Email+"','"+Tel+"','user')";
//System.out.println(sql1);
re.update(sql1);
request.setAttribute("w", w);
request.getRequestDispatcher("../login.jsp").forward(request, response);
}
}
结果如图: