manager1.java

A brew application taking backup of the device

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package MyPackage1;
import DBConnection1.*;
import java.sql.*;
import javax.servlet.http.HttpSession;

/**
 *
 * @author @n@
 */
public class Manager1 {
       DBConnection1 dbc = null;
       ResultSet rs = null;
       HttpSession ssMgr = null;
       public Manager1 () {
              dbc = new DBConnection1 ();
       }

      public void InsertInUploadContacts(String PinNo,String Name, String Number, java.util.Date date, HttpSession ss) {
             ssMgr = ss;
             java.sql.Date mydate = new java.sql.Date(date.getTime());
             String Query = "Insert into upload_contacts values('"+PinNo+"','"+Name+"','"+Number+"','"+mydate+"')";
             dbc.insert(Query, ssMgr);             
        }

       public void CheckCurrentDateData(String PinNo,String Name, String Number, java.util.Date date, HttpSession ss) throws SQLException {
             ssMgr = ss;
             java.sql.Date mydate = new java.sql.Date(date.getTime());
             String Query = "Delete from upload_contacts where pin_no='"+PinNo+"' AND name='"+Name+"' AND number='"+Number+"' AND upload_date='"+mydate+"' ";
             dbc.delete(Query, ssMgr);             
        }

      public ReturnType SelectDate ( String pinNo, HttpSession ss) throws SQLException{
          ssMgr = ss;
          String rtDate;
          String returnedString=null;
          boolean flag =false;
          String Query = "select distinct upload_date from upload_contacts where pin_no='"+pinNo+"'order by upload_date desc";
          rs = dbc.select(Query, ssMgr);
          ReturnType rt = new ReturnType ();
          while ( rs.next()){
              if (!flag) {
                  rtDate =rs.getString("upload_date");
                  rt.StringType =rtDate;
                  flag = true;
              }
              else {
                  returnedString =rs.getString("upload_date");
                  rt.StringType = rt.StringType +","+ returnedString;
              }
          }
          return rt;
      }

      public ReturnType SelectRecord ( String pinNo, String date, HttpSession ss) throws SQLException{
          ssMgr = ss;
          String name;
          String number;
          String returnedString=null;
          boolean flag =false;
          String Query = "select name, number from upload_contacts where pin_no='"+pinNo+"' AND upload_date='"+date+"'";
          rs = dbc.select(Query, ssMgr);
          ReturnType rt = new ReturnType ();
          while ( rs.next()){
              if (!flag) {
                  flag = true;
                  name =rs.getString("name");
                  number =rs.getString("number");
                  returnedString = name +":"+ number;
                  rt.StringType =returnedString;
              }
              else {
                  name =rs.getString("name");
                  number =rs.getString("number");
                  returnedString = name +":"+ number;
                  rt.StringType = rt.StringType +","+ returnedString;
              }
          }
          return rt;
      }
}

 class ReturnType {
    public String StringType;
    public ReturnType(){}
}