Ejemplo n.º 1
0
 public DBWorker() {
   try {
     Class.forName("com.mysql.jdbc.Driver");
     connection = DriverManager.getConnection(HOST, USERNAME, PASSWORD);
   } catch (SQLException | ClassNotFoundException e) {
     e.printStackTrace();
   }
 }
Ejemplo n.º 2
0
  public static void main(String[] args) {

    Connection connection = null;
    try {
      // Register the driver
      Class.forName("org.postgresql.Driver");
      // Make the connection
      connection =
          DriverManager.getConnection(
              "jdbc:postgresql://cmps180-db.lt.ucsc.edu/ssmcgrat", "ssmcgrat", "calculated33XML");

      StoreApplication app = new StoreApplication();
      List<String> phoneNumbers =
          app.getCustomerPhoneFromFirstLastName(connection, "John", "Smith");

      /** ********** Print the phone numbers here: *************** */
      List<String> filmTitles = app.getFilmTitlesBasedOnLengthRange(connection, 60, 120);

      /** *********** Print the film titles here: **************** */
      int count = app.countCustomersInDistrict(connection, "Buenos Aires", false);

      /** ********** Print the customer count here: ************* */

      // add a film to the database
      app.insertFilmIntoInventory(connection, "Sequel to the Prequel", "Memorable", 98, "PG-13");
    } catch (SQLException | ClassNotFoundException e) {
      System.out.println("Error while connecting to database: " + e);
      e.printStackTrace();
    } finally {
      if (connection != null) {
        // Closing Connection
        try {
          connection.close();
        } catch (SQLException e) {
          System.out.println("Failed to close connection: " + e);
          e.printStackTrace();
        }
      }
    }
  }
Ejemplo n.º 3
0
  @Override
  public synchronized Account newAccount(String name) throws RemoteException, RejectedException {
    AccountImpl account = (AccountImpl) accounts.get(name);
    if (account != null) {
      System.out.println("Account [" + name + "] exists!!!");
      throw new RejectedException(
          "Rejected: Bank:  Account for: " + name + " already exists: " + account);
    }
    ResultSet result = null;
    try {
      findAccountStatement.setString(1, name);
      result = findAccountStatement.executeQuery();

      if (result.next()) {
        // account exists, instantiate, put in cache and throw exception.
        account = new AccountImpl(name, result.getFloat("balance"), getConnection());
        accounts.put(name, account);
        throw new RejectedException("Rejected: Account for: " + name + " already exists");
      }
      result.close();

      // create account.
      createAccountStatement.setString(1, name);
      int rows = createAccountStatement.executeUpdate();
      if (rows == 1) {
        account = new AccountImpl(name, getConnection());
        accounts.put(name, account);
        System.out.println("Bank: Account: " + account + " has been created for " + name);
        return account;
      } else {
        throw new RejectedException("Cannot create an account for " + name);
      }
    } catch (SQLException | ClassNotFoundException e) {
      e.printStackTrace();
      throw new RejectedException("Cannot create an account for " + name, e);
    }
  }
Ejemplo n.º 4
0
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    String userAgent = request.getHeader("user-agent");
    if (userAgent.matches(".*Android.*")) {
      int flag = 0;
      try {
        Connection con = DBConnectionAdmin.getConnection();
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT email,password FROM admin");

        String emailmember = request.getParameter("mail");
        String passwordmember = request.getParameter("pass");
        while (rs.next()) {
          String email = rs.getString("email");
          String password = rs.getString("password");
          if (email.equals(emailmember) && password.equals(passwordmember)) {
            flag = 1; // success in login
            break;
          }
        }

        /*if(request.getParameter("remember")!=null ){
        	if( request.getParameter("remember").equals("yes") ){
        					Cookie c1 = new Cookie("email", emailmember);
        					c1.setMaxAge(60*60*24*365);
        					response.addCookie(c1);
        					Cookie c2 = new Cookie("password", passwordmember);
        					c2.setMaxAge(60*60*24*365);
        					response.addCookie(c2);

        	}
        }
        else{
        	Cookie[] cookies = request.getCookies();
        	if (cookies != null) {
        		for(Cookie cookie: cookies) {
        			if(cookie.getName().equals("email")){
        				cookie.setMaxAge(0);
        				response.addCookie(cookie);
        			}
        			else if(cookie.getName().equals("password")){
        				cookie.setMaxAge(0);
        				response.addCookie(cookie);
        			}
        		}
        	}

        }*/

      } catch (SQLException | ClassNotFoundException e1) {
        e1.printStackTrace();
      }
      if (flag == 1) {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
        String title = "You Signed In Successfully";
        out.println(
            docType
                + "<HTML>\n"
                + "<HEAD>"
                + "<script type='text/javascript'>"
                + "function changeweb() {"
                + "   AndroidFunction.Second();"
                + "}"
                + "</script>"
                + "<TITLE>"
                + title
                + "</TITLE></HEAD>\n"
                + "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>"
                + title
                + "</H1>\n"
                + "<button type='button' onclick=\"changeweb()\">Click Me!</button>"
                + "</BODY></HTML>");
        HttpSession session = request.getSession(true);
        String email = request.getParameter("mail");
        session.setAttribute("email", email);

      } else {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
        String title = "Wrong password or E-mail.Please try again.";
        out.println(
            docType
                + "<HTML>\n"
                + "<HEAD><TITLE>"
                + title
                + "</TITLE></HEAD>\n"
                + "<BODY BGCOLOR=\"#FDF5E6\" ><H1 ALIGN=CENTER>"
                + title
                + "</H1>\n</BODY></HTML>");
      }
    } else {
      response.setContentType("text/html");
      PrintWriter out = response.getWriter();
      String docType = "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 " + "Transitional//EN\">\n";
      String title = "Main";
      out.println(
          docType
              + "<HTML>\n"
              + "<HEAD><TITLE>"
              + title
              + "</TITLE>"
              + "<style>"
              + "ul"
              + "{"
              + "list-style-type:none;"
              + "margin:0;"
              + "padding:0;"
              + "overflow:hidden;"
              + "}"
              + "li"
              + "{"
              + "float:left;"
              + "}"
              + "a:link,a:visited"
              + "{"
              + "display:block;"
              + "font-weight:bold;"
              + "font-size:200%;"
              + "color:#FFFFFF;"
              + "background-color:#98bf21;"
              + "text-align:center;"
              + "padding:4px;"
              + "text-decoration:none;"
              + "text-transform:uppercase;"
              + "border: 1px solid black;"
              + "padding:25px"
              + "}"
              + "a:hover,a:active"
              + "{"
              + "background-color:#7A991A;"
              + "}"
              + "</style>"
              + "</HEAD>\n"
              + "<body style='background-color:black' >\n");

      out.println("<ul>");
      out.println("<li><a href='http://localhost:8083/TestProject/main.html'>New Event!!</a></li>");
      out.println("<li><a href='post.Eventlist'>Events</a></li>");
      out.println("<li><a href='post.Myeventlist'>My Events</a></li>");
      out.println("<li><a href='post.Memberslist'>Members</a></li>");
      out.println("<li><a href='post.Profile'>Profile</a></li>");
      out.println("<li><a href='post.Help'>Help</a></li>");
      out.println("</ul>");
      out.println("</BODY></HTML>");
    }
  }