upbooksaction.java

eclipse+struts+sqlserver 简单图书管理系统,内有文档

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kignbi.dong.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import kignbi.dong.Books;
import kignbi.dong.Constants;
import kignbi.dong.DB;
import kignbi.dong.form.UpBooksForm;
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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

/** 
 * MyEclipse Struts
 * Creation date: 01-30-2008
 * 
 * XDoclet definition:
 * @struts.action path="/upBooks" name="upBooksForm" input="/admin/upbooks.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/user/booklist.jsp"
 */
public class UpBooksAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		UpBooksForm upBooksForm = (UpBooksForm) form;// TODO Auto-generated method stub
		String bid=upBooksForm.getBid();
		String bname=upBooksForm.getBname();
		String bkind=upBooksForm.getBkind();
		String bauthor=upBooksForm.getBauthor();
		String bpublish=upBooksForm.getBpublish();
		int bnumber=0+Integer.parseInt(upBooksForm.getBnumber());
		float bprice=0+Float.parseFloat(upBooksForm.getBprice());
		String bdt_publish=upBooksForm.getBdt_publish();
		
		//HttpSession session = request.getSession(true);
		ActionMessages errors = new ActionMessages();
		String PageForward = "false";
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		String str="select * from books ";
		String sql="update books set bname='"+bname+"',bkind='"+bkind+"',bpublish='"+bpublish
		+"',bauthor='"+bauthor+"',bnumber="+bnumber+",bprice="+bprice+",bdt_publish='"+bdt_publish+"'"
		+" where bid='"+bid+"'";
		try{ int status=db.ExecSql(sql);
		     if(status==1)
		     {
		    	ResultSet rs=db.OpenSql(str); 
		    	ArrayList res=new ArrayList();
		    	int i=0;
		    	while(rs.next()){
		    		i=i+1;
		    		Books book=new Books();
		    		book.setBid(rs.getString(2));
		    		book.setBname(rs.getString(3));
		    		book.setBkind(rs.getString(4));
		    		book.setBpublish(rs.getString(5));
		    		book.setBauthor(rs.getString(6));
		    		book.setBprice(rs.getFloat(7));
		    		book.setBnumber(rs.getInt(8));
		    		book.setBdt_publish(rs.getString(9));
		    		res.add(book);
		    	}
		    	  String count=Integer.toString(i);
		          request.setAttribute("count", count);
		          request.setAttribute("books",res);
		          PageForward="success";
		     }
		     else {
				  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("up.book.failture"));
		         if (!errors.isEmpty()) {
			       saveErrors(request, errors);
			     }
		     }
		}
		     catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				    }
					db.close();
					return mapping.findForward(PageForward);
	}
}