Nenhum Driver Apropriado ! :-(

Senhores,

Estou tentando rodar esta classe …
Mas acaba dando a informação que não há driver apropriado …
Estou perdido … Tem como alguém ajudar ???

import javax.servlet.<em>;

import javax.servlet.http.</em>;

import <a href="http://java.io">java.io</a>.<em>;

import java.util.</em>;

import java.sql.*;

//import com.brainysoftware.java.StringUtil;

public class SQLToolServlet extends HttpServlet {

/*<em>Load the JDBC driver</em>/

public void init() {

try {

Class.forName(“org.postgresql.Driver”);

System.out.println(“JDBC driver loaded”);

}

catch (ClassNotFoundException e) {

System.out.println(e.toString());

}

}

/*<em>Process the HTTP Get request</em>/

public void doGet(HttpServletRequest request,

HttpServletResponse response)

throws ServletException, IOException {

sendSqlForm(request, response);

}

/*<em>Process the HTTP Post request</em>/

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

sendSqlForm(request, response);

}

/**Send the form where the user can type in

an SQL statement to be processed
*/
private void sendSqlForm(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {

response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("&lt;HTML&gt;");
out.println("&lt;HEAD&gt;");
out.println("&lt;TITLE&gt;SQL Tool Servlet&lt;/TITLE&gt;");
out.println("&lt;/HEAD&gt;");
out.println("&lt;BODY&gt;");
out.println("&lt;BR&gt;&lt;H2&gt;SQL Tool&lt;/H2&gt;");
out.println("&lt;BR&gt;Please type your SQL statement in the following box.");
out.println("&lt;BR&gt;");
out.println("&lt;BR&gt;&lt;FORM METHOD=POST&gt;");
out.println("&lt;TEXTAREA NAME=sql COLS=80 ROWS=8&gt;");
String sql = request.getParameter("sql");

// Reprint the previously entered SQL in the TextArea
if (sql!=null)
  out.println(sql);

out.println("&lt;/TEXTAREA&gt;");
out.println("&lt;BR&gt;");
out.println("&lt;INPUT TYPE=SUBMIT VALUE=Execute&gt;");
out.println("&lt;/FORM&gt;");
out.println("&lt;BR&gt;");
out.println("&lt;HR&gt;");
out.println("&lt;BR&gt;");

if (sql!=null) {
  executeSql(sql.trim(), response);
}

out.println("&lt;/BODY&gt;");
out.println("&lt;/HTML&gt;");

}

/**execute the SQL */

public void executeSql(String sql, HttpServletResponse response)

throws ServletException, IOException {

PrintWriter out = response.getWriter();
try {
  //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:JavaWeb");
  System.out.println("got connection");

  Statement s = con.createStatement();

  if (sql.toUpperCase().startsWith("SELECT")) {
    out.println("&lt;TABLE BORDER=1&gt;");
    ResultSet rs = s.executeQuery(sql);
    ResultSetMetaData rsmd = rs.getMetaData();
    // Write table headings
    int columnCount = rsmd.getColumnCount();
    out.println("&lt;TR&gt;");
    for (int i=1; i&lt;=columnCount; i++) {
      out.println("&lt;TD&gt;<B>" + rsmd.getColumnName(i) + "</B>&lt;/TD&gt;\n");
    }
    out.println("&lt;/TR&gt;");
    /*while (rs.next()) {
      out.println("&lt;TR&gt;");
      for (int i=1; i&lt;=columnCount; i++) {
        out.println("&lt;TD&gt;" + StringUtil.encodeHtmlTag(rs.getString(i)) + "&lt;/TD&gt;" );
      }
      out.println("&lt;/TR&gt;");
    }*/
    rs.close();
    out.println("&lt;/TABLE&gt;");
  }
  else {
    int i = s.executeUpdate(sql);
    out.println("Record(s) affected: " + i);
  }
  s.close();
  con.close();
  out.println("&lt;/TABLE&gt;");
}
catch (SQLException e) {
  out.println("<B>Error</B>");
  out.println("&lt;BR&gt;");
  out.println(e.toString());
}
catch (Exception e) {
  out.println("<B>Error</B>");
  out.println("&lt;BR&gt;");
  out.println(e.toString());
}

}
}

Abraços,
Lingenover

1 Resposta

Topicos relacionados