ssh三大框架整合后的增删改查以及分页

import java.util.ArrayList;
import java.util.List;
import er;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
q.setString("bookName", bookName);
this.pageSize = pageSize;
}
public int getPageCount() {
return pageCount;
}
public void setPageCount(int pageCount) {
this.pageCount = pageCount;
paging.setRowCount(rowCount);
int pageCount = 0;
if(rowCount % pageSize == 0){
pageCount = (int) (rowCount / pageSize);
}else{
pageCount = (int) (rowCount / pageSize)+1;
this.id = id;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
Query q = getSession().createQuery(hql.toString())
.setFirstResult((pageNow-1)*pageSize)
.setMaxResults(pageSize);
if(bookName != null && !"".equals(bookName.trim())){
hql.append(" and bookName=:bookName ");
}
Query q = getSession().createQuery(hql.toString());
if(bookName != null && !"".equals(bookName.trim())){
getSession().save(book);
}
@Override
public void update(Book book) {
getSession().update(book);
}
/*@Override
public void delete(int id) {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getPublish() {
return publish;
}
public void setPublish(String publish) {
void save(Book book);
void update(Book book);
//void delete(int id);
void delete(Book book);
Book get(int id);
List<Book> getAll();
实体类:
Book:
package com.ssh.vero.entity;
import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
q.setString("bookName", bookName);
}
Paging paging = new Paging();
List<Book> books = q.list();
long rowCount = this.getRowCount(bookName);
}
public String getWriter() {
return writer;
}
public void setWriter(String writer) {
this.writer = writer;
}
public double getPrice() {
package com.ssh.vero.dao;
import java.util.List;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
public interface IBookDao {
public class BookDaoImpl implements IBookDao {
private SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
Paging selectBooksByName(String bookName,int pageNow,int pageSize);
List<Book> findByName(String bookName);
}
BookDaoImpl:
package com.ssh.vero.dao.impl;
private int pageNow;//所在的页数
private int pageSize;//每页的数量
private int pageCount;//总页数
private long rowCount;//总条数
public List<Book> getBooks() {
Object obj = get(id);
if(obj != null){
getSession().delete(obj);
}
}*/
@Override
public void delete(Book book){
getSession().delete(book);
private double price;
private String publish;
@Id
@GeneratedValue
public int getId() {
return id;
}
public void setId(int id) {
import org.hibernate.criterion.Restrictions;
import com.ssh.vero.dao.IBookDao;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
public void setPageNow(int pageNow) {
this.pageNow = pageNow;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
}
@Override
public Book get(int id) {
Book book = (Book) getSession().get(Book.class, id);
return book;
}
@Override
public List<Book> getAll() {
StringBuffer hql = new StringBuffer("from Book where 1=1");
if(bookName != null && !"".equals(bookName.trim())){
hql.append("and bห้องสมุดไป่ตู้okName=:bookName");
}
private long getRowCount(String bookName) {
StringBuffer hql = new StringBuffer("select count(*) from Book where 1=1 ");
if(bookName != null && !"".equals(bookName.trim())){
import javax.persistence.Table;
@Entity
@Table(name="tbl_book")
public class Book {
private int id;
private String bookName;
private String writer;
}
paging.setBooks(books);