Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. @WebServlet("/typologieKontrolle")
  2. public class typologieKontrolle extends HttpServlet {
  3. private static final long serialVersionUID = 1L;
  4.  
  5.  
  6. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  7.  
  8. String data= request.getParameter("id");
  9.  
  10. String[] neu = data.split(",");
  11.  
  12.  
  13. List risikobereich_kunde = new ArrayList();
  14. List risikobereich_produkte = new ArrayList();
  15.  
  16.  
  17. PrintWriter out = response.getWriter();
  18.  
  19. for (int i=0;i<neu.length;i++) {
  20.  
  21. try {
  22. Class.forName("com.mysql.jdbc.Driver");
  23. Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test","admin","****");
  24. PreparedStatement stmt = con.prepareStatement("SELECT id,risikobereich FROM tabelle_abstrakt WHERE id = ?");
  25. stmt.setString(1, neu[i]);
  26. ResultSet rs = stmt.executeQuery();
  27.  
  28. if(rs.next())
  29. {
  30.  
  31. if(rs.getString("risikobereich") == "Kunden")
  32. {
  33. risikobereich_kunde.add(rs.getString("id"));
  34. }
  35. else if(rs.getString("risikobereich") == "Produkte")
  36. {
  37. risikobereich_produkte.add(rs.getString("id"));
  38. }
  39.  
  40. }
  41. System.out.println("KUNDE : " + risikobereich_kunde);
  42. System.out.println("PRODUKTE : " + risikobereich_produkte);
  43.  
  44. stmt.close();
  45. con.close();
  46.  
  47. } catch (Exception e) {
  48.  
  49. e.printStackTrace();
  50. }
  51.  
  52. }
  53. }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement