Flash MX with Database using JSP
I am looking for some tips or samples for developing drop down menus in Flash MX and connecting it with database using Java application server. I have found lots of samples using php and asp, but none in jsp.
I am looking for some tips or samples for developing drop down menus in Flash MX and connecting it with database using Java application server. I have found lots of samples using php and asp, but none in jsp.
Comments
Example jsp + macromedia
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());
}
%>
You must me logged in to write a comment.