www.pudn.com > BeiJie.rar > 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(); 
	} 
}