Current Technology: Web Technologies Record

AIM: To design a student database using XML and display the content using XSL by validating through XML schema.

PROGRAM:

XML document

<?xml version="1.0"?>

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

<firstname>Lakshmi</firstname>

<course>Mtech</course>

</student>

<firstname>Sarvani</firstname>

<course>Mtech</course>

</student>

</studentdata>

XMLSchema

<?xml version="1.0"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:elementType id="studentdata">

<xs:elementType id="student">

<xs:elementType id="name">

<xs:elementType id="firstname" type="#firstname"/>

<xs:elementType id="lastname" type="#lastname"/>

</xs:elementType>

<xs:elementType id="rollno"/>

<xs:elementType id="dept"/>

<xs:elementType id="course"/>

</xs:elementType>

</xs:schema>

XML Stylesheet : CSE.xsl

<?xml version="1.0"?>

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

<xsl:output method="html"/>

<xsl:template match="/">

<html>

<head>

<title>details</title>

</head>

<body>

<tr>

<th>Firstname</th>

<th>Lastname</th>

<th>Rollno</th>

<th>Course</th>

</tr>

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

<xsl:if test="dept='CSE'">

</tr>

</xsl:if>

<xsl:if test="dept='ECE'">

</tr>

</xsl:if>

</xsl:for-each>

</table>

</body>

</html>

</xsl:template>

</xsl:stylesheet>

RESULT: Hence the program to design a student database using XML and display the content using XSL by validating through XML schema have been successfully completed

OUTPUT:

AIM: To design a web application using different types of CSS.

PROGRAM:

<html>

<head>

.medium {border-width:medium}

.thin {border-width:thin}

.solid {border-style:solid}

.outset {border-style:outset}

.red {border-color:red}

.blue {border-top-color:blue;border-left-color:red;border-right-color:red;

border-bottom-color:blue;margin-bottom:1em}

</style>

</head>

<body>

<p>This text doesnot have style applied</p>

<p style="font-size:20pt;color:SteelBlue">this text has inline style

<em>font-size</em><em> color</em> applied to it.</p>

<p>These have embedded styles applied</p>

<div class="thin red solid">thin red Solid Border</div>

<hr>

<div class="medium blue outset ">medium blue outset Border</div>

<p>These have external styles applied</p>

<div class="floated"> External StyleSheets</div>

A style sheet is linked using link element that uses rel attribute="stylesheet"

means the linked document is a stylesheet for this document.

</div>

</body>

</html>

E.css:

div.floated { background-color:#eeeeee;

font-size:1.5em;

font-family:arial;

margin-bottom:.5em;

float:right;

text-align:center;

width:50%;

}

div.section {

border: 1px solid #bbddff

}

RESULT: Hence the design of web application using different types of CSS has been successfully executed

OUTPUT:

AIM: To write a program in Java Script for displaying the current date in the following format. FRIDAY, 3-May-2013

PROGRAM:

<html>

<head>

var current = new Date();

var d=["SUNDAY","MONDAY","TUESDAY","WEDNESDAY",

"THURSDAY","FRIDAY","SATURDAY"];

var m=["January","February","March","April","May","June","July","August",

"September","October","November","December"];

document.writeln("<h1>Today's date is</h1>");

document.writeln(d[current.getDay()]);

document.write(","+current.getDate());

document.write("-"+m[current.getMonth()]);

document.write("-"+current.getYear());

</script>

</head>

<body>

</body>

</html>

RESULT: Hence the program that displays the current date in the following format FRIDAY, 3-May-2013 has been successfully executed.

OUTPUT:

AIM: To write a Java Script program that uses onMouseOver and onMouseOut events

PROGRAM:

<html>

<head>

function bigImg(x)

{

x.style.height="256px";

x.style.width="256px";

}

function normalImg(x)

{

x.style.height="64px";

x.style.width="64px";

}

</script>

</head>

<body>

<img onMouseOver="bigImg(this)" onMouseOut="normalImg(this)" border="0"

src="p.jpg" alt="Flower" width="32" height="32">

</body>

</html>

RESULT: Hence the Java Script program that uses onMouseOver and onMouseOut events has been successfully executed.

OUTPUT:

AIM: To write an applet program that implements ItemListener

PROGRAM:

import java.applet.*;

import java.awt.*;

import java.awt.event.*;

</applet>

public class ItemListenerDemo extends Applet implements ItemListener

{

Choice c;

public void init()

{

c = new Choice(); //create choice or combobox

c.add("red"); //add items to the choice

c.add("green");

c.add("blue");

c.add("pink");

add(c); //add choice or combobox

c.addItemListener(this); //add item listener

}

public void paint(Graphics g)

{

// To get selected item, use String getSelectedItem() method of AWT Choice class.

g.drawString(c.getSelectedItem(),10, 70);

}

public void itemStateChanged(ItemEvent e)

{

repaint();

}

RESULT: Hence the applet program that implements ItemListener has been successfully executed.

OUTPUT:

AIM: To design an applet with ‘n’ labels with ‘n’ different colours occupy ‘n’ grids.

PROGRAM:

import java.awt.*;

import java.awt.GridLayout.*;

import java.applet.*;

/*<applet code="GridDemo" width="300" height="200"></applet>*/

public class GridDemo extends Applet

{

static final int n=4;

Label l[] = new Label[16];

Color[] c;

public void init()

{

c= new Color[16];

Color c[] = { Color.blue,Color.cyan, Color.black,Color.red, Color.gray, Color.green,

Color.lightGray,Color.blue, Color.magenta, Color.orange, Color.pink,

Color.cyan,Color.red, Color.white, Color.green, Color.yellow,

Color.darkGray };

setLayout(new GridLayout(n,n));

for(int i=0;i< n;i++)

{

for(int j=0;j< n;j++)

{

int k=i*n+j;

if(k>0)

{

l[k]=new Label(""+k);

l[k].setBackground(c[k]);

add(l[k]);

}

RESULT: Hence the applet program with ‘n’ labels with ‘n’ different colours occupy ‘n’ grids has been successfully executed.

OUTPUT:

AIM: To write an applet program that allows parameter passing.

PROGRAM:

import java.awt.*;

import java.awt.event.*;

import java.applet.*;

</applet>*/

public class ParamDemo extends Applet implements ActionListener

{

Button b1;

int w,h;

public void init()

{

setBackground(Color.YELLOW);

b1=new Button("Change");

b1.addActionListener(this);

add(b1);

}

public void start()

{

setSize(800,800);

setVisible(true);

String s1= getParameter("w");

String s2= getParameter("h");

w=Integer.parseInt(s1);

h=Integer.parseInt(s2);

}

public void actionPerformed(ActionEvent ac)

{

setSize(w,h);

}

RESULT: Hence the applet program that allows parameter passing has been successfully executed.

OUTPUT:

AIM: To write an applet program that implements AdjustmentListener.

PROGRAM:

import java.awt.*;

import java.awt.event.*;

import java.applet.*;

/*<applet code="AdjDemo" width="300" height="200" >

</applet>*/

public class AdjDemo extends Applet implements AdjustmentListener

{

Scrollbar s1,s2,s3;

TextField t1;

public void init()

{

setLayout(new BorderLayout());

s1 = new Scrollbar(0,125,15,0,255);

s2 = new Scrollbar(Scrollbar.VERTICAL, 0, 51, 0, 255);

s3 = new Scrollbar(0,205,15,0,255);

t1 = new TextField(20);

s1.setBackground(Color.YELLOW);

s2.setBackground(Color.RED);

s3.setBackground(Color.blue);

s1.addAdjustmentListener(this);

s2.addAdjustmentListener(this);

s3.addAdjustmentListener(this);

add(s1,BorderLayout.NORTH);

add(s2,BorderLayout.WEST);

add(s3,BorderLayout.SOUTH);

add(t1,BorderLayout.EAST);

}

public void adjustmentValueChanged(AdjustmentEvent e)

{

setBackground(new Color(s1.getValue(),s2.getValue(),s3.getValue()));

t1.setText("value of s1,s2,s3 is"+s1.getValue()+s2.getValue()+s3.getValue());

}

public void start()

{

setSize(400,400);

setVisible(true);

}

RESULT: Hence the applet program that implements AdjustmentListener has been successfully executed.

OUTPUT:

AIM: Write a simple Java program to display the details of a particular department from Access database.

PROGRAM:

import java.sql.*;

public class AccessDatabase

{

public static void main(String[] args)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:db1");

Statement st=con.createStatement();

ResultSet rs = st.executeQuery("select * from department where deptno='1'");

while (rs.next())

{

System.out.println("Deptno= " + rs.getString(1) + " Deptname= " +

rs.getString(2)+ " Location = " + rs.getString(3));

}

catch(Exception e)

{

System.out.println("this is");

System.out.println(e);

}

RESULT: Hence a simple Java program to display the details of a particular department has been successfully executed.

OUTPUT:

AIM: To write a servlet program that creates a new user entry in the user table in database.

User entry is done through html form and a new user is created on clicking login button on form.html.

PROGRAM:

Form.html

<html>

<body>

<br>

Password : <input type=password name="password">

<br>

</form>

</body>

</html>

SERVLET PROGRAM:

import java.io.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DBServlet extends HttpServlet

{

public void doPost(HttpServletRequest req, HttpServletResponse res) throws

ServletException, IOException

{

String login=req.getParameter("login");

String pwd=req.getParameter("password");

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:db1");

PreparedStatement st=con.prepareStatement("insert into user values (?,?)");

st.setString(1,login);

st.setString(2,pwd);

int n = st.executeUpdate();

con.close();

res.setContentType("text/html");

PrintWriter out =res.getWriter();

out.println("<html><body><h1>");

if(n >0)

{

out.println("new user created");

}

else

{

out.println("new user not created");

}

out.println("</h1></body></html>");

out.close();

}

catch(Exception e)

{

System.out.println("this is");

System.out.println(e);

}

RESULT: Hence the servlet program has been successfully executed.
OUTPUT:

AIM: To write a JSP program that displays the data in the user table that exists in database.

PROGRAM:

<html>

<body>

<%@ page import="javax.sql.*;" %>

java.sql.Connection con=null;

java.sql.Statement s=null;

java.sql.ResultSet rs=null;

java.sql.ResultSetMetaData rsmd;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con = java.sql.DriverManager.getConnection("jdbc:odbc:db1");

s = con.createStatement();

rs = s.executeQuery("select * from user");

rsmd=rs.getMetaData();

int count = rsmd.getColumnCount();

out.print("<tr>");

for (int i=1; i<=count; i++)

{

out.print("<th>");

out.print(rsmd.getColumnName(i));

}

out.println("</tr>");

while( rs.next() )

{

<tr>

</tr>

}

catch(Exception e)

e.printStackTrace();

</table>

</body>

</html>

RESULT: Hence the JSP program that displays the data in the user table has been successfully executed.

OUTPUT:

Monday, 5 May 2014

Web Technologies Record

No comments:

Post a Comment

Recent

Comments