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
|
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
List<List<String>> list = new ArrayList<List<String>>();
String chp_affaire = request.getParameter("affaire");
String url = "jdbc:oracle:thin:@.....";
String login = "....";
String password = ".....";
try{
Connection dbc = DriverManager.getConnection(url,login,password);
if (chp_affaire != null)
{
PreparedStatement pstmt_affaire = dbc.prepareStatement("SELECT id_fouille,num_ctv,num_ccs,num_adr,nom_type_voie,nom_voie,num_cp FROM fouille, ccs,numadr,nomvoie,typevoie,code_postal,numero_aff WHERE fouille.id_numero_aff = numero_aff.id_numero_aff AND fouille.id_ccs = ccs.id_ccs AND fouille.id_numAdr = numadr.id_numAdr AND fouille.id_nom_voie = nomvoie.id_nom_voie AND fouille.id_type_voie = typevoie.id_type_voie AND fouille.id_cp = code_postal.id_cp AND num_affaire= ?");
pstmt_affaire.setString(1, chp_affaire);
ResultSet resultat_affaire = pstmt_affaire.executeQuery();
ResultSetMetaData rsmd = resultat_affaire.getMetaData();
while (resultat_affaire.next())
{
List<String> record = new ArrayList<String>();
for (int i = 0; i < rsmd.getColumnCount(); i++)
{
record.add(resultat_affaire.getString(i+1));
}
list.add(record);
}
request.setAttribute("Liste", list);
request.getRequestDispatcher("/rechAffaire.jsp").forward(request, response);
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
dbc.close();
}
} |
Partager