clientbusiness.java

来自「企业进销存源码」· Java 代码 · 共 97 行

package com.business;
import java.util.HashMap;
import java.util.List;

import com.business.vo.Client;
import com.dao.util.DaoImp;
import com.web.util.WebTools;
/**
 * @author Administrator
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class ClientBusiness {
	public String getNameById(String id) throws Exception {
		try {
			String str = "select name from client where id = " + id;
			DaoImp dao = new DaoImp();
			return WebTools.showEx(dao.find(str).get("NAME"));
		} catch (Exception e) {
			return "";
		}
	}

	public void add(Client vo) throws Exception {
		try {
			String str =
				"insert into Client(name,address,tel,type,memo) values('"
					+ vo.getName()
					+ "','"
					+ vo.getAddress()
					+ "','"
					+ vo.getTel()
					+ "','"
				    + vo.getType()
				    + "','"
					+ vo.getMemo()
					+ "')";
			DaoImp dao = new DaoImp();
			dao.insert(str);
		} catch (Exception e) {
			throw e;
		}
	}
	public void edit(Client vo) throws Exception {
		try {
			String str =
				"update client set name = '"
					+ vo.getName()
					+ "',address = '"
					+ vo.getAddress()
					+ "',tel = '"
					+ vo.getTel()
					+ "',type = '"
					+ vo.getType()
					+ "',memo = '"
					+ vo.getMemo()
					+ "' where Id = "
					+ vo.getId();
			DaoImp dao = new DaoImp();
			dao.insert(str);
		} catch (Exception e) {
			throw e;
		}
	}
	public void remove(Client vo) throws Exception {
		try {
			String str = "delete from Client where Id = " + vo.getId();
			DaoImp dao = new DaoImp();
			dao.insert(str);
		} catch (Exception e) {
			throw e;
		}
	}

	public HashMap find(String key) throws Exception {
		try {
			String str = "select * from Client where Id = " + key + "";
			DaoImp dao = new DaoImp();
			return dao.find(str);
		} catch (Exception e) {
			return null;
		}
	}
	public List select()throws Exception {
		try {
			String str = "select TOP 9 * from Client order by id desc";
			DaoImp dao = new DaoImp();
			return dao.select(str);
		} catch (Exception e) {
			return null;
		}
	}
}