boardroomdaoimpl.java

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

package com.icss.oa.dao.impl;

import java.util.List;

import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.Boardroom;
import com.icss.oa.dao.BoardroomDao;
import com.icss.oa.utils.ConnectionFactory;

public class BoardroomDaoImpl extends BaseDAOImpl implements BoardroomDao {

	public boolean addBoardroom(Boardroom boardroom) {
		// TODO Auto-generated method stub
			
		String strInsert = "insert into boardroom values(boardroom_seq.nextval,?,?,?,?)";
			
		return executeObject(strInsert,new Object[]{"","","空闲中",boardroom.getBoardroomNo()});
		
	}

	public List query() {
		
		String strQuety = "select boradroomno from boardroom";
		
		return  queryAllObject(strQuety);
		
	}

	public boolean del(String boardroomNo) {
		String strDel = "delete from boardroom where boradroomno =?";
		return executeObject(strDel,new Object[]{boardroomNo});
	}



}