<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ page language="java" import="sun.jdbc.rowset.CachedRowSet" %>
<%@ page language="java" import="java.io.*" %>
<%@ include file="Connections/globalformacion.jsp" %>
<%
Class.forName(MM_globalformacion_DRIVER).newInstance();
Connection Connregistro = DriverManager.getConnection("jdbc:odbc:globalformacion",MM_globalformacion_USERNAME,MM_globalformacion_PASSWORD);
registro.setUsername("");
registro.setPassword("");
registro.setUrl("jdbc:odbc:globalformacion");
registro.setTableName("contadores");
registro.setCommand("SELECT max(contador)+1 as iden FROM globalformacion.contadores where id='CE'");
registro.execute();
registro.first();
String identifCli = registro.getString("iden");
File fichero = new File("c:\\Archivos de programa\\Apache Software Foundation\\Tomcat 5.0\\webapps\\globalformacion\\contador.js");
if(!fichero.createNewFile()){
fichero.delete();
fichero.createNewFile();
}
String salidaTotal;
OutputStream fsalida=new FileOutputStream(fichero,true);
out.print("document.write('");
salidaTotal="document.write('";
//new PrintStream(fsalida).println ();
int numDigitos=identifCli.length();
out.print(numDigitos-2);
for (int i=0;i");
//new PrintStream(fsalida).println ("![](\"\\digitos\\")
");
out.print(identifCli.substring(i,i+1)+"UNO");
salidaTotal=salidaTotal+"![](\"digitos/")
";
}
salidaTotal=salidaTotal+"');";
out.print(salidaTotal);
new PrintStream(fsalida).println (salidaTotal);
fsalida.close();
PreparedStatement stmt;
String cadInsert;
Connregistro.setAutoCommit(false);
cadInsert="update contadores set contador="+identifCli+"where id='CE'";
stmt = Connregistro.prepareStatement(cadInsert);
stmt.executeUpdate();
Connregistro.commit();
Connregistro.close();
%>