用户通过表单输入的用户名,通过ajax传送到后台给servlet程序检查用户名是否存在,不言而喻涉及到的内容有:ajax,html语言,js,servlet,后台数据库的连接,查询操作语句。可谓小功能大内容!
部分代码粘贴如下:
AJAX:
var xmlHttp=null;
function ajaxFunction()
{
var xmlHttp = null;
try
{
// Firefox, Opera 8.0+,
Safari
xmlHttp=new
XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e)
{
alert("您的浏览器不支持AJAX!");
}
}
}
return xmlHttp;
}
function ajaxTest()
{
xmlHttp = ajaxFunction();
var
url="\LoginCl1?username="+document.getElementByIdx("username").value;
xmlHttp.open("GET",url,true);
xmlHttp.onreadystatechange=renderajax;
xmlHttp.send(null);
}
function renderajax()
{
if(xmlHttp.readyState==4)
{
alert("ok3");
document.getElementByIdx("test").innerHTML=xmlHttp.responseText;
}
}
name="myForm">
用户:
id="username" />
id="test">
οnclick="ajaxTest();"/>
SERVLET:
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.gem.model.UserOper;
import com.gem.vo.User;
public class LoginCl1 extends HttpServlet {
public void
doGet(HttpServletRequest request, HttpServletResponse
response)
throws
ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriter out =
response.getWriter();
String uname =
request.getParameter("username");
User us = new User();
us.setUname(uname);
UserOper uo = new
UserOper();
if(uo.checkus(uname))
{
out.println("user
been used!");
}
else out.println("ok,go
on!");
}
连接数据库:
import java.sql.Connection;
import java.sql.DriverManager;
public class DBCon {
public Connection
getConnection(){
Connection con = null ;
try {
Class.forName("com.mysql.jdbc.Driver");
String url =
"jdbc:mysql://localhost:3306/user";
String uname
= "root";
String upass
= "xal";
con =
DriverManager.getConnection(url, uname, upass);
//System.out.println("=====ok");
} catch (Exception e) {
// TODO
Auto-generated catch block
e.printStackTrace();
}
return con;
}
}