src/com/drugsp/dao/impl/UserDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.drugsp.dao.impl;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.drugsp.bean.User;
import com.drugsp.dao.UserDao;
import com.drugsp.util.DB_util;

public class UserDaoImpl implements UserDao{
	DB_util du=new DB_util();
	
	private List<User> mapToUser(String sql,Object[] obj){
		List<User> users=new ArrayList<>();
		List<Map<String,String>> maps=du.select(sql, obj);
		for (Map<String, String> m : maps) {
			User u=new User();
			u.setUid(Integer.parseInt(m.get("u_id")));
			u.setUname(m.get("u_name"));
			u.setUpassword(m.get("u_password"));
			u.setUrealname(m.get("u_realname"));
			u.setUage(m.get("u_age"));
			u.setUsex(m.get("u_sex"));
			u.setUtel(m.get("u_tel"));
			users.add(u);
		}
		return users;
	}

	@Override
	public User getLogin(String loginname, String password) {
		String sql ="select * from d_user where u_name=?and u_password=?";
		Object[] obj = {loginname,password};
		List<User> user=mapToUser(sql, obj);
		if (user!=null&&user.size()>0) {
			return user.get(0);
		} else {
			return null;
		}
	}

	@Override
	public int getCount() {
		String sql="select count(*) from d_user";
		List<Map<String, String>> list=du.select(sql, null);
		if (list!=null && list.size()>0) {
			return Integer.parseInt(list.get(0).get("count(*)"));
		} else {
			return 0;
		}
	}

	@Override
	public List<User> selectUserBylimit(int b, int l) {
		String sql ="SELECT * FROM d_user limit ? ,?";
		Object[] obj = {b,l};
		List<User> users=mapToUser(sql, obj);
		return users;
	}