前台
index.jsp
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
留学生系统var XMLHttpReq = false;
function createXMLHttpRequest(){
if(window.XMLHttpRequest){
XMLHttpReq = new XMLHttpRequest();
}else if(window.ActiveXObject){
try{
XMLHttpReq = new ActiveXObject("MSXML2.XMLHTTP");
}catch(e){
try{
XMLHttpReq = new ActiveXObject("Mircsoft.XMLHTTP");
}catch(e1){}
}
}
}
function sendRequest(url){
createXMLHttpRequest();
XMLHttpReq.open("GET",url,true);
XMLHttpReq.onreadystatechange = processResponse;
XMLHttpReq.send(null);
}
function processResponse(){
if(XMLHttpReq.readyState == 4){
if(XMLHttpReq.status == 200){
var res = XMLHttpReq.responseXML.getElementsByTagName("res")[0].firstChild.data;
window.alert(res);
document.myform.userid.value="";
document.myform.pwd.value="";
}else{
window.alert("你请求的页面有异常1");
}
}
}
function userCheck(){
var userid = document.myform.userid.value;
var pwd = document.myform.pwd.value;
if(userid == ""){
window.alert("用户名不能为空");
document.myform.pwd.value="";
document.myform.userid.focus();
return false;
}else{
sendRequest("login?userid="+userid);
}
}
function pwdCheck(){
var pwd = document.myform.pwd.value;
var pwd2 = document.myform.pwd2.value;
if(pwd!=pwd2){
window.alert("密码不一致");
document.myform.pwd.value="";
document.myform.pwd2.value="";
document.myform.pwd.focus();
return false;
}
}
|
用户名 | |
真实姓名 | |
性别 | 男 女 |
密码 | |
密码确认 | |
电子邮箱 | |
学校 | |
电话号码 | |
后台连接MySql数据库
DB.java
package com.common;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class DBConfig
{
public static boolean inited = false;
public static DataSource ds = null;
public static void Init()
{
InitialContext localInitialContext;
try
{
localInitialContext = new InitialContext();
ds = (DataSource)localInitialContext.lookup("java:/comp/env/jdbc/saDB");
inited = true;
}
catch (Exception exception)
{
System.err.println("DBConfig (): " + exception.getMessage());
exception.printStackTrace();
}
}
public static Connection getConn()
{
if (!(inited))
Init();
try
{
return ds.getConnection();
}
catch (SQLException localSQLException)
{
System.err.println("getConn ():" + localSQLException.getMessage());
localSQLException.printStackTrace(System.err);
Init();
}
return null;
}
}
接受request和回应response
LoginAction.java
package com.common;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginAction extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
//TODO Auto-generated method stub req.setCharacterEncoding("UTF-8");
String userid = req.getParameter("userid");
resp.setContentType("text/xml;charset=UTF-8");
resp.setHeader("Cache-Control", "no-cache");
PrintWriter out = resp.getWriter();
out.println("");
DB db = new DB();
ResultSet rs;
String strSql = null;
strSql = "select * from users where user_id='" + userid + "';";
rs = db.executeQuery(strSql);
try{
if(rs.next()){
out.println("" + "用户名已存在" + "");
}else{
out.println("");
}
}catch(SQLException e){
e.printStackTrace();
}
out.println("");
out.close();
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
//TODO Auto-generated method stub super.doGet(req, resp);
}
@Override
public void init(ServletConfig config) throws ServletException {
//TODO Auto-generated method stub }
}
注意编码最好是UTF-8,GBK会出错?(搞了一个晚上也没搞明白)