noncurrentassetsaccess.java

Athena酒店小组_Athena酒店管理系统

/*
 * NonCurrentAssetsAccess.java
 *
 * Created on 2007年6月19日, 上午5:31
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package minco;

import java.sql.*;
import java.util.*;

import plugin.*;
import helper.*;
/**
 *
 * @author mj
 */
public class NonCurrentAssetsAccess 
{
    private IDBResource dbRes;
    
   /**
    * 构造函数
    * @param dbRes 数据库资源
    */
    public NonCurrentAssetsAccess(IDBResource dbRes)
    {
	this.dbRes = dbRes;
    }

   /**
    * 对NonCurrentAssets表进行插入操作
    * @param NonCurrentAssets 要插入的收支情况
    * @return 影响的行数，如果发生错误，则返回-1
    */
    public int insert(NonCurrentAssets nonCurrentAssets)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "INSERT INTO NonCurrentAssets(AsseetTime, TangibleFixedAssets,Depreciation, NetValue, IntangibleFixedAssets, Investments, ConstructionInProgress) " +
		    " VALUES(?, ?, ?, ?, ?, ?, ?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setObject(1, nonCurrentAssets.getAsseetTime());
	    ps.setDouble(2, nonCurrentAssets.getTangibleFixedAssets());
	    ps.setDouble(3, nonCurrentAssets.getDepreciation());
	    ps.setDouble(4, nonCurrentAssets.getNetValue());
	    ps.setDouble(5, nonCurrentAssets.getIntangibleFixedAssets());
	    ps.setDouble(6, nonCurrentAssets.getInvestments());
            ps.setDouble(7, nonCurrentAssets.getConstructionInProgress());
	    
	    int rs = ps.executeUpdate();
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}
    }

   /**
    * 对NonCurrentAssets表进行更新操作
    * @param nonCurrentAssets 要更新的非流动资产信息
    * @return 影响的行数，如果发生错误，则返回-1
    */
    public int update(NonCurrentAssets nonCurrentAssets)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "UPDATE NonCurrentAssets SET TangibleFixedAssets = ?, Depreciation = ?, " +
		    "NetValue= ?, IntangibleFixedAssets = ?, Investments = ?, ConstructionInProgress = ?) " +
		    "WHERE AsseetTime = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);	    
	    	    
	    ps.setDouble(1, nonCurrentAssets.getConstructionInProgress());
	    ps.setDouble(2, nonCurrentAssets.getTangibleFixedAssets());
	    ps.setDouble(3, nonCurrentAssets.getDepreciation());
	    ps.setDouble(4, nonCurrentAssets.getNetValue());
	    ps.setDouble(5, nonCurrentAssets.getIntangibleFixedAssets());
	    ps.setDouble(6, nonCurrentAssets.getInvestments());
            ps.setObject(7, nonCurrentAssets.getAsseetTime());
	    
	    int rs = ps.executeUpdate();
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}
    }

   /**
    * 对NonCurrentAssets表进行删除操作
    * @param nonCurrentAssets 要删除的非流动资产信息
    * @return 影响的行数，如果发生错误，则返回-1
    */
    public int delete(NonCurrentAssets nonCurrentAssets)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "DELETE FROM NonCurrentAssets WHERE AsseetTime = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    
            ps.setObject(1, nonCurrentAssets.getAsseetTime());
	    
	    int rs = ps.executeUpdate();
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}
    }

   /**
    * 根据Time查询NonCurrentAssets表的信息
    * @param AsseetTime 日期
    * @return 查询到的非流动资产信息
    */
    public NonCurrentAssets getNonCurrentAssetsByTime(java.util.Date asseetTime)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM NonCurrentAssets WHERE AsseetTime = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setObject(1, asseetTime);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<NonCurrentAssets> nonCurrentAssets = new ArrayList<NonCurrentAssets>();
	    readData(nonCurrentAssets, rs);
	    if (nonCurrentAssets.size() != 1)
	    {
		return null;
	    }
	    return nonCurrentAssets.get(0);
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}
    }

    /**
     * 返回NonCurrentAssets表的所有信息
     * @return 所有流动资产信息
     */
    public ArrayList<NonCurrentAssets> getAllNonCurrentAssets()
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM NonCurrentAssets";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<NonCurrentAssets> nonCurrentAssets = new ArrayList<NonCurrentAssets>();
	    readData(nonCurrentAssets, rs);
	    return nonCurrentAssets;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}
    }

   /**
    * 根据条件查询NonCurrentAssets表的信息
    * @param names 条件的名称
    * @param values 条件的值
    * @return 查询到的流动资产信息
     */
    public ArrayList<NonCurrentAssets> getNonCurrentAssetsByCondition(ArrayList<String> names, ArrayList<Object> values)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM NonCurrentAssets " + SQLHelper.createCondition(names);
	    PreparedStatement ps = conn.prepareStatement(sql);
	    for(int i = 0; i < values.size(); i++)
	    {
		ps.setObject(i+1, values.get(i));
	    }
	    ResultSet rs = ps.executeQuery();
	    ArrayList<NonCurrentAssets> nonCurrentAssets = new ArrayList<NonCurrentAssets>();
	    readData(nonCurrentAssets, rs);
	    return nonCurrentAssets;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}
    }
    
    //读取数据
    private void readData(ArrayList<NonCurrentAssets> nonCurrentAsset, ResultSet rs) throws SQLException
    {
	while(rs.next())
	{
	    NonCurrentAssets nonCurrentAssets = new NonCurrentAssets();
	    nonCurrentAssets.setAsseetTime(rs.getDate("AsseetTime"));
	    nonCurrentAssets.setTangibleFixedAssets(rs.getDouble("TangibleFixedAssets"));
	    nonCurrentAssets.setDepreciation(rs.getDouble("Depreciation"));
	    nonCurrentAssets.setNetValue(rs.getDouble("NetValue"));
	    nonCurrentAssets.setIntangibleFixedAssets(rs.getDouble("IntangibleFixedAssets"));
	    nonCurrentAssets.setInvestments(rs.getDouble("Investments"));
            nonCurrentAssets.setConstructionInProgress(rs.getDouble("ConstructionInProgress"));
	    nonCurrentAsset.add(nonCurrentAssets);
	}
    }
}