XMLProg

-

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

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

<students>

 <student>

 <name>Aswath S</name>

 <age>21</age>

 <dob>09/08/2000</dob>

 <mobile>9812989444</mobile>

 <address>CBE</address>

 </student>

 <student>

 <name>Surya M</name>

 <age>21</age>

 <dob>04/08/2000</dob>

 <mobile>9585593999</mobile>

 <address>CBE</address>

 </student>

</students>




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

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

 <html>

 <body>

 <h2>Students Personal Details</h2>

 <table border="1">

 <tr bgcolor="#9acd32">

 <th>Name</th>

 <th>Age</th>

 <th>DOB</th>

 <th>Mobile</th>

 <th>Address</th>

 </tr>

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

 <tr>

 <td><xsl:value-of select="name"/></td>

 <td><xsl:value-of select="age"/></td>

<td><xsl:value-of select="dob"/></td>

 <td><xsl:value-of select="mobile"/></td>

 <td><xsl:value-of select="address"/></td>

 </tr>

 </xsl:for-each>

 </table>

 </body>

 </html>

</xsl:template>

</xsl:stylesheet>




================customer.xsl==================

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

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

 <html>

 <body>

 <h2>customer details</h2>

 <table border="1">

 <tr bgcolor="#9acd32">

 <th>Name</th>

 <th>Branch</th>

 <th>Age</th>

 <th>City</th>

 </tr>


<tr>

 <td><xsl:value-of select="name"/></td>

 <td><xsl:value-of select="branch"/></td>

 <td><xsl:value-of select="age"/></td>

 <td><xsl:value-of select="city"/></td>

 </tr>

 </xsl:for-each>

 </table>

 </body>

 </html>

</xsl:template>

</xsl:stylesheet>

=====================customers.xml======================

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

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

<customers>

 <customer>

 <name>Aswath</name>

 <branch>MCA</branch>

 <age>21</age>

<city>CBE</city>

 </customer>

 <customer>

 <name>Indru</name>

 <branch>MCA</branch>

 <age>21</age>

 <city>CBE</city>

 </customer>

 <customer>

 <name>Raja</name>

 <branch>MCA</branch>

 <age>21</age>

 <city>CBE</city>

 </customer>

 <customer>

 <name>Jai</name>

 <branch>MCA</branch>

 <age>21</age>

 <city>CBE</city>

 </customer>

</customers>

======================demo.xml========================

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

<books>

 <book>

 <bookname>HARRY POTTER</bookname>

 <author> J K ROWLING</author>

 </book>

 <book>

 <bookname>THE HOBBIT</bookname>

 <author> JRR TOLKIEN</author>

 </book>

 <book>

 <bookname>PONNIYIN SELVAM</bookname>

 <author>KALKI</author>

 </book>

 <book>

 <bookname>THIRUKURAL</bookname>

 <author> THIRUVALLUVAR</author>

 </book>

</books>


======================demo.xml========================

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

<books>

 <book>

 <bookname>HARRY POTTER</bookname>

 <author> J K ROWLING</author>

 </book>

 <book>

 <bookname>THE HOBBIT</bookname>

 <author> JRR TOLKIEN</author>

 </book>

 <book>

 <bookname>PONNIYIN SELVAM</bookname>

 <author>KALKI</author>

 </book>

 <book>

 <bookname>THIRUKURAL</bookname>

 <author> THIRUVALLUVAR</author>

 </book>

</books>

Comments

Post a Comment

Popular posts from this blog

RDBMS SEMINAR

-
Image
       Specialized Locking Techniques :                 The concurrency control technique in which the value of the lock variable is manipulated is called locking.         The technique of locking is one way to   Ensure Serializability in DBMS.       In DBMS, locking is the responsibility of a subsystem called lock manager.        Binary Locks :               A binary lock has two states or values associated with each data item. These values are:                                        Locked – 1                                  Unlocked – 0 Locked (A):      To access a data item in the database.   Unlocked (B):     ...
Read more

R tools Code

-
Apirori Code:  install.packages("arules") > library(arules) > data(Groceries) > transactions <- Groceries > summary(transactions) > itemFrequencyPlot(transactions, support=0.1, cex.names=0.8) > itemFrequencyPlot(transactions, support=0.05, cex.names=0.8) > itemFrequencyPlot(transactions,topN=20) > rules <- apriori(Groceries, parameter = list(support = 0.009, confidence = 0.25, minlen = 2)) > inspect(head(sort(rules, by="lift"),5)) > install.packages("arulesViz") > library("arulesViz") > plot(rules, measure=c("support", "confidence"), shading="lift", interactive=FALSE) > milk.rules <- sort(subset(rules, subset = rhs %in% "whole milk"), by = "confidence") > summary(milk.rules) > inspect(milk.rules) ===================================== NaivesBayes Code : install.packages("e1071")  library(e1071)  data("iris") head(iris)  tail(...
Read more

Database Connectivity

-
 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication3 { public partial class Form1 : Form { SqlConnection con = new SqlConnection(@"Data  Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kisho\OneDrive\Documents\Empl oyee.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void button2_Click(object sender, EventArgs e) { con.Open(); SqlCommand cmd = new SqlCommand ("Insert into Employee_Table  values('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text +"','"+textBox4  .Text+"','"+comboBox1 .Text +"')",con); cmd.ExecuteNonQuery(); MessageBox .Show("Insert dat...
Read more