From 4d1d6819d49a2346aaea26ae22827c2acf3ec191 Mon Sep 17 00:00:00 2001 From: tspitzer Date: Wed, 5 Jun 2013 11:42:24 +0200 Subject: initial --- Dozentenmodul_V1/src/db/DB_Access.java | 78 ++++++++++++++++++++++++++++++++++ 1 file changed, 78 insertions(+) create mode 100644 Dozentenmodul_V1/src/db/DB_Access.java (limited to 'Dozentenmodul_V1/src/db/DB_Access.java') diff --git a/Dozentenmodul_V1/src/db/DB_Access.java b/Dozentenmodul_V1/src/db/DB_Access.java new file mode 100644 index 00000000..99bdca06 --- /dev/null +++ b/Dozentenmodul_V1/src/db/DB_Access.java @@ -0,0 +1,78 @@ +package db; + +import java.io.IOException; +import java.io.PrintWriter; +import java.util.logging.Level; +import java.util.logging.Logger; + +import javax.naming.NamingException; +import javax.naming.directory.DirContext; +import javax.naming.directory.InitialDirContext; +import javax.servlet.RequestDispatcher; +import javax.servlet.ServletException; +import javax.servlet.annotation.WebServlet; +import javax.servlet.http.HttpServlet; +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; +import java.sql.*; + + +import authentifizierung.Ldap; + +/** + * Servlet implementation class mySQLServlet + */ +@WebServlet("/DB_Access") +public class DB_Access extends HttpServlet { + private static final long serialVersionUID = 1L; + + /** + * @see HttpServlet#HttpServlet() + */ + public DB_Access() { + super(); + // TODO Auto-generated constructor stub + } + + /** + * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) + */ + protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { + doPost(request,response); + } + + /** + * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) + */ + protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { + response.setContentType("text/html;charset=UTF-8"); + PrintWriter out = response.getWriter(); + + try { + Class.forName("com.mysql.jdbc.Driver").newInstance(); + } catch (InstantiationException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } catch (IllegalAccessException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } catch (ClassNotFoundException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + + try { + Connection con=DriverManager.getConnection("jdbc:mysql://141.79.128.121/bwLehrpool?user=root&password=!N4ye,04u."); + + + RequestDispatcher disp= getServletContext().getRequestDispatcher("/GUI/de/Login_Error.jsp"); + disp.forward(request, response); + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + + + } + +} -- cgit v1.2.3-55-g7522