listaction.java

很好的东东 本人随便做的 仅供学习之用

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kefu.servlets;

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 kefu.javabeans.DBConnection;
import java.util.List;
import java.util.ArrayList;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import kefu.javabeans.DrugInfo;
/** 
 * MyEclipse Struts
 * Creation date: 09-09-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class ListAction 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) {
		// TODO Auto-generated method stub
		List list = new ArrayList();
		DBConnection dbc = new DBConnection();
		Connection conn = dbc.getConnection();
		String sql="select * from druginfo";
		PreparedStatement stmt;
		ResultSet rs;
		try{
			stmt=conn.prepareStatement(sql);
			rs=stmt.executeQuery();
			while(rs.next()){
				DrugInfo drug = new DrugInfo();
				drug.setId(rs.getInt(1));
				drug.setDrugNo(rs.getString(2));
				drug.setName(rs.getString(3));
				drug.setPrice(rs.getFloat(4));
				drug.setDrugType(rs.getString(5));
				drug.setComment(rs.getString(6));
				drug.setValidity(rs.getInt(7));
				list.add(drug);
			}
			System.out.println("ListAction数据库连接成功。。。");
		}catch(Exception ee){
			ee.printStackTrace();
			System.out.println("ListAction数据库连接失败。。。");
		}
		request.setAttribute("list", list);
		return mapping.findForward("ok");
	}
}