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("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>SQL Tool Servlet</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<BR><H2>SQL Tool</H2>");
out.println("<BR>Please type your SQL statement in the following box.");
out.println("<BR>");
out.println("<BR><FORM METHOD=POST>");
out.println("<TEXTAREA NAME=sql COLS=80 ROWS=8>");
String sql = request.getParameter("sql");
// Reprint the previously entered SQL in the TextArea
if (sql!=null)
out.println(sql);
out.println("</TEXTAREA>");
out.println("<BR>");
out.println("<INPUT TYPE=SUBMIT VALUE=Execute>");
out.println("</FORM>");
out.println("<BR>");
out.println("<HR>");
out.println("<BR>");
if (sql!=null) {
executeSql(sql.trim(), response);
}
out.println("</BODY>");
out.println("</HTML>");
}
/**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("<TABLE BORDER=1>");
ResultSet rs = s.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
// Write table headings
int columnCount = rsmd.getColumnCount();
out.println("<TR>");
for (int i=1; i<=columnCount; i++) {
out.println("<TD><B>" + rsmd.getColumnName(i) + "</B></TD>\n");
}
out.println("</TR>");
/*while (rs.next()) {
out.println("<TR>");
for (int i=1; i<=columnCount; i++) {
out.println("<TD>" + StringUtil.encodeHtmlTag(rs.getString(i)) + "</TD>" );
}
out.println("</TR>");
}*/
rs.close();
out.println("</TABLE>");
}
else {
int i = s.executeUpdate(sql);
out.println("Record(s) affected: " + i);
}
s.close();
con.close();
out.println("</TABLE>");
}
catch (SQLException e) {
out.println("<B>Error</B>");
out.println("<BR>");
out.println(e.toString());
}
catch (Exception e) {
out.println("<B>Error</B>");
out.println("<BR>");
out.println(e.toString());
}
}
}
Abraços,
Lingenover
:arrow: :idea: