dconnetfood.java

利用Struts的MVC写的WEB开发程序

/****************************
****************************/
package dlayer;

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

import bean.FoodMenuBean;

public class DConnetFood extends DConnet {

	private Connection con;
	
	private ResultSet rs;
	
	private Statement stmt;
	
	public void DOperation() {
		
	}

	public ArrayList getUserResultSet() throws SQLException {
	
		//this.Connect();
		
		con = super.Connect();

		stmt = con.createStatement();
		
		StringBuffer buffer = new StringBuffer();
		
		ArrayList foodList = new ArrayList();
	
			buffer.append("select * from FOOD_MENU");
		
		String sql = buffer.toString();
	
			rs = stmt.executeQuery(sql);
			
			while (rs.next()) {
			
				FoodMenuBean foodBean = new FoodMenuBean();
				
				foodBean.setFoodId(rs.getString("FOOD_ID"));
		
				foodBean.setFoodName(rs.getString("FOOD_NAME"));
				
				foodBean.setFoodprice(rs.getString("FOOD_PRICE"));
                
				foodList.add(foodBean);
			
			}			
				
		return foodList;
		
	}

}