userdaoimpl.java

JAVA E拍网上购物业务管理 使用CRM业务流程

package org.ch02zf.dao.daoImpl;

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

import javax.servlet.jsp.jstl.sql.Result;

import org.ch02zf.dao.UserDao;
import org.ch02zf.entity.USER;

public class UserDaoImpl implements UserDao {

	public USER validateUser(String username, String password) {
		// TODO Auto-generated method stub
		
		CommonDao cd = new CommonDao();
		cd.setConn(BasicDao.getCon());
		String sql = "select * from tbl_user where uname=? and upass=? ";
		cd.setSqlvalue(sql);
		List<String> list = new ArrayList<String>();
		list.add(username);
		list.add(password);
		cd.setValues(list);
		Result rs = null;
		USER user = new USER();
		try {
			rs = cd.executeQuery();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if(null != rs && rs.getRowCount()>0)
		{
			user.setUid((Integer)rs.getRows()[0].get("uid"));
			user.setUname((String)rs.getRows()[0].get("uname"));
			user.setUpass((String)rs.getRows()[0].get("upass"));
		}
		
			return user;
	}
	

}