| | |
| | | @GeneratedValue(strategy = GenerationType.IDENTITY) |
| | | private Long id; |
| | | private String name; |
| | | private String companyType; |
| | | private String profitYN; |
| | | private String industy; |
| | | private String domain; |
| | | private String email; |
| | | private String tel; |
| | | private String desc; |
| | | private String email; |
| | | private String memo; |
| | | |
| | | public CompanyField() {} |
| | | |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getCompanyType() { |
| | | return companyType; |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | | |
| | | public void setCompanyType(String companyType) { |
| | | this.companyType = companyType; |
| | | } |
| | | |
| | | public String getProfitYN() { |
| | | return profitYN; |
| | | } |
| | | |
| | | public void setProfitYN(String profitYN) { |
| | | this.profitYN = profitYN; |
| | | } |
| | | |
| | | public String getIndusty() { |
| | | return industy; |
| | | } |
| | | |
| | | public void setIndusty(String industy) { |
| | | this.industy = industy; |
| | | } |
| | | |
| | | public String getDomain() { |
| | | return domain; |
| | | } |
| | | |
| | | public void setDomain(String domain) { |
| | | this.domain = domain; |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getEmail() { |
| | |
| | | this.email = email; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | public String getMemo() { |
| | | return memo; |
| | | } |
| | | |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getDesc() { |
| | | return desc; |
| | | } |
| | | |
| | | public void setDesc(String desc) { |
| | | this.desc = desc; |
| | | public void setMemo(String memo) { |
| | | this.memo = memo; |
| | | } |
| | | } |
| | |
| | | |
| | | private Long id; |
| | | private String name; |
| | | private String companyType; |
| | | private String profitYN; |
| | | private String industy; |
| | | private String domain; |
| | | private String email; |
| | | private String tel; |
| | | private String desc; |
| | | private String email; |
| | | private String memo; |
| | | |
| | | public CompanyFieldVo() {} |
| | | |
| | | public CompanyFieldVo(Long id, String name, String companyType, String profitYN, String industy, String domain, String email, String tel, String desc) { |
| | | public CompanyFieldVo(Long id, String name, String tel, String email, String memo) { |
| | | |
| | | this.id = id; |
| | | this.name = name; |
| | | this.companyType = companyType; |
| | | this.profitYN = profitYN; |
| | | this.industy = industy; |
| | | this.domain = domain; |
| | | this.email = email; |
| | | this.tel = tel; |
| | | this.desc = desc; |
| | | this.email = email; |
| | | this.memo = memo; |
| | | } |
| | | |
| | | public Long getId() { |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getCompanyType() { |
| | | return companyType; |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | | |
| | | public void setCompanyType(String companyType) { |
| | | this.companyType = companyType; |
| | | } |
| | | |
| | | public String getProfitYN() { |
| | | return profitYN; |
| | | } |
| | | |
| | | public void setProfitYN(String profitYN) { |
| | | this.profitYN = profitYN; |
| | | } |
| | | |
| | | public String getIndusty() { |
| | | return industy; |
| | | } |
| | | |
| | | public void setIndusty(String industy) { |
| | | this.industy = industy; |
| | | } |
| | | |
| | | public String getDomain() { |
| | | return domain; |
| | | } |
| | | |
| | | public void setDomain(String domain) { |
| | | this.domain = domain; |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getEmail() { |
| | |
| | | this.email = email; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | public String getMemo() { |
| | | return memo; |
| | | } |
| | | |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getDesc() { |
| | | return desc; |
| | | } |
| | | |
| | | public void setDesc(String desc) { |
| | | this.desc = desc; |
| | | public void setMemo(String memo) { |
| | | this.memo = memo; |
| | | } |
| | | } |
| | |
| | | private String name; |
| | | private String companyType; |
| | | private String profitYN; |
| | | private String industy; |
| | | private String industry; |
| | | private String domain; |
| | | private String email; |
| | | private String tel; |
| | |
| | | this.profitYN = profitYN; |
| | | } |
| | | |
| | | public String getIndusty() { |
| | | return industy; |
| | | public String getIndustry() { |
| | | return industry; |
| | | } |
| | | |
| | | public void setIndusty(String industy) { |
| | | this.industy = industy; |
| | | public void setIndustry(String industry) { |
| | | this.industry = industry; |
| | | } |
| | | |
| | | public String getDomain() { |
| | |
| | | public class CompanyFieldForm { |
| | | private Long id; |
| | | private String name; |
| | | private String companyType; |
| | | private String profitYN; |
| | | private String industy; |
| | | private String domain; |
| | | private String email; |
| | | private String tel; |
| | | private String desc; |
| | | private String email; |
| | | private String memo; |
| | | private List<Long> removeIds = Lists.newArrayList(); |
| | | |
| | | public CompanyFieldForm() { |
| | |
| | | this.name = name; |
| | | } |
| | | |
| | | public String getCompanyType() { |
| | | return companyType; |
| | | public String getTel() { |
| | | return tel; |
| | | } |
| | | |
| | | public void setCompanyType(String companyType) { |
| | | this.companyType = companyType; |
| | | } |
| | | |
| | | public String getProfitYN() { |
| | | return profitYN; |
| | | } |
| | | |
| | | public void setProfitYN(String profitYN) { |
| | | this.profitYN = profitYN; |
| | | } |
| | | |
| | | public String getIndusty() { |
| | | return industy; |
| | | } |
| | | |
| | | public void setIndusty(String industy) { |
| | | this.industy = industy; |
| | | } |
| | | |
| | | public String getDomain() { |
| | | return domain; |
| | | } |
| | | |
| | | public void setDomain(String domain) { |
| | | this.domain = domain; |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getEmail() { |
| | |
| | | this.email = email; |
| | | } |
| | | |
| | | public String getTel() { |
| | | return tel; |
| | | public String getMemo() { |
| | | return memo; |
| | | } |
| | | |
| | | public void setTel(String tel) { |
| | | this.tel = tel; |
| | | } |
| | | |
| | | public String getDesc() { |
| | | return desc; |
| | | } |
| | | |
| | | public void setDesc(String desc) { |
| | | this.desc = desc; |
| | | public void setMemo(String memo) { |
| | | this.memo = memo; |
| | | } |
| | | |
| | | public List<Long> getRemoveIds() { |
| | |
| | | CREATE TABLE `company`( |
| | | `id` BIGINT(11) AUTO_INCREMENT, |
| | | `name` VARCHAR(50) NOT NULL, |
| | | `company_type` VARCHAR(50) NOT NULL, |
| | | `profit_yn` VARCHAR(50) NOT NULL, |
| | | `industry` VARCHAR(50) NOT NULL, |
| | | `domain` VARCHAR(255) NOT NULL, |
| | | `email` VARCHAR (255) NOT NULL, |
| | | `tel` VARCHAR (50) NOT NULL, |
| | | `desc` VARCHAR(255) NOT NULL, |
| | | `email` VARCHAR (255) NOT NULL, |
| | | `memo` VARCHAR(255) NOT NULL, |
| | | `register_date` TIMESTAMP NULL, |
| | | `modify_id` BIGINT(20) NOT NULL, |
| | | `modify_date` TIMESTAMP NULL, |
| | |
| | | SELECT |
| | | c.id as id, |
| | | c.name as name, |
| | | c.email as email, |
| | | c.tel as tel, |
| | | c.desc as desc |
| | | c.email as email, |
| | | c.memo as memo |
| | | FROM |
| | | company c |
| | | WHERE 1=1 |