PHP PROJECT CODE , C/CPP/JAVA LANGUAGE PROGRAM ,

Sunday, October 12, 2014

ADVANCE SOFTWARE ENGINEERING MSC IT & CA SEM-3 QUESTION BANK(as par syallbus of saurashtra university)

Software Engineering MSCIT Sem-3

Explain object-oriented concepts with example
Explain object-oriented s/w projects management in brief.
Explain object-oriented paradigm with figure.
Explain generic components of object-oriented analysis modal.
Explain object-relationship modal with appropriate example.
Write brief note on object-behavior modal.
Explain domain analysis with figure
Explain CRC modal index card or Explain OOA process and give brief description of CRC modal index card.
Explain OOA process.
Briefly define a)operation b)message c) method d) services e)class
Briefly explain how to identify classes and objects while developing oo model.
Briefly explain Booch and Rumbaugh method for OOA.
Explain the process of translating an OOA model in OOD model with diagram.
What do you mean by system design process? Explain activities involved in it.
Write short note on object-design process.
Write short note on Design Patterns,
Discuss design of object-oriented system with appropriate example.
Give the name of testing method which are applicable at class level and explain it in details.
Write brief note on testing object-oriented design and object-oriented analysis model.
What do you mean by testing context to object oriented? Explain testing strategies in context to object oriented system development.
Which is the impact of OOP on testing?
Explain fault based testing.
Explain interclass test case design.
Define the objectives of OOT correctness and consistency.
Explain the characteristics of OOM.
What are the metrics for OOD model.
Explain metrics of object-oriented projects.
Briefly explain CK metrics suite proposed by chidamber and kemerer.
Provide detail view of class oriented metrics
Describe following terms
Class size b. NOO c. NOA d. SI
Specify MOOD metrics suite.
Describe operation-oriented metrics.
Explain metrics for object-oriented testing.
What do you meant by cleanroom SE? describe common approach and its strategy with figure.
What is BSS in cleanroom SE? describe types of boxes used in functional specification of cleanroom approach.
Write brief note on cleanroom SE approach.
Explain clean-room testing.
Explain design refinement and verification.
Describe statistical use testing and what its core utility?
Write short note on component based software engineering process.
Describe component qualification and component adaption.
What do you mean by CBSE? Explain different set of s/w engineering activities involved in CBSE.
Briefly explain component composition activity involved in CBSE.
Explain Domain Engineering with its identification and reusable components.
Write short note on classifying and retrieving components.

Saturday, September 6, 2014

USE SINGLE QUERY FOR UPDATE STATUS OF ANY ENUM

Create table feedback (

fid int(3),name varchar2(30),

email varchar(20),subject varchar(30),

satatus enum('0','1'));

UPDATE feedback SET status =  
CASE
  WHEN  1 THEN 0
  WHEN 0 THEN 1
END
WHERE fid = 3;

SELECT CASE is_status 
      WHEN 1 THEN 'Replied' 
      WHEN 0 THEN 'Not Replied' 
      END AS 'fstatus' 
FROM feedback;

Tuesday, September 2, 2014

DISPLAY DIV USING NONE AND BLOCK IN JAVASCRIPT

<body>
<script language="JavaScript">
function setDisplay(id,attribute){
document.getElementById(id).style.display = attribute;
}
</script>

<div id="register" style="display: block;">
<input onclick="setDisplay('myform', 'block');setDisplay('register', 'none');" type="button" value="Register Now" />
</div>

<div id="myform" style="display: none;">
<table>
<tr>
<td>Userid:</td>
<td><input name="userid" TYPE="text" SIZE="20" MAXLENGTH="20"></td>
</tr>
<tr>
<td>Password:</td>
<td><input name="password" TYPE="password" SIZE="20" MAXLENGTH="20"></td>
</tr>
<tr>
<td>Name:</td>
<td><input name="name" TYPE="text" SIZE="30" MAXLENGTH="30"></td>
</tr>
<tr>
<td>Email:</td>
<td><input name="email" TYPE="text" SIZE="50" MAXLENGTH="50"></td></tr>
</table>
<input onclick="setDisplay('myform', 'none');setDisplay('register', 'block');" type="button" value="Go Back" />
</div>
</body>
</html>

SHOW AND HIDE DIV USING JAVASCRIPT

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>hide and display</title>
<script language="javascript">
function hideform(id,attribute)
{
document.getElementById(id).style.visibility= attribute;
}
</script>
</head>
<body>
<a href='#' onclick="hideform('loginfrm','visible')" >For login Click Here</a>
<div id='loginfrm' style="visibility:hidden;">
<form name='frm' action="login.php" method="post">
<table>
<TR><TD>Enter UserName:</TD><TD><input type="text" name="uname" /></TD></TR>
<TR><TD>Enter Password:</TD><TD><input type="text" name="upass" /></TD></TR>
<TR><TD><input type="submit" name="login" value="login"/></TD>
<TD><a href="#" onclick="hideform('loginfrm','hidden')">Close</a></TD></TR>
</table>
</form>
</div>
</body>
</html>

Wednesday, August 27, 2014

ASP.NET with C# Disconnected architecture

using System.Data;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Sagar\Documents\Visual Studio 2010\WebSites\kalp\App_Data\example.mdf;Integrated Security=True;User Instance=True";
    SqlConnection con;
    protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(str);
        dispdata();
    }
    protected void submit_Click(object sender, EventArgs e)
    {

        con.Open();
        SqlCommand cmd = new SqlCommand("insert into tblstu values('"+name.Text+"','"+city.Text+"')",con);
        cmd.ExecuteNonQuery();
        Response.Write("<script>alert('record inserted successfully');</script>");
        con.Close();
    }
    protected void dispdata()
    {
        DataTable dt = new DataTable();
        SqlCommand cmd = new SqlCommand("select * from tblstu",con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        GridView1.DataSource=dt;
        GridView1.DataBind();

    }
}

Wednesday, August 6, 2014

PAGING BY NUMBERS LENGTH

<?php
include("./connections/connect.php");
$sql="SELECT count(student.grno) from student";
$res=mysql_query($sql);

while($row=mysql_fetch_array($res,MYSQL_NUM))
{

$pages=$row[0]/5;
}
echo "No of pages....:",$pages;
echo "<table><TR>";
for($x=0;$x<=($pages*5);$x=$x+5)
{
echo "<TD><a href='paging.php?nor=".$x."'>",$x,"-",$x+5,"</a> | </td>";
}
echo "</table></TR>";

$sql = "SELECT STUDENT.GRNO,STUDENT.NAME,CITY.CNAME FROM STUDENT,CITY WHERE STUDENT.CITY=CITY.CID ORDER BY student.GRNO ASC LIMIT ".($_REQUEST["nor"]+1).", 5 ";
$res=mysql_query($sql);
echo "<table>";
while($row=mysql_fetch_row($res))
{
echo "<TR>";
foreach($row as $k=>$v)
{
echo "<TD>",$v,"</td>";
}
echo "</tr>";

}
echo "</table>";
?>

Tuesday, August 5, 2014

PAGING USING LETTERS

<html>
<head>
<title>Paging Using PHP</title>
</head>
<body>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass ='';

echo "<table><TR>";
for($x=65;$x<91;$x++)
{
echo "<td><a href='pagingbyletter.php?letter=",chr($x),"'>".chr($x)."</a></td>";
}
echo "</tr></table>";
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('dbpractice');
/* Get total number of records */
if(!isset($_REQUEST['letter']))
{
$_REQUEST['letter']='a';
}

$sql = "SELECT eid, ename,phone ".
"FROM tblemp where ename like '".$_REQUEST['letter']."%'";
echo $sql,"<BR>";
$retval = mysql_query( $sql, $conn );

while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
echo "EMP ID :{$row['eid']} <br> ".
"EMP NAME : {$row['ename']} <br> ".
"EMP SALARY : {$row['phone']} <br> ".
"--------------------------------<br>";
}
mysql_close($conn);
?>

PAGING IN PHP

<html>
<head>
<title>Paging Using PHP</title>
</head>
<body>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass ='';
$rec_limit = 5;

$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('dbpractice');
/* Get total number of records */
$sql = "SELECT count(eid) FROM tblemp ";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
$row = mysql_fetch_array($retval, MYSQL_NUM );
//record counter
$rec_count = $row[0];

if( isset($_GET{'page'} ) )
{
$page = $_GET{'page'} + 1;
$offset = $rec_limit * $page ;
}
else
{
$page = 0;
$offset = 0;
}
$left_rec = $rec_count - ($page * $rec_limit);

$sql = "SELECT eid, ename,phone ".
"FROM tblemp ".
"LIMIT $offset, $rec_limit";

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
echo "EMP ID :{$row['eid']} <br> ".
"EMP NAME : {$row['ename']} <br> ".
"EMP SALARY : {$row['phone']} <br> ".
"--------------------------------<br>";
}

if( $page > 0 )
{
$last = $page - 2;
echo "<a href=\"$_PHP_SELF?page=$last\">Last 10 Records</a> |";
echo "<a href=\"$_PHP_SELF?page=$page\">Next 10 Records</a>";
}
else if( $page == 0 )
{
echo "<a href=\"$_PHP_SELF?page=$page\">Next 10 Records</a>";
}
else if( $left_rec < $rec_limit )
{
$last = $page - 2;
echo "<a href=\"$_PHP_SELF?page=$last\">Last 10 Records</a>";
}
mysql_close($conn);
?>

Saturday, August 2, 2014

swaping programme

#include 
 
int main()
{
   int x, y, temp;
 
   printf("Enter the value of x and y\n");
   scanf("%d%d", &x, &y);
 
   printf("Before Swapping\nx = %d\ny = %d\n",x,y);
 
   temp = x;
   x    = y;
   y    = temp;
 
   printf("After Swapping\nx = %d\ny = %d\n",x,y);
 
   return 0;
}

#include 
 
int main()
{
   int a, b;
 
   printf("Enter two integers to swap\n");
   scanf("%d%d", &a, &b);
 
   a = a + b;
   b = a - b;
   a = a - b;
 
   printf("a = %d\nb = %d\n",a,b);
   return 0;
}

Android tutorial

introduction to android