SQL Queries & HTML

Learn ruby on rails

noreply@blogger.com (Ganesh Raju) — Sun, 02 Dec 2018 05:55:00 +0000

Learn ruby on rails visit Rails Cheatsheet

XML program for student details by using cascading style sheets(CSS)

noreply@blogger.com (Ganesh Raju) — Tue, 26 May 2015 15:54:00 +0000

Program:

<?xml version ="1.0"?>
          <?xml-style sheet type="text/css"href="student info=css"?>
    <student info>
    <student>
         <name>ABC</name>
         <rno>004</rno>
         <branch>MMT</branch>
        </student>

<student>
         <name>Nitesh</name>
        <rno>008</rno>
        <branch>Biotech</branch>
        </student>
        <student>
              <name>Jignesh</name>
        <rno>012</rno>
        <branch>chemical</branch>
        </student>
        </student info>
CSS fig:-
    student info
    {
        background-color:cyace;
        width:100%;
        }
        name
        {
        width:100%;
        color:yellow
        font:14px;
        }
              rno
        {
            width:100%
            display:black;
            color:red;
            margin-rynt:20pt
           font:20pt
        }
           branch
           {
            width:100%
            display:blw;
            color:white;
            font:25pt;
            }

Learn ruby on rails visit Rails Cheatsheet

Employee details by using XML,DTD? XSL

noreply@blogger.com (Ganesh Raju) — Sat, 16 May 2015 17:30:00 +0000

Program:

Read: Create your own website

Read: Visit more c,c++ and java programs

<?xml version="1.0" encoding="iso_88591"?>
<!DOCTYPE empinfo SYSTEM "empinfo.dtd"?>
<?xml-stylesheet type="text\xsl" href="empinfo.xsl">
<empinfo>
<employee>

<ename>ganesh</ename>
<sal>100000</sal>
<dept>cse</dept>
</employee>
<ename>naresh</ename>
<sal>200000</sal>
<dept>it</dept>
</employee>
<employee>
<ename>shiva</ename>
<sal>100000</sal>
<dept>it</dept>
</employee>
</empinfo>

empinfo.dtd

<!ELEMENT empinfo(employee)>
<!ELEMENT employee(ename,sal.dept)>
<!ELEMENT ename(#PCDATA)>
<!ELEMENT dept(#PCDATA)>

empinfo.xsl

<?xml version="1.0"?>
<xsl:stylesheet-version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform">
<xsl:template match="1">
<html>
<body>
<xsl:for-each select="empinfo/employee">
<div style="background-color:teal;color:red;padding:4px">
<span style="front-weight:bold">
<xsl:value-of select="ename"/>
</span>
</div>
<div style="background-color:green;text-align:center">
<xsl:value-of select="sal"/>
</div>
<div style="margin-left:20px;font-size:20pt">
<span style="font-style:italic">
<xsl:value-of select="dept"/>
</span>
</div>
</xsl:for-each>
</body>
</html>

JSP program for scripting elements

noreply@blogger.com (Ganesh Raju) — Sat, 16 May 2015 17:22:00 +0000

Program:

Visit more c,c++ and java programs

<%@page language="java" session="false"%>
<%@page info="simple scriplet example"%>
<%@page import="java.util.*"%>
<%! calender cal;
String months[]={"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov",dec"};%>

<html>
<head>
<title>simple JSp elementd demonstration</title>
</head>
<body>
<h3>server date is now:</h3>
<%cal=Calender.getInstance();%>
<%=cal.get(calender.Date)%>
<%=months(calender.get(Calender.MONTH))%>
<%=cal.get(calender.YEAR)%>
</body>
</html>

JSP program using Script code

noreply@blogger.com (Ganesh Raju) — Sun, 26 Apr 2015 06:58:00 +0000

Program:

Read: More C,C++ and Java programs

Read: To display numbers in recursive order

<%@page language="java" session="false"%>

<%@page info="demostration of script"%>

<%@page import="java.util.Date"%>

<html>

<head>

<title>Displaying values using scriplets</title>

</head>

<body>

<% System.out.println ("The server time is:")

java.util.Date date=new java.util.Date();

System.out.println(date);%>

<hu>Hello the server time is now :</hu>

<% out.println("<hu>"+date.toLocalString()+"</hu>");

out.println("<br><em>your machine address is:</em>");

out.println(request.getRemoteHost());%>

</body>

</html>

Simple JSP program

noreply@blogger.com (Ganesh Raju) — Sun, 26 Apr 2015 06:48:00 +0000

Program:

Read: Tips for creating a website

Read: Visit more c,c++ and java programs

<%@page language="java" contentType="text/html"%>

<%@page import=java.util.*%>

<html>

<body>

<%--Displaying the message on browser--%>

<%out.println("First JSP page")%>

</body>

</html>

Simple Servlet program with XML file

noreply@blogger.com (Ganesh Raju) — Thu, 02 Apr 2015 13:43:00 +0000

Program:

Read: Tips for creating a Website.

import java.io.*;
import javax.servlet.*;
public class simpleservlet extends GenericServlet{

public void service(ServletRequest request,ServletResponse response)throws ServletException,IOException

{
    response.setContentType("text/html");
    PrintWriter pw=response.getWriter();
    pw.println("<B>Hello!");
    pw.close();
}
}

Web.xml

<web_app>
<servlet>
<servlet_name>Hello servlet</servlet_name>
<servlet_class>simpleservlet</servlet_class>
</servlet>
<servlet_mapping>
<servlet_name>Hello servlet</servlet_name>
<url_pattern>/hello</url_pattern>
</servlet_mapping>
</web_app>

XML program to display the Book details With Table

noreply@blogger.com (Ganesh Raju) — Sun, 29 Mar 2015 06:53:00 +0000

Program:

Read: Download free Java Server E-book

<?xml version="1.0" encoding="UTF-8" ?><?xml-stylesheet type="text/xsl" href="catalog_xsl.xsl" ?>
<Catalog>
    <Book>
        <Title>XML Bible</Title>
        <Author>Winston</Author>
        <Publication>Wiely</Publication>

<Edition>Fifth Edition</Edition>
        <ISBN>0-7645-4760-7</ISBN>
        <Price>$40.5</Price>
    </Book>

    <Book>
        <Title>Artificial Intelegence</Title>
        <Author>S.Russel</Author>
        <Publication>Princeton Hall</Publication>
        <Edition>Sixth Edition</Edition>
        <ISBN>0-13-1038-5-2</ISBN>
        <Price>$63</Price>
    </Book>

    <Book>
        <Title>Java2</Title>
        <Author>Watson</Author>
        <Publication>BPB Publications</Publication>
        <Edition>Third Edition</Edition>
        <ISBN>0-41-1058-7-2</ISBN>
        <Price>$60</Price>
    </Book>

    <Book>
        <Title>HTML in 24 hours</Title>
        <Author>Sam Peter</Author>
        <Publication>SAM Publications</Publication>
        <Edition>Fifth Edition</Edition>
        <ISBN>0-0672-32841-2</ISBN>
        <Price>$40</Price>
    </Book>
</Catalog>

XML program to display the book catalogue

noreply@blogger.com (Ganesh Raju) — Sun, 29 Mar 2015 06:49:00 +0000

Program:

<?xml version="1.0" encoding="UTF-8" ?><?xml-stylesheet type="text/css" href="library.css" ?>
<Catalog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="catalog.xsd">
    <Book>
        <Title>XML Bible</Title>

<Author>Winston</Author>
        <Publication>Wiely</Publication>
        <Edition>Fifth Edition</Edition>
        <ISBN>0-7645-4760-7</ISBN>
        <Price>$40.5</Price>
    </Book>

    <Book>
        <Title>Artificial Intelegence</Title>
        <Author>S.Russel</Author>
        <Publication>Princeton Hall</Publication>
        <Edition>Sixth Edition</Edition>
        <ISBN>0-13-1038-5-2</ISBN>
        <Price>$63</Price>
    </Book>

    <Book>
        <Title>Java2</Title>
        <Author>Watson</Author>
        <Publication>BPB Publications</Publication>
        <Edition>Third Edition</Edition>
        <ISBN>0-41-1058-7-2</ISBN>
        <Price>$60</Price>
    </Book>

    <Book>
        <Title>HTML in 24 hours</Title>
        <Author>Sam Peter</Author>
        <Publication>SAM Publications</Publication>
        <Edition>Fifth Edition</Edition>
        <ISBN>0-0672-32841-2</ISBN>
        <Price>$40</Price>
    </Book>
</Catalog>

HTML program for employee details with data

noreply@blogger.com (Ganesh Raju) — Sat, 21 Mar 2015 06:35:00 +0000

program:

<xml id="movies">
    <?xml version="1.0"?>
    <movies>
        <movie>
            <name><b>Clark Kent</b></name>
            <jobtitle>Superman</jobtitle>
            <born>1966</born>
        </movie>

<movie>
            <name><b>Lois Lane</b></name>
            <jobtitle>Reporter</jobtitle>
            <born>1964</born>
        </movie>
    </movies>
</xml>

<table width="100%" cellpadding="0px" cellspacing="2px" border="1px" datasrc="#movies"
       datapagesize="2">
    <thead>
    <tr>
        <th>Name</th>
        <th>Jobtitle</th>
        <th>Born</th>
    </tr>
    </thead>
    <tbody>
    <tr>
        <td><span datafld="name" dataformatas="html"></span></td>
        <td><span datafld="jobtitle"></span></td>
        <td><span datafld="born"></span></td>
    </tr>
    </tbody>
</table>

HTML program for employee details table

noreply@blogger.com (Ganesh Raju) — Sat, 21 Mar 2015 06:32:00 +0000

program:

<html>
<body>
<h1 style="background-color:blue;color:white;text-align:center">Employee Details</h1>
<xml id="emp records" src="employee.xml">
</xml>
<table id=etable name=emp width=100% border=2 bordercolor=red bg=cyan cellpaddding=0
       datasrc=#emprecords>
    <thead>
    <tr>

   <th>empno</th>
        <th>ename</th>
    </tr>
    </thead>
    <tbody>
    <tr>
        <td><span datafld=empno></span></td>
        <td><span datafld=ename></span></td>
    </tr>
    </tbody>
</table>
</body>
</html>

Javascript validation for registration form

noreply@blogger.com (Ganesh Raju) — Sat, 14 Mar 2015 04:55:00 +0000

Program:

<html>
<head>
<title>Registration form</title>
<script language="javascript">
function validate()
{
   var name=document.forms[0].elements[0].value;
   var pwd=document.forms[0].elements[1].value;
   var email=document.forms[0].elements[2].value;
   var phno=document.forms[0].elements[3].value;


name_re=new RegExp("^[A-Za-z][a-zA-Z ]+$","g");
    pwd_re=new RegExp("^[0-9a-zA-Z]+$","g");
    email_re=new RegExp("^[a-zA-Z][\\w_.]+[@][\\w]+[.][com]+$","g");
    phno_re=new RegExp("^[\\d]+","g");

   if(!name.match(name_re))
     {
        alert(" name contains only alphabets only");
        document.forms[0].elements[0].select();

    }
    if(name.length<6)
    {
    alert("name should contain atleast 6 characters");
    document.forms[0].elements[0].select();
    }

    if(!pwd.match(pwd_re))
     {
        alert(" password should contain alphanumerics only");
        document.forms[0].elements[1].select();

    }
    if(pwd.length<6)
    {
    alert("password should contain atleast 6 characters");
    document.forms[0].elements[1].select();
    }

    if(!email.match(email_re))
     {
        alert(" invalid email");
        document.forms[0].elements[2].select();

    }

    if(!phno.match(phno_re))
     {
        alert(" invalid phone number");
        document.forms[0].elements[3].select();

    }
    if(phno.length<10)
    {
    alert("phone number should contain 10 digits ");
    document.forms[0].elements[3].select();
    }


}
</script>
</head>
<body bgcolor="#abcdef">
<h3 align="center">Registration Form</h3>
<form name="reg_form" method="post">
NAME
<input type="text" name="uname" value="" size="15" maxlength="20"><br>
PASSWORD
<input type="password" name="pwd" value="" size="25"><br>
EMAIL
<input type="text" name="email" value="" size="15"><br>
PHONE NUMBER
<input type="text" name="phno" value="" size="15" maxlength="10"><br>
<pre>
GENDER
    male    <input type="radio" name="gender" value="male">
    female <input type="radio" name="gender" value="female">
</pre>
<br>
DATE OF BIRTH   
<select name="day">
<option selected>day</option>
<option >1</option>
<option >2</option>
<option >3</option>
</select>
 

<select name="month">
<option selected>month</option>
<option >jan</option>
<option >feb</option>
<option >mar</option>
</select>
 
<select name="year">
<option selected>year</option>
<option >1980</option>
<option >1981</option>
<option >1982</option>
</select>
<br>
<br>
<pre>
LANGUAGES KNOWN
   ENGLISH   <input type="checkbox" name="eng" >
   TELUGU    <input type="checkbox" name="tel" >
   HINDI     <input type="checkbox" name="hin" >
</pre>
ADDRESS <br>
<textarea name="address" rows="3" cols="30">
enter your address here
</textarea>
<br><br>
<input type="button" name="sumbmit" value="submit" onClick="validate()">
<input type="reset" name="reset" value="clear">
</form>
</body>
</html>

Javascript program for payment validation page

noreply@blogger.com (Ganesh Raju) — Sat, 14 Mar 2015 04:50:00 +0000

Program:

<html>
<head>
<script language="javascript">
function validate()
{
    var amt=document.forms[0].elements[2].value;
    var card=document.forms[0].elements[3].value;

    var amt_re=new RegExp("^[0-9][0-9]+$","g");
    var card_re=new RegExp("^[0-9][0-9]+$","g");
   if(!amt.match(amt_re))

   {
          alert("amount should contan only digits");
          //document.forms[0].elements[2].select();
    }
   if(card.length!=16)
    {
    alert("credit card number must contain 16 digits ");
    //document.forms[0].elements[3].select();
    }
}

</script>
</head>
<body bgcolor="yellow">
<form name="myform">
<h1 align="center">Payment Page</h1>
<div align="center"><pre>
LOGIN ID     <input type="text" name="id"><br>

PASSWORD     <input type="password" name="pwd"><br>

AMOUNT      <input type="text" name="amount"><br>

CREDITCARDNUMBER<input type="PASSWORD" name="num+"><br></pre><br><br>
</div>
<br><br>
<div align="center">
<input type="submit" value="ok" onClick="validate()">    
<input type="reset" value="clear" >
</form>
<body>
</html>

Javascript program to validate the Login page

noreply@blogger.com (Ganesh Raju) — Mon, 09 Mar 2015 07:18:00 +0000

Program:

<html>

<head>

<title>Login Form</title>

function validate()

{

name=document.forms[0].elements[0].value;

pwd=document.forms[0].elements[1].value;

name_re=new RegExp("^[A-Za-Z][a-zA-Z]+$","g");

pwd_re-new RegExp("^[0-ga-zA-Z]+$","g");

if(name.match(name_re))

{

if(pwd.match(pwd_re))

{

alert("login successful");

//document.forms[0].elements[1].select();

var mywindow=window.open(" "," ","toolbar=yes,menubar=yes,status=yes");

var mywindow.document.write("<p>you entered username: and password is correct</p>"):

}

else

{

alert("invalid Password");

document.forms[0].elements[1].select();

}

else

{

alert("invalid Username");

document.forms[0].elements[0].select();

}

}
</script>
</head>
<body bgcolor="#abcdef">
<h3 align="center">Login</h3>
<form>
<p align="center">Name<input type="text" name="uname" value=" " size="15">
<p align="center">Password<input type="Password" name="pwd" value=" " size="15">
<p align="center">Name<input type="buttom" name="submit" value="login" onclick="validate()">
<input type="reset" name="reset" value="cancel">
</form>
</body>
</html>

create your own website Click here.....

HTML program for order confirmation page

noreply@blogger.com (Ganesh Raju) — Mon, 02 Mar 2015 13:26:00 +0000

program:

<html>

<head><title>Order confirmation</title></head>
<body background="redflower.jpg">
<h1 align="center">order confirmation page</h1>
<table name="confirm" padding="10%" cellpadding="30%">
<tr>
<th>order confirmation no</th>
<td>:</td>
<td>:</td>
</tr>
<tr>
<th>total number of books</th>
<td>:</td>
<td>4</td>
</tr>
<tr>
<th align="left"> Total Cost</th>
<td>:</td>
<td>2500.0</td>
</tr>
<tr>

<th align="left">Date</th>
<td>:</td>
<td>10/03/2014</td>
</tr>
<tr>
<th align="right">Note</th>
<td>:</td>
<td>Order will be delivered in 3 working days</td>
</tr>
<tr>
<th><input type="button" name="confirm" value="confirm"></td>
<td>:</td>
<td><input type="button" name="cancel" value="cancel"></td>
</tr>
</body>
</html>

How to execute SQL queries in windows 8.1

noreply@blogger.com (Ganesh Raju) — Sun, 22 Feb 2015 05:45:00 +0000

HTML code for user profile page

noreply@blogger.com (Ganesh Raju) — Sun, 15 Feb 2015 06:00:00 +0000

program:

<html>

<head>

<title>User profile</title>

</head>

<h3 align="center">User profile</h3>

NAME

PASSWORD

PHONE NUMBER

<pre>

GENDER

male<input type="radio" name="gender" value="male" checked>

female<input type="radio" name="gender" value="female">

</pre>

<br>

DATE OF BIRTH   

</select>

<option>month</option>

</select>

</select>

<br>

<pre>

LANGUAGES KNOWN

ENGLISH <input type="checkbox" name="eng" ckecked>

TELUGU <input type="checkbox" name="tel" ckecked>

HINDI <input type="checkbox" name="hin" ckecked>

</pre>

ADDRESS<br>

d.no.12/412,village,mandal,dist,pincode

</textarea>

<br>

</form>

</body>

</html>

create your own website click here....

more c and java programs click here...

Create a table using HTML

noreply@blogger.com (Ganesh Raju) — Sun, 08 Feb 2015 15:00:00 +0000

Program:

<html>

<head>

<title> To create a table model</title>

</head>

<body>

<caption> Comphrehensive table </caption>

</colgroup>

</colgroup>

<thead><tr><td>First</td>

<td>Second</td>

<td>Third</td>

<td>Fourth</td>

<td>Fifth</td></tr>

<tr><td>First</td>

<td>Second</td>

<td>Third</td>

<td>Fourth</td>

<td>Fifth</td><tr></tbody>

<tfoot><tr><td>The Table Footer</td>

</tr></tfoot></body>

</html>

for more computer programs click here...

Create your own website click here....

PL/SQL program to create employe table and insert employment number, name, salary. If it is above 30000 don't perform update operation

noreply@blogger.com (Ganesh Raju) — Wed, 14 Jan 2015 14:28:00 +0000

Create employee table

Sql>create table employee(empno varchar2(20),ename varchar2(20),sal number(8,2));

Insert data into employee table

Sql>insert into employee('1001','bcd',10000);

Sql>insert into employee('1002','abc','1000);

Sql>insert into employee('1003','xyz',5000);

Sql>insert into employee('1004','gani',5000);

Program

Declare
emp_no varchar2(20);
upd_sal number(5);
total_sal number(8,2);
begin
emp_no:='&emp_no';
upd_sal:='&upd_sal';
Insert into employee values('1005','ganesh', 2000);
savepoint no_update;
update employee set_sal=sal+upd_sal where empno=emp_no;
select sum(sal) into total_sal from employee;
if total_sal>30000 then
rollback to savepoint no_update;
dbms_output.put_line('no update, we are exceeding the total salary 30000) ;
else
dbms_output.put_line('salary updated successfully to the account:'|| emp_no) ;
end if;
end;
/

Create your own website

Click here

Pl/sql program to debit the amount and check the minimum bal 500 while debiting the account

noreply@blogger.com (Ganesh Raju) — Fri, 09 Jan 2015 18:20:00 +0000

Sql>Create table account(name varchar2(20),anumber varchar2(15),bal number(8,2));

Output: Table created

Sql>insert into account values('abc','101',5000);

Output: row inserted

Sql>insert into account values('abcd','102',500);

Output: row inserted

Sql>insert into account values('ganesh','103',3000);

Output: row inserted.

Sql>insert into account values('raju','104',1000);

Output: row inserted

Sql>insert into account values('gani','105',9000);

Output: row inserted.

Program:

declare
acct _bal number(8,2);
acct_no varchar2(15);
debit_amt number(5);
min_bal Number(5);=500;
begin
acct_no:=&acct_no;
debit_amt:=&debit_amt;
select bal into acct_bal from account
where anumber=acct_no;
acct_bal:=acct_bal-debit_amt;
if acct_bal>=min_bal then
update account set bal=bal-debit_
amt where anumber:=acct_no;
else
dbms_output.put_line('insufficient
bal in the output ');
end if;
end;
/

PL/SQL program to display the numbers in recursive order

noreply@blogger.com (Ganesh Raju) — Sun, 04 Jan 2015 16:39:00 +0000

Program:

Declare

a number(4);

rev number(4);

d number(4);

begin

a:=&a;

rev:=a;

while a>0

Loop

d:=mod(a,10);

rev=(rev*10)+d;

a:=trunc(a/10);

end loop;

dbms. output. put_line('rev ='¦¦rev) ;

end;

Pl/sql program to find factorial of given number

noreply@blogger.com (Ganesh Raju) — Wed, 31 Dec 2014 19:07:00 +0000

Program:

Declare
n number(4);
f number(4):=1;
begin n:=&n;
for i to 1...n
loop
f:=f*i;
end loop;
days output.put_line('the fact of a given no'='¦¦f) ;
end;
/

How to create a website
Click http://lapcode.blogspot.com

How to create a table using primary key?

noreply@blogger.com (Ganesh Raju) — Fri, 19 Dec 2014 06:15:00 +0000

Create table:

create table client_master(client_no varchar2(6),name varchar2(20) not null,address1 varchar2(30) not null,address2 varchar2(30) not null,city varchar2(15) not null,pincode number(8) not null, state varchar2(15) not null,bal_due number(10,2),primary key(client_no), CHECK(client_no like 'c%'));

Insert into table:

insert into client_master values(' c0001','ivan',bombay',4000054,'maharastr',15000);

insert into client_master values('c0002','varad','madras',780001,'tamilnadu',0);

insert into client_master values('c0003','pramod','bombay',400057,'maharastra',5000);

insert into client_master values('c00004','balli','bombay',400096,'maharastra',0);

Sql queries for create table and insert elements into table and display table

noreply@blogger.com (Ganesh Raju) — Sat, 06 Dec 2014 11:25:00 +0000

Create:

Queries

SQL query

Create table smobile1(emino varchar2(20),name varchar2(20) not null,os varchar2(10) not null,ram varchar2 (20) not null,I memory varchar2(20) not null,coast number(30),primary key (emino) , CHECK (emino like 'e%'));

Table created.

Insert:

Queries

insert into smobile1 values('emi435','gs5','android','1gb','4gb',40000);

insert into smobile1 values ('emi435','gs5','android','1gb','16gb',40000);

insert into smobile1 values
('emi436','gs4','android','4gb','16gb',40000);

insert into smobile1 values
('emi5431','gs4','android','2gb','16gb',30000);

insert into smobile1 values
('emi541','gs4','android','android','2gb','16gb',3000);
........,.......
..........

Display:

Query

Select *from smobile;

How to create a website
Click www.lapcode.blogspot.com
http://www.YouTube.com/OurLifeStyle