menuinfoaccess.java

Athena酒店小组_Athena酒店管理系统

/*
 * MenuInfoAccess.java
 *
 * Created on 2007年6月18日, 下午1:05
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dennis;
import java.util.*;
import java.sql.*;

import plugin.*;
/**
 *
 * @author Administrator
 */
public class MenuInfoAccess {
    private IDBResource dbRes;
    /** Creates a new instance of MenuInfoAccess */
    public MenuInfoAccess(IDBResource dbRes)
    {
        this.dbRes=dbRes;
    }
    
   public int insert(MenuInfo menuInfo)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "INSERT INTO MenuInfo(MenuId, FoodId,IsLargess, Rebate,ConsumeDate) " +
		    " VALUES(?, ?, ?,?,?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, menuInfo.getMenuId());
	    ps.setString(2, menuInfo.getFoodId());
	    ps.setString(3, menuInfo.getIsLargess());
            ps.setString(4, menuInfo.getRebate());
            java.sql.Date da=new java.sql.Date(menuInfo.getConsumeDate().getYear(),menuInfo.getConsumeDate().getMonth(),menuInfo.getConsumeDate().getDay());
            ps.setDate(5, da);
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}		
    }
   
    public int update(MenuInfo menuInfo)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "UPDATE MenuInfo SET IsLargess = ?, Rebate = ? WHERE lineNum = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, menuInfo.getIsLargess());
	    ps.setString(2, menuInfo.getRebate());
	    ps.setInt(3, menuInfo.getLineNum());
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}		
    }
     public int delete(MenuInfo menuInfo)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "DELETE FROM MenuInfo WHERE lineNum = ?";
	    PreparedStatement ps = conn.prepareStatement(sql);	   
	    ps.setInt(1, menuInfo.getLineNum());
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}		
    }
     

     
      public ArrayList<MenuInfo> getAllMenuInfos()
    {
	try
	{
	    Connection conn = dbRes.getConnection();
	    String sql = "SELECT * FROM MenuInfo";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ResultSet rs = ps.executeQuery();
	    ArrayList<MenuInfo> menuInfos = new ArrayList<MenuInfo>();
	    while(rs.next())
	    {
		MenuInfo menuInfo = new MenuInfo();
		menuInfo.setLineNum(rs.getInt("lineNum"));
		menuInfo.setMenuId(rs.getString("MenuId"));
                menuInfo.setFoodId(rs.getString("FoodId"));
		menuInfo.setIsLargess(rs.getString("IsLargess"));
                menuInfo.setRebate(rs.getString("Rebate"));
                menuInfo.setConsumeDate(rs.getDate("ConsumeDate"));
		menuInfos.add(menuInfo);
	    }
	    return menuInfos;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return null;
	}		
    }
}