2021暑期项目实训之企业Dao层及Vo代码

最新推荐文章于 2021-11-27 15:23:02 发布

lly1357

最新推荐文章于 2021-11-27 15:23:02 发布

阅读量74

点赞数

分类专栏：项目实训

本文链接：https://blog.csdn.net/qq_44475361/article/details/119157566

版权

项目实训专栏收录该内容

15 篇文章 0 订阅

订阅专栏

Dao层：

package com.rjxy.Repository;

import com.rjxy.Entity.Company;
import com.rjxy.Entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import javax.persistence.criteria.CriteriaBuilder;
import java.sql.Timestamp;
import java.util.List;

public interface CompanyRepository extends JpaRepository<Company, Integer> {

    Company findCompanyById(Integer companyId);

    @Query("SELECT company FROM Company company WHERE company.name LIKE %?1%")
    List<Company> searchByName(String name);

    @Query("SELECT company FROM Company company WHERE company.deleted = true ")
    List<Company> findCompaniesByDeleted(Boolean deleted);

    Company findCompanyByIdAndDeletedFalse(Integer companyId);

    List<Company> findCompanyInformationById(Integer companyId);


}

Vo类：

将企业信息封装好返回给前端

package com.rjxy.Model;

import com.rjxy.Entity.Company;
import com.rjxy.Entity.User;
import com.rjxy.Service.UserService;
import lombok.Data;

@Data
public class CompanyVo {

    private Integer id;

    private String name;

    private String address;

    private String type;

    private String founderName;

    private String founderPhone;

    private String founderEmail;

    public static CompanyVo setCompany(Company company) {
        CompanyVo cv = new CompanyVo();
        cv.setId(company.getId());
        cv.setName(company.getName());
        return cv;
    }
    public static CompanyVo getCompany(Company company, User founder) {
        CompanyVo cv = new CompanyVo();
        cv.setId(company.getId());
        cv.setName(company.getName());
        cv.setAddress(company.getCAddress());
        cv.setType(company.getCType());
        cv.setFounderName(founder.getName());
        cv.setFounderPhone(founder.getTelephone());
        cv.setFounderEmail(founder.getEmail());
        return cv;
    }
}