three login | htmlunit login example | form submit html | login example in java | three way login

three login | htmlunit login example | form submit html | login example in java | three way login

here, two way to login on form using HtmlUnit.
using this method you can setup by your custom website login.
you have to just modify your attribute by custom parameter.

Requrie library :- HtmlUnit

convert get request to post java | request param

convert get request to post java | request param

In some case convert post() request into get() request.
If your request is in post just try into get() else you try post()  (into webRequest HttpMethod.GET OR HttpMethod.POST)
Using HtmlUnit fire get() request. In some cases we need to pass parameter for getting response.
so we need to add parameter for request.
so,we set parameters and headers,browser(User-Agent) etc in request code.

Here,i used https://scrapemania.blogspot.in for request processing.
you update by your required site url.
also update parameter AND Host also Referer in WebRequest Header (startLinkCollectionPageSource() method).

Require Library :- HtmlUnit

get request java | get html page java | htmlpage java | set header in get request

get request java | get html page java | htmlpage java | set header in get request

Using HtmlUnit fire get() request. but,some cases response will not given by site properly. Difference like our String response not contain same as text like on our browser response text.
Because of our request is not browser.Actually server will confused it is not understand this is browser request.
so,we set headers,browser(User-Agent) etc in our code.

Here,i used https://scrapemania.blogspot.in for request processing.
you update by your required site url.
also update Host AND Referer in WebRequest Header (startLinkCollectionPageSource() method).

Requrie library :- HtmlUnit

excel reader in java | java xlsx reader | read xssfworkbook example in java

excel reader in java | java xlsx reader | read xssfworkbook example in java

Here code that read (.xlsx) file get appropriate manner,

it means here only three fields demo but you setup by your custom value datatype and add or delete your required fields.

 Requrie library :  ApachePOI
                             Poi-ooxml (if Xml Error) 

Input File :-

import csv in mysql | how to read data from csv file in java

import csv in mysql | how to read data from csv file in java

In mysql insert .csv file regarding same manner fields.

you have to modify for your requirement table fields.

Requrie library : mysqlConnector

Table Script

CREATE TABLE `client_master` (

  `client_master_id` INT NOT NULL AUTO_INCREMENT,

  `client_name` VARCHAR(55) NULL,

  `client_region` VARCHAR(55) NULL,

  `client_order_number` VARCHAR(55) NULL,

  `client_status` INT(1) NULL,

  PRIMARY KEY (`client_master_id`));