<%@
page  import ="java.io.*,java.io.IOException,java.io.PrintWriter,java.util.Enumeration,
javax.servlet.ServletException,javax.servlet.http.HttpServlet,
javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,java.sql.*,java.util.Locale"
%>
<%
 response.setContentType("text/html");
 PrintWriter writer = response.getWriter();
 Statement stmt;
 Connection con;
  try  {
          Class .forName("com.mysql.jdbc.Driver").newInstance();
        }
         catch  (Exception E) {
          writer.println("<font color=#ff0000><b>Unable to load driver.</b></font>");
        }
 try  {
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/info?useUnicode=true&characterEncoding=utf8","jsp","
passwd");
          stmt = con.createStatement ();
          ResultSet rs = stmt.executeQuery("select * from sections");
          writer.println("<table>");
           while  (rs.next()) {
          writer.print("<tr><td>");
          writer.print("<a href=view.jsp?us="+rs.getString("id")+" >"+rs.getString("otdel")+"</a>");
            writer.print("</td><td>");
            writer.print("</td><td>");
            writer.println("</td></tr>");
          }
          writer.println("</table>");
          rs.close();
          stmt.close();
          con.close();

        }
         catch  (java.lang.Exception e) {
          writer.println(e);
          writer.println("<br><font color=#ff0000><b>Database error.</b></font>");
        }

CREATE TABLE `sections` (
  `id`  int ( 11 ) NOT  NULL  auto_increment,
  `otdel` varchar( 255 ) collate utf8_unicode_ci NOT  NULL   default  '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT  CHARSET=utf8 COLLATE=utf8_unicode_ci;

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling  this  request.

exception 

org.apache.jasper.JasperException: Unable to compile  class   for  JSP

An error occurred at line:  5  in the jsp file: /ind1.jsp
Generated servlet error:
Statement cannot be resolved or is not a type

An error occurred at line:  5  in the jsp file: /ind1.jsp
Generated servlet error:
Connection cannot be resolved or is not a type

An error occurred at line:  5  in the jsp file: /ind1.jsp