material.java

简单的餐厅管理系统

package beans;

import java.sql.ResultSet;
import java.sql.SQLException;

import util.AddZeroAhead;
import util.BaseSQL;

public class Material {

	private String materialID = "";
	private String name = "";
	private float weight = 0;

	public String getMaterialID(){
		return materialID;
	}
	
	public String getName(){
		return name;
	}
	
	public float getWeight(){
		return weight;
	}
	
	public void setMaterialID(String newID){
		 materialID = AddZeroAhead.addZeroAhead(newID,8);
	}
	
	public void setName(String newName){
		name = newName;
	}
	
	public void setWeight(float ght){
		weight = ght;
	}
	
	public String getMaterialData(String materialID){
		materialID = AddZeroAhead.addZeroAhead(materialID, 8);
		BaseSQL b = new BaseSQL();
		try {
			b.connect("eatery", "root", "123456");

			ResultSet rs = b.statement.executeQuery(
					"select * from material where materialID = '"+materialID+"'");
			if(rs.next()){
				this.name = rs.getString(2);
			}else{

				return "材料不存在！";
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block

			return "数据库操作出错！";
		} catch (Exception e) {
			// TODO Auto-generated catch block

			return "出现未知错误！";
		} finally {
			try {
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block

			}
		}
		return null;
	}
	
	public String getData(String dishID, String materialID){
		dishID = AddZeroAhead.addZeroAhead(dishID, 8);
		materialID = AddZeroAhead.addZeroAhead(materialID, 8);
		BaseSQL b = new BaseSQL();
		try {
			b.connect("eatery", "root", "123456");

			ResultSet rs = b.statement.executeQuery(
					"select * from dish_material,material " +
					"where dishID = '"+dishID+"' and material.materialID = '"+materialID+"'" +
					" and dish_material.materialID = material.materialID");

			if(rs.next()){
				setMaterialID(rs.getString(2));
				setWeight(rs.getFloat(3));
				setName(rs.getString(5));
			}else{
				b.close();
				return "数据库中不存在该项！";
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block

			return "数据库操作出错！";
		} catch (Exception e) {
			// TODO Auto-generated catch block

			return "出现未知错误！";
		} finally {
			try {
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
			}
		}
		return null;
	}
	
	public String addNewMaterial(){
		BaseSQL b = new BaseSQL();
		try {
			b.connect("eatery", "root", "123456");

			ResultSet rs = b.statement.executeQuery(
				"select materialID from material where materialName = '"+name+"'");
			if(rs.next()){

				return "菜名已经存在！无法添加！";
			}
			rs = b.statement.executeQuery(
				"select materialID from material");
			
			materialID = "00000001";

			while(rs.next()){
				if(Integer.parseInt(materialID) == Integer.parseInt(rs.getString(1))){
					materialID = Integer.parseInt(materialID)+1+"";
				}
			}
			materialID = AddZeroAhead.addZeroAhead(materialID, 8);

			b.connection.setAutoCommit(false);
			b.statement.executeUpdate("insert into material values ('"
				+materialID+"','"+name+"')");

			b.connection.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			try {
				b.connection.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
			} 
			return "数据库操作出错！";
		} catch (Exception e) {
			// TODO Auto-generated catch block
			try {
				b.connection.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
			} 
			return "出现未知错误！";
		} finally {
			try {
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
			}
		}
		return null;
	}
	
	public boolean equals(String compare){
		if(Integer.parseInt(materialID)==Integer.parseInt(compare)){
			return true;
		}else{
			return false;
		}
	}

	public String delete() {
		// TODO Auto-generated method stub
		BaseSQL b = new BaseSQL();
		try {
			b.connect("eatery", "root", "123456");

			ResultSet rs = b.statement.executeQuery("select materialID from material where materialID = '"+materialID+"'");
			if(rs.next()){
				b.statement.executeUpdate("delete from material where materialID = '"+materialID+"'");
				return null;
			}else{
				return "不存在该主料！";
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return "数据库操作出错！";
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return "出现未知错误！";
		} finally {
			try {
				b.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block

			}
		}
	}
}