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

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

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

package com.drugsp.dao.impl;

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

import com.drugsp.bean.Admin;
import com.drugsp.bean.Shops;
import com.drugsp.bean.User;
import com.drugsp.dao.ShopsDao;
import com.drugsp.util.DB_util;

public class ShopsDaoImpl implements ShopsDao{
	DB_util du=new DB_util();
	
	private List<Shops> mapToShops(String sql,Object[] obj){
		List<Shops> shops=new ArrayList<>();
		List<Map<String,String>> maps=du.select(sql, obj);
		for (Map<String, String> m : maps) {
			Shops s=new Shops();
			s.setSid(Integer.parseInt(m.get("s_id")));
			s.setSname(m.get("s_name"));
			s.setSpassword(m.get("s_password"));
			s.setSrealname(m.get("s_realname"));
			s.setStel(m.get("s_tel"));
			shops.add(s);
		}
		return shops;
	}

	@Override
	public Shops getLogin(String loginname, String password) {
		String sql ="select * from d_shops where s_name=?and s_password=?";
		Object[] obj = {loginname,password};
		List<Shops> shop=mapToShops(sql, obj);
		if (shop!=null&&shop.size()>0) {
			return shop.get(0);
		} else {
			return null;
		}
	}

	@Override
	public int getCount() {
		String sql="select count(*) from d_shops";
		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<Shops> selectShopsBylimit(int b, int l) {
		String sql ="SELECT * FROM d_shops limit ? ,?";
		Object[] obj = {b,l};
		List<Shops> shops=mapToShops(sql, obj);
		return shops;
	}