Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package registracia;
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- *
- * @author Juri
- */
- @WebServlet(urlPatterns = {"/kontrola"})
- public class kontrola extends HttpServlet {
- String driver = "com.mysql.jdbc.Driver";
- Connection con = null;
- Statement stmt = null;
- ResultSet rs = null;
- String userName = "root";
- String password = "";
- String URL = "jdbc:mysql://localhost/kelebercova_shop";
- public void init() {
- try {
- super.init();
- Class.forName(driver);
- con = DriverManager.getConnection(URL, userName, password);
- } catch (Exception ex) {
- }
- }
- void ZapisDoDB(PrintWriter out, String meno, String priezvisko, String email, String heslo, String adresa) {
- if (email.contains("@") == false || email.contains(".") == false) {
- } else {
- try {
- stmt = con.createStatement(); // "', "+"'" + priezvisko +
- stmt.executeUpdate("INSERT INTO pouzivatelia (meno, priezvisko, email, heslo, adresa) VALUES ('" + meno + "','" + priezvisko + "','" + email + "','" + heslo + "','" + adresa + "' ) ");
- stmt.close();
- } catch (Exception e) {
- System.out.println("Problém so zápisom " + e.toString());
- }
- }
- }
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- try (PrintWriter out = response.getWriter()) {
- String tlacidlo = request.getParameter("tlacidlo").substring(0, 1);
- if (tlacidlo.equals("R")) {
- ZapisDoDB(out, request.getParameter("meno"), request.getParameter("priezvisko"), request.getParameter("email"), request.getParameter("heslo"), request.getParameter("adresa"));
- }
- out.println("<!DOCTYPE html>");
- out.println("<title>Servlet kontrola</title>");
- if (request.getParameter("email").toString().contains("@") == false || request.getParameter("email").toString().contains(".") == false) {
- } else {
- // sem vypises napriklad ze Dakujem za registraciu alebo tak
- // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
- /**
- * Handles the HTTP <code>GET</code> method.
- *
- * @param request servlet request
- * @param response servlet response
- * @throws ServletException if a servlet-specific error occurs
- * @throws IOException if an I/O error occurs
- */
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- /**
- * Handles the HTTP <code>POST</code> method.
- *
- * @param request servlet request
- * @param response servlet response
- * @throws ServletException if a servlet-specific error occurs
- * @throws IOException if an I/O error occurs
- */
- @Override
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- /**
- * Returns a short description of the servlet.
- *
- * @return a String containing servlet description
- */
- @Override
- public String getServletInfo() {
- return "Short description";
- }// </editor-fold>
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement