Home Java Example Java Io Create XML file from flat file and data insert into database

Questions:Ask|Latest

Create XML file from flat file and data insert into database
Posted on: September 9, 2008 By Deepak Kumar

In this section, we have developed an application to create xml file from flat file and data insert into database in Java.

Create XML file from flat file and data insert into database

In this section, we have developed an application to create xml file from flat file and data insert into database in Java.
Two files are used "FlatFileXml.java" and "flatfile.txt" in the code given below.

Flat file: A flat file is a simple plain text file. It consists of one record per line. The fields can be separated by delimiters, e.g. commas,
or have a fixed length. It is a static document, spreadsheet, or textual record that typically contains data that is not structurally related.

Brief description of the flow of application :

1). Create a flat file "flatfile.txt".

2). Create a file "FlatFileXml.java" used to create an XML and data insert into the database.

Step:1 Create a "flatfile" table in Database .

create table `flatfile` (
`id` int ,
`title` varchar (250),
`url` varchar (250)
)

Step:2 Create a "FlatFileXml.java"


import java.io.*;

import java.sql.*;



import org.xml.sax.*;

import org.xml.sax.helpers.*;



import javax.xml.parsers.*;

import javax.xml.transform.*;

import javax.xml.transform.stream.*;

import javax.xml.transform.sax.*;



public class FlatFileXml  {

  String url = "jdbc:mysql://localhost:3306/";

  String dbName = "userdetails";

  String driver = "com.mysql.jdbc.Driver";

  String userName = "root"; 

  String password = "root";

  Statement stmt = null;

  Connection con;

  int val;



  BufferedReader br;

  StreamResult sr;



  TransformerHandler tfh;

  AttributesImpl ai;



  public static void main(String args[])  throws Exception{

  try

  {

  new FlatFileXml().datamain();

      System.out.println("You are Successfully create XML and 

  data insert into the database.");

     }

  catch (Exception e)

  {

  System.out.println(e.getMessage());

  }

  

  }



  public void datamain () {

  try  {

  br = new BufferedReader(new FileReader("flatfile.txt"));

  sr = new StreamResult("flatfile.xml");

  xmlMain();

  String str;

  while ((str = br.readLine()) != null) {

  doWork(str);

  }

  br.close();

  xmlEnd();

  }

  catch (Exception e) { e.printStackTrace(); }

  }





  public void xmlMain() throws Exception {

  SAXTransformerFactory tf = (SAXTransformerFactory) 

  SAXTransformerFactory.newInstance();

tfh = tf.newTransformerHandler(); Transformer serTf = tfh.getTransformer(); serTf.setOutputProperty(OutputKeys.ENCODING,"ISO-8859-1"); tfh.setResult(sr); tfh.startDocument(); ai = new AttributesImpl(); } public void doWork (String s) throws Exception{ String [] ar = s.split("\\-"); try{ Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection(url+dbName,userName,password); String queryString = "INSERT INTO flatfile ( title,url) values('"+ar[0]+"','"+ar[1]+"')";

stmt=con.createStatement(); val = stmt.executeUpdate(queryString); } catch(Exception e) { System.out.println("e : " + e); } ai.clear(); tfh.startElement("","","TITLE",ai); tfh.characters(ar[0].toCharArray(),0,ar[0].length()); tfh.endElement("","","TITLE"); tfh.startElement("","","URL",ai); tfh.characters(ar[1].toCharArray(),0,ar[1].length()); tfh.endElement("","","URL"); } public void xmlEnd() throws Exception{ tfh.endDocument(); } }

Step:3 Create a flat file "flatfile.txt".

Java - http://www.roseindia.net

    JSP - http://www.roseindia.net

    SERVLET - http://www.roseindia.net

    Struts - http://www.roseindia.net

Output:

After run Successfully Create an XML file "flatfile.xml"

Download the full Code

«Previous Index Next»

Recommend the tutorial

Ask Questions? Discuss: Create XML file from flat file and data insert into database View All Comments

Post your Comment

Comments

gayathri
April 12, 2012
doubt

at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(FileInputStream.java:106) at java.io.FileInputStream.<init>(FileInputStream.java:66) at java.io.FileReader.<init>(FileReader.java:41) at FlatFileXml.datamain(FlatFileXml.java:56) at FlatFileXml.main(FlatFileXml.java:44) How to solve this problem?

Latest
Related
Frameworks
Category