assetdao.java

固定资产管理系统包括一个基本的部分

package com.shenlong.assetmanage.dao;

import java.sql.SQLException;
import java.util.List;

import com.shenlong.assetmanage.domain.Asset;



public interface AssetDao {
	
	
	public Asset queryAssetById(int id) throws SQLException;
	
	
	public int saveNewAsset (Asset asset) throws SQLException;
	
	
	public List<Asset> queryAssetByName(String name) throws SQLException;
	
	
	public List<Asset> queryAssetByName(String name, int page, int total) throws SQLException;
	
	
	public int getAssetCountByName(String name) throws SQLException;
	
	
	
	public List<Asset> queryAssetByClass(int class2Id, int page, int total) throws SQLException;
	
	
	public int getAssetCountByClass(int class2Id) throws SQLException;
	
	
	public int getAssetCountByEmpName(String empName) throws SQLException;
	
	
	public List<Asset> queryAssetByEmpName(String empName, int page, int total) throws SQLException;
	
	
	public int modifyAsset(Asset asset) throws SQLException;
	
	
	public int deleteAssetById(int id) throws SQLException;
	
	
	public int updateEmpId(int assetId, int empId) throws SQLException;
}