<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*,java.util.*,java.text.*"%> <%@ include file="/Connections/edros.jsp" %> <% String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null; DecimalFormat df = new DecimalFormat("€ ###,###,##0.00") ; String sql=""; Driver MM_driver = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection MM_connection = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement MM_editStatement = MM_connection.prepareStatement(""); String[] idzValues = request.getParameterValues("idz"); String[] qtazValues = request.getParameterValues("qtaz"); String[] pricezValues = request.getParameterValues("pricez"); String[] namezValues = request.getParameterValues("name_prod"); MM_editStatement = MM_connection.prepareStatement("delete from shopping where quantity=0 and session='"+session.getValue("s")+"'"); ResultSet prodotti=MM_editStatement.executeQuery(); java.util.StringTokenizer prezzoz; int num_tok,qta_richiesta; String qtax; String prezzo_def="",vecchio=""; if (idzValues!=null){ for(int i=0; i0){ prezzoz= new java.util.StringTokenizer(pricezValues[i],","); qtax=""; if (prezzoz.countTokens()>2) { num_tok=(prezzoz.countTokens()-1)/2; for (int ss=0;ss"); } vecchio=prezzoz.nextToken(); if (prezzo_def==""){ prezzo_def=vecchio; } // out.println("Da "+(Integer.parseInt(qtax,10)+1)+" - "); // out.println("€ "+df.format(Double.valueOf(vecchio).doubleValue()/1936.27)+"
"); } else { prezzo_def=prezzoz.nextToken(); } //out.println(prezzo_def); MM_editStatement = MM_connection.prepareStatement("select * from shopping where product="+idzValues[i]+" and session='"+session.getValue("s")+"'"); prodotti=MM_editStatement.executeQuery(); if (!prodotti.next()) { MM_editStatement = MM_connection.prepareStatement("insert into shopping (card,quantity,product,session,prezzo) values ('"+namezValues[i]+"','"+qtazValues[i]+"','"+idzValues[i]+"','"+session.getValue("s")+"','"+prezzo_def+"')"); MM_editStatement.executeUpdate(); } else { MM_editStatement = MM_connection.prepareStatement("update shopping set quantity="+qtazValues[i]+",prezzo="+prezzo_def+" where id="+Integer.parseInt(prodotti.getObject("id").toString(),10)); MM_editStatement.executeUpdate(); } // out.println("insert into shopping (quantity,product,session,prezzo) values ('"+namezValues[i]+"','"+qtazValues[i]+"','"+idzValues[i]+"','"+session.getValue("s")+"','"+prezzo_def+"')
"); } } } String tot; prezzo_def=""; if (request.getParameter("MM_update") != null) { qta_richiesta=Integer.parseInt(request.getParameter("quantity").toString(),10); prezzoz= new java.util.StringTokenizer(pricezValues[0],","); qtax=""; if (prezzoz.countTokens()>2) { num_tok=(prezzoz.countTokens()-1)/2; for (int ss=0;ss"); } vecchio=prezzoz.nextToken(); if (prezzo_def=="") { prezzo_def=vecchio; } out.println("Da "+(Integer.parseInt(qtax,10)+1)+" - "); out.println("€ "+df.format(Double.valueOf(vecchio).doubleValue()/1936.27)+"
"); } else { prezzo_def=prezzoz.nextToken(); } sql="update shopping set quantity="+request.getParameter("quantity")+",prezzo="+prezzo_def+" where id="+request.getParameter("MM_recordId"); MM_editStatement = MM_connection.prepareStatement(sql); MM_editStatement.executeUpdate(); MM_connection.close(); response.sendRedirect("carrello.jsp"); } String prodotti__MMColParam = "1"; if (request.getParameter("id") !=null) {prodotti__MMColParam = (String)request.getParameter("id");} Driver Driverprodotti = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection Connprodotti = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement Statementprodotti = Connprodotti.prepareStatement("SELECT * FROM c_prodotti WHERE id = " + prodotti__MMColParam + ""); prodotti = Statementprodotti.executeQuery(); boolean prodotti_isEmpty = !prodotti.next(); boolean prodotti_hasData = !prodotti_isEmpty; Object prodotti_data; int prodotti_numRows = 0; %> <% String carrello__MMColParam = "lu587ynqu1 "; carrello__MMColParam = session.getValue("s").toString() ; %> <% Driver Drivercarrello = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection Conncarrello = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement Statementcarrello = Conncarrello.prepareStatement("SELECT *,titolo,shopping.id as id_shop FROM shopping left join c_prodotti on product=c_prodotti.id WHERE session = '" + carrello__MMColParam + "'"); ResultSet carrello = Statementcarrello.executeQuery(); boolean carrello_isEmpty = !carrello.next(); boolean carrello_hasData = !carrello_isEmpty; Object carrello_data; int carrello_numRows = 0; %> <% Driver DriverProgrammatori = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection ConnProgrammatori = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement StatementProgrammatori = ConnProgrammatori.prepareStatement("SELECT * FROM shopping WHERE session = '"+session.getValue("s").toString()+"' and (product=66)"); ResultSet Programmatori = StatementProgrammatori.executeQuery(); boolean Programmatori_isEmpty = !Programmatori.next(); boolean Programmatori_hasData = !Programmatori_isEmpty; Object Programmatori_data; int Programmatori_numRows = 0; %> <% Driver DriverCavo_PIN = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection ConnCavo_PIN = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement StatementCavo_PIN = ConnCavo_PIN.prepareStatement("SELECT * FROM shopping WHERE session = '"+session.getValue("s").toString()+"' and (product=14)"); ResultSet Cavo_PIN = StatementCavo_PIN.executeQuery(); boolean Cavo_PIN_isEmpty = !Cavo_PIN.next(); boolean Cavo_PIN_hasData = !Cavo_PIN_isEmpty; Object Cavo_PIN_data; int Cavo_PIN_numRows = 0; %> <% Driver DriverAlimentatore = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection ConnAlimentatore = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement StatementAlimentatore = ConnAlimentatore.prepareStatement("SELECT * FROM shopping WHERE session = '"+session.getValue("s").toString()+"' and (product=37)"); ResultSet Alimentatore = StatementAlimentatore.executeQuery(); boolean Alimentatore_isEmpty = !Alimentatore.next(); boolean Alimentatore_hasData = !Alimentatore_isEmpty; Object Alimentatore_data; int Alimentatore_numRows = 0; %> <% Driver DriverCavo_parallelo = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection ConnCavo_parallelo = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement StatementCavo_parallelo = ConnCavo_parallelo.prepareStatement("SELECT * FROM shopping WHERE session = '"+session.getValue("s").toString()+"' and (product=29)"); ResultSet Cavo_parallelo = StatementCavo_parallelo.executeQuery(); boolean Cavo_parallelo_isEmpty = !Cavo_parallelo.next(); boolean Cavo_parallelo_hasData = !Cavo_parallelo_isEmpty; Object Cavo_parallelo_data; int Cavo_parallelo_numRows = 0; %> <% Driver DriverProgrammatore_parallelo = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection ConnProgrammatore_parallelo = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement StatementProgrammatore_parallelo = ConnProgrammatore_parallelo.prepareStatement("SELECT * FROM shopping WHERE session = '"+session.getValue("s").toString()+"' and (product=23)"); ResultSet Programmatore_parallelo = StatementProgrammatore_parallelo.executeQuery(); boolean Programmatore_parallelo_isEmpty = !Programmatore_parallelo.next(); boolean Programmatore_parallelo_hasData = !Programmatore_parallelo_isEmpty; Object Programmatore_parallelo_data; int Programmatore_parallelo_numRows = 0; %> <% Driver Driverspedizione = (Driver)Class.forName(MM_edros_DRIVER).newInstance(); Connection Connspedizione = DriverManager.getConnection(MM_edros_STRING,MM_edros_USERNAME,MM_edros_PASSWORD); PreparedStatement Statementspedizione = Connspedizione.prepareStatement("SELECT distinct stato FROM spedizione"); ResultSet spedizione = Statementspedizione.executeQuery(); boolean spedizione_isEmpty = !spedizione.next(); boolean spedizione_hasData = !spedizione_isEmpty; Object spedizione_data; int spedizione_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; carrello_numRows += Repeat1__numRows; %> <% String Recordset1__MMColParam = "1"; %> <% if (!carrello_isEmpty ) { %>
<% java.util.StringTokenizer pppppp; double totale=0; double price=0; String pp="",preprezzi="",shop_id,temp; int qta=0,i; while ((carrello_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; carrello_hasData = carrello.next(); } %>
Product
Quantity
Price
Total
<%=(((carrello_data = carrello.getObject("card"))==null || carrello.wasNull())?"":carrello_data)%>
<% qta=Integer.parseInt(carrello.getObject("quantity").toString()); preprezzi=carrello.getObject("prezzi").toString(); pppppp= new java.util.StringTokenizer(preprezzi,"|"); shop_id=carrello.getObject("id_shop").toString(); temp=pppppp.nextToken(); i=temp.length(); temp=temp.substring(0,i-2); %>
<% pp=carrello.getObject("prezzo").toString(); if (pp!=""){ price = Double.valueOf(pp).doubleValue()/1936.27; totale=price*qta+totale; } %> <%=df.format(price)%>
<%=df.format(price*qta)%>
  For shipping charge please select your country and wait some seconds

Insert 0 if you want to remove the product from your shopping cart.

<% if (!Programmatori_isEmpty ) { %> <% if (Cavo_PIN_isEmpty ) { %> <% } /* end Cavo_PIN_isEmpty */ %> <% } /* end !Programmatori_isEmpty */ %> <% if (!Programmatori_isEmpty ) { %> <% if (Alimentatore_isEmpty ) { %> <% } /* end Alimentatore_isEmpty */ %> <% } /* end !Programmatori_isEmpty */ %> <% if (Cavo_parallelo_isEmpty ) { %> <% if (!Programmatore_parallelo_isEmpty ) { %> <% } /* end !Programmatore_parallelo_isEmpty */ %> <% } /* end Cavo_parallelo_isEmpty */ %>
 
 
ATTENZION: The connection cable is missing do you want to add it? Click here!
ATTENZIONE: The Power supplier is missing. Do you wanto to add it? Click here!
ATTENZIONE: The connection cable is missing do you want to add it? Click
 
<% } /* end !carrello_isEmpty */ %> <% if (carrello_isEmpty ) { %>

Your Shopping Cart is Empty

<% } /* end carrello_isEmpty */ %> <% prodotti.close(); Connprodotti.close(); %> <% carrello.close(); Conncarrello.close(); %> <% Programmatori.close(); ConnProgrammatori.close(); %> <% Cavo_PIN.close(); ConnCavo_PIN.close(); %> <% Alimentatore.close(); ConnAlimentatore.close(); %> <% Cavo_parallelo.close(); ConnCavo_parallelo.close(); %> <% Programmatore_parallelo.close(); ConnProgrammatore_parallelo.close(); %> <% spedizione.close(); Statementspedizione.close(); Connspedizione.close(); %>