WORK2

<%@ page contentType="text/html; charset=GBK" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<html>
<head><title>
resultBookQuery
</title>
</head>
<body bgcolor="#ffffff">
<table align="center"  border="1" cellspacing="1" cellpadding="0" bgcolor="#C4B8F1">
 <tr bgcolor="#FFFFFF">
    <th>书名</th>
    <th>作者</th>
    <th>书本简介</th>
    <th>价格</th>
    <th>类型</th>
    <th>销售数量</th>
    <th>是否特价书</th>
    <th>降价后的价格</th>
  </tr>
  <logic:present name="result">
 <logic:iterate id="book" name="result" type="admin.B_UpLoadForm" scope="session">
    <logic:present name="book">
    <html:form action="bookAlterAction.do">
     <tr bgcolor="#FFFFFF">
      <td>
        <bean:write name="book" property="book_name"/>
      </td>
      <td width="60">
        <bean:write name="book" property="author"/>
      </td>
      <td>
      <bean:write name="book" property="details"/>
      </td>
      <td>
        <bean:write name="book" property="price"/>
      </td>
      <td>
        <bean:write name="book" property="book_type"/>
      </td>
      <td width="60">
        <bean:write name="book" property="sell_count"/>
      </td>
      <td width="80">
        <bean:write name="book" property="istjbook"/>
      </td>
      <td width="100">
        <bean:write name="book" property="rebate_price"/>
      </td>      <td>
        <html:hidden property="book_id" name="book"/>
      <html:hidden name="book" property="rebate_price"/>
      <html:hidden name="book" property="istjbook"/>
      <html:hidden  name="book" property="sell_count"/>
      <html:hidden property="book_type" name="book"/>
      <html:hidden property="price" name="book"/>
      <html:hidden property="details" name="book"/>
      <html:hidden property="book_name" name="book"/>
      <html:hidden property="author" name="book"/>
      <html:submit property="alter"><bean:message key="button.alter"/>
      </html:submit>
      </td>
      <td><html:submit property="alter"><bean:message key="button.delete"/></html:submit></td>
    </tr>
    </html:form>
     </logic:present>
   </logic:iterate>
 </logic:present>
</table>
<logic:equal name="page" property="hasNextPage" value="true">
    <html:link page="/bookQuery2Action.do?action=nextPage">下一页</html:link>
  </logic:equal>
  <logic:equal name="page" property="hasPreviousPage" value="true">
    <html:link page="/bookQuery2Action.do?action=previousPage">前一页</html:link>
  </logic:equal>
  共有数据总数
  <bean:write name="page" property="totalRows"/>  ;
  共分
  <bean:write name="page" property="totalPages"/>
  页,当前是第
  <bean:write name="page" property="currentPage"/>
  页
</body>
</html>
====================================================================
package admin;import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.actions.LookupDispatchAction;
import java.util.Map;
import java.util.HashMap;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.DynaActionForm;
import bookstore.DBManage;
import javax.sql.DataSource;public class BookAlterAction extends LookupDispatchAction {
    public ActionForward bookAlter(ActionMapping mapping,
                                   ActionForm actionForm,
                                   HttpServletRequest request,
                                   HttpServletResponse response) {
        B_UpLoadForm book = (B_UpLoadForm) actionForm;        System.out.println("bookid:" + book.getBook_id() + "\n" +
                           book.getBook_type());
        HttpSession session = request.getSession();
        session.setAttribute("book", book);        return mapping.findForward("type_bookAlter");
    }    public ActionForward deleteItem(ActionMapping mapp,
                                    ActionForm actionForm,
                                    HttpServletRequest request,
                                    HttpServletResponse servletResponse) {
        B_UpLoadForm book = (B_UpLoadForm) actionForm;
        System.out.println(book.getBook_id());
        System.out.println("delete!!!!");
        String book_id = book.getBook_id();
        /// DBManage db=new DBManage();
        DataSource dataSource = getDataSource(request, "db");
        DBManage db_mg = new DBManage(dataSource);
        // if(db.conn==null)
        //db.getConnection();
        String sql = "delete from books where book_id='" + book_id + "'";
        db_mg.execSql(sql);
        db_mg.close();        return mapp.findForward("bookDeleteSucceed");
    }    protected Map getKeyMethodMap() {
        Map map = new HashMap();
        map.put("button.alter", "bookAlter");
        map.put("button.delete", "deleteItem");
        return map;
    }}
    protected Map getKeyMethodMap() {
        Map map = new HashMap();
        map.put("button.alter", "bookAlter");
        map.put("button.delete", "deleteItem");
        return map;
    }}