angelo1793's questions

I am using the potable version of XAMMP, and the server starts up perfectly (when I do the tests on my personal pc) when the folder is located on the C:/ drive, which if it cannot be opened in D or another path because it throws the following error:

Now in my work I don't have permissions to add anything to drive C , so I only have to install it on drive D , I know that I probably have to change some paths in the configuration documents to make it work on drive D , like " ServerRoot" or something like that. I am researching the documentation, but I would still like the advice of someone who knows how to configure it as required.

I'm using eclipse Photon and working on the eGit plugin for version control. Working individually I have no problem, but now I need that other collaborators in the company's local network can also access my repository to collaborate in its development, the questions are:

• Do I need to configure or download something extra in Eclipse?
• Can I control who enters to collaborate in the code?
• I can't use online tools (hence I don't use Github)
• The other contributors are not IT professionals, so I need the changes to be done from the intuitive interface provided by the eclipse eGit plugin, not from a terminal.

I have a JS function embedded in my web page, at the end of body

<script>
function permisosMenu() {
  var cadena = <%=permisos%>
  if(!cadena.includes(1) && !cadena.includes(2) && !cadena.includes(3) && !cadena.includes(4))
        document.getElementById("bloque1").style.display ="none";

  if(!cadena.includes(5) && !cadena.includes(6) && !cadena.includes(7) && !cadena.includes(8) &&
          !cadena.includes(9) && !cadena.includes(10) && !cadena.includes(11) && !cadena.includes(12) &&
          !cadena.includes(13) && !cadena.includes(14) && !cadena.includes(15) && !cadena.includes(16))
        document.getElementById("bloque2").style.display ="none";

  if(!cadena.includes(6) && !cadena.includes(7) && !cadena.includes(8) && !cadena.includes(9) 
          && !cadena.includes(10) && !cadena.includes(11) && !cadena.includes(12))
        document.getElementById("bloque2_op2").style.display ="none";

  if(!cadena.includes(17) && !cadena.includes(18) && !cadena.includes(19) && !cadena.includes(20) )
        document.getElementById("bloque3").style.display ="none";

  if(!cadena.includes(21) && !cadena.includes(22) && !cadena.includes(23))
        document.getElementById("bloque4").style.display ="none";

  if(!cadena.includes(24) && !cadena.includes(25))
        document.getElementById("bloque5").style.display ="none";

  for (var i = 1; i <= 32; i++) {
      if(!cadena.includes(i)){
        document.getElementById("op"+i).style.display ="none";
    }
}
}
</script>

This code meets what I need, the string variable will get its value from <%=permissions%> (which is found at the beginning of the document before the body)

<%
String permisos= (String)session.getAttribute("permisos");
%>

When it is directly placed in the html it works correctly, when I want to put it in a separate .js file, to later call it with

<script source="ruta.."></script>

It doesn't work for me, perhaps the scriptest <%=permissions> is what doesn't allow calling it in my html ?

Is there any way to be able to hide the passwords that my users register, so that when the database is checked, it shows ********* or encrypted, some function of SQLite?

On the other hand, if there is no function to do that, my system has a login and registration that works, but the passwords are in a simple string, if I work the encryption in the servlets I would like to know what classes I should use, I suppose that for At the time of registration, the password is encrypted and for login it is decrypted for authentication?

I'm making a system with a complete CRUD, the only problem I have is that I can't retrieve 1 object from my database, I can list all the objects but not get only 1, I'm using MVC and java web.

Here I leave the servlet that executes the search

@Override
    public Usuario_DTO_bean mostrarUsuario(String usu) {
        Usuario_DTO_bean usuarioMostrar= new Usuario_DTO_bean(1, "falla", "falla", "falla", 1, "falla", "falla", "falla");
        try {
            String sql="select * from usuario where usuario =?";
            con=Conector.connect();
            PreparedStatement statement;
            statement=con.prepareStatement(sql);
            statement.setString(1,usu);
            ResultSet resultSet = statement.executeQuery(sql);
            if (resultSet.next()) {
                int id = resultSet.getInt("id");
                String usuario = resultSet.getString("usuario");
                String clave = resultSet.getString("clave");
                String permisos=resultSet.getString("permisos");
                int estado=resultSet.getInt("estado");
                String nombre=resultSet.getString("nombre");
                String apellido_p=resultSet.getString("apellido_p");
                String apellido_m=resultSet.getString("apellido_m");
                usuarioMostrar=new Usuario_DTO_bean(id, usuario, clave, permisos, estado, nombre, apellido_p,apellido_m);
            }
            resultSet.close();
            statement.close();
            con.close();

        } catch (Exception e) {
            // TODO: handle exception
        }
        return usuarioMostrar;



    }

After testing, I think the problem is in this line of code

ResultSet resultSet = statement.executeQuery(sql);

Since after this line no code is executed, not even a simple println in the console and it jumps straight to the return, as if the try detected an error and exited the block.

With this code in a main I execute the function

String registro="SI-84";
    Usuario_DTO_bean usuario;
    Usuario_DTO_bo bo=new Usuario_DTO_bo();
    usuario=bo.mostrarUsuario(registro);
    System.out.println(usuario.getId());
    System.out.println(usuario.getUsuario());

They must know that the user with record SI-84 exists, but instead of returning their values, it returns the following

I need to get the value of an attribute of an object (user.state) and put it inside a JSP variable (state) to then make if statements depending on that variable. Here the code.

<tbody>
                <tr>
                    <td><c:out value="${usuario.id}"/></td>
                    <td><c:out value="${usuario.apellidos}"/></td>
                    <td><c:out value="${usuario.nombre}"/></td>
                    <td><c:out value="${usuario.usuario}"/></td>
                    <td><c:out value="${usuario.clave}"/></td>
                    <td><c:out value="${usuario.permisos}"/></td>
                    <td><c:out value="${usuario.estado}"/></td>
                    <% String estado=(AQUI ES DONDE NECESITO OBTENER EL VALOR DE usuario.estado);%>
                    <td><form action=""><button type="button" class="btn 
btn-block btn-info btn-xs" name="${usuario.usuario }" value="${usuario.usuario }">Editar</button></form></td>
                    <td><form action="DeshabilitaServlet" method="post"> 

Off Delete

I need to list an array to display it in a table (specifically the user table with its attributes), I am using JSTL to display the data in the JSP, the only problem is that it only lists the first object of my ArrayList, here is the code of the function that generates the ArrayList.

public List<Usuario_DTO_bean> listarUsuarios() {
    List<Usuario_DTO_bean> listaUsuario= new ArrayList<>();
    try {
        con=Conector.connect();
        String sql = "select * from usuario";
        Statement statement=con.createStatement();
        ResultSet resultSet = statement.executeQuery(sql);
        while(resultSet.next()) {
            int id = resultSet.getInt("id");
            String usu = resultSet.getString("usuario");
            String clave = resultSet.getString("clave");
            String permisos=resultSet.getString("permisos");
            int estado=resultSet.getInt("estado");

            Usuario_DTO_bean usuario_DTO_bean=new Usuario_DTO_bean(id, usu, clave, permisos, estado);
            listaUsuario.add(usuario_DTO_bean); 
            resultSet.close();
            statement.close();
            con.close();
            System.out.println("nuevo registro");
        }
    } catch (Exception e) {
        System.err.println(e.getMessage());
    }
    return listaUsuario;
}

When I call to print the first data by console there is no problem, the following is the code that is in a main class that I use to show data by console

Usuario_DTO_bo listar=new Usuario_DTO_bo();
    List<Usuario_DTO_bean> lista=new ArrayList<>();
    lista=listar.listarUsuarios();
    int tamano=lista.size();
    String aux=lista.get(0).getUsuario();
    System.out.println(aux);
    System.out.println(tamano);

Result by console

When I access position 1 or higher of my array to read the data, it sends me the following error (which is because the arrayList only has 1 element, I know)