action

最新推荐文章于 2025-09-11 20:50:11 发布

原创最新推荐文章于 2025-09-11 20:50:11 发布 · 346 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#list #import #string #exception #action #sql

本文介绍了一个使用Struts框架实现的图书管理系统，包括增删改查等基本功能，并实现了分页显示已删除图书和回收站功能。

package action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.bookdao;

import actionform.bookform;

public class add extends Action {
public ActionForward execute(ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
  bookform book=(bookform)actionform;

  String sql="insert into book(author,title,publish,time,price) values ('"+book.getAuthor()+"','"+book.getTitle()+"','"+book.getPublish()+"','"+book.getTime()+"','"+book.getPrice()+"')";
  bookdao dao=new bookdao();
  int i= dao.getadd(sql);
  System.out.println(sql);
  request.setAttribute("book", book);
  if(i>0){
   return mapping.findForward("select");
  }else{
   return mapping.findForward("select");
   }

}

}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;

import javax.servlet.http.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMapping;

import com.bookdao;
import actionform.bookform;

public class del extends Action{
public ActionForward execute (ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
  System.out.print("阿里巴巴");
// bookform book =(bookform)actionform;

  String id=request.getParameter("id");
  bookdao bookdao =new bookdao();
  String sql="delete from book where id='"+id+"'";
  int i=bookdao.getadd(sql);

  if(i>0){
   System.out.println("删除成功");
   request.setAttribute("message", "添加成功");
   return mapping.findForward("list1");
  }else{return mapping.findForward("failure");}
}

}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.DBConnection;
import com.bookdao;

import actionform.bookform;

public class recycle extends Action{

public ActionForward execute (ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
// bookform book = (bookform)actionform;


   int   begin_no=0;   //开始的rownum记录号
      int   end_no=0;     //结束的rownum记录号
       ResultSet rs = null;

       // 获得当前页码
       int pageNo = 1;
       try {
           pageNo = Integer.parseInt(request.getParameter("pageNo"));
       } catch(Exception ex) {
       }
       if (pageNo < 1) {
           pageNo = 1;
       }
       request.setAttribute("pageNo", pageNo);

       List list = new ArrayList();
       int count = 0;
       // 根据页码从数据库中获得对应的数据
       try {
       DBConnection db= new DBConnection();
       Connection con;
       Statement stm;
       con=db.getConnection();
       stm=con.createStatement();
           begin_no=1+(5*(pageNo-1));
           end_no   = 5+(5*(pageNo-1));

       rs=stm.executeQuery("select   *   from   (select   rownum   row_id   ,id,author,title,publish,time,price,del from   (select   id,author,title,publish,time,price,del from   book   where del=0))   where   row_id   between   "   +begin_no+   "   and   "   +end_no );
    //   rs=stm.executeQuery("select   *   from   (select   rownum   row_id   ,id,author,title,publish,time,price,del from   (select   id,author,title,publish,time,price,del from   book   order   by   id   desc))   where   row_id   between   "   +begin_no+   "   and   "   +end_no );
           while (rs.next()) {
               bookform bean = new bookform();
               bean.setId(rs.getString("id"));
               bean.setAuthor(rs.getString("author"));
               bean.setTitle(rs.getString("title"));
               bean.setPublish(rs.getString("publish"));
               bean.setTime(rs.getString("time"));
               bean.setPrice(rs.getString("price"));
               bean.setDel(rs.getString("del"));
               list.add(bean);
           }
           rs.close();
        //   rs = stm.executeQuery("select * from book where del=1 ");
       rs = stm.executeQuery("select count(*) from book where del=0 ");
           if (rs.next()) {
               count = rs.getInt(1);
           }

       } catch(Exception ex) {
           ex.printStackTrace();
       }

request.setAttribute("count", count);
request.setAttribute("list", list);

//  String sql="select*from book";
//  bookdao bookdao= new bookdao();
//  ArrayList list=bookdao.getSelect(sql);
//  request.setAttribute("list", list);
  return mapping.findForward("list5");

}

}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.DBConnection;
import com.bookdao;

import actionform.bookform;

public class select extends Action{

public ActionForward execute (ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
// bookform book = (bookform)actionform;


   int   begin_no=0;   //开始的rownum记录号
      int   end_no=0;     //结束的rownum记录号
       ResultSet rs = null;

       List list = new ArrayList();
       int count = 0;
       // 根据页码从数据库中获得对应的数据
       try {
       DBConnection db= new DBConnection();
       Connection con;
       Statement stm;
       con=db.getConnection();
       stm=con.createStatement();
           begin_no=1+(5*(pageNo-1));
           end_no   = 5+(5*(pageNo-1));

       rs=stm.executeQuery("select   *   from   (select   rownum   row_id   ,id,author,title,publish,time,price,del from   (select   id,author,title,publish,time,price,del from   book   where del=1))   where   row_id   between   "   +begin_no+   "   and   "   +end_no );
    //   rs=stm.executeQuery("select   *   from   (select   rownum   row_id   ,id,author,title,publish,time,price,del from   (select   id,author,title,publish,time,price,del from   book   order   by   id   desc))   where   row_id   between   "   +begin_no+   "   and   "   +end_no );
           while (rs.next()) {
               bookform bean = new bookform();
               bean.setId(rs.getString("id"));
               bean.setAuthor(rs.getString("author"));
               bean.setTitle(rs.getString("title"));
               bean.setPublish(rs.getString("publish"));
               bean.setTime(rs.getString("time"));
               bean.setPrice(rs.getString("price"));
               bean.setDel(rs.getString("del"));
               list.add(bean);
           }
           rs.close();
        //   rs = stm.executeQuery("select * from book where del=1 ");
       rs = stm.executeQuery("select count(*) from book where del=1 ");
           if (rs.next()) {
               count = rs.getInt(1);
           }

       } catch(Exception ex) {
           ex.printStackTrace();
       }

request.setAttribute("count", count);
request.setAttribute("list", list);

//  String sql="select*from book";
//  bookdao bookdao= new bookdao();
//  ArrayList list=bookdao.getSelect(sql);
//  request.setAttribute("list", list);
  return mapping.findForward("list");

}

}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import com.bookdao;
import actionform.bookform;

public class select1 extends Action {
public ActionForward execute(ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
  bookform book =(bookform)actionform;
  bookdao bookdao= new bookdao();

  String id=request.getParameter("id");

  String sql="update book set del=0 where id='"+id+"'";


  int i=bookdao.getadd(sql);
  if(i>0){
   System.out.println("添加成功");
   request.setAttribute("message", "添加成功");

   return mapping.findForward("list3");

  }else{
   request.setAttribute("message", "添加失败");
   return mapping.findForward("failure");

  }

}

}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import com.bookdao;
import actionform.bookform;

public class up extends Action {
public ActionForward execute(ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
  bookform book =(bookform)actionform;
  bookdao bookdao= new bookdao();

  String id=request.getParameter("id");
  String author=request.getParameter("author");
  String title=request.getParameter("title");
  String publish=request.getParameter("publish");
  String time =request.getParameter("time");
  String price=request.getParameter("price");

  String sql="update book set author='"+author+"',title='"+title+"',publish='"+publish+"',time='"+time+"',price='"+price+"' where id='"+id+"'";


  int i=bookdao.getadd(sql);
  if(i>0){
   System.out.println("添加成功");
   request.setAttribute("message", "添加成功");

   return mapping.findForward("list2");

  }else{
   request.setAttribute("message", "添加失败");
   return mapping.findForward("failure");

  }

}

}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package action;
import java.util.ArrayList;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bookdao;

import actionform.bookform;

public class up1 extends Action{

public ActionForward execute (ActionMapping mapping,ActionForm actionform,HttpServletRequest request,HttpServletResponse response)
{
  String id=request.getParameter("id");

  bookform book = (bookform)actionform;

  String sql="select*from book where id='"+id+"'";
  bookdao bookdao= new bookdao();
  ArrayList list=bookdao.getSelect(sql);
  request.setAttribute("list", list);
  return mapping.findForward("update");

}

}