import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class JDBCServlet extends HttpServlet {
private PreparedStatement sqlStatement;
private Connection connection;
public void init() {
try {
// cloudscape.jar in $CATALINA_HOME/lib installieren!!
Class.forName("COM.cloudscape.core.JDBCDriver");
// Wichtig: Ort der DB anpassen!!
connection = DriverManager.getConnection("jdbc:cloudscape:C:/bsp/JDBC/StudentDB2");
} catch (Exception e) {
System.err.println("Fehler in JDBCServlet::init():" + e);
// System.exit(-1);
}
System.out.println("JDBCServlet::init(): successful open of DB connection");
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String selector = request.getParameter("selector");
if (selector.equals("anfrage1")) {
try {
sqlStatement = connection.prepareStatement("select * from Student where Nachname = ?");
sqlStatement.setString(1,request.getParameter("studentName"));
ResultSet res = sqlStatement.executeQuery();
out.println("");
while (res.next()) {
out.print(res.getString("MatrikelNummer") + " ");
out.print(res.getString("Vorname") + " ");
out.println(res.getString("Nachname"));
}
out.println("
");
out.println("Zurück zum Formular");
out.println("");
} catch (Exception e) {
System.err.println("JDBCServlet::doGet(): " + e);
}
} else {
out.println("Not implemented!");
}
}
public void destroy() {
try {
connection.close();
} catch (Exception e) {
System.err.println("Fehler in JDBCServlet::destroy():" + e);
System.exit(-1);
}
}
}