Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package org.db.veiksmai;
- 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.io.IOException;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- @WebServlet(
- name = "prekesIvedimoServlet",
- urlPatterns = "/PrekesIvedimas" )
- public class PrekesIvedimoServlet extends HttpServlet
- {
- @Override
- protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException
- {
- /*------------------------Gauname duomenis is HTML formos*----------------------------*/
- String prekesPavadinimas = req.getParameter("pav");
- double prekesKaina = Double.parseDouble(req.getParameter("kaina"));
- String prekesAprasas = req.getParameter("aprasas");
- System.out.println(prekesPavadinimas);
- System.out.println(prekesKaina + 1);
- System.out.println(prekesAprasas);
- /*------------------------Veiksmai su Duomenu baze prasideda*----------------------*/
- try {
- Connection jungtis = DuombazesSukurimas.sukurtiDuomenuBaze();
- String sqlUzklausa = "INSERT INTO prekes (pav, kaina, aprasas) VALUES (?, ?, ?)";
- PreparedStatement prepSt = jungtis.prepareStatement(sqlUzklausa);
- prepSt.setString(1, prekesPavadinimas);
- prepSt.setDouble(2, prekesKaina);
- prepSt.setString(3, prekesAprasas);
- prepSt.executeUpdate();
- prepSt.close();
- jungtis.close();
- PrintWriter out = resp.getWriter();
- out.println("Idejome duomenu baze");
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement