Insert Rows into the Database

Servlet Code to Insert Rows into the Database
This servlet will accept name and age as parameters and insert them into the users table.

java
Copy code
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/InsertUserServlet")
public class InsertUserServlet extends HttpServlet {

    private static final String DB_URL = "jdbc:mysql://localhost:3306/yourDatabaseName";
    private static final String DB_USER = "yourUsername";
    private static final String DB_PASSWORD = "yourPassword";

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // Get parameters from the request
        String name = request.getParameter("name");
        String age = request.getParameter("age");

        // Set response content type
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        Connection conn = null;
        PreparedStatement stmt = null;

        try {
         
            Class.forName("com.mysql.cj.jdbc.Driver");

   
            conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

            String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
            stmt = conn.prepareStatement(sql);
            stmt.setString(1, name);
            stmt.setInt(2, Integer.parseInt(age));

       
            int rowsInserted = stmt.executeUpdate();
            if (rowsInserted > 0) {
                out.println("<h1>New user added successfully!</h1>");
            } else {
                out.println("<h1>Error: No user was added.</h1>");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            out.println("<h1>Error: Unable to load database driver.</h1>");
        } catch (SQLException e) {
            e.printStackTrace();
            out.println("<h1>Error: Unable to execute insert operation.</h1>");
        } finally {
            try {
                if (stmt != null) stmt.close();
                if (conn != null) conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}