| 12
 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