readerdaoimpl.java

来自「Java协同办公系统。实现公司内部的人事」· Java 代码 · 共 49 行

package com.icss.oa.dao.impl;

import java.util.List;
import java.util.Properties;

import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.ReaderUser;
import com.icss.oa.dao.ReaderDAO;

public class ReaderDAOImpl extends BaseDAOImpl implements ReaderDAO{

	public List lookReader(String dname) {
		String sqlstr="select p.personid,p.name,p.postion from person p,dept d where p.deptno=d.deptno and d.dname=? ";
		List list=(List)queryAllObject( sqlstr,new Object[]{dname});
		
		return list;

	}

	public boolean addReader(Integer personid,Integer readid) {
		String sqlstr="insert into reader values(insert_reader.nextval,?,?)";
		
		return executeObject(sqlstr, new Object[]{personid,readid});
	}

	public List selectReader() {
		String sqlstr="select r.readid,p.name,p.postion from person p,reader r where  p.personid=r.readid";
		List list=(List)queryAllObject(sqlstr,new Object[]{});
		return list;
	}

	public boolean deleteReader(Integer readid) {
		String sqlstr="delete reader where readid=?";
		
		return executeObject(sqlstr, new Object[]{readid});
	}

	public Properties isValidate(Integer readid) {
		String sqlstr="select * from reader where readid=?";
		System.out.println("readid = " + readid);
		Properties pro = querySingleObject(sqlstr, new Object[]{readid});
		return pro;
	}
	
	
	

}