orderexeoperation.java

该源代码实现了系统的进货

package operation;

import java.sql.ResultSet;
import dataBase.DataBase;

public class OrderExeOperation
{
	private ResultSet rs;
	private DataBase db;
	public OrderExeOperation()
	{
		db=new DataBase();
	}
	public int getAttribute(String OrderID,String Index)
	{
		int a=0;
		String sql="select * from OrderList where OrderID='"+OrderID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			a=rs.getInt(Index);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return a;
	}
	public void OrderChange(String OrderID)
	{
		String sql="Update OrderList set OrderState='已执行' where OrderID='"+OrderID+"'";
		try
		{
			db.ExeQuery(sql);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void close()
	{
		db.close();
	}
}