网上书店（Java ee）

package DAO; /* * 后台管理book操作类 */ import java.io.IOException; import java.io.UnsupportedEncodingException; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import miao.Book; import miao.HibernateSessionFactory; import org.hibernate.Query; import org.hibernate.Session; public class BookDao { public int isAddbook(HttpServletRequest request) throws Exception { // 各数值表示意义 /*-1:表示添加图书失败 * 0:表示添加图书成功 * 1：表示图书编号不合格 * 2:表示图书编号重复 * 3：表示图书价格不合格 */ int flag = -1; Session session = HibernateSessionFactory.getSession(); // 获取页面提交过来的参数并且对其判断是否合法 session.clear(); flag = check(request); if (flag == -1) { String bookNum = request.getParameter("bookNum").toString().trim();// 图书编号 String bookName = request.getParameter("bookName").toString() .trim();// 图书名称 String bookWriter = request.getParameter("bookWriter").toString()// 图书作者 .trim(); String bookPublish = request.getParameter("bookPublish").toString()// 图书出版社 .trim(); Double bookPrice = Double.parseDouble(request .getParameter("bookPrice".toString().trim()));// 图书价格 int bookSort = Integer.parseInt(request.getParameter("bookSort")// 图书类别 // 1：小说 // 2：文学 // 3：管理 // 4：经济 // 5：旅游 .toString().trim()); String bookDesc = request.getParameter("bookDesc").toString() .trim();// 图书描述 /* 测试数据 */ // String bookNum="book"; // String bookName="hello"; // String bookWriter="writer"; // String bookPublish="publish"; // double bookPrice=30.3; // int bookSort=1; // String bookDesc="descript"; Book book = new Book(); // 声明一个book， book.setBookNum(bookNum); book.setBookName(bookName); book.setBookWriter(bookWriter); book.setBookPublish(bookPublish); book.setBookPrice(bookPrice); book.setBookSort(bookSort); book.setBookDesc(bookDesc); // 建立一个事物 ，将book写入数据库中 if (flag == -1) { session.beginTransaction().begin(); session.save(book); flag = 0; session.beginTransaction().commit(); } } return flag; } public int isModifybook(HttpServletRequest request) throws Exception { // 各数值表示意义 /*-1:表示修改图书失败 * 0:表示修改图书成功 * 1：表示图书编号不合格 * 2:表示图书编号重复 * 3：表示图书价格不合格 */ int flag = -1; Session session = HibernateSessionFactory.getSession(); // 获取页面提交过来的参数并且对其判断是否合法 session.clear(); flag = checkModifyBook(request); if (flag == -1) { String bookNum = request.getParameter("bookNum").toString().trim();// 图书编号 String bookName = request.getParameter("bookName").toString() .trim();// 图书名称 String bookWriter = request.getParameter("bookWriter").toString()// 图书作者 .trim(); String bookPublish = request.getParameter("bookPublish").toString()// 图书出版社 .trim(); Double bookPrice = Double.parseDouble(request .getParameter("bookPrice".toString().trim()));// 图书价格 int bookSort = Integer.parseInt(request.getParameter("bookSort")// 图书类别 // 1：小说 // 2：文学 // 3：管理 // 4：经济 // 5：旅游 .toString().trim()); String bookDesc = request.getParameter("bookDesc").toString() .trim();// 图书描述 // 建立一个事物 ，将book写入数据库中 if (flag == -1) { session.beginTransaction().begin(); Book book = (Book) session.get(Book.class, bookNum); // 声明一个book， book.setBookName(bookName); book.setBookPrice(bookPrice); book.setBookDesc(bookDesc); book.setBookPublish(bookPublish); book.setBookSort(bookSort); book.setBookWriter(bookWriter); session.update(book); flag = 0; session.beginTransaction().commit(); } } return flag; } public int checkModifyBook(HttpServletRequest request) { int flag = -1; String bookNum = request.getParameter("bookNum").toString().trim(); for (int i = 0; i < bookNum.length(); i++) { if (bookNum.charAt(i) < '0' || bookNum.charAt(i) > '9') { flag = 1; break; } } String bookName = request.getParameter("bookName").toString().trim(); if (bookName.length() == 0) { flag = 5; } if (bookNum.length() > 9) { flag = 4; } String bookPrice = request.getParameter("bookPrice").toString().trim(); for (int i = 0; i < bookPrice.length(); i++) { if (bookPrice.charAt(i) != '.') { if (bookPrice.charAt(i) < '0' || bookPrice.charAt(i) > '9') { flag = 3; break; } } } return flag; } // 判断书籍各属性是否合法，返回INT值 public int check(HttpServletRequest request) { int flag = -1; String bookNum = request.getParameter("bookNum").toString().trim(); for (int i = 0; i < bookNum.length(); i++) { if (bookNum.charAt(i) < '0' || bookNum.charAt(i) > '9') { flag = 1; break; } } String bookName = request.getParameter("bookName").toString().trim(); if (bookName.length() == 0) { flag = 5; } if (bookNum.length() > 9) { flag = 4; } String bookPrice = request.getParameter("bookPrice").toString().trim(); for (int i = 0; i < bookPrice.length(); i++) { if (bookPrice.charAt(i) != '.') { if (bookPrice.charAt(i) < '0' || bookPrice.charAt(i) > '9') { flag = 3; break; } } } Session session = HibernateSessionFactory.getSession(); session.clear(); String Hql = "from miao.Book as book where bookNum=:number"; Query query = session.createQuery(Hql).setString("number", request.getParameter("bookNum").toString().trim()); List<Book> list = query.list(); if (list.size() > 0) flag = 2; return flag; } // 接收值，显示提示 public String print(int flag, HttpServletRequest request) throws UnsupportedEncodingException { String print = ""; if (flag == 0) { String s = request.getParameter("bookName").toString().trim(); String bookName = new String(s.getBytes("iso-8859-1")); print = "<font size=2 color=\"red\">《" + bookName + "》：图书处理成功!</font>"; } if (flag == 1) { print = "<font size=2 color=\"red\">图书编号必须为数字!</font>"; } if (flag == 2) { print = ("<font size=2 color=\"red\">图书编号重复!</font>"); } if (flag == 3) { print = ("<font size=2 color=\"red\">图书价格必须是数字!</font>"); } if (flag == 4) { print = ("<font size=2 color=\"red\">图书编号为1~9位数字!</font>"); } if (flag == 5) { print = "<font size=2 color=\"red\">请输入图书名称!</font>"; } if (flag == -1) { print = (request.getParameter("bookName") + "<font size=2 color=\"red\">图书处理失败!</font>"); } return print; } // 分页查询图书 public List<Book> findBook(HttpServletRequest request, int first) throws IOException { Session session = HibernateSessionFactory.getSession(); session.clear(); String Hql = "from miao.Book"; Query query = session.createQuery(Hql); query.setFirstResult(first); query.setMaxResults(9); List<Book> list = query.list(); return list; } public int getMaxBook(){ Session session=HibernateSessionFactory.getSession(); session.clear(); String Hql="from miao.Book"; Query query = session.createQuery(Hql); List<Book> list=query.list(); return list.size(); } /* * 接收String类型，将其统一设置为iso-8859-1格式 处理中文乱码 */ public String setBytes(String str) throws UnsupportedEncodingException { String s = new String(str.getBytes("iso-8859-1")); return s; } /* * 函数名称：getBookByNum() * 输入数据：bookNum; * 输出数据：Book对象 */ public Book getBookByNum(String bookNum){ Session session = HibernateSessionFactory.getSession(); Bo