package good;

import java.sql.ResultSet;
import java.util.Vector;

public class Imanufacturer {

	/**
	 * @param args
	 */
	private String manufName;
	//private String goodName;
	private String manufPhonenumber;
	private String manufAddress;
	
	
	public String getManufAddress() {
		return manufAddress;
	}


	public void setManufAddress(String manufAddress) {
		this.manufAddress = manufAddress;
	}


	public String getManufName() {
		return manufName;
	}


	public void setManufName(String manufName) {
		this.manufName = manufName;
	}


	public String getManufPhonenumber() {
		return manufPhonenumber;
	}


	public void setManufPhonenumber(String manufPhonenumber) {
		this.manufPhonenumber = manufPhonenumber;
	}


	public boolean ImanufacturerAdd()
	{
		DataConn storCon = new DataConn();
		String addSql = null;
		storCon.dataConnDerectForMySql();
		addSql="Insert into Imanufacturer(imanufname,imanufphonenumber,imanufAddress) values('"+manufName
		+"','"+manufPhonenumber+"','"+manufAddress+"')";
		storCon.executeDerectUpdate(addSql);
		return true;
	}
	public Vector GetAllSupplyName() {
		String quy;
		String temp;
		int i = 0;
		DataConn storCon = new DataConn();
		Vector list = new Vector();
		storCon.dataConnDerectForMySql();
		ResultSet rs = null;
		quy = "select imanufname from Imanufacturer";
		try {
			rs = storCon.executeDerectQuery(quy);

			while (rs.next()) {
				
				temp=rs.getString(1);
				System.out.println(temp);
				list.add(temp==null? "":temp.trim());

			}
		} catch (Exception e) {
			e.printStackTrace();

		}
		return list;

	}


	public boolean checkExist(String text) {
		String quy;
		DataConn storCon = new DataConn();
		ResultSet rs = null;
		storCon.dataConnDerectForMySql();
		quy = "select * from Imanufacturer where imanufname='" + text + "'";
		try {
			rs = storCon.executeDerectQuery(quy);
			if (rs.next()) {
				return false;
			} else {
				return true;
			}
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}


	public boolean checkData() {
		String quy;
		DataConn storCon = new DataConn();
		ResultSet rs = null;
		storCon.dataConnDerectForMySql();
		quy = "select * from Imanufacturer where imanufname='" + this.getManufName() + "'";
		try {
			rs = storCon.executeDerectQuery(quy);
			if (rs.next()) {
				return false;
			} else {
				return true;
			}
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}
  
}