package com.dnweb.springmvcshoeshop.entities;
// Generated Apr 30, 2017 10:28:13 AM by Hibernate Tools 4.3.5.Final

import java.util.HashSet;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;


@Entity
@Table(name = "category")
public class Category implements java.io.Serializable {

	private static final long serialVersionUID = -192560943260065434L;
	
	private String id;
	private String name;
	private Set<Product> products = new HashSet<Product>(0);

	@Id

	@Column(name = "id", unique = true, nullable = false, length = 11)
	public String getId() {
		return this.id;
	}

	public void setId(String id) {
		this.id = id;
	}

	@Column(name = "name", nullable = false)
	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}

	@OneToMany(fetch = FetchType.LAZY, mappedBy = "category")
	public Set<Product> getProducts() {
		return this.products;
	}

	public void setProducts(Set<Product> products) {
		this.products = products;
	}

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

// Query san pham theo category
	public PaginationResult<ProductInfo> queryProductsCategory(int page, int maxResult, int maxNavigationPage,
			String categoryId, String likeName) {

		String sql = "Select new " + ProductInfo.class.getName()
				+ "((p.id, p.name, p.price, p.description, p.discount, p.category.id)) " + " from "
				+ Product.class.getName() + " p " + "inner join " 
				+ Category.class.getName() + " c " + " on "
				+ "p.category.id = c.id";

		if (likeName != null && likeName.length() > 0) {
			sql += " Where lower(p.name) like :likeName ";
		}
		sql += " order by p.created desc ";

		Session session = sessionFactory.getCurrentSession();

		// Co duoc doi tuong Query
		Query query = session.createQuery(sql);
		if (likeName != null && likeName.length() > 0) {
			query.setParameter("likeName", "%" + likeName.toLowerCase() + "%");
		}

		return new PaginationResult<ProductInfo>(query, page, maxResult, maxNavigationPage);
	}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

package com.dnweb.springmvcshoeshop.model;

import org.springframework.web.multipart.commons.CommonsMultipartFile;

import com.dnweb.springmvcshoeshop.entities.Product;

public class ProductInfo {

	private String id;
	private String name;
	private double price;
	private String description;
	private Float discount;
	private String categoryId;
	
	private boolean newProduct = false;

	// Upload file.
	private CommonsMultipartFile fileData;

	
	public ProductInfo() {
		
	}

	public ProductInfo(Product product) {
		this.id = product.getId();
		this.name = product.getName();
		this.price = product.getPrice();
		this.description = product.getDescription();
		this.discount = product.getDiscount();
		this.categoryId = product.getCategory().getId();
	}

	//Dung de truy van trong Hibernate
	public ProductInfo(String id, String name, double price) {
		super();
		this.id = id;
		this.name = name;
		this.price = price;
	}
	
	public ProductInfo(String id, String name, double price, String description, Float discount, String categoryId) {
		this.id = id;
		this.name = name;
		this.price = price;
		this.description = description;
		this.discount = discount;
		this.categoryId = categoryId;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public double getPrice() {
		return price;
	}

	public void setPrice(double price) {
		this.price = price;
	}
	
	public CommonsMultipartFile getFileData() {
		return fileData;
	}

	public void setFileData(CommonsMultipartFile fileData) {
		this.fileData = fileData;
	}

	public boolean isNewProduct() {
		return newProduct;
	}

	public void setNewProduct(boolean newProduct) {
		this.newProduct = newProduct;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public Float getDiscount() {
		return discount;
	}

	public void setDiscount(Float discount) {
		this.discount = discount;
	}

	public String getCategoryId() {
		return categoryId;
	}

	public void setCategoryId(String categoryId) {
		this.categoryId = categoryId;
	}
	
	
	
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119