Table:tes_aja

CREATE TABLE `tes_aja` (
`kd_div` varchar(30) default NULL,
`nm_div` varchar(30) default NULL,
`dep` varchar(30) default NULL,
`jab` varchar(30) default NULL,
`cab` varchar(30) default NULL,
`ket` varchar(30) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

divisi.txt:

d00001;Operation;Finance;Finance Head;Kantor; Pusat;
d00001;Operation;Acct-Tax;Account Receivable;Kantor; Pusat;
d00001;Operation;Acct-Tax;Account Payable;Kantor; Pusat;
d00001;Operation;Operation;Operation Manager;Kantor; Pusat;

import java.io.*;
import java.sql.*;

public class ReadDataTxtFileAndInsertIntoDatabase
{
public static void main(String[] args)
{
try{
// Open the file that is the first
// command line parameter
FileInputStream fstream = new FileInputStream("C:\\divisi.txt");
// Get the object of DataInputStream
DataInputStream in = new DataInputStream(fstream);
BufferedReader br = new BufferedReader(new InputStreamReader(in));
String strLine;

Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://192.168.10.75:3306/textdata","root","root";);

//Read File Line By Line
while ((strLine = br.readLine()) != null) {
// Print the content on the console
String strar[] = strLine.split(";");
String query="";

try{
Statement st = con.createStatement();
System.out.println(strar[5]);
query = "INSERT into tes_aja (kd_div,nm_div,dep,jab,cab,ket) VALUES('"+strar[0]+"','"+strar[1]+"','"+strar[2]+"','"+strar[3]+"','"+strar[4]+"','"+strar[5]+"')";

int val = st.executeUpdate(query);
System.out.println("1 row affected");
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}

}
//Close the input stream
in.close();
}catch (Exception e){//Catch exception if any
System.err.println("Error: " + e.getMessage());
}
}
}


Thanks
Vinod kumar

Tks Vinod Kumar,

and how if create file in pdf and call from database?. thank you before