一个Struts实现分页,增删改查,Tiles,国际化的DEMO

  }

  public void reset(ActionMapping actionMapping,
                    HttpServletRequest servletRequest) {
  }
}
以下是业务类和数据库访问类：
package com.bookshop.model;

import java.util.Map;
import java.util.List;
import com.bookshop.util.*;

public class Operator {

  private static int recordPerPage = ApplicationUtil.recordPerPage;
  //动态SQL
  private static String sqlNumber = "";

  //留出接口设置每页显示多少条记录
  public static void setRecordPerPage(int number) {
    recordPerPage = number;
  }

  public Operator() {
  }

  //获得所有记录集(只查询一页记录)
  public static List getRecords(int startIndex) {
    String sql = "select * from booktab limit ?,?";
    sqlNumber = "select count(*) from booktab";
    return DBUtil.executeQuery(sql, startIndex, recordPerPage);
  }

  //按条件查找记录集(只查询一页记录)
  public static List getRecords(String key, String value, int startIndex) {

    String sql = "select * from booktab where " + key + "='" + value +
        "' limit ?,?";
    sqlNumber = "select count(*) from booktab where " + key + "='" + value +
        "'";
    return DBUtil.executeQuery(sql, startIndex, recordPerPage);
  }

  //查询单条记录 用于修改
  public static BookBean getRecord(String value) {
    String sql = "select * from booktab where bookid='" + value + "'";
    BookBean book = new BookBean();
    book = DBUtil.execQuery(sql);
    return book;
  }

  //添加一条新记录
  public static int addRecord(Map newRecord) {
    String sql =
        "insert into booktab(bookname,author,publish,price,bookid)values(?,?,?,?,?)";
    return DBUtil.execUpdate(sql, newRecord);
  }

  //修改指定的记录
  public static int modifyRecord(Map newRecord) {
    String sql =
        "update booktab set bookname=?,author=?,publish=?,price=? where bookid=?";

上一页 [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] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:JBuilder2005实战JSP之特殊页面

下一篇:JSP数据库操作例程