//Das ist das Servletimport java.io.*;import java.sql.*;import javax.servlet.ServletException;import javax.servlet.http.*;public class StoreProc extends HttpServlet { protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { //Initialisierung der Variablen boolean html = false; boolean text = false; boolean xls = false; boolean self = false; ResultSet rs = null; //Ermitteln der uebergebenen Parameter int start = Integer.parseInt(req.getParameterValues("Start")[0]); int stop = Integer.parseInt(req.getParameterValues("Ende")[0]); html = (req.getParameterValues("htmlformat") != null); text = (req.getParameterValues("textformat") != null); xls = (req.getParameterValues("xlsformat") != null); self = (req.getParameterValues("selfformat") != null); try { rs = DataBase.RequestData(start, stop); //<-- Aufruf der Problemfunktion } catch (SQLException es) { System.out.println(es.toString()); } PrintWriter out = res.getWriter(); try { if (xls) printxls(res, out, rs); else if (text) printtxt(res, out, rs); else if (html) printhtml(res, out, rs); } catch (SQLException e1) { System.out.println(e1.toString()); } }}
import java.sql.*;import java.util.Date;public class DataBase { private static Connection c; public static ResultSet RequestData(long von, long bis) throws SQLException { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); //!!!!!!!! } catch (Exception e) { System.out.println(e.toString()); } try { c = DriverManager.getConnection("jdbc:mysql:///ftku", "root", "secret"); } catch (SQLException e1) { System.out.println(e1.toString()); } StringBuffer sb = new StringBuffer("SELECT * FROM Messwerte WHERE "); Date d_von = new Date(System.currentTimeMillis() - von * 60000); Date d_bis = new Date(System.currentTimeMillis() - bis * 60000); sb.append("ZEIT < " + d_bis.getTime() + " AND ZEIT > " + d_von.getTime() + ";"); Statement s = c.createStatement(); return s.executeQuery(sb.toString()); }}
//Testklasseimport java.sql.*;public class Host { public static void main(String args[]){ ResultSet rs = null; try { rs = DataBase.RequestData(10, 0); } catch (SQLException e1) { System.out.println(" " + e1.toString()); } try { while(rs.next()) { System.out.print(rs.getString(1) + "\t"); System.out.println(rs.getString(2)); } } catch (SQLException e) { System.out.println(" " + e.toString()); } System.out.println("Succeful"); }}
java.lang.ClassNotFoundException: com.mysql.jdbc.Driverjava.sql.SQLException: No suitable driver