寒假工程8

public class CommunicationService {
SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
public List select(String AssessmentID) {
SqlSession sqlSession = sqlSessionFactory.openSession();
CommunicationMapper communicationMapper = sqlSession.getMapper(CommunicationMapper.class);
List communicationList=communicationMapper.select(AssessmentID);
sqlSession.close();
return communicationList;
}

public void add(Communication communication) {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    CommunicationMapper communicationMapper = sqlSession.getMapper(CommunicationMapper.class);
    communicationMapper.addCommunication(communication);
    sqlSession.commit();
    sqlSession.close();
}

}

SqlSession sqlSession = sqlSessionFactory.openSession();：通过 SqlSessionFactory 打开一个新的 SqlSession。
CommunicationMapper communicationMapper = sqlSession.getMapper(CommunicationMapper.class);：通过 SqlSession 获取 CommunicationMapper 的实例。
communicationMapper.addCommunication(communication);：调用 CommunicationMapper 的 addCommunication 方法，传入 communication 对象作为参数，执行数据库插入操作。
sqlSession.commit();：提交事务，将之前的插入操作持久化到数据库中。
sqlSession.close();：关闭 SqlSession，释放相关资源。