area.java

一个网站的系统主要是jsp的进存销的系统

package TeaWeb;

import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Area {

	public Area()
	{
		//
	}
	public ResultSet getArea(AreaDetail obj)  //查询
	{
		ResultSet rs = null;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Select * From Area Where (Code = ?) Or (Country = ?) Or (Province = ?) Or (City = ?) Or(AreaID=?)");
		   pstms.setString(1, obj.Code);
		   pstms.setString(2, obj.Country);
		   pstms.setString(3, obj.Province);
		   pstms.setString(4, obj.City);
		   pstms.setInt(5, obj.AreaID);
		   rs = pstms.executeQuery();
		}
		catch(Exception e)
		{
			rs = null;
		}
		return rs;
	}

	public boolean addArea(AreaDetail obj)   //添加
	{
		boolean Result = false;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Insert into Area Values(Seq_Area.NextVal,?,?,?,?)");
		   pstms.setString(1, obj.Code);
		   pstms.setString(2, obj.Country);
		   pstms.setString(3, obj.Province);
		   pstms.setString(4, obj.City);
		   Result = pstms.execute();
		   pstms.close();
		   db.cn.close();
		}
		catch(Exception e)
		{
			Result = false;
		}
		return Result;
	}

	public boolean updateArea(AreaDetail obj)  //修改
	{
		boolean Result = false;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Update Area Set Country=?,Province=?,City=? Where Code = ?");
		   pstms.setString(1, obj.Country);
		   pstms.setString(2, obj.Province);
		   pstms.setString(3, obj.City);
		   pstms.setString(4, obj.Code);
		   Result = pstms.execute();
		   pstms.close();
		   db.cn.close();
		}
		catch(Exception e)
		{
			Result = false;
		}
		return Result;
	}

	public boolean delArea(AreaDetail obj)  //删除
	{
		boolean Result = false;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Delete Area Where AreaID = ?");
		   pstms.setInt(1, obj.AreaID);
		   Result = pstms.execute();
		   pstms.close();
		   db.cn.close();
		}
		catch(Exception e)
		{
			Result = false;
		}
		return Result;
	}
}