storage.java

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

package TeaWeb;

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

public class Storage {

	public Storage()
	{

	}
	public ResultSet getStorage(StorageDetail obj)  //查询
	{
		ResultSet rs = null;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Select * From Storage Where (Code = ?) Or (Name = ?) Or (Capability = ?)Or(StorID=?)");
		   pstms.setString(1, obj.Code);
		   pstms.setString(2, obj.Name);
		   pstms.setInt(3, obj.Capability);
		   pstms.setInt(4,obj.StorID);
		   rs = pstms.executeQuery();

		}
		catch(Exception e)
		{
			rs = null;
		}
		return rs;
	}

	public boolean addStorage(StorageDetail obj)   //添加
	{
		boolean Result = false;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Insert into Storage Values(Seq_Storage.NextVal,?,?,?,sysdate)");
		   pstms.setString(1, obj.Code);
		   pstms.setString(2, obj.Name);
		   pstms.setInt(3, obj.Capability);
		   Result = pstms.execute();
		   pstms.close();
		   db.cn.close();

		}
		catch(Exception e)
		{
			Result = false;
		}
		return Result;
	}

	public boolean updateStorage(StorageDetail obj)  //修改
	{
		boolean Result = false;
		try
		{
		   OracleHepler db = new OracleHepler();
		   PreparedStatement pstms = db.getconnection().prepareStatement("Update Storage Set Name=?,Capability=? Where Code = ?");
		   pstms.setString(1, obj.Name);
		   pstms.setInt(2, obj.Capability);
		   pstms.setString(3, obj.Code);
		   Result = pstms.execute();
		   pstms.close();
		   db.cn.close();
		}
		catch(Exception e)
		{
			Result = false;
		}
		return Result;
	}

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

}