package Dao.impl;
import Dao.MapperEmployeeDao;
import Utils.Mybatis;
import org.apache.ibatis.session.SqlSession;
import pojo.EmployeeUser;
import java.util.ArrayList;
import java.util.List;
public class Funtion_impl implements MapperEmployeeDao{
public EmployeeUser FindById(int id){
//根据Id查询员工信息
SqlSession sqlSession = Mybatis.openSession();
MapperEmployeeDao userMapper = sqlSession.getMapper(MapperEmployeeDao.class);
EmployeeUser user = userMapper.FindById(id);
System.out.println(user.getName()+user.getSex()+user.getTelephone()+user.getPost());
sqlSession.close();
return user;
}
@Override
public int AddEmployee(EmployeeUser employeeUser) {
//添加员工信息
SqlSession sqlSession = Mybatis.openSession();
MapperEmployeeDao userMapper = sqlSession.getMapper(MapperEmployeeDao.class);
int i= userMapper.AddEmployee(employeeUser);
sqlSession.commit();
sqlSession.close();
return i;
}
@Override
public int UpdateEmployee(EmployeeUser employeeUser) {
//修改职工信息
SqlSession sqlSession = Mybatis.openSession();
MapperEmployeeDao userMapper = sqlSession.getMapper(MapperEmployeeDao.class);
int i = userMapper.UpdateEmployee(employeeUser);
sqlSession.commit();
sqlSession.close();
return i;
}
@Override
public int DelEmployeeById(int id) {
//删除职工信息
SqlSession sqlSession = Mybatis.openSession();
MapperEmployeeDao userMapper = sqlSession.getMapper(MapperEmployeeDao.class);
int i=userMapper.DelEmployeeById(id);
sqlSession.commit();
sqlSession.close();
return i;
}
@Override
public List<EmployeeUser> FindAllEmployee() {
SqlSession sqlSession = Mybatis.openSession();
MapperEmployeeDao userMapper = sqlSession.getMapper(MapperEmployeeDao.class);
List<EmployeeUser> employee_list = userMapper.FindAllEmployee();
for (EmployeeUser user:employee_list
) {
System.out.println(user.getId()+" "
+user.getName()+" "
+user.getSex()+" "
+user.getTelephone()+" "
+user.getPost());
}
return employee_list;
}
}
基于Java+Mybatis+MVC的增删改查
需积分: 14 36 浏览量
2022-03-06
13:14:45
上传
评论
收藏 27KB ZIP 举报
Employee.zip （34个子文件） 
Employee 
Employee.iml 81B src main resources db.properties 206B mapper employee.xml 1009B mybatis-config.xml 946B java Utils Mybatis.java 748B InputUtil.java 1KB pojo EmployeeUser.java 860B Service impl Service_impl.java 852B Service_Fun.java 328B Controler Menu.java 2KB Dao impl Funtion_impl.java 2KB MapperEmployeeDao.java 332B test java Apptest.java 965B pom.xml 1KB target classes Utils InputUtil.class 2KB Mybatis.class 1KB pojo EmployeeUser.class 1KB db.properties 206B Service impl Service_impl.class 1KB Service_Fun.class 369B mapper employee.xml 1009B Controler Menu.class 2KB Dao MapperEmployeeDao.class 377B impl Funtion_impl.class 3KB mybatis-config.xml 946B generated-test-sources test-annotations generated-sources annotations test-classes Apptest.class 841B .idea .gitignore 233B misc.xml 526B workspace.xml 6KB uiDesigner.xml 9KB codeStyles codeStyleConfig.xml 153B Project.xml 269B compiler.xml 541B jarRepositories.xml 864B
评论0