package com.meritit.ysjian.spring3learning.model;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable{
	private static final long serialVersionUID = -5271584436847697641L;

	private int userId;

	private String userName;

	private String password;

	private int credits;

	private String lastIp;

	private Date lastVisit;

	public String getLastIp() {
		return lastIp;
	}

	public void setLastIp(String lastIp) {
		this.lastIp = lastIp;
	}

	public Date getLastVisit() {
		return lastVisit;
	}

	public void setLastVisit(Date lastVisit) {
		this.lastVisit = lastVisit;
	}

	public int getUserId() {
		return userId;
	}

	public void setUserId(int userId) {
		this.userId = userId;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public int getCredits() {
		return credits;
	}

	public void setCredits(int credits) {
		this.credits = credits;
	}

	@Override
	public String toString() {
		return "User [credits=" + credits + ", lastIp=" + lastIp
				+ ", lastVisit=" + lastVisit + ", password=" + password
				+ ", userId=" + userId + ", userName=" + userName + "]";
	}
}

package com.meritit.ysjian.spring3learning.model;
import java.io.Serializable;
import java.util.Date;

public class LoginLog implements Serializable{
	
	private static final long serialVersionUID = -1764224611964600980L;

	private int loginLogId;

	private int userId;

	private String ip;

	private Date loginDate;

	public String getIp() {
		return ip;
	}

	public void setIp(String ip) {
		this.ip = ip;
	}

	public Date getLoginDate() {
		return loginDate;
	}

	public void setLoginDate(Date loginDate) {
		this.loginDate = loginDate;
	}

	public int getLoginLogId() {
		return loginLogId;
	}

	public void setLoginLogId(int loginLogId) {
		this.loginLogId = loginLogId;
	}
	
	public int getUserId() {
		return userId;
	}

	public void setUserId(int userId) {
		this.userId = userId;
	}

	@Override
	public String toString() {
		return "LoginLog [ip=" + ip + ", loginDate=" + loginDate
				+ ", loginLogId=" + loginLogId + ", userId=" + userId + "]";
	}
}

package com.meritit.ysjian.spring3learning.dao;

import com.meritit.ysjian.spring3learning.model.User;

public interface IUserDao {

	/**
	 * 根据用户名和密码获取匹配的个数
	 * @param userName 用户名
	 * @param password 密码
	 * @return 返回匹配的个数
	 */
	public int getMatchCount(final String userName, final String password);

	/**
	 * 根据用户名查找用户
	 * @param userName 用户名
	 * @return 返回用户对象
	 */
	public User findUserByUserName(final String userName);

	/**
	 * 更新登陆信息
	 * @param user 登陆用户
	 */
	public void updateLoginInfo(User user);
}

package com.meritit.ysjian.spring3learning.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.stereotype.Repository;

import com.meritit.ysjian.spring3learning.dao.IUserDao;
import com.meritit.ysjian.spring3learning.model.User;
import com.meritit.ysjian.spring3learning.util.EncryptUtils;

@Repository
// 注解Repository，告诉Spring这是一个仓库
public class UserDao implements IUserDao {

	@Autowired
	// 装配JdbcTemplate，JdbcTemplate在applicationContext.xml中配置了
	private JdbcTemplate jdbcTemplate;

	/**
	 * 根据用户名和密码获取匹配的个数
	 * 
	 * @param userName
	 *            用户名
	 * @param password
	 *            密码
	 * @return 返回匹配的个数
	 */
	public int getMatchCount(final String userName, final String password) {
		String sqlStr = " SELECT count(*) FROM tb_user "
				+ " WHERE user_name =? and password=? ";
		return jdbcTemplate.queryForInt(sqlStr, new Object[] { userName,
				EncryptUtils.encryptByMD5(password) });
	}

	/**
	 * 根据用户名查找用户
	 * 
	 * @param userName
	 *            用户名
	 * @return 返回用户对象
	 */
	public User findUserByUserName(final String userName) {
		String sql = " SELECT user_id,user_name,credits "
				+ " FROM tb_user WHERE user_name =? ";
		final User user = new User();
		jdbcTemplate.query(sql, new Object[] { userName },
				new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						user.setUserId(rs.getInt("user_id"));
						user.setUserName(userName);
						user.setCredits(rs.getInt("credits"));
					}
				});
		return user;
	}

	/**
	 * 更新登陆信息
	 * 
	 * @param user
	 *            登陆用户
	 */
	public void updateLoginInfo(User user) {
		String sql = " UPDATE tb_user SET last_visit=?,last_ip=?,credits=? "
				+ " WHERE user_id =?";
		jdbcTemplate.update(sql, new Object[] { user.getLastVisit(),
				user.getLastIp(), user.getCredits(), user.getUserId() });
	}
}

package com.meritit.ysjian.spring3learning.dao;

import com.meritit.ysjian.spring3learning.model.LoginLog;

public interface ILoginLogDao {

	/**
	 * 记录日志
	 * @param loginLog 日志对象
	 */
	public void insertLoginLog(LoginLog loginLog);
}

package com.meritit.ysjian.spring3learning.dao.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import com.meritit.ysjian.spring3learning.dao.ILoginLogDao;
import com.meritit.ysjian.spring3learning.model.LoginLog;

@Repository
// 注解Repository，告诉Spring这是一个仓库
public class LoginLogDao implements ILoginLogDao {

	@Autowired
	// 装配JdbcTemplate，JdbcTemplate在applicationContext.xml中配置了
	private JdbcTemplate jdbcTemplate;

	/**
	 * 记录日志
	 * 
	 * @param loginLog
	 *            日志对象
	 */
	public void insertLoginLog(LoginLog loginLog) {
		String sql = "INSERT INTO tb_login_log(user_id,ip,login_datetime) "
				+ "VALUES(?,?,?)";
		Object[] args = { loginLog.getUserId(), loginLog.getIp(),
				loginLog.getLoginDate() };
		jdbcTemplate.update(sql, args);
	}      

      
      
    

      

在项目的开发过程中离不开用户名唯一的验证或者邮件唯一的验证.那通过struts2技术是怎么实现,下面以用户名唯一验证案例讲解。

实现效果：

当用户名输入框失去焦点的时候,能够实现用户名唯一的验证

步骤：

  1、设计界面代码

并且引入js文件

2、在util.js文件中封装

     1、通过id获取dom对象的方法

     2、创建XMLHTTPRequest对象的方法

3、在reg.js文件实现 功能

4、创建Action 

   说明：1、封装的name属性是接受 ajax请求传递的name参数

         2、checkName方法就是处理用户名唯一验证的方法. 此方法是在struts.xml文件中通过通配符配置的(详见struts.xml文件)。

5、配置struts.xml文件