Android Open Source - foodroid Order S M S






From Project

Back to project page foodroid.

License

The source code is released under:

GNU General Public License

If you think the Android project foodroid listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor./*from  www  . ja  v  a2  s  .  com*/
 */
package smsserver;

import java.sql.*;

public class OrderSMS 
{
    public void put(String order, String food, String table, String price)
    {
        Connection connection = null;
        PreparedStatement InsertOrder = null;
        PreparedStatement InsertTable = null;
        PreparedStatement InsertFood = null;
        PreparedStatement lookupUser = null;
        
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(Settings.DATABASE_URL,
                    Settings.DATABASE_USER, Settings.DATABASE_PASS);
            
            String Username = order.substring(0, order.indexOf('-'));
            order = order.substring(order.indexOf('-') + 1);
            String BranchID = order.substring(0, order.indexOf('-'));
            order = order.substring(order.indexOf('-') + 1);
            String date = order.substring(0, order.indexOf('-'));
            date = Settings.replace(date,"_", "/");
            order = order.substring(order.indexOf('-') + 1);
            String time = order;
            time = Settings.replace(time,"_", ":");
                 
            lookupUser = connection.prepareStatement(
            "SELECT ID FROM user WHERE Username = '" + Username + "'");
            ResultSet resultSetUser = lookupUser.executeQuery();
            resultSetUser.next();
            String UserID = resultSetUser.getObject("ID").toString();
            
            InsertOrder = connection.prepareStatement("insert into tbl_order (UserID,BranchID,Date,Time,Price)" +
                  " values (" + UserID + "," + BranchID + ",'" + date + "','" + time +"'," + price + ")");
            InsertOrder.executeUpdate();

            InsertOrder = connection.prepareStatement("select max(ID) AS ID  from  tbl_order");
            ResultSet resultSetOrder = InsertOrder.executeQuery();
            resultSetOrder.next();
            int OrederID = Integer.parseInt(resultSetOrder.getObject("ID").toString());
            
            if(!table.equals("-"))
            {
                String tableID = table;
                InsertTable = connection.prepareStatement("insert into ordertable (OrderID,TableID)" +
                    " values (" + OrederID + "," + tableID + ")");
                InsertTable.executeUpdate();
            }
            String FoodRow;
            if(!food.equals("-"))
            {
                while(!food.equals(""))
                {
                    if(food.substring(1).indexOf('_') != -1)
                        FoodRow = food.substring(1,food.substring(1).indexOf('_')+1);
                    else
                        FoodRow = food.substring(1);     
                    if(food.substring(1).indexOf('_') != -1)
                        food = food.substring(food.substring(1).indexOf('_')+1);
                    else
                        food = "";
                    String FoodID = FoodRow.substring(0,FoodRow.indexOf('-'));
                    FoodRow = FoodRow.substring(FoodRow.indexOf('-') + 1);
                    String FoodNum = FoodRow;
                
                    InsertFood = connection.prepareStatement("insert into orderfood (OrderID,FoodID,FoodNum)" +
                        " values (" + OrederID + "," + FoodID + "," + FoodNum + ")");
                    InsertFood.executeUpdate();
                }
            }

         }
        catch(SQLException e)
        {
           e.printStackTrace();
        }
        catch (ClassNotFoundException cE)
        {
            System.out.println("Class Not Found Exception: "+ cE.toString());
        }
        catch(Exception e)
        {
           e.printStackTrace();
        }
        finally
        {
            try
            {
                InsertOrder.close();
                InsertTable.close();
                InsertFood.close();
                lookupUser.close();
                connection.close();
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }
    }
}




Java Source Code List

com.adp.ADPWsSample.java
com.adp.BalanceResult.java
com.adp.ChangePasswordResponse.java
com.adp.ChangePassword.java
com.adp.GetBalanceResponse.java
com.adp.GetBalance.java
com.adp.GetStatusResponse.java
com.adp.GetStatus.java
com.adp.IncomingMessage.java
com.adp.JaxRpcMessagingServiceServiceLocator.java
com.adp.JaxRpcMessagingServiceService.java
com.adp.JaxRpcMessagingService.java
com.adp.MessageObject.java
com.adp.MessagingServiceSoapBindingStub.java
com.adp.MultiAddressMessageObject.java
com.adp.OutgoingMessage.java
com.adp.ReceiveResponse.java
com.adp.ReceiveResult.java
com.adp.Receive.java
com.adp.ReportResponse.java
com.adp.ReportResult.java
com.adp.Report.java
com.adp.Result.java
com.adp.SendMultipleResponse.java
com.adp.SendMultiple.java
com.adp.SendResponse.java
com.adp.SendResult.java
com.adp.Send.java
com.adp.StatusReportResponse.java
com.adp.StatusReportResult.java
com.adp.StatusReportType0.java
com.adp.StatusReport.java
com.sba.util.DateFields.java
com.sba.util.PersianCalendar.java
com.wmc.Registration.BranchlistResource.java
com.wmc.Registration.CommentListBean.java
com.wmc.Registration.CommentResource.java
com.wmc.Registration.CommentlistResource.java
com.wmc.Registration.FoodListResource.java
com.wmc.Registration.LoginResource.java
com.wmc.Registration.OrderBean.java
com.wmc.Registration.OrderListBean.java
com.wmc.Registration.OrderResource.java
com.wmc.Registration.RegisterResource.java
com.wmc.Registration.ReserveListBean.java
com.wmc.Registration.Settings.java
com.wmc.ReservationClient.Account.java
com.wmc.ReservationClient.BranchList.java
com.wmc.ReservationClient.BranchPage.java
com.wmc.ReservationClient.Branch.java
com.wmc.ReservationClient.Comment.java
com.wmc.ReservationClient.DatabaseHelper.java
com.wmc.ReservationClient.Favorite.java
com.wmc.ReservationClient.FoodList.java
com.wmc.ReservationClient.FoodPage.java
com.wmc.ReservationClient.Food.java
com.wmc.ReservationClient.Login.java
com.wmc.ReservationClient.Main.java
com.wmc.ReservationClient.OrderList.java
com.wmc.ReservationClient.Order.java
com.wmc.ReservationClient.Search.java
com.wmc.ReservationClient.SmsMessageReceiver.java
com.wmc.ReservationClient.Table.java
com.wmc.ReservationClient.Update.java
com.wmc.ReservationClient.Utility.java
smsserver.CommentSMS.java
smsserver.LoginSMS.java
smsserver.OrderSMS.java
smsserver.Settings.java
smsserver.SmsServer.java