addbookaction.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.servlet.http.HttpSession;
import javax.sql.DataSource;

import kignbi.dong.*;
import kignbi.dong.form.AddBookForm;
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-29-2008
 * 
 * XDoclet definition:
 * @struts.action path="/addBook" name="addBookForm" input="/admin/addbook.jsp" scope="request" validate="true"
 */
public class AddBookAction 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) {
		AddBookForm addBookForm = (AddBookForm) form;// TODO Auto-generated method stub
	String bid=addBookForm.getBid();
	String bname=addBookForm.getBname();
	String bkind=addBookForm.getBkind();
	String bauthor=addBookForm.getBauthor();
	String bpublish=addBookForm.getBpublish();
	int bnumber=0+Integer.parseInt(addBookForm.getBnumber());
	float bprice=0+Float.parseFloat(addBookForm.getBprice());
	String bdt_publish=addBookForm.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="insert into books  values('"+bid+"','"+bname+"','"+bkind+" ','"+bpublish
	+" ','"+bauthor+" ',"+bprice+","+bnumber+",'"+bdt_publish+"')";
	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<10){
	    		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("add.book.failture"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
		     }
	     }
	}
	     catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			    }
				db.close();
				return mapping.findForward(PageForward);
    }

}