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 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
|
package ft.proto.v2.presentation.declaration.servlets;
import javax.servlet.*;
import javax.servlet.http.*;
import ft.proto.v2.persistance.bean.liste.ImpactFinancier;
import ft.proto.v2.presentation.declaration.forms.ExtractionDonneesForm;
import java.io.*;
import java.sql.*;
import java.util.ResourceBundle;
public class Extraction_DonneesServlet extends HttpServlet
{
public void doGet( HttpServletRequest request, HttpServletResponse reponse ) throws ServletException, IOException
{
doPost(request, reponse);
}
public void doPost( HttpServletRequest request, HttpServletResponse reponse ) throws ServletException, IOException
{
PrintWriter sortie;
reponse.setContentType("text/html;charset=UTF-8");
sortie = reponse.getWriter();
StringBuffer tamp = new StringBuffer();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
System.err.println("ERROR: failed to load HSQLDB JDBC driver.");
e.printStackTrace();
return;
}
Connection connexion;
try {
connexion = DriverManager.getConnection("jdbc:mysql://localhost/sequoris", "root", "");
Statement st = connexion.createStatement();
int id = Integer.parseInt(request.getParameter("id"));
ExtractionDonneesForm f = (ExtractionDonneesForm)request.getAttribute("extractionDonneesForm");
if(id == 1){
String res;
if(request.getParameter("idEntite")!= ""){
ResultSet resultat = st.executeQuery("SELECT * FROM t_entite_securite WHERE id="+ request.getParameter("idEntite"));
resultat.next();
ResultSet resultat2 = st.executeQuery("SELECT id_devise FROM t_intervalles_financier WHERE id="+resultat.getString("id_intervalle_financier"));
resultat2.next();
ResultSet resultat3 = st.executeQuery("SELECT symbole FROM t_devises WHERE id="+resultat2.getString("id_devise"));
resultat3.next();
res = resultat3.getString("symbole");
}
else
res = "";
tamp.append("<table>");
tamp.append("<tr>");
tamp.append("<td>");
ResourceBundle bundle = ResourceBundle.getBundle("ChampsResources_fr");
tamp.append(bundle.getString("extractionDonnees.impactFinancier.estime.de"));
tamp.append("<input type=\"text\" size=\"10\" maxlength=\"16\" name=\"impactFinancierReelMin\" id=\"impactFinancierReelMin\" value="+f.getImpactFinancierReelMin()+"/>");
tamp.append(res);
tamp.append("</td>");
tamp.append("<td>");
tamp.append(bundle.getString("extractionDonnees.impactFinancier.estime.a"));
tamp.append("<input type=\"text\" size=\"10\" maxlength=\"16\" name=\"impactFinancierReelMax\" id=\"impactFinancierReelMax\" value="+f.getImpactFinancierReelMax()+"/>");
tamp.append(res);
tamp.append("</td>");
tamp.append("</tr>");
tamp.append("<tr valign=top>");
tamp.append("<td colspan=\"4\"> </td>");
tamp.append("</tr>");
tamp.append("</table>");
}
else if(id == 2){
if(request.getParameter("idEntite")!= ""){
ResultSet resultat = st.executeQuery("SELECT * FROM t_entite_securite WHERE id="+ request.getParameter("idEntite"));
resultat.next();
ResultSet resultat2 = st.executeQuery("SELECT * FROM t_intervalles_financier WHERE id="+resultat.getString("id_intervalle_financier"));
resultat2.next();
ResourceBundle bundle2 = ResourceBundle.getBundle("EnumDescResources_fr");
tamp.append("<table>");
tamp.append("<tr>");
tamp.append("<td align=\"left\" width=\"100%\">");
tamp.append("<html:radio property=\"impactFinancierEstime\" value=/>");
tamp.append(bundle2.getString("impactfinancier.inf"));
tamp.append(resultat2.getString("niv1"));
tamp.append("<html:radio property=\"impactFinancierEstime\" value=/>");
tamp.append(bundle2.getString("impactfinancier.entre"));
tamp.append(resultat2.getString("niv2inf"));
tamp.append(bundle2.getString("impactfinancier.et"));
tamp.append(resultat2.getString("niv2sup"));
tamp.append("<html:radio property=\"impactFinancierEstime\" value=/>");
tamp.append(bundle2.getString("impactfinancier.entre"));
tamp.append(resultat2.getString("niv3inf"));
tamp.append(bundle2.getString("impactfinancier.et"));
tamp.append(resultat2.getString("niv3sup"));
tamp.append("<html:radio property=\"impactFinancierEstime\" value=/>");
tamp.append(bundle2.getString("impactfinancier.sup"));
tamp.append(resultat2.getString("niv4"));
tamp.append("</td>");
tamp.append("</tr>");
tamp.append("<tr valign=top>");
tamp.append("<td colspan=\"4\"> </td>");
tamp.append("</tr>");
tamp.append("</table>");
}
}
st.close();
connexion.close();
sortie.println(tamp);
sortie.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} |
Partager