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