Récupération propriété Bean

Bonjour,

j'ai deux pages jsp: planned_orders.jsp et controller.jsp

Dans ces deux pages j'utilises un bean représentant une entité de base de données, j'aimerais paramètrer ma requête sql dans le controller puis l'envoyer mon entité...

Dans planned_orders, il me récupère pas la requête sql paramétrée

planned_orders.jsp

Code:

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
 
 <% 
        
        PlannedOrder[] poList = poDao.getInstance().getPlannedOrder();
        for(int i=0;i<poList.length;i++)
        {
            po = poList[i];%>
        <tr class="listing_line">
            <td ><%= po.getOrderNo() %></td>
            <td ><%= po.getFrac() %></td>
            <td ><%= po.getSearchKey() %></td>
            <td ><%= po.getQuantity() %></td>
            <td ><%= po.getProduct() %></td>
            <td c><%= po.getColor() %></td>
            <td ><%= po.getDueDate() %></td>
            <form id="frmAction" name="frmAction" action="control.jsp"  method="post">
                <td width="120px" >
                    <input type="button" onclick="javascript:sendFrmAction('release')" value="RE" class="input_button" alt="to release"/>
                    <input type="button" onclick="javascript:sendFrmAction('delete')" value="DE" class="input_button" alt="to delete"/>
                    <input id="id3" name="id3" type="hidden" value="<%= po.getId()%>">
                    <input id="actionValue" name="actionValue" type="hidden">                                           
                </td>
            </form>
        </tr>
        <%}%>

controller.jsp

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
<%@page import="basic.*" %>
<%@page import="java.sql.Connection,java.sql.ResultSet,java.sql.Statement" %>
<jsp:useBean id="po" scope="session" class="basic.PlannedOrder" />
<jsp:useBean id="poDao" scope="session" class="basic.DaoPlannedOrder" />
<jsp:useBean id="dbConnection" scope="session" class="basic.DbConnection" />
 
<%
String pageName=request.getParameter("pagename");
String action=request.getParameter("action");
String orderType=request.getParameter("ordertype");
String orderBy=request.getParameter("orderby");
 
 
if(pageName==null && action==null)
    {
    poDao.getInstance().setQueryGET("SELECT * FROM tb_planned_orders ORDER BY orderno DESC");    
    %>
    <jsp:forward page="index.jsp?pageId=1" />
    <%}

mon bean DaoPlannedOrder

Code:

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
 
 
package basic ;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Vector;
 
/**
 *
 * @author fabrice
 */
public class DaoPlannedOrder {
 
    private static DaoPlannedOrder instance;
 
    private String driver="com.mysql.jdbc.Driver";
    private String dbUrl="jdbc:mysql://localhost/lalima";
    private String user="root";
    private String password="123456";
 
    private Connection cnx;
    private PreparedStatement getAllStmt;
    private String queryGET;
 
    /** Creates a new instance of DaoPlannedOrder */
 
    public DaoPlannedOrder() {
        /*queryGET="SELECT * FROM tb_planned_orders";*/
        try{
            Class.forName(driver);
            cnx=DriverManager.getConnection(dbUrl,user,password);
             getAllStmt=cnx.prepareStatement(queryGET);
        } catch (ClassNotFoundException e){
        } catch (SQLException e){
        }
    }
 
    public static DaoPlannedOrder getInstance() {
        if(instance==null)
            instance=new DaoPlannedOrder();
        return instance;
    }
 
    public PlannedOrder[] getPlannedOrder() {
        try{
            ResultSet rs;
            ArrayList plannedOrderList= new ArrayList();
            synchronized (getAllStmt) {
                rs=getAllStmt.executeQuery();
            }
 
 
            while (rs.next()) {
                plannedOrderList.add(makeOrder(rs));
            }
            return (PlannedOrder[]) plannedOrderList.toArray(new PlannedOrder[0]);
        } catch (SQLException e){
            return null;
        }
 
    }
 
    public PlannedOrder makeOrder(ResultSet rs) {
        PlannedOrder p =new PlannedOrder();
        try{
            p.setId(rs.getInt("id"));
            p.setOrderNo(rs.getString("orderno"));
            p.setFrac(rs.getInt("frac"));
            p.setSearchKey(rs.getString("searchkey"));
            p.setColor(rs.getString("color"));
            p.setProduct(rs.getString("product"));
            p.setQuantity(rs.getInt("quantity"));
            p.setDueDate(rs.getString("duedate"));
 
        } catch(SQLException e) {
 
        }
        return p;
    }
 
    public void setQueryGET(String queryGet)
    {
        this.queryGET = getQueryGET();
    }
 
    public String getQueryGET()
    {
        return queryGET;
    }
 
 
}