dbsyuser.java

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

package com.qhit.db.instance;

import java.util.List;

import com.qhit.UseException;
import com.qhit.db.DbOper;
import com.qhit.po.SyUser;

public class DbSyUser extends DbOper{
	public DbSyUser() throws UseException{
		super();
	}
	
	public int insert(SyUser su) throws UseException{
		String sql = "insert into SyUser values(?,?)";
		Object obj[] = {su.getUserid(),su.getPassword()};
		
		int ret = this.exeSql(sql, obj);
		
		return ret;
	}
	
	public int delete(SyUser su) throws UseException{
		String sql = "delete from SyUser where userid = ?";
		Object obj[] = {su.getUserid()};
		
		int ret = this.exeSql(sql, obj);
		
		return ret;
	}
	
	public int update(SyUser su) throws UseException{
		String sql = "update SyUser set password = ? where userid = ?";
		Object obj[] = {su.getPassword(),su.getUserid()};
		
		int ret = this.exeSql(sql, obj);
		
		return ret;
	}
	
	public SyUser get(SyUser su) throws UseException{
		SyUser resu = null;
		String sql = "select userid,password from SyUser where userid = ?";
		Object obj[] = {su.getUserid()};
		resu = (SyUser)this.getARecord(sql, obj, SyUser.class);
		return resu;
	}
	
	public List query(SyUser su) throws UseException{
		List list = null;
		String sql = "select * from SyUser where userid = ? and password = ?";
		Object obj[] = {su.getUserid(),su.getPassword()};
		
		list = this.getQuery(sql,obj,SyUser.class);
		return list;
	}
}