moneyaction.java

图书管理系统,Struts框架开发,有数据库

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.yourcompany.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;

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.yourcompany.struts.form.MoneyForm;
import com.yourcompany.struts.datebase.*;
/** 
 * MyEclipse Struts
 * Creation date: 09-02-2008
 * 
 * XDoclet definition:
 * @struts.action path="/money" name="moneyForm" input="/money.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/user.jsp"
 */
public class MoneyAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws SQLException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws SQLException {
		MoneyForm moneyForm = (MoneyForm) form;// TODO Auto-generated method stub
		String username=moneyForm.getUsername();
		String select=null;
		System.out.println(username);
		System.out.println(select);
		int i=Integer.parseInt(moneyForm.getSelect());
		System.out.println(i);
		ResultSet rs=Database.getregister(username);
		while(rs.next())
		{
			select=rs.getString("money");
		}
		if(select!=null)
		{
			int j=Integer.parseInt(select);
			System.out.println("j:"+j);
			int k=j+i;
			String se=String.valueOf(k);
			System.out.println("se:"+se);
			boolean tag=Database.money_update(username, se);
			if(tag)
			{
				return mapping.findForward("success");
			}
			else
			{
				return mapping.findForward("failure");
			}
		}
		else
		{
			return mapping.findForward("failure");
		}
		
	}
}