员工两表增删改查

Dao 层

package com.aaa.dao;

import java.util.*;

public interface copyDao {
    //查询所有员工信息
    List<Map<String,Object>> queryAllYg();
    //添加员工信息
   int add(Object[]obj );
    //删除员工信息
    int dele(int id);
    //查询需要修改的信息
    List<Map<String,Object>> upQuery(int id);
    //修改员工信息
    int update(Object[]obj);
    //遍历查询证件类型
    List<Map<String,Object>>Idquery();
    //根据一个id查询一条数据
    Map queryById(Object id);
}

daoimpl

package com.aaa.dao.impl;

import com.aaa.dao.BaseDao;
import com.aaa.dao.copyDao;

import java.util.List;
import java.util.Map;

public class copyDaoimpl implements copyDao {
    @Override
    public List<Map<String, Object>> queryAllYg() {
        String sql = "select a.id,a.username,a.sex,a.age,b.job\n" +
                "FROM yuangong a,bumen b\n" +
                "where a.job = b.id";
        return BaseDao.executeQuery(sql);
    }

    @Override
    public int add(Object[] obj) {
        String sql = "insert into yuangong (username,sex,age,job)values(?,?,?,?) ";
        return BaseDao.insertDeleUp(sql,obj);
    }

    @Override
    public int dele(int id) {
        String sql = "delete from yuangong where id = ?";
        return BaseDao.insertDeleUp(sql,id);
    }

    @Override
    public List<Map<String, Object>> upQuery(int id) {
        String sql = "select a.username,a.sex,a.age,b.job\n" +
                "from yuangong a,bumen b \n" +
                "where a.job = b.id and a.id  = ?";
        return BaseDao.executeQuery(sql,id);
    }

    @Override
    public int update(Object[] obj) {
        String sql = "update yuangong set username = ?,sex = ?, age = ?, job = ? \n" +
                "where id = ?";
        return BaseDao.insertDeleUp(sql,obj);
    }

    @Override
    public List<Map<String, Object>> Idquery() {
        String sql = "select * from bumen";
        return BaseDao.executeQuery(sql);
    }

    @Override
    public Map queryById(Object id) {
        String sql = "select * from yuangong where id =?";
        return BaseDao.executeQuery(sql,id).get(0);
    }
}

service

package com.aaa.service;

import java.util.List;
import java.util.Map;

public interface copysetvice {
    //查询所有员工信息
    List<Map<String,Object>> queryAllYg();
    //添加员工信息
    int add(Object[]obj );
    //删除员工信息
    int dele(int id);
    //查询需要修改的信息
    List<Map<String,Object>> upQuery(int id);
    //修改员工信息
    int update(Object[]obj);
    //遍历查询证件类型
    List<Map<String,Object>>Idquery();
    //根据一个id查询一条数据
    Map queryById(Object id);
}

serviceImpl

package com.aaa.service.impl;

import co