ok....allora
Questa è la pagina jsp:
<%--
Document : paginaRiepilogo
Created on : 23-set-2009, 16.15.20
Author : Daniele Bertelli
--%>
<html>
<%@page import="java.sql.*, java.text.DecimalFormat, java.util.GregorianCalendar, java.text.SimpleDateFormat, java.util.Calendar" %>
<head>
<title> WEST SYSTEMS </title>
<script type="text/javascript">
function SelectPost()
{
document.reload.method = "post";
document.reload.action = "Riepilogo";
document.reload.submit();
}
</script>
</head>
<body>
<%!private static final String DATE_FORMAT = "dd MMMMMMMMM yyyy";%>
<%
String par = (String) request.getAttribute("parametro");
String url = "com.mysql.jdbc.Driver";
Connection conn = null;
try {
Class.forName(url);
conn = DriverManager.getConnection("jdbc:mysql://localhost/tirocinio?user=root&password=10a5gr8b");
} catch (Exception exc) {
out.println(exc.toString());
}
%>
<div align="center">
<strong>
<label for="Intestazione"> RIEPILOGO DATI PREVENTIVO </label><br><br>
</strong>
<form name="myform" action="PrimaPagina" method="get">
<p>
</p>
<table width="688" border="0" cellspacing="1" cellpadding="2">
<%Statement stm = null, stm2 = null;
ResultSet rst = null;
String queryPrev = "";
int ID = 0;
stm = conn.createStatement();
stm2 = conn.createStatement();
if (par.equalsIgnoreCase("nessun_parametro")) {
queryPrev = "SELECT * FROM preventivo";
} else {
String[] tmp = par.split(",");
ID = Integer.parseInt(tmp[0]);
queryPrev = "SELECT * FROM preventivo WHERE IDpreventivo=" + ID + ";";
}
rst = stm.executeQuery(queryPrev);
ResultSet prev = stm2.executeQuery("SELECT * FROM preventivo");
rst.last();
ID = Integer.parseInt(rst.getString("IDpreventivo"));
%>
<tr>
<td width="154"><label for="Nome" >Nome: </label></td>
<td width="523" bgcolor="#EAEAEA"><input type="text" name="nome" size="50" value="<%=rst.getString("Nome")%>" readonly/></td>
</tr>
<tr>
<td><label for="Descrizione" >Descrizione:</label></td>
<td bgcolor="#DBDBDB"><input type="text" name="descrizione" size="50" value="<%=rst.getString(3)%>" readonly/></td>
</tr>
<tr>
<%Statement temp = null;
ResultSet rstTemp = null;
temp = conn.createStatement();
rstTemp = temp.executeQuery("SELECT Nome FROM clienti WHERE IDcliente=" + Integer.parseInt(rst.getString(6)) + ";");
rstTemp.next();
%>
<td><label for="Committente" >Committente:</label></td>
<td bgcolor="#DBDBDB"><input type="text" name="committente" size="50" value="<%=rstTemp.getString("Nome")%>" readonly/></td>
</tr>
<tr>
<%temp = null;
rstTemp = null;
temp = conn.createStatement();
rstTemp = temp.executeQuery("SELECT Nome, Cognome FROM utenti WHERE IDutente=" + Integer.parseInt(rst.getString(7)) + ";");
rstTemp.next();
%>
<td><label for="Responsabile" >Responsabile:</label></td>
<td bgcolor="#DBDBDB"><input type="text" name="responsabile" size="50" value="<%=rstTemp.getString("Nome") + " " + rstTemp.getString("Cognome")%>"readonly/></td>
</tr>
<tr>
<%String[] data = rst.getString(4).split("-");
GregorianCalendar gc = new GregorianCalendar(Integer.parseInt(data[0]),
Integer.parseInt(data[1]) - 1, Integer.parseInt(data[2]));
SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
%>
<td><label for="Inizio" >Data di inizio:</label></td>
<td bgcolor="#DBDBDB"><input type="text" name="inizio" size="50" value="<%=sdf.format(gc.getTime())%>" readonly/></td>
</tr>
<tr>
<td><label for="Durata">Durata Preventivata:</label></td>
<td bgcolor="#DBDBDB"><input type="text" name="durata" size="50" value="<%=rst.getString(5)%> mesi" readonly/></td>
</tr>
<tr><td></td></tr>
<tr><td></td></tr>
<tr>
<%gc.add(Calendar.MONTH, Integer.parseInt(rst.getString(5)));%>
<td><label for="Fine"><b>Fine prevista per il:</b></label></td>
<td bgcolor="#DBDBDB"><b><input type="text" name="fine" size="50" value="<%=sdf.format(gc.getTime())%>" readonly/></b></td>
</tr>
</table>
<br><br>
<%
/* Calcolo il COSTO TOTALE MANODOPERA */
temp = null;
rstTemp = null;
temp = conn.createStatement();
rstTemp = temp.executeQuery("SELECT IDqualifica, NumeroOre FROM preventivoqualifica WHERE IDpreventivo=" + Integer.parseInt(rst.getString(1)) + ";");
double costo = 0.00;
Statement in = null;
while (rstTemp.next()) {
in = conn.createStatement();
ResultSet s = in.executeQuery("SELECT CostoOrario FROM qualifica WHERE IDqualifica=" + rstTemp.getString("IDqualifica") + ";");
s.next();
costo += Double.parseDouble(s.getString("CostoOrario")) * Double.parseDouble(rstTemp.getString("NumeroOre"));
in.close();
}
DecimalFormat format = new DecimalFormat("0.00");
%>
<label for="Costo">
<b><font color="blue">Costo della manodopera qualificata utilizzata:</font></b>
</label>
<input type="text" name="durata" size="20" value="<%=format.format(costo)%>" readonly/>
<label for="euro">Euro</label><br><br>
<table width="500" border="0" cellspacing="1" cellpadding="2">
<% Statement att = null, att2 = null, att3 = null, inQ = null;
ResultSet rstAtt = null, rstQual = null;
att = conn.createStatement();
att2 = conn.createStatement();
att3 = conn.createStatement();
inQ = conn.createStatement();
rst = att.executeQuery("SELECT * FROM preventivo;");
rst.last();
rstAtt = att2.executeQuery("SELECT * FROM attivitapreventivo WHERE IDpreventivo=" + ID + ";");
while (rstAtt.next()) {
rstQual = inQ.executeQuery("SELECT * FROM preventivoqualifica WHERE IDpreventivo=" + ID + " AND IDattivita=" + Integer.parseInt(rstAtt.getString("IDattivita")) + ";");
rstTemp = att3.executeQuery("SELECT Nome FROM attivita WHERE IDattivita=" + Integer.parseInt(rstAtt.getString("IDattivita")) + ";");
rstTemp.next();
%>
<tr>
<td></td>
<td><hr noshade size="1" style="color:black"></td>
<td><hr noshade size="1" style="color:black"></td>
<td></td>
</tr>
<tr>
<td width="150"><label for="Attività" style="color:blue">Attività</label></td>
<td width="150"><label for="Durata" style="color:blue">Durata</label></td>
<td width="150"><label for="Numero Ore" style="color:blue">Numero di ore</label></td>
<td width="50"><label for="Shift" style="color:blue" >Shift</label></td>
</tr>
<tr>
<td width="150"> <%=rstTemp.getString("Nome")%></td>
<td width="150"><%=rstAtt.getString("Durata")%> mese/i</td>
<td width="150"><%=rstAtt.getString("NumeroOre")%></td>
<td width="50"><%=rstAtt.getString("ShiftTemporale")%></td>
</tr>
<%
while (rstQual.next()) {
rstTemp = att3.executeQuery("SELECT Descrizione FROM qualifica WHERE IDqualifica=" + Integer.parseInt(rstQual.getString("IDqualifica")) + ";");
rstTemp.next();
%>
<tr>
<td width="150"></td>
<td width="150"><label for="Durata" style="color:red">Qualifica</label></td>
<td width="150"><label for="Numero Ore" style="color:red">Numero di ore</label></td>
<td width="50"><label for="Shift" style="color:red" >Shift</label></td>
</tr>
<tr>
<td width="150"></td>
<td width="150"><%=rstTemp.getString("Descrizione")%></td>
<td width="150"><%=rstQual.getString("NumeroOre")%></td>
<td width="50"><%=rstQual.getString("ShiftTemporale")%></td>
</tr>
<%
}
}%>
</table>
<br><br><input type="submit" name="submit" value="Inserisci altri preventivi"/>
</form>
</div>
<p></p>
<div align="center">
<table border="0">
<tr>
<td width="100" align="center" valign="middle">
<form action="Start" method="get">
<input type ="submit" name="main" value="Torna alla HomePage" />
</form>
</td>
<td width="100" align="center" valign="middle">
<p>
<label for=spazio" ></label>
</p>
</td>
<td width="100" align="center" valign="middle">
<p>
<label for=Scelta" >Scegli il preventivo da visualizzare</label>
</p>
</td>
<td width="100" align="center" valign="middle">
<form action="Riepilogo" name="reload" method="get">
<select name="Prev" id="Prev" onchange="SelectPost()">
<option selected> <%=" "%></option>
<% while (prev.next()) {%>
<option>
<%=prev.getString("IDpreventivo") + ", " + prev.getString("Nome")%>
</option>
<%}%>
</select>
</form>
</td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</table>
</div>
<p></p>
<div align="center">
<table border="0">
<tr>
<td width="100" align="center" valign="middle">
<form action="Export" method="get">
<input type ="submit" name="main" value="Export in .XLS" />
</form>
</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</table>
</div>
</body>
</html>
mentre questa è la servlet che dovrei fare...qui c'è solo un esempio da me fatto per la creazione di un nuovo foglio excel con una cella riempita....funzionante
import java.io.IOException;
import java.io.OutputStream;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Export extends HttpServlet {
@Override
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
OutputStream out = null;
try {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition",
"attachment");
WritableWorkbook w = Workbook.createWorkbook(response.getOutputStream());
WritableSheet s = w.createSheet("Demo", 0);
s.addCell(new Label(0, 0, "Hello World"));
w.write();
w.close();
} catch (Exception e) {
throw new ServletException("Exception in Excel Sample Servlet", e);
} finally {
if (out != null) {
out.close();
}
}
}
}
Grazie ancora per l'immensa disponibilità....