getallvetcommand.java

利用设计模式设计的宠物中心管理系统！分为管理员管理

package vetcommand;
import java.util.*;
import java.sql.*;

import vet.*;
import db.*;
import command.*;


public class GetAllVetCommand implements ICommand
{
	private IDbservice  dbservice;
	private Vet vet;
	public Map execute(Map param) {
		Map map = new HashMap();
		List list = new ArrayList();
		dbservice = DbserviceFactory.getDbservice();
		String sql = "select * from vet";
		ResultSet rs = dbservice.query(sql);
		try {
			while(rs.next()){
				vet = new Vet(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4));
				list.add(vet);
			}
			map.put("list",list);
		} catch (Exception e) {
			System.out.println("GetAllVetCommand.execute:"+e);
		}
		return map;
	}
}