dbmap.java

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

package com.qhit.db.instance;

import java.util.List;

import com.qhit.UseException;
import com.qhit.Utils;
import com.qhit.db.DbOper;
import com.qhit.po.Map;

public class DbMap extends DbOper {


	public DbMap() throws UseException {
		super();
	}
	//封装与数据库的操作
	
	public int insert(Map map)throws UseException{
		int ret = 0;
		String sql = "insert into mptab values(?,?,?,?,?)";
		Object obj[] = {map.getMpid(),map.getMpname(),map.getMpnum(),map.getMpunit(),map.getMpdes()};
		ret = this.exeSql(sql, obj);
		return ret;
	}
	
	public int update(Map map)throws UseException{
		int ret = 0;
		String sql = "update mptab set mpname=?,mpnum=?,mpunit=?,mpdes=? where mpid = ?";
		Object obj[] = {map.getMpname(),map.getMpnum(),map.getMpunit(),map.getMpdes(),map.getMpid()};
		ret = this.exeSql(sql, obj);
		return ret;
	}
	
	public int delete(Map map)throws UseException{
		int ret = 0;
		String sql = "delete from mptab where mpid = ?";
		Object obj[] = {map.getMpid()};
		ret = this.exeSql(sql, obj);
		return ret;
	}
	
	public List query(Map map) throws UseException{
		List list = null;
		String sql = "select * from mptab where 1=1 ";
		if(!Utils.getNotNull(map.getMpid()).equals("")){
			sql = sql + " and mpid like '%" + map.getMpid() + "%'";
		}
		if(!Utils.getNotNull(map.getMpname()).equals("")){
			sql = sql + " and mpname like '%" + map.getMpname() + "%'";
		}
		if(map.getMpnum()!=0){
			sql = sql + " and mpnum >= '"+map.getMpnum()+"'";
		}
		list = this.getQuery(sql, Map.class);
		return list;
	}
	//总数查询
	public int querysum(Map map) throws UseException{
		int sum = 0;
		String sql = "select sum(mpnum) from mptab where 1 = 1 ";
		if(!Utils.getNotNull(map.getMpid()).equals("")){
			sql = sql + " and mpid like '%" + map.getMpid() + "%'";
		}
		if(!Utils.getNotNull(map.getMpname()).equals("")){
			sql = sql + " and mpname like '%" + map.getMpname() + "%'";
		}
		if(map.getMpnum()!=0){
			sql = sql + " and mpnum >= '"+map.getMpnum()+"'";
		}
		sum = this.getSum(sql);
		return sum;
	}
	
	public Map get(Map map) throws UseException{
		Map m = null;
		String sql = "select * from mptab where mpid = ?";
		Object obj[] = {map.getMpid()};
		m = (Map)this.getARecord(sql, obj, Map.class);
		return m;
	}

}