Query

<%<a class="mention" href="/u/page">@page</a> contentType=“text/html”%>

<%<a class="mention" href="/u/page">@page</a> pageEncoding=“UTF-8”%>

<%@ page language=“java” %>

<%@ page import=“java.sql.*”%>

<%@ page import=“java.sql.Date”%>

<%–

The taglib directive below imports the JSTL library. If you uncomment it,

you must also add the JSTL library to the project. The Add Library… action

on Libraries node in Projects view can be used to add the JSTL 1.1 library.

–%>

<%–

<%@taglib uri=“<a href="http://java.sun.com/jsp/jstl/core">http://java.sun.com/jsp/jstl/core</a>” prefix=“c”%>

–%>

<th>Ramal</th><th>Numero discado</>    
            </tr>
        </thead>
        <tbody>
          
            <%
//Connection con = null;
Statement st  = null;
ResultSet rs   = null;            
            
            
            try {
             String dsn     = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:/Atn/DB/maio.mdb";

String usuario = “”;

String senha   = “”;

String sql     = “”;

st = con.createStatement();

rs = st.executeQuery(“select Ramal.grupo, count (CRJJ04.origem) As teste from CRJJ04, Ramal” +

“where CRJJ04.origem = Ramal.ramal” +

" Group By Ramal.grupo ");

while (rs.next()){
        
        %>
                            
        <tr>
        <td><%= rs.getString(1) %></td>
        <td><%= rs.getString("teste") %><td>
       
        </tr>
        <% 
        }
                       
        } catch (Exception ex) {
        ex.printStackTrace();
        } finally {
        if (rs != null) rs.close();
        if (st != null) st.close();
       // if (con != null) con.close();
        }
        %>    
        
                     
            
        </tbody>
        
    </table>
</body>