String pname=request.getParameter("pname");
    String mno=request.getParameter("mno");
    String pdetails=request.getParameter("pdetails");
    String paddress=request.getParameter("paddress");
    try {
        Class.forName("com.mysql.jdbc.Driver");
        PrintWriter out=response.getWriter();
        out.println("driver loading ");
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/hospital","root","root");
        String query="insert into patient values(?,?,?,?)";
        PreparedStatement st= con.prepareStatement(query);
        st.setString(1, pname);
        st.setString(2,mno );
        st.setString(3, pdetails);
        st.setString(4,paddress);
        st.executeUpdate();
        out.println("patient registration sucessfull");
        }
        catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }



    response.getWriter().append("Served at: ").append(request.getContextPath());
}