开发记录 04

编写older的service文件：

package com.test.service;

import com.test.mapper.OlderMapper;
import com.test.pojo.Older;
import com.test.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;
public class OlderService {
    SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();

    public void add(Older older){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        System.out.println("wjhddj");
        olderMapper.addOlder(older);
        System.out.println("hi的");
        sqlSession.commit();
        sqlSession.close();
    }

    public void delete(String name ){

        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        olderMapper.deleteByname(name);
        sqlSession.commit();
        sqlSession.close();
    }

    public Older Findbyname(String name){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        System.out.println(name);
        Older older=olderMapper.Findbyname(name);
        sqlSession.close();
        return older;
    }

    public List<Older> Findbytwo(Older older){

        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        List<Older> cls=olderMapper.Findbytwo(older);
        sqlSession.close();
        return cls;
    }

    public void update(Older older){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        System.out.println("提交前");
        olderMapper.updateOlder(older);
        System.out.println("提交后期");
        sqlSession.commit();
        sqlSession.close();
    }

    public List<Older> selectAll(){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        List<Older> OlderSelectAll=olderMapper.selectAll();
        sqlSession.close();
        return OlderSelectAll;
    }

    public Older Findbyage(int age){
        SqlSession sqlSession = sqlSessionFactory.openSession();
        OlderMapper olderMapper = sqlSession.getMapper(OlderMapper.class);
        System.out.println(age);
        Older worker=olderMapper.Findbyage(age);
        sqlSession.close();
        return worker;
    }
}