getvetbyidcommand.java

来自「利用设计模式设计的宠物中心管理系统！分为管理员管理」· Java 代码 · 共 29 行

package vetcommand;
import java.util.*;
import java.sql.*;
import vet.*;
import db.*;
import command.*;

public class GetVetByIdCommand implements ICommand {
	private IDbservice  dbservice;
	private Vet vet;
	public Map execute(Map param) {
		Map map = new HashMap();
		int id = ((Integer)param.get("id")).intValue();
		dbservice = DbserviceFactory.getDbservice();
		String sql = "select * from vet where id = "+id+"";
		ResultSet rs = dbservice.query(sql);
		try {
			if(rs.next()){
				vet = new Vet(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4));
			}
			map.put("vet",vet);
		} catch (Exception e) {
			System.out.println("GetVetByIdCommand.execute:"+e);
		}
		return map;
	}

}