admin – Page 10

Angular 4 Deployment

by admin

September 12, 2017

10:09 am

30 Comments on Angular 4 Deployment

Angular JS

Use any of the commands:

ng build
ng build –prod
ng build –prod –base-href /directory-name/sub-directory-name/

Create testing branch on github

add normal git repository
git branch gh-pages
git push -u origin gh-pages

To push on the git repository

git init
git add origin
git add .
git commit -m “Initial Commit”
git push -u origin master
ng build –prod –base-href https://whateveruser.github.io/whateverprojectrepo/
ngh

ng build –prod –base-href https://github.com/whateveruser/whateverprojectrepo/

Ref:

https://www.youtube.com/watch?v=nxV3weqMzYo

.htaccess for production site

RewriteEngine on
# Don't rewrite files or directories
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]

# Rewrite everything else to index.html to allow html5 state links
RewriteRule ^ index.html [L]

OOPS

by admin

August 18, 2017

3:17 pm

15 Comments on OOPS

Java, Javascript, Php, Python

1. Rectangle Class

Design a class Rectangle
Data Members:

length
breadth

Member Functions:

setDimension()
area()
perimeter()

2. Worker Class

Design a class Worker
Data Members:

wages
working_days

Member Functions:

setData()
payment()

3. Box Class

Design a class Box
Data Members:

length
breadth
height

Member Functions:

setDimension()
volume()

4. Student Class

Design a class Student
Data Members:

roll_number
name

Member Functions:

setData()
getData()

5. Account Class

Design a class Account
Data Members:

balance

Member Functions:

deposit(amount)
withdraw(amount)
showBalance()

6. Set Class

Design a class Set that stores three numbers
Member Functions:

SUM()
MEAN()
MAX()
MIN()

7. Rectangle Class (Method Overloading – Java / C++)

Design a class Rectangle
Data Members:

length
breadth

Member Functions:

setDimension(int side)
setDimension(int length, int breadth)
area()
perimeter()

8. Box Class (Constructors – Java / C++)

Design a class Box
Data Members:

length
breadth
height

Constructors:

Box(int side)
Box(int length, int breadth)
Box(int length, int breadth, int height)

Member Function:

volume()

9. Account Class (Static Data Member)

Design a class Account
Data Members:

balance
interest_rate (static, default value = 10.25)

Member Function:

interest(no_of_years)

10. Student Class (Auto Roll Number)

Design a class Student
Data Members:

roll_number (auto-generated)
name

Member Functions:

getData()

Additional Requirement:

Keep track of the total number of students using a static variable.

11. Student Objects Using Array

Design a class Student
Data Members:

roll_number
name

Member Functions:

getData()
showData()

Task:

Create an array of 5 Student objects and display their details.

12. Student Class with College

Create an array of Student objects
Data Members:

roll_no
name
college

Member Functions:

readData()
showData()

13. Student & ClassRoom

Design:

Student class
ClassRoom class

Task:

Add a list of students to ClassRoom
Display the student list

14. Account & Bank

Design:

Account class
Bank class

Task:

Add a list of accounts to Bank
Display account details

15. Java Packages

Create two packages:

MyCircle
MyRectangle

Data Members:

radius (Circle)
length, breadth (Rectangle)

Member Functions:

area()
circumference()
perimeter()

16. RBI Class (Java Only)

Design a class RBI
Data Member:

balance

Member Functions:

RBI() (constructor)
deposit(int amount)
withdraw(int amount)
showBalance()

Freemarker Template

by admin

July 26, 2017

10:37 am

6 Comments on Freemarker Template

Java

Array to CSV in Java

by admin

July 11, 2017

8:49 am

4 Comments on Array to CSV in Java

Java

package com.demo;

import java.io.IOException;
import com.csvreader.CsvWriter;

public class ArrayToCSVDemo {

  public static void main(String[] args) {
    
    String array[] = {"Suryanagar, Vikhroli", "Java", "SQL", "13"};
    
    try {
      
      CsvWriter writer = new CsvWriter("awesomefile.csv");
      
      writer.writeRecord(array);
      
      writer.close();
      
    } catch (IOException e) {

      e.printStackTrace();
    }
    
  }

}

Reference Link: http://www.journaldev.com/12014/opencsv-csvreader-csvwriter-example

Jar File: http://www.java2s.com/Code/Jar/j/Downloadjavacsvjar.htm

Using FileWriter class

import java.io.FileWriter;

public class TestFileWriter {

  public static String implodeString(String[] split) {
    StringBuilder sb = new StringBuilder();
    for (int i = 0; i < split.length; i++) {			
        sb.append(split[i]);
        if (i != split.length - 1) {
            sb.append("\",\"");
        }
    }
    return "\"" . concat(sb.toString()) .concat("\"");
  }
  
  public static void main(String[] args) {
    
    String array[] = {"Suryanagar, Vikhroli", "Java", "SQL", "13"};
    
    try {
      
      FileWriter fw = new FileWriter("testout.csv");
      //fw.write("\"Suryanagar, Vikhroli\", Java, SQL, 13");
      fw.write(implodeString(array));
      fw.close();
    } catch (Exception e) {
      System.out.println(e);
    }

    System.out.println("Success...");

  }

}

Hello World django

by admin

July 7, 2017

1:07 pm

7 Comments on Hello World django

Python

Here are simple steps to create hello world web application in python using django framework

Step 1: Install virtual environment and create virtual environment for your project
```
pip install virtualenvwrapper-win
```
```
mkvirtualenv myproject
```
```
pip install virtualenv
```
```
virtualenv name_to_your_env
```
```
name_to_your_env\Scripts\activate
```

After activation 

$ django-admin.py startproject HelloWorld  $ cd HelloWorld 
$ ls HelloWorld manage.py

$ python manage.py runserver 
Validating models... 
0 errors found ... 
Django version 1.6.5, using settings 'HelloWorld.settings' 
Starting development server at http://127.0.0.1:8000/ 
Quit the server with CONTROL-C.

$ django-admin startapp HelloWorldApp
$ ls
HelloWorld HelloWorldApp manage.py
edit settings.py under HelloWorld project directory
# Application definition
INSTALLED_APPS = ( ‘django.contrib.admin’,
‘django.contrib.auth’,
‘django.contrib.contenttypes’,
‘django.contrib.sessions’,
‘django.contrib.messages’,
‘django.contrib.staticfiles’,
‘HelloWorldApp’, )

modify the urls.py which is under the project directory, HelloWorld

from django.conf.urls import patterns, include, url 
from HelloWorldApp.views import foo 

#from django.contrib import admin 
#admin.autodiscover() 

urlpatterns = patterns('', 
# Examples: 
# url(r'^$', 'HelloWorld.views.home', name='home'), 
# url(r'^blog/', include('blog.urls')), 
#url(r'^admin/', include(admin.site.urls)), 
url(r'HelloWorldApp/$', foo), 
)

modify views.py under app directory, HelloWorldApp

# Create your views here. 
from django.http import HttpResponse 
def foo(request): 
    return HttpResponse("Hello World!")

Run the server
```
python manage.py runserver
```
Hit this URL on browser
http://localhost:8000/HelloWorldApp/

Ref Links:

https://docs.djangoproject.com/en/1.11/howto/windows/
http://www.bogotobogo.com/python/Django/Python_Django_hello_world.php
https://stackoverflow.com/questions/18684231/python-setup-command-not-found
https://stackoverflow.com/questions/8074955/cannot-import-name-patterns
https://scotch.io/tutorials/build-your-first-python-and-django-application
http://jinja.pocoo.org/docs/2.10/templates/

Installation

by admin

July 3, 2017

1:18 pm

1 Comment on Installation

C Programming

git clone https://github.com/angular/quickstart.git quickstart

Apache POI (Poor Obfuscation Implementation File System)

by admin

June 22, 2017

11:38 am

64 Comments on Apache POI (Poor Obfuscation Implementation File System)

Java

Prerequisite
Download all poi jar files
https://poi.apache.org/download.html

Terms
- Workbook – The file contains number of sheets
- Sheet – Matrix contains rows and cell
- Row – Record of an entity in one row
- Cell – A single cell which hold value

JFileChooser fileChooser = new JFileChooser();
        int returnValue = fileChooser.showDialog(null, "Select File");
        
        if(returnValue == JFileChooser.APPROVE_OPTION) {
            Workbook workbook = new HSSFWorkbook(new FileInputStream(fileChooser.getSelectedFile()));
            
            Sheet sheet = workbook.getSheetAt(0);
            
            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();){
                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();){
                    System.out.println(cit.next());
                }
                System.out.println("");
            }
        } else {
            System.out.println("Invalid output");
        }

JFileChooser fileChooser = new JFileChooser();
        int returnValue = fileChooser.showDialog(null, "Select File");
        
        if(returnValue == JFileChooser.APPROVE_OPTION) {
            FileInputStream excelFile = new FileInputStream(fileChooser.getSelectedFile());
            Workbook workbook = new XSSFWorkbook(excelFile);
            
            Sheet sheet = workbook.getSheetAt(0);
            
            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();) {
                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();) {
                    System.out.print(cit.next() + "\t" + cit.next());
                }
                System.out.println("");
            }
        }

 Workbook workbook = new HSSFWorkbook();
        
        Sheet sheet1 = workbook.createSheet("movies");
//        Sheet sheet2 = workbook.createSheet("Test Cases");
//        Sheet sheet3 = workbook.createSheet(WorkbookUtil.createSafeSheetName("$*(^&?"));
        
        Row row = sheet1.createRow(0);
        
//        Cell cell = row.createCell(4);
//        cell.setCellValue("Hello World");
//        Cell cell2 = row.createCell(3);
//        cell2.setCellValue("terminator");
//        System.out.println(cell.getRichStringCellValue().toString());
//        System.out.println(cell2.getRichStringCellValue().toString());

        Cell cell1 = row.createCell(0);
        Cell cell2 = row.createCell(1);
        Cell cell3 = row.createCell(2);
        Cell cell4 = row.createCell(3);
        Cell cell5 = row.createCell(4);
        
        cell1.setCellValue(5);
        cell2.setCellValue("+");
        cell3.setCellValue(6);
        cell4.setCellValue("=");
        cell5.setCellFormula("A1+C1");
        
        try {
            FileOutputStream outputStream = new FileOutputStream("test1.xlsx");
            workbook.write(outputStream);
            outputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

Complete Program

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Iterator;
import javax.swing.JFileChooser;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.WorkbookUtil;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author Shailesh Sonare
 */
public class ApachePOIDemo {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] shailesh) throws IOException {
        
        /*
        
        Workbook workbook = new HSSFWorkbook();
        
        Sheet sheet1 = workbook.createSheet("movies");
//        Sheet sheet2 = workbook.createSheet("Test Cases");
//        Sheet sheet3 = workbook.createSheet(WorkbookUtil.createSafeSheetName("$*(^&?"));
        
        Row row = sheet1.createRow(0);
        
//        Cell cell = row.createCell(4);
//        cell.setCellValue("Hello World");
//        Cell cell2 = row.createCell(3);
//        cell2.setCellValue("terminator");
//        System.out.println(cell.getRichStringCellValue().toString());
//        System.out.println(cell2.getRichStringCellValue().toString());

        Cell cell1 = row.createCell(0);
        Cell cell2 = row.createCell(1);
        Cell cell3 = row.createCell(2);
        Cell cell4 = row.createCell(3);
        Cell cell5 = row.createCell(4);
        
        cell1.setCellValue(5);
        cell2.setCellValue("+");
        cell3.setCellValue(6);
        cell4.setCellValue("=");
        cell5.setCellFormula("A1+C1");
        
        try {
            FileOutputStream outputStream = new FileOutputStream("test1.xlsx");
            workbook.write(outputStream);
            outputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        */
        /*
        JFileChooser fileChooser = new JFileChooser();
        int returnValue = fileChooser.showDialog(null, "Select File");
        
        if(returnValue == JFileChooser.APPROVE_OPTION) {
            Workbook workbook = new HSSFWorkbook(new FileInputStream(fileChooser.getSelectedFile()));
            
            Sheet sheet = workbook.getSheetAt(0);
            
            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();){
                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();){
                    System.out.println(cit.next());
                }
                System.out.println("");
            }
        } else {
            System.out.println("Invalid output");
        }
        */
        
        JFileChooser fileChooser = new JFileChooser();
        int returnValue = fileChooser.showDialog(null, "Select File");
        
        if(returnValue == JFileChooser.APPROVE_OPTION) {
            FileInputStream excelFile = new FileInputStream(fileChooser.getSelectedFile());
            Workbook workbook = new XSSFWorkbook(excelFile);
            
            Sheet sheet = workbook.getSheetAt(0);
            
            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();) {
                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();) {
                    System.out.print(cit.next() + "\t" + cit.next());
                }
                System.out.println("");
            }
        }
        
    }    
}

polymorphism

by admin

June 9, 2017

11:54 am

1 Comment on polymorphism

Java

class A {
    public void test(){
        System.out.println("hello");
    }
    
    public void foo(){
        System.out.println("fooo");
    }
}

class B extends A {
    @Override
    public void test(){
        System.out.println("world");
    }
    public void bar(){
        System.out.println("baar");
    }
}


public class PolymorphismDemo {

    public static void main(String[] args) {
        
        A a = new A();
        a.test(); // allowed: will print hello
        a.foo(); // allowed: will print fooo
        //a.bar(); // not allowed: compile time error
        
        B b = new B();
        b.test(); // allowed: will print world
        b.foo(); // allowed: will print fooo
        b.bar(); // allowed: will print baar
        
        A c = new B();
        c.test(); // allowed: will print world
        c.foo(); // allowed: will print fooo
        //c.bar(); // not allowed: compile time error
        
        //B d = new A(); // not allowed: compile time error
        
        A e = new B();
        A f = (A)e;
        f.test(); // allowed: will print world
        f.foo(); // allowed: will print fooo
        //f.bar(); // not allowed: compile time error
        
        B g = new B();
        A h = (A)g;
        h.test(); // allowed: will print world
        h.foo(); // allowed: will print fooo
        //h.bar(); // not allowed: compile time error
    }    
}

programs on pointers

by admin

June 8, 2017

2:20 pm

1 Comment on programs on pointers

C Programming

WAP to exchange values of 2 variables by calling a function exchange
WAP to find length of a string by calling a function lenght
WAP to copy contents of one string into another by calling a function copy.
WAP to reverse contents of a string
WAP to find sum of 10 int values by calling a function sum (passing array as an argument)
WAP to find mean of 10 in values by calling a function MEAN (passing array as an argument)
WAP to dynamically read n values and find their sum
WAP to read information about n students and display them
WAP to find area and circumference of a circle by calling a single function circle
WAP to call functions area and circumference of circle by using function pointer
WAP to count total number of words in a string by calling a function wcount
WAP to read a String and coutn total vowels in that string
WAP to read a string and count total no of digits in that string
WAP to read a string and copy it into another array
WAP to rad a string and reverse that string

Hibernate Native SQL

by admin

June 2, 2017

12:56 pm

8 Comments on Hibernate Native SQL

C Programming

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package corehibernatedemo;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import model.Person;
import model.Student;
import model.Users;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;

/**
 *
 * @author Shailesh Sonare
 */
public class CoreHibernateDemo {
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws ParseException {
        // TODO code application logic here
        /*
        Configuration cfg = new Configuration();
        cfg.configure("hibernate.cfg.xml");
        
        StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties());
        
        SessionFactory factory = cfg.buildSessionFactory(ssrb.build());
        
        Session session = factory.openSession();
        
        Transaction t = session.beginTransaction();
        
        List users = session.createQuery("from Users").list();
        System.out.println("done...");
        
        for (Iterator iterator = users.iterator(); iterator.hasNext();) {
            Users e = (Users) iterator.next();
            System.out.println(e.getFirstName());
        }
        
        
        
        Date bdate = new SimpleDateFormat("yyyy-MM-dd").parse("1992-11-15");
        
        Users  usr = new Users("Sunita", "Sonare", bdate);
        
        String hql = "UPDATE Users SET dob = :dob WHERE id = :id";
        
        Query query = session.createQuery(hql);
        query.setParameter("dob", bdate);
        query.setParameter("id", 4);
        query.executeUpdate();
        
        //session.save(usr);
        t.commit();
        session.close();
        System.out.println("DOne....");
        */
        
        //Student s = new Student();
        
        Configuration cfg = new Configuration().configure("hibernate.cfg.xml");
        
        StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties());
        
        SessionFactory factory = cfg.buildSessionFactory(ssrb.build());
        
        Session session = factory.openSession();
        
//        String hql = "FROM Users";
//        List<Users> list = session.createQuery(hql).list();

        String sql = "SELECT first_name, last_name, dob FROM users";
        
        SQLQuery query = session.createSQLQuery(sql);
        query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP); // important when you are using alias <key><value> pair
//        List<Object[]> rows = query.list();
//        
//        for(Object[] row : rows){
//            
//            Users u = new Users(row[0].toString(), row[1].toString(), new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(row[2].toString()));
//            System.out.println(u);
//            System.out.println("--------------");
//        }

        List list = query.list();
        
        for(Object obj : list){
            Map map = (Map)obj;
            System.out.println("" + map.get("first_name"));
            System.out.println("" + map.get("last_name"));
            System.out.println("" + map.get("dob"));
            System.out.println("-------------------------");
        }
    }
    
}

Users.java

package model;
// Generated 30 May, 2017 5:20:27 PM by Hibernate Tools 4.3.1


import java.util.Date;

/**
 * Users generated by hbm2java
 */
public class Users  implements java.io.Serializable {


     private Integer id;
     private String firstName;
     private String lastName;
     private Date dob;

    public Users() {
    }

    public Users(String firstName, String lastName, Date dob) {
       this.firstName = firstName;
       this.lastName = lastName;
       this.dob = dob;
    }
   
    public Integer getId() {
        return this.id;
    }
    
    public void setId(Integer id) {
        this.id = id;
    }
    public String getFirstName() {
        return this.firstName;
    }
    
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return this.lastName;
    }
    
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public Date getDob() {
        return this.dob;
    }
    
    public void setDob(Date dob) {
        this.dob = dob;
    }

    @Override
    public String toString() {
        return "Users{" + "id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", dob=" + dob + '}';
    }

}