largessaccess.java

来自「Athena酒店小组_Athena酒店管理系统」· Java 代码 · 共 54 行

/*
 * LargessAccess.java
 *
 * Created on 2007年6月18日, 上午4:54
 *
 * 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 LargessAccess {
     private IDBResource dbRes;
    /** Creates a new instance of LargessAccess */
    public LargessAccess(IDBResource dbRes)
    {
        this.dbRes=dbRes;
    }
    
     public int insert(LargessInfo largessInfo)
    {
	try
	{
	    Connection conn = dbRes.getConnection();
            java.util.Date d = new java.util.Date(System.currentTimeMillis());
            d.toString(); 
	    String sql = "INSERT INTO LargessInfo(MenuId, TableId, FoodId,LargessDate,LargessReason) " +
		    " VALUES(?, ?, ?,?,?)";
	    PreparedStatement ps = conn.prepareStatement(sql);
	    ps.setString(1, largessInfo.getMenuId());
	    ps.setString(2, largessInfo.getTableId());
	    ps.setString(3, largessInfo.getFoodId());
            ps.setObject(4,largessInfo.getLargessDate());
            ps.setString(5,largessInfo.getLargessReason());
	    int rs = ps.executeUpdate();	    
	    return rs;
	}
	catch (SQLException ex)
	{
	    ex.printStackTrace();
	    return -1;
	}		
    }
    
}