dbiomaplist.java

仓库管理系统毕业设计论文最好的参考资料！

package com.qhit.db.instance;

import java.util.List;

import com.qhit.UseException;
import com.qhit.db.DbOper;
import com.qhit.po.IoMapList;
import com.qhit.po.IoMapMain;

public class DbIoMapList extends DbOper {

	public DbIoMapList() throws UseException {
		super();
	}
	
	public int insertL(IoMapList ibl) throws UseException{
		int ret = 0;
		String sql = "insert into out_in_listtab values(?,?,?)";
		Object obj[] = {ibl.getMpid(),ibl.getOiid(),ibl.getOutinnum()};
		ret = this.exeSql(sql, obj);
		return ret;
	}
	
	public int updateL(IoMapList ibl) throws UseException{
		int ret = 0;
		String sql = "update out_in_listtab set oiid = ?,mpid = ?,outinnum = ? where sysid = ?";
		Object obj[] = {ibl.getOiid(),ibl.getMpid(),ibl.getOutinnum(),ibl.getSysid()};
		ret = this.exeSql(sql, obj);
		return ret;
	}
	
	public List queryL(IoMapMain ibm) throws UseException{
		List list = null;
		String sql = "select * from out_in_listtab where oiid = '" + ibm.getOiid() + "'";
		list = this.getQuery(sql, IoMapList.class);
		return list;
	}
	
	public IoMapList getL(IoMapList ibl) throws UseException{
		IoMapList ib = null;
		String sql = "select * from out_in_listtab where sysid = " + ibl.getSysid();
		ib = (IoMapList)this.getARecord(sql, IoMapList.class);
		return ib;
	}
	
	public int deleteL(IoMapList ibl) throws UseException{
		int ret = 0;
		String sql = "delete from out_in_listtab where sysid = " + ibl.getSysid();
		ret = this.exeSql(sql);
		return ret;
	}

}