Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package controller;
- import java.sql.*;
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import javax.annotation.Resource;
- import javax.servlet.RequestDispatcher;
- 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 javax.sql.DataSource;
- @WebServlet(name = "AddBookServlet", urlPatterns = {"/addBook.do"})
- public class AddBookServlet extends HttpServlet {
- @Resource(name = "test")
- private DataSource test;
- private Connection conn;
- public void init() {
- try {
- conn = test.getConnection();
- } catch (Exception ex) {
- System.out.println(ex);
- }
- }
- protected void processRequest(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- try (PrintWriter out = response.getWriter()) {
- String isbn = request.getParameter("isbn");
- String author = request.getParameter("author");
- String title = request.getParameter("title");
- String price = request.getParameter("price");
- //----------------------------------------------------------------//
- Statement stmt = null;
- try {
- stmt = conn.createStatement();
- } catch (SQLException ex) {
- Logger.getLogger(AddBookServlet.class.getName()).log(Level.SEVERE, null, ex);
- }
- String sql = "INSERT INTO books VALUES('" + isbn + "','" + title + "','" + author + "'," + price + ")"; //int numRow = stmt.executeUpdate(sql);
- //----------------------------------------------------------------//
- int numRow = 0;
- try {
- numRow = stmt.executeUpdate(sql);
- } catch (SQLException ex) {
- Logger.getLogger(AddBookServlet.class.getName()).log(Level.SEVERE, null, ex);
- }
- //----------------------------------------------------------------//
- RequestDispatcher obj = request.getRequestDispatcher("thankyou.html");
- if (numRow == 1 && obj != null) {
- obj.forward(request, response);
- }
- }
- }
- @Override
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- @Override
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- processRequest(request, response);
- }
- @Override
- public String getServletInfo() {
- return "Short description";
- }// </editor-fold>
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement