Android Open Source - foodroid Comment 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.//w w w . j av  a  2s  . c o  m
 */
package smsserver;

import java.sql.*;

public class CommentSMS
{
    public void put(String favorite, String rate, String branch, String user, String message)
    {
        Connection connection = null;
        PreparedStatement InsertComment = null;
        PreparedStatement lookupFavorite = null;
        PreparedStatement InsertFavorite = null;
        PreparedStatement lookupUser = null;
        
        try
        {
            
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(Settings.DATABASE_URL,
                    Settings.DATABASE_USER, Settings.DATABASE_PASS);
            
            InsertComment = connection.prepareStatement("insert into comment (BranchID, message, rate)" +
                  " values (" + branch + ",'" + message.replace('-', ' ') + "'," + rate + ")");
            InsertComment.executeUpdate();

            lookupUser = connection.prepareStatement(
            "SELECT ID FROM user WHERE Username = '" + user + "'");
            ResultSet resultSetUser = lookupUser.executeQuery();
            resultSetUser.next();
            String UserID = resultSetUser.getObject("ID").toString();

            lookupFavorite = connection.prepareStatement(
            "SELECT * FROM favorite WHERE BranchID = " + branch + " AND UserID = " + UserID);
            ResultSet resultSetFavorite = lookupFavorite.executeQuery();

            if(!resultSetFavorite.next())
            {
                InsertFavorite = connection.prepareStatement("insert into favorite (UserID, BranchID)" +
                        " values (" + UserID + "," + branch + ")");
                InsertFavorite.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{
                InsertComment.close();
                lookupFavorite.close();
                InsertFavorite.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