Untitled

package com.insurance.registration;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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;


@WebServlet("/search")
public class searchunderwriter extends HttpServlet {
	private static final long serialVersionUID = 1L;
  
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		ArrayList<Underw> underw = new ArrayList<>();
		
		String uname = request.getParameter("underwritername");
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			Connection con = DriverManager.getConnection("jdbc:mysql://intvmunix1:3306/DB_TVM29_2324?useSSL=false","USER_TVM29_2324","Tcs@12345");
			PreparedStatement pst =con.prepareStatement("select * from usersd where uname=?");
			pst.setString(1, uname);
			ResultSet rs = pst.executeQuery();
			while(rs.next()) {
				int id=rs.getInt(1);
				String udname =rs.getString(2);
				String passw=rs.getString(3);
		      	String dob=	rs.getString(4);
				String doj=rs.getString(5);
				
				Underw u = new Underw(id,uname,passw,dob,doj);
				underw.add(u);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		
		
		try {
			List<Underw> userItems = Underwriterdbutil.getUnderWriter();
		} catch (ClassNotFoundException | SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("userItems",underw);
		
	RequestDispatcher dispatcher =request.getRequestDispatcher("searchu.jsp");
	dispatcher.forward(request,response);
	}
		
	

	

}