Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * 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.InputStream;
- import java.io.PrintWriter;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.MultipartConfig;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import javax.servlet.http.Part;
- /**
- *
- * @author Milton
- */
- @WebServlet(urlPatterns = {"/SaveSlider"})
- @MultipartConfig(maxFileSize = 16222222)
- public class SaveSlider extends HttpServlet {
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html");
- doPost(request, response);
- }
- @Override
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String gettitle = request.getParameter("title");
- String substitle = request.getParameter("subtitle");
- Part filePart = request.getPart("sliderfile");
- InputStream inp = null;
- if (filePart != null) {
- inp = filePart.getInputStream();
- }
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/carservices", "root", "");
- Statement stm = con.createStatement();
- String query = "INSERT INTO tbl_image (title, subtitle, image) VALUES ('" + gettitle + "', '" + substitle + "','" + inp + "')";
- int a = stm.executeUpdate(query);
- if (a > 0) {
- request.getRequestDispatcher("saveslider.jsp").forward(request, response);
- }
- } catch (SQLException | ClassNotFoundException ex) {
- ex.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement