日期:2014-05-16 浏览次数:20440 次
<script type="text/javascript" language="javascript">
var xmlHttp = false;
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e2) {
xmlHttp = false;
}
}
if (!xmlHttp && typeof XMLHttpRequest != 'undefined') {
xmlHttp = new XMLHttpRequest();
}
//检测用户名是否存在
function callServerCheckUname() {
//通过GET方法请求,将请求封装在URL中
var uname = document.getElementById("u_name").value;
xmlHttp.open("POST", 'CheckUname?u_name='+uname);
//设置服务器响应的处理方法
xmlHttp.onreadystatechange = updatePageCheckUname;
// 发送请求
xmlHttp.send(null);
}
function updatePageCheckUname() {
if (xmlHttp.readyState == 4) {
var response = xmlHttp.responseText;
if(response >= 1){
alert("用户名已存在!");
}else{
alert("可注册!");
}
}
}
</script><servlet>
<servlet-name>CheckUname</servlet-name>
<servlet-class>servlet.AjaxCheckUname</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CheckUname</servlet-name>
<url-pattern>/CheckUname</url-pattern>
</servlet-mapping>public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=GB2312");
PrintWriter out = response.getWriter();
try {
String uname = request.getParameter("u_name");
RegistDAOImpl regDao = new RegistDAOImpl();
out.print(regDao.checkUname(uname)) ;
} catch (Exception e) {
}
out.flush();
out.close();
}public int checkUname(String uname){
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
int success = 0;
String sql = "select u_name from u_info where u_name='"+uname+"' or u_mobtel='"+uname+"' or u_email='"+uname+"'";
try {
conn = getConnection();
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery(sql);
if(rs.next()){
success = 1;
}
return success;
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return success;
}