1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
package app.entite;
import javax.faces.FactoryFinder;
import javax.faces.context.FacesContext;
import javax.faces.context.FacesContextFactory;
import javax.faces.el.ValueBinding;
import javax.faces.lifecycle.Lifecycle;
import javax.faces.lifecycle.LifecycleFactory;
import javax.faces.model.SelectItem;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import app.entite.It01ComptesHandler;
import java.util.Iterator;
import java.util.List;
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 matta.bd.UtilisateurIdent;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class It01ComptesRechercheResultatExporter extends HttpServlet
{
// It01ComptesHandler iIt01ComptesHandler;
// FacesContext context ;
// ExpressionFactory expressionFactory;
// ValueExpression valueExpression;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
FacesContextFactory factory = (FacesContextFactory) FactoryFinder.getFactory(FactoryFinder.FACES_CONTEXT_FACTORY);
LifecycleFactory factory2 = (LifecycleFactory) FactoryFinder.getFactory(FactoryFinder.LIFECYCLE_FACTORY);
Lifecycle lifecycle = factory2.getLifecycle (LifecycleFactory.DEFAULT_LIFECYCLE);
FacesContext context = factory.getFacesContext( this.getServletContext(), request, response, lifecycle);
context = factory.getFacesContext( this.getServletContext(), request, response, lifecycle);
context = FacesContext.getCurrentInstance();
ValueBinding valueBinding = context.getApplication().createValueBinding("#{It01ComptesHandler}");
It01ComptesHandler iIt01ComptesHandler = (It01ComptesHandler) valueBinding.getValue(context);
OutputStream out = null;
try
{
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment; filename=contact.xls");
WritableWorkbook w = Workbook.createWorkbook(response.getOutputStream());
WritableSheet s = w.createSheet("Demo", 0);
List listit01comptesfull = iIt01ComptesHandler.getlistit01comptesfull();
Iterator iter = listit01comptesfull.iterator();
int x=0; // horizontal X
int y=0; // vertical Y
while ( iter.hasNext() )
{
app.hb.It01Comptes iIt01Comptes = (app.hb.It01Comptes) iter.next();
s.addCell(new Label(x, y, iIt01Comptes.getit01nom()));
x = x+1;y = y+1;
}
// s.addCell(new Label(0, 0, "Hello World"));
// s.addCell(new Label(1, 1, "Hello World"));
// s.addCell(new Label(2, 2, "Hello World"));
w.write();
w.close();
} catch (Exception e)
{
throw new ServletException("Exception in Excel Sample Servlet", e);
} finally
{
if (out != null)
out.close();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
// a faire recuperation
// a partir de la base serv_ft de nom, passwd, serv_id dula table tmp
// passage des argument a doPost
doGet(request, response);
} //do get
} |
