Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @WebServlet("/typologieKontrolle")
- public class typologieKontrolle extends HttpServlet {
- private static final long serialVersionUID = 1L;
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String data= request.getParameter("id");
- String[] neu = data.split(",");
- List risikobereich_kunde = new ArrayList();
- List risikobereich_produkte = new ArrayList();
- PrintWriter out = response.getWriter();
- for (int i=0;i<neu.length;i++) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test","admin","****");
- PreparedStatement stmt = con.prepareStatement("SELECT id,risikobereich FROM tabelle_abstrakt WHERE id = ?");
- stmt.setString(1, neu[i]);
- ResultSet rs = stmt.executeQuery();
- if(rs.next())
- {
- if(rs.getString("risikobereich") == "Kunden")
- {
- risikobereich_kunde.add(rs.getString("id"));
- }
- else if(rs.getString("risikobereich") == "Produkte")
- {
- risikobereich_produkte.add(rs.getString("id"));
- }
- }
- System.out.println("KUNDE : " + risikobereich_kunde);
- System.out.println("PRODUKTE : " + risikobereich_produkte);
- stmt.close();
- con.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement