Programming Pandit: XML Programming

Showing posts with label XML Programming. Show all posts

Thursday, September 15, 2022

XML Programming September 15, 2022

To write a program to parse xml document using sax parser.

<?xml version = "1.0"?>
<class>
   <student rollno = "01">
      <firstname>Gopal </firstname>
      <lastname>Krishna</lastname>
      <nickname>Krish</nickname>
      <marks>85</marks>
   </student>
   
   <student rollno = "02">
      <firstname>Himani</firstname>
      <lastname>Sharma</lastname>
      <nickname>Guddu</nickname>
      <marks>95</marks>
   </student>
   
   <student rollno = "03">
      <firstname>Abhishek</firstname>
      <lastname>Gusai</lastname>
      <nickname>Abhishek</nickname>
      <marks>98</marks>
   </student>
</class>

UserHandler.java :

package com.tutorialspoint.xml;

import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;

public class UserHandler extends DefaultHandler {

   boolean bFirstName = false;
   boolean bLastName = false;
   boolean bNickName = false;
   boolean bMarks = false;

   @Override
   public void startElement(String uri, 
   String localName, String qName, Attributes attributes) throws SAXException {

      if (qName.equalsIgnoreCase("student")) {
         String rollNo = attributes.getValue("rollno");
         System.out.println("Roll No : " + rollNo);
      } else if (qName.equalsIgnoreCase("firstname")) {
         bFirstName = true;
      } else if (qName.equalsIgnoreCase("lastname")) {
         bLastName = true;
      } else if (qName.equalsIgnoreCase("nickname")) {
         bNickName = true;
      }
      else if (qName.equalsIgnoreCase("marks")) {
         bMarks = true;
      }
   }

   @Override
   public void endElement(String uri, 
   String localName, String qName) throws SAXException {
      if (qName.equalsIgnoreCase("student")) {
         System.out.println("End Element :" + qName);
      }
   }

   @Override
   public void characters(char ch[], int start, int length) throws SAXException {
      
      if (bFirstName) {
         System.out.println("First Name: " 
            + new String(ch, start, length));
         bFirstName = false;
      } else if (bLastName) {
         System.out.println("Last Name: " + new String(ch, start, length));
         bLastName = false;
      } else if (bNickName) {
         System.out.println("Nick Name: " + new String(ch, start, length));
         bNickName = false;
      } else if (bMarks) {
         System.out.println("Marks: " + new String(ch, start, length));
         bMarks = false;
      }
   }
}

SAXParserDemo.java:

package com.tutorialspoint.xml;

import java.io.File;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;

import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;

public class SAXParserDemo {

   public static void main(String[] args) {

      try {
         File inputFile = new File("input.txt");
         SAXParserFactory factory = SAXParserFactory.newInstance();
         SAXParser saxParser = factory.newSAXParser();
         UserHandler userhandler = new UserHandler();
         saxParser.parse(inputFile, userhandler);     
      } catch (Exception e) {
         e.printStackTrace();
      }
   }   
}

class UserHandler extends DefaultHandler {

   boolean bFirstName = false;
   boolean bLastName = false;
   boolean bNickName = false;
   boolean bMarks = false;

   @Override
   public void startElement(
      String uri, String localName, String qName, Attributes attributes)
      throws SAXException {
      
      if (qName.equalsIgnoreCase("student")) {
         String rollNo = attributes.getValue("rollno");
         System.out.println("Roll No : " + rollNo);
      } else if (qName.equalsIgnoreCase("firstname")) {
         bFirstName = true;
      } else if (qName.equalsIgnoreCase("lastname")) {
         bLastName = true;
      } else if (qName.equalsIgnoreCase("nickname")) {
         bNickName = true;
      }
      else if (qName.equalsIgnoreCase("marks")) {
         bMarks = true;
      }
   }

   @Override
   public void endElement(String uri, 
      String localName, String qName) throws SAXException {
      
      if (qName.equalsIgnoreCase("student")) {
         System.out.println("End Element :" + qName);
      }
   }

   @Override
   public void characters(char ch[], int start, int length) throws SAXException {

      if (bFirstName) {
         System.out.println("First Name: " + new String(ch, start, length));
         bFirstName = false;
      } else if (bLastName) {
         System.out.println("Last Name: " + new String(ch, start, length));
         bLastName = false;
      } else if (bNickName) {
         System.out.println("Nick Name: " + new String(ch, start, length));
         bNickName = false;
      } else if (bMarks) {
         System.out.println("Marks: " + new String(ch, start, length));
         bMarks = false;
      }
   }
}

Output:

Roll No : 393
First Name: dinkar
Last Name: kad
Nick Name: dinkar
Marks: 85
End Element :student
Roll No : 493
First Name: Vaneet
Last Name: Gupta
Nick Name: vinni
Marks: 95
End Element :student
Roll No : 593
First Name: jasvir
Last Name: singn
Nick Name: jazz
Marks: 90
End Element :student

gopal krishna 0

Tuesday, September 13, 2022

XML Programming September 13, 2022

To write a program to create XML Schema document

employee.xsd :

<?xml version="1.0"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.javatpoint.com" xmlns="http://www.javatpoint.com" elementFormDefault="qualified">

<xs:element name="employee">

<xs:complexType>

<xs:sequence>

<xs:element name="firstname" type="xs:string"/>

<xs:element name="lastname" type="xs:string"/>

<xs:element name="email" type="xs:string"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

employee.xml

<?xml version="1.0"?>

<employee xmlns="http://www.javatpoint.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="employee.xsd">

<firstname>vimal</firstname>

<lastname>jaiswal</lastname>

<email>vimal@javatpoint.com</email>

</employee>

gopal krishna 0

XML Programming September 13, 2022

To write a program to perform XML transformation using XML and XSL coding.

XML FILE :

<?xml version="1.0" encoding="UTF-8"?>

<?xml-stylesheet type = "text/xsl" href = "student.xsl"?>

<class>

<firstname>Graham</firstname>

<nickname>Garry</nickname>

</student>

<firstname>Albert</firstname>

<lastname>Einstein</lastname>

</student>

<firstname>Thomas</firstname>

<lastname>Edison</lastname>

</student>

</class>

XSL FILE:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version = "1.0" xmlns:xsl = "http://www.w3.org/1999/XSL/Transform">

<xsl:template match = "/class">

<html>

<body>

<h2>Student List</h2>

<th>First Name</th>

</tr>

<xsl:for-each select = "student">

<tr>

</tr>

</xsl:for-each>

</table>

</body>

</html>

</xsl:template>

</xsl:stylesheet>

gopal krishna 0

XML Programming September 13, 2022

To write a program to import and export XML documents using Microsoft Accesss and Microsoft excel.

First Write the XML Program and save with .xml extention

<?xml version="1.0" encoding="UTF-8"?>
<breakfast_menu>
<food>
    <name>Belgian Waffles</name>
    <price>$5.95</price>
    <description>
   Two of our famous Belgian Waffles with plenty of real maple syrup
   </description>
    <calories>650</calories>
</food>
<food>
    <name>Strawberry Belgian Waffles</name>
    <price>$7.95</price>
    <description>
    Light Belgian waffles covered with strawberries and whipped cream
    </description>
    <calories>900</calories>
</food>
<food>
    <name>Berry-Berry Belgian Waffles</name>
    <price>$8.95</price>
    <description>
    Belgian waffles covered with assorted fresh berries and whipped cream
    </description>
    <calories>900</calories>
</food>
<food>
    <name>French Toast</name>
    <price>$4.50</price>
    <description>
    Thick slices made from our homemade sourdough bread
    </description>
    <calories>600</calories>
</food>
<food>
    <name>Homestyle Breakfast</name>
    <price>$6.95</price>
    <description>
    Two eggs, bacon or sausage, toast, and our ever-popular hash browns
    </description>
    <calories>950</calories>
</food>
</breakfast_menu>

After then follow the following Steps.

For Excel:

1. Open the Excel file where you want to get the data from the XML file

2. Click the Data tab

3. In the ‘Get & Transform’ data group, click on the ‘Get Data’ option

4.Go to the ‘From file’ option

5.Click on ‘From XML

6. In the input data dialog box that opens up, locate the XML file that you want to import and select it.

7. Click Import. This will import the XML file into power query and open the Navigator dialog box

8. Select the data from the XML file that you want to import.

For access :

1. If necessary, open the XML or XSD file in Notepad that you want to import, and verify its data.
2. Open the desired database and, on the External Data tab, in the Import group, click XML File.
3. In the Get External Data - XML File dialog box, click Browse to locate the XML or XSD file.
4. In the File Open dialog box, navigate to the folder that contains the XML or XSD file you want to import, select the desired XML or XSD file, and click Open.
5. Select the file type All Files so that XML or XSD files will be displayed.
6. In the Get External Data - XML File dialog box, click OK.
7. If the file type is XML, in the Import XML dialog box, in the Import Options section, select the desired option and click OK.
8. If the file type is XSD, in the Import XML dialog box, click OK.
9. In the Get External Data - XML File dialog box, click Close.
10. If necessary, open the imported table and verify its structure.

gopal krishna 0