Example jsp + macromedia

April 27, 2003 by Heriberto Heriberto

Yor loadvariables with  program jsp

and loadvariables to file txt

<%@page import="java.io.*" import="java.sql.*"%>
<jsp:useBean id="validarfc" scope="request" class="inventarios.valida"/>
<%
out.println("Entrada");
String rfc="request".getParameter("RFC");
String archivo="request".getParameter("archivo");
     String empresa="nada", calle="", numero="", municipio="", estado="", ciudad="", pais="";
     ResultSet rs="null;"
     String ok="OK=failed";
        try {
                Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
                Connection con = DriverManager.getConnection("jdbc:mysql://xxxx.com/xxxb?user=xxxxx&password=xxxxx");
  Statement st = con.createStatement();
                String mysql1="Select nomcli, dircalle, dirnumext, dirmunic, direntfed, dirpais from cmcli where rfc='"+rfc+"'";
  rs = st.executeQuery(mysql1);
               if (rs.next()){
                  empresa="Empresax="+rs.getString(1);
                  calle="Direccion="+rs.getString(2);
                  numero="Numero="+rs.getString(3);
                  municipio="Municipio="+rs.getString(4);
                  estado="Estado="+rs.getString(5);
                  pais="Pais="+rs.getString(6);
                  ok="OK=correct";
              }
        } catch (SQLException exx) {
            out.println(exx.toString());
        }
          catch( Exception ex) {
            out.println(ex.toString());
        }        
       
        try {

//        ***  file create yor name random for loadvariable
        PrintWriter pw = new PrintWriter( new FileWriter( "txt//"+archivo+".txt") );
        pw.print(empresa+"&");
        pw.print(calle+"&");
        pw.print(numero+"&");
        pw.print(municipio+"&");
        pw.print(estado+"&");
        pw.print(pais+"&");
        pw.print(ok+"&");
        pw.flush();
        pw.close();  
        }
          catch( IOException esx) {            
              out.println(esx.toString());
        }            

%>