Android Open Source - foodroid Order Bean

• Back to Development/sdk  ↑

From Project

Back to project page foodroid.

License

The source code is released under:

GNU General Public License

Java Source Code

package com.wmc.Registration;
//from  ww w. ja  va 2s. c  o  m
import java.sql.*;
import javax.annotation.Resource;
import javax.faces.bean.ManagedBean;
import javax.sql.DataSource;
import javax.sql.rowset.CachedRowSet;

@ManagedBean( name="OrderBean" )
public class OrderBean 
{    
    public ResultSet getOrders(int OrderID)
    {
        Connection connection = null;
        PreparedStatement getOrders = null;
        CachedRowSet rowSet = null;
        
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(Settings.DATABASE_URL,
                    Settings.DATABASE_USER, Settings.DATABASE_PASS);
            
            if ( connection == null )
                throw new SQLException( "Unable to connect to DataSource" );
            
            getOrders = connection.prepareStatement(
                //FoodID, FoodName, Price, FoodNum, OrderID
                "SELECT * " +
                "FROM vw_orderfoodlist Where OrderID = " + OrderID + " ORDER BY FoodID" );
            
            rowSet = new com.sun.rowset.CachedRowSetImpl();
            rowSet.populate( getOrders.executeQuery() );

        }
        catch(Exception e)
        {
           e.printStackTrace();
        }
        finally
        {            
            try
            {
                getOrders.close();
                connection.close();
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }
        
        return rowSet;
    }
}

Java Source Code List

• Back to Development/sdk  ↑