Android Open Source - foodroid Order List 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;
//w  w  w . j  a  v  a2s  . co m
import java.sql.*;
import javax.annotation.Resource;
import javax.faces.bean.ManagedBean;
import javax.sql.DataSource;
import javax.sql.rowset.CachedRowSet;

@ManagedBean( name="OrderListBean" )
public class OrderListBean 
{
    public ResultSet getOrders()
    {
        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(
                    //ID, BranchName, Username, Address, Tel, Date, Time, Price
                "SELECT *" +
                "FROM vw_orderlist ORDER BY ID" );
            
            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  ↑