userbeandaoimpl.java

Java协同办公系统。实现公司内部的人事

package com.icss.oa.dao.impl;

import java.util.List;

import com.icss.oa.base.impl.BaseDAOImpl;
import com.icss.oa.bean.UserBean;
import com.icss.oa.dao.UserBeanDAO;
import com.icss.oa.service.UserBeanService;
import com.icss.oa.service.impl.UserBeanServiceImpl;



public class UserBeanDAOImpl extends BaseDAOImpl implements UserBeanDAO {

	

	public boolean addUser(UserBean userbean1) {
		//UserBean userbean1 = new UserBean();
		String userInsert = "insert into person values(" + userbean1.getPersonID() + ",'" + userbean1.getName()+ "','"
		+ userbean1.getPassword() + "','" + userbean1.getSex() + "','" + userbean1.getBorth() + "','" 
		+ userbean1.getNation()+ "','" + userbean1.getEmail()+ "','" + userbean1.getTelephone()+ "','" + userbean1.getAddress()
		+ "','" + userbean1.getPosion()+ "','" + userbean1.getOwner()+ "'," + userbean1.getID()+ ",'" + userbean1.getDeptno() + "')";
		System.out.println(userInsert);
		return executeObject(userInsert);
	}

	public UserBean queryUserById(int id) {
		// TODO Auto-generated method stub
		return null;
	}

	public boolean deleteUser(Integer personID) {
        String strSql = "delete person where personID=?";

        return executeObject(strSql, new Object[]{personID});
	}

	public List selectUserBean() {
		//String userSelect = "select p.personID,p.name,p.pass,p.sex,p.birth,p.nation,p.email,p.telephone,p.address,p.postion,p.owner,p.id,p.deptno from person p";
		String userSelect = "select * from person";
		return queryAllObject(userSelect,new Object[]{});
	}

	

	



}