userinfodaoimpl.java

java开发的系统,主要用SS框架,以供大家研究和参考学习.

package com.fpms.wwyz.model.dao.sysManage.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.fpms.wwyz.model.dao.sysManage.IUserInfoDAO;
import com.fpms.wwyz.vo.sysManage.UserInfoVO;

public class UserInfoDAOImpl extends JdbcDaoSupport implements IUserInfoDAO {
	private Log log = LogFactory.getLog(UserInfoDAOImpl.class);

	public List<UserInfoVO> findUserNameAndPassword(String username,
			String password) {
		log.info("find username and password");
		try {
			String sql = "select uuid,username,password from user_info where username='"
					+ username + "and password='" + password + "'";
			final List<UserInfoVO> userList=new ArrayList<UserInfoVO>();
			getJdbcTemplate().query(sql, new RowCallbackHandler(){
				public void processRow(ResultSet rs) throws SQLException {
					UserInfoVO userInfoVO=new UserInfoVO();
					userInfoVO.setUuid(rs.getInt("uuid"));
					userInfoVO.setUsername(rs.getString("username"));
					userInfoVO.setPassword(rs.getString("password"));
					userList.add(userInfoVO);
				}
				
			});
			return userList;
		} catch (RuntimeException e) {
            log.error("find falied");
            throw e;
		}
	}

}