addkinddaoimpl.java

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

package com.icss.oa.dao.impl;

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

import com.icss.oa.base.BaseDAO;
import com.icss.oa.base.CardDAO;
import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.CardKindVO;
import com.icss.oa.dao.AddKindDAO;

public class AddKindDAOImpl implements AddKindDAO{

	public boolean insertkind(CardKindVO cardkind) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="insert into t_cardkind(cardkindid,personid,cardkindname) values(sequence_001.nextval,?,?)";
		Object[] num={cardkind.getPersonId(),cardkind.getKindName()};
		BaseDAO baseDAO=new BaseDAOImpl();
		System.out.println("verg good");
		System.out.println("&&&&&&&&&&&&&&&&&&&&&&& PersonId = " + cardkind.getPersonId()+ "KindName = " + cardkind.getKindName());
		flag=baseDAO.executeObject(sql, num);
		String name=cardkind.getKindName();
		System.out.println("verg good"+name);
		return flag;
	}

	public List checktable(CardKindVO cardkind) {
		// TODO Auto-generated method stub
		String sql="select * from t_cardkind where personid=?";
		Object[] num={cardkind.getPersonId()};
		//Properties prop=
		BaseDAO baseDAO=new BaseDAOImpl();
		List array=baseDAO.queryAllObject(sql, num);
		return array;
	}

	public boolean modishared(CardKindVO cardkind) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="update t_cardkind set isshare=? where cardkindid=?";
		int isshare;
		if(cardkind.getIsShard()==0)
			isshare=1;
		else isshare=0;
		Object[] num={isshare,cardkind.getKindId()};
		 BaseDAO baseDAO=new BaseDAOImpl();
		flag=baseDAO.executeObject(sql, num);
		return false;
		
	}

	public boolean deletecardkind(int id) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="delete from t_card where cardkindid=?";
		Object[] num={id};
		BaseDAO baseDAO=new BaseDAOImpl();
		flag=baseDAO.executeObject(sql, num);
		System.out.println("无语了"+flag);
		return flag;
	}

	public List checkall(int id) {
		// TODO Auto-generated method stub
		String sql="select person.name,person.telphone,person.email,person.address from person,t_card where person.personid=t_card.userid and t_card.personid=?";
		Object[] num={id};
		BaseDAO baseDAO=new BaseDAOImpl();
		
		List array=baseDAO.queryAllObject(sql, num);
		return array;
	}

	public boolean deletekind(int id) {
		boolean flag=false;
		String sql="delete from t_cardkind where cardkindid=?";
		Object[] num={id};
		BaseDAO baseDAO=new BaseDAOImpl();
		flag=baseDAO.executeObject(sql, num);
		System.out.println("无语了"+flag);
		return flag;
		
		
	}

	public boolean checkisvalue(int id) {
		// TODO Auto-generated method stub
		boolean flag=false;
		String sql="select * from t_card where cardkindid=?";
		Object[] num={id};
		BaseDAO baseDAO=new BaseDAOImpl();
		System.out.println("执行了吗");
		flag=baseDAO.executeObject(sql, num);
		System.out.println("存在吗?"+flag);
		return flag;
	}

	



	

	

}