Write Text File to Table

In this section, you will learn how to read the records of a simple text file and write (insert) into a simple table in MySQL database. All records are written in the simple text file and again, if you need to insert these records in tabular format the fo

Write Text File to Table

Write Text File to Table

     

In this section, you will learn how to read the records of a simple text file and write (insert) into a simple table in MySQL database. All records are written in the simple text file and again, if you need to insert these records in tabular format the following example will provide the facility for writing this content.

Description of program:

The following program helps you in writing the records in the MySQL database table  from the simple text file. For this, you must have to create a simple text file that have to be inserted the records into a database table. This program uses the simple Text file (Employee_list.txt) that contains all employees record (id, Emp_name, Emp_depart and sal). After creating a text file, you should establish the connection with MySQL database. Here, we applying the connection() method that will provide the connection and another is TextFileToTable() method that helps you for writing or inserting the records into a MySQL database table (Employee_Records). The inserting process is completely successfully, it will show a message "All data are inserted in the database table".  

Description of code:

StringTokenizer(String data, String comma):
This is the constructor of StringTokenizer class that allows the permission for breaking an application into tokens. It constructs a string tokenizer for the given string. The characters are separated by the comma arguments. 

nextToken():
This is the method that returns the next tokens from the StringTokenizer object. 

Here is the code of program:

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

public class TextFileToTable{
  Connection con = null;
  Statement st;
  public static void main(String[] args) {
  System.out.println("Write Text File to Table!");
  TextFileToTable text = new TextFileToTable();
  }

  public Connection connection(){
  try{
  Class.forName("com.mysql.jdbc.Driver");
  }
  catch(ClassNotFoundException c){
  System.out.println("Class not found!");
  }
  try{
  con = DriverManager.getConnection(
  "jdbc:mysql://localhost:3306/jdbctutorial","root","root");
  }
  catch(SQLException s){
  System.out.println("Connection is not found!");
  }
  return con;
  }

  public TextFileToTable(){
  try{
  FileInputStream fstream = new FileInputStream("Employee_list.txt");
  DataInputStream dstream = new DataInputStream(fstream);
  BufferedReader bf = new BufferedReader(new InputStreamReader(dstream));
  String data = null;
  String comma = ",";
  while((data = bf.readLine()) != null){
  StringTokenizer stoken = new StringTokenizer(data,comma);  
  String Emp_id = stoken.nextToken();
  int id = Integer.parseInt(Emp_id);
  String Emp_name = stoken.nextToken();
  String Emp_depart = stoken.nextToken();
  String Emp_sal = stoken.nextToken();
  int sal = Integer.parseInt(Emp_sal);
  st = connection().createStatement();
  int row = st.executeUpdate("INSERT Employee_Records VALUES
   ("+id+" , '"+Emp_name+"'"+" , '"+Emp_depart+"' ,"+sal+")");
  }
  System.out.println("All data are inserted in the database table");
  bf.close();
  st.close();
  }
  catch(Exception e){
  e.printStackTrace();
  }
  }
} 

Download this example.

Tutorials

  1. Mapping MySQL Data Types in Java
  2. Connecting to a MySQL Database in Java
  3. Creating a Database in MySQL
  4. Creating a Database Table
  5. Creating a MySQL Database Table to store Java Types
  6. Description of Database Table
  7. Deleting a Table from Database
  8. Retrieving Tables from a Database
  9. Inserting values in MySQL database table
  10. Retrieving All Rows from a Database Table
  11. Adding a New Column Name in Database Table
  12. Change Column Name of a Table
  13. Make Unique Column in Database Table
  14. Remove Unique Column in Database Table
  15. Arrange a Column of Database Table
  16. Arrange a Column of Database Table
  17. Sum of Column in a Database Table
  18. Deleting All Rows from a Database Table
  19. Delete a Specific Row from a Database Table
  20. Delete a Column from a Database Table
  21. Join tables in the specific database
  22. Join tables with the NATURAL LEFT JOIN operation
  23. Join tables with the NATURAL RIGHT JOIN operation
  24. Cross Join Tables in a Specific Database
  25. Prepared Statement Set Object
  26. Statement Batch Update
  27. Prepared Statement With Batch Update
  28. Select Records Using Prepared Statement
  29. Update Records using Prepared Statement
  30. Inserting Records using the Prepared Statement
  31. Count Records using the Prepared Statement
  32. Deleting Records using the Prepared Statement
  33. Using the Prepared Statement Twice
  34. Set Data Types by using Prepared Statement
  35. Set byte, short and long data types by using the Prepared Statement
  36. Prepared Statement Set Big Decimal
  37. Set Date by using the Prepared Statement
  38. Set Time by using the Prepared Statement
  39. Set Timestamp by using the Prepared Statement
  40. Copy Table in a MySQL Database