Posts

Ternary operator and Nested Ternary operator

Ternary operator  Ternary operator which is a conditional operator and, as the name suggests, it takes three operands (parts). Ternary operator is available in most languages, like, C, C++, Java, JavaScript, etc  Syntax:-  variable = condition ? expression1_if_true : expression2_if_false Explanation: condition: This is a boolean expression that evaluates to either true or false. expression1_if_true: This is the value or statement that is executed if the condition is true. expression2_if_false: This is the value or statement that is executed if the condition is false.  Ternary operator is nothing, just a concise way of writing an if-else statement, i.e. the same operation can be achieved using an if-else block as shown below.  if(condition){     variable = value_if_true  }else{     variable = value_if_false  } Example 1 :- C program find max number among two given numbers using ternary operator #include <stdio.h> int mai...
Post a Comment
Read more

how to compile multiple file in java using single command

Some times we need to compile multiple files with a single command. Though most programmer use IDe but sometimes we have command lines only. If your case is like that then you can use any of the following methods- 1. Specify all the files manually javac File1.java File2.java File3.java 2. Compile all .java file in the directory javac *.java This will compile all the Java files in the current directory.
Post a Comment
Read more

Activity Diagram ,Component diagram,Collaboration Diagram and Use case diagram of Airport Check In and security Screening in uml

Image
Activity Diagram ,Component diagram,Collaboration Diagram  and Use case diagram of Airport Check In and security Screening in uml Collaboration Diagram Component Diagram Use Case diagram
Post a Comment
Read more

How to add comment on column of table or schema in oracle

Image
How to add comment on column  of a table or schema in oracle  Syntax:   COMMENT ON  COLUMN table_name . column_name IS 'comment description'; For example,  create table student(s_id number primary key,s_name varchar(20) not null ); After this if you want to comment of s_id column which acn be done as below:     comment on column student . s_id   is  'abbreviation of student id'; You can remove comment by setting it to null as shown below:     comment on column student . s_id   is ' '; Add comment in Oracle sql
Post a Comment
Read more

How to upload file or image in html form using php

How to upload file or image in html form using php The source code of uploading a file is given below. <?php error_reporting ( 0 ); ? > < html > < body > < form action = "" method = "post" enctype = "multipart/form-data" > < input type = "file" name = "uploadfile" value = "" > < input type = "submit" name = "submit" value = "Upload File" > </ form > </ body > </ html > <?php $folder = "student/" ; $filename = $_FILES [ "uploadfile" ][ "name" ]; $tempname = $_FILES [ "uploadfile" ][ "tmp_name" ]; $folder = "student/" . $filename ; // To save the image at folder student/image_name //echo $folder; move_uploaded_file ( $tempname , $folder ); //temp location to destination echo "<img src=' $folde...
Post a Comment
Read more

Login page in php ,mysql using using html form (source code)

Login page in php ,mysql using using html form The  source code of login page in html using php and mysql connection is given below. <?php session_start (); include ( "connection.php" ); ? > < form acion = "" method = "POST" > Username: < input type = "text" name = "username" value = "" />< br >< br > Password: < input type = "password" name = "password" value = "" />< br >< br > < input type = "submit" name = "submit" value = "login" /> </ form > <?php if ( isset ( $_POST [ 'submit' ])) { $user = $_POST [ 'username' ]; $pwd = $_POST [ 'password' ]; $query = " SELECT * FROM STUDENT WHERE username = ' $user ' && password = ' $pwd ' " ; $data = mysqli_query ( $conn , $query );...
Post a Comment
Read more

Database table of a tennis club in oracle(query)

 Database table of a tennis club The following is query of the database of a tennis club with different tables ,their relationships and constraints. It has following five tables:  PLAYERS TEAMS MATCHES PENALTIES COMMITTEE_MEMBERS CREATE TABLE PLAYERS (PLAYERNO NUMBER PRIMARY KEY,NAME VARCHAR(20) NOT NULL , INITIALS VARCHAR(30) NOT NULL CHECK(INITIALS NOT LIKE '% %' AND INITIALS NOT LIKE '%.%') , BIRTH_DATE DATE NOT NULL ,SEX CHAR(1) CHECK(SEX IN ('M','F')) ,JOINED DATE CHECK(JOINED>'31-DEC-1969'), STREET VARCHAR(20),HOUSENO VARCHAR(20) NOT NULL,POSTCODE NUMBER NOT NULL CHECK(LENGTH(POSTCODE)=6), TOWN VARCHAR(20) UNIQUE,PHONENO NUMBER NOT NULL CHECK(LENGTH(PHONENO)=10),LEAGUENO NUMBER UNIQUE NOT NULL); CREATE TABLE TEAMS (TEAMNO NUMBER PRIMARY KEY,PLAYERNO NUMBER ,FOREIGN KEY(PLAYERNO) REFERENCES PLAYERS(PLAYERNO),DIVISION VARCHAR(7) CHECK(DIVISION IN ('FIRST','SECOND'))); CREATE TABLE M...
Post a Comment
Read more