ssh三大框架整合后的增删改查以及分页
实体类:
Book:
package com.ssh.vero.entity;
import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="tbl_book")
public class Book {
private int id;
private String bookName;
private String writer;
private double price;
private String publish;
@Id
@GeneratedValue
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public String getWriter() {
return writer;
}
public void setWriter(String writer) {
this.writer = writer;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getPublish() {
return publish;
}
public void setPublish(String publish) {
this.publish = publish;
}
}
Paging:
package com.ssh.vero.entity;
import java.util.List;
public class Paging {
private List
private int pageNow;//所在的页数
private int pageSize;//每页的数量
private int pageCount;//总页数
private long rowCount;//总条数
public List
return books;
}
public void setBooks(List
this.books = books;
}
public int getPageNow() {
return pageNow;
}
public void setPageNow(int pageNow) {
this.pageNow = pageNow;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getPageCount() {
return pageCount;
}
public void setPageCount(int pageCount) {
this.pageCount = pageCount;
}
public long getRowCount() {
return rowCount;
}
public void setRowCount(long rowCount) {
this.rowCount = rowCount;
}
}
Dao:
IBookDao:
package com.ssh.vero.dao;
import java.util.List;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
public interface IBookDao {
void save(Book book);
void update(Book book);
//void delete(int id);
void delete(Book book);
Book get(int id);
List
Paging selectBooksByName(String bookName,int pageNow,int pageSize);
List
}
BookDaoImpl:
package com.ssh.vero.dao.impl;
import java.util.ArrayList;
import java.util.List;
import https://www.sodocs.net/doc/4816620149.html,er;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Restrictions;
import com.ssh.vero.dao.IBookDao;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
public class BookDaoImpl implements IBookDao {
private SessionFactory sessionFactory;
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
private Session getSession(){
return sessionFactory.getCurrentSession();
}
@Override
public void save(Book book) {
getSession().save(book);
}
@Override
public void update(Book book) {
getSession().update(book);
}
/*@Override
public void delete(int id) {
Object obj = get(id);
if(obj != null){
getSession().delete(obj);
}
}*/
@Override
public void delete(Book book){
getSession().delete(book);
}
@Override
public Book get(int id) {
Book book = (Book) getSession().get(Book.class, id);
return book;
}
@Override
public List
List
return books;
}
@Override
public Paging selectBooksByName(String bookName,int pageNow,int pageSize) {
StringBuffer hql = new StringBuffer("from Book where 1=1");
if(bookName != null && !"".equals(bookName.trim())){
hql.append("and bookName=:bookName");
}
Query q = getSession().createQuery(hql.toString())
.setFirstResult((pageNow-1)*pageSize)
.setMaxResults(pageSize);
if(bookName != null && !"".equals(bookName.trim())){
q.setString("bookName", bookName);
}
Paging paging = new Paging();
List
long rowCount = this.getRowCount(bookName);
paging.setRowCount(rowCount);
int pageCount = 0;
if(rowCount % pageSize == 0){
pageCount = (int) (rowCount / pageSize);
}else{
pageCount = (int) (rowCount / pageSize)+1;
}
paging.setBooks(books);
paging.setPageNow(pageNow);
paging.setPageSize(pageSize);
paging.setPageCount(pageCount);
return paging;
}
private long getRowCount(String bookName) {
StringBuffer hql = new StringBuffer("select count(*) from Book where 1=1 ");
if(bookName != null && !"".equals(bookName.trim())){
hql.append(" and bookName=:bookName ");
}
Query q = getSession().createQuery(hql.toString());
if(bookName != null && !"".equals(bookName.trim())){
q.setString("bookName", bookName);
}
Long count = (Long) q.uniqueResult();
return count;
}
@Override
public List
StringBuffer hql = new StringBuffer("from Book where 1=1");
hql.append("and bookName like '%bookName%'");
Query q = getSession().createQuery(hql.toString());
if(bookName != null && !"".equals(bookName.trim())){
q.setString("bookName", bookName);
}
List
return books;
}
}
service:
IBookService:
package com.ssh.vero.service;
import java.util.List;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
publi
c interface IBookSerivce {
void save(Book book);
void update(Book book);
//void delete(int id);
void delete(Book book);
Book get(int id);
List
Paging selectBooksByName(String bookName,int pageNow,int pageSize);
List
}
BookServiceImpl:
package com.ssh.vero.service.impl;
import java.util.List;
import com.ssh.vero.dao.IBookDao;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
import com.ssh.vero.service.IBookSerivce;
public class BookServiceImpl implements IBookSerivce {
private IBookDao bookDao;
public IBookDao getBookDao() {
return bookDao;
}
public void setBookDao(IBookDao bookDao) {
this.bookDao = bookDao;
}
@Override
public void save(Book book) {
bookDao.save(book);
}
@Override
public void update(Book book) {
bookDao.update(book);
}
/*
* @Override public void delete(int id) { bookDao.delete(id); }
*/
@Override
public void delete(Book book) {
bookDao.delete(book);
}
@Override
public Book get(int id) {
return bookDao.get(id);
}
@Override
public List
return bookDao.getAll();
}
@Override
public Paging selectBooksByName(String bookName, int pageNow, int pageSize) {
return bookDao.selectBooksByName(bookName, pageNow, pageSize);
}
@Override
public List
return bookDao.findByName(bookName);
}
}
Controller:
BookController;
package com.ssh.vero.controller;
import java.util.List;
import com.opensymphony.xwork2.ActionSupport;
import com.ssh.vero.entity.Book;
import com.ssh.vero.entity.Paging;
import com.ssh.vero.service.IBookSerivce;
public class BookController extends ActionSupport {
private List
private Book book;
private String bookName;
private int id;
private int pageNow;
//private int pageSize;
private Paging paging;
private IBookSerivce bookService;
public void setBookService(IBookSerivce bookService) {
this.bookService = bookService;
}
public BookController() {
}
public String list(){
//books = bookService.getAll();
if(pageNow == 0){
pageNow = 1;
}
paging = bookService.selectBooksByName(bookName, pageNow, 2);
return "list";
}
public String save(){
bookService.save(book);
return "save";
}
public String delete(){
book = bookService.get(id);
if(book != null){
bookService.delete(book);
}
return "delete";
}
public String update(){
//book = bookService.get(id);
if(book != null){
bookService.update(book);
}
return "update";
}
public String get(){
book = bookService.get(id);
return "get";
}
public String find(){
books = bookService.findByName(bookName);
return "find";
}
public List
return books;
}
public void setBooks(List
this.books = books;
}
public Book getBook() {
return book;
}
public void setBook(Book book) {
this.book = book;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getPageNow() {
return pageNow;
}
public void setPageNow(int pageNow) {
this.pageNow = pageNow;
}
public Paging getPaging() {
return paging;
}
public void setPaging(Paging paging) {
this.paging = paging;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
}
jsp页面:
list.jsp:
<%@page import="com.ssh.vero.service.impl.BookServiceImpl"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="https://www.sodocs.net/doc/4816620149.html,/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="s" uri="/struts-tags"%>
欢迎来到用户列表界面
图书添加图书ID 图书名称 作者 价格 出版社 操作 修改||
删除
首页
上一页
下一页
尾页
save.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
欢迎来到用户添加页面
update.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags" %>
修改页面
配置文件:
applicationContext.xml:
xmlns:aop="https://www.sodocs.net/doc/4816620149.html,/schema/aop"
xmlns:tx="https://www.sodocs.net/doc/4816620149.html,/schema/tx"
xsi:schemaLocation="https://www.sodocs.net/doc/4816620149.html,/schema/beans
https://www.sodocs.net/doc/4816620149.html,/schema/beans/spring-beans.xsd
https://www.sodocs.net/doc/4816620149.html,/schema/tx
https://www.sodocs.net/doc/4816620149.html,/schema/tx/spring-tx.xsd
https://www.sodocs.net/doc/4816620149.html,/schema/ao
p
https://www.sodocs.net/doc/4816620149.html,/schema/aop/spring-aop.xsd">
struts.xml:
"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
"https://www.sodocs.net/doc/4816620149.html,/dtds/struts-2.3.dtd">
<
result name="get" type="dispatcher">/update.jsp