Monday, 11 March 2019

தளபதி விஜய் நடித்த Top 5 Action movies | Thalapathy Vijay Top 5 Action m...

தளபதி விஜய் நடித்த Top 10 Action movies | Thalapathy Vijay Top 10 Action...

தளபதி விஜய் நடித்த Top 15 Action movies | Thalapathy Vijay Top 15 Action...

தளபதி விஜய் நடித்த Average movies | Thalapathy Vijay Average movies | Tamil

தளபதி விஜய் நடித்த Top 5 Love Story movies | Thalapathy Vijay Top 5 Love...

தளபதி விஜய் நடித்த Top 10 Love Story movies | Thalapathy Vijay Top 10 Lo...

தளபதி விஜய் நடித்த Hit movies | Thalapathy Vijay Hit movies | Tamil

தளபதி விஜய் நடித்த Super Hit movies | Thalapathy Vijay Super Hit movies ...

தளபதி விஜய் நடித்த Blockbuster movies | Thalapathy Vijay Blockbuster mov...

Sunday, 10 March 2019

kids story in English: The Flea and the mouse story in English

kids story in English: The Fox and the goat story in English

Spring - How to get all records by calling the stored procedure using SimpleJdbcCall

Spring - Calling a stored function using SimpleJdbcCall | Spring JDBC tutorial | Spring JDBC

Spring - Calling a stored procedure with SimpleJdbcCall (Explicitly declaring parameters)

Spring - Calling a stored procedure with SimpleJdbcCall | Spring JDBC tutorial

Spring - Inserting data using SimpleJdbcInsert and MapSqlParameterSource | Spring JDBC tutorial

Spring - Inserting data using SimpleJdbcInsert and SqlParameterSource | Spring JDBC tutorial

kids story in English: Freedom and Good Food story in English

kids story in English: The kangaroo and the koala story in English

kids story in English: The Crows and the Serpent story | The crows and the snake story in English

kids story in English: The Lion and His Brothers story in English

kids story in English: The Lioness and the young Jackal story in English

kids story in English: The wolf and the seven little goats story in English

Saturday, 9 March 2019

தல அஜித் குமார் நடித்த Top 5 flop movies | Thala Ajith 5 flop movies

தல அஜித் குமார் நடித்த Top 10 flop movies | Thala Ajith 10 flop movies

தல அஜித் குமார் நடித்த Top 15 flop movies | Thala Ajith 15 flop movies

தல அஜித் குமார் நடித்த Cameo appearance movies | Thala Ajith Cameo appea...

தல அஜித் குமார் நடித்த Average movies | Thala Ajith Average movies

தல அஜித் குமார் நடித்த Hit movies | Thala Ajith Hit movies

தல அஜித் குமார் நடித்த Top 6 SuperHit movies | Thala Ajith Top 6 SuperHi...

தல அஜித் குமார் நடித்த Top 3 Blockbuster movies | Thala Ajith Top 3 Bloc...

தல அஜித் குமார் நடித்த Top 5 love story movies | Thala Ajith Kumar Top 5...

தல அஜித் குமார் நடித்த Top 10 Action movies | Thala Ajith Kumar Top 10 A...

Thala Ajith Kumar Top 10 love story movies | Thala Ajith Top 10 love sto...

தல அஜித் குமார் நடித்த Top 5 Action movies | Thala Ajith Kumar Top 5 Act...

தல அஜித் குமார் நடித்த Top 5 movies | Thala Ajith Kumar Top 5 movies | T...

தல அஜித் குமார் நடித்த Top 10 movies | Thala Ajith kumar Top 10 movies |...

தல அஜித் குமார் நடித்த Top 15 movies | Thala Ajith kumar Top 15 movies |...

தளபதி விஜய் நடித்த Top 5 movies | Thalapathy Vijay Top 5 movies | Tamil

தளபதி விஜய் நடித்த Top 10 movies | Thalapathy Vijay Top 10 movies | Tamil

தளபதி விஜய் நடித்த Top 15 movies | Thalapathy Vijay Top 15 movies | Tamil

தளபதி விஜய் நடித்த Top 20 movies | Thalapathy Vijay Top 20 movies | Tamil

விஜய் சேதுபதி நடித்த Top 5 Side actor movies | Vijay Sethupathi Top 5 S...

விஜய் சேதுபதி நடித்த Top 5 Comedy movies | Vijay Sethupathi Top 5 Comedy...

விஜய் சேதுபதி நடித்த Top 10 movies | Vijay Sethupathi Top 10 movies | Tamil

விஜய் சேதுபதி நடித்த Top 5 movies | Vijay Sethupathi Top 5 movies | Tamil

விஜய் சேதுபதி நடித்த Top 5 Action movies | Vijay Sethupathi Top 5 Action...

kids story in English: The Cunning Hyena story in English

Wednesday, 6 March 2019

Spring - Specifying columns for SimpleJdbcInsert | Spring JDBC tutorial | Spring JDBC

Spring - Inserting data using SimpleJdbcInsert | Spring JDBC tutorial | Spring JDBC

kids story in English: The cat, partridge and the hare story in English

kids story in English: The Lion and The Foolish Donkey story in English

How to format the string using java.util.Formatter class - Playlist

Tuesday, 5 March 2019

How to use format(Locale l, String format, Object... args) method of java.util.Formatter class


Click here to watch on Youtube:
https://www.youtube.com/watch?v=ec2-YfmtPSk&list=UUhwKlOVR041tngjerWxVccw

FormatterDemo.java

import java.util.Formatter;
import java.util.Locale;

/**
 * public Formatter format(Locale l, String format, Object... args)
 *
 * Parameters:
 *
 * l - The locale to apply during formatting.
 *
 * format - A format string as described in Format string syntax.
 *
 * args - Arguments referenced by the format specifiers in the format
 * string. If there are more arguments than format specifiers, the
 * extra arguments are ignored. The maximum number of arguments is
 * limited by the maximum dimension of a Java array as defined by The
 * Java™ Virtual Machine Specification.
 *
 * Returns: This formatter
 *
 */

public class FormatterDemo
{

    public static void main(String[] args)
    {
        Formatter formatter = new Formatter();

        /*
         * In this example, the format specifiers, %s and %d are
         * replaced with the arguments that follow the format string.
         * %s is replaced by "Peter", %d is replaced by 10. %s
         * specifies a string, and %d specifies an integer value. All
         * other characters are simply used as-is.
         */

        formatter.format(Locale.US, "%s age is %d", "Peter", 10);
        System.out.println(formatter.out());
        formatter.close();
    }

}

Output:

Peter age is 10

Click the below link to download the code:
https://sites.google.com/site/javaspringram2019/java_spring_2019/FormatterDemo_format_locale.zip?attredirects=0&d=1

Github Link:
https://github.com/ramram43210/Java_Spring_2019/tree/master/Java_2019/FormatterDemo_format_locale

Bitbucket Link:
https://bitbucket.org/ramram43210/java_spring_2019/src/ef6f73b2185c28cb9cd0149bcd1e9fa0a5b2bdf3/Java_2019/FormatterDemo_format_locale/?at=master

See also:

  • All JavaEE Videos Playlist
  • All JavaEE Videos
  • All JAVA EE Links
  • Spring Tutorial
  • Servlets Tutorial
  • All Design Patterns Links
  • JDBC Tutorial
  • Java Collection Framework Tutorial
  • JAVA Tutorial
  • Kids Tutorial
  • Cooking Tutorial
  • How to format the string using java.util.Formatter class


    Click here to watch on Youtube:
    https://www.youtube.com/watch?v=qt89kDYMBGo&list=UUhwKlOVR041tngjerWxVccw

    Click the below Image to Enlarge:

    How to format the string using java.util.Formatter class

    FormatterDemo.java

    import java.util.Formatter;

    /**
     * public Formatter format(String format, Object... args)
     *
     * Parameters:
     *
     * format - A format string as described in Format string syntax.
     *
     * args - Arguments referenced by the format specifiers in the format
     * string. If there are more arguments than format specifiers, the
     * extra arguments are ignored. The maximum number of arguments is
     * limited by the maximum dimension of a Java array as defined by The
     * Java™ Virtual Machine Specification.
     *
     * Returns: This formatter
     *
     */

    public class FormatterDemo
    {

        public static void main(String[] args)
        {
            Formatter formatter = new Formatter();

            /*
             * In this example, the format specifiers, %s and %d are
             * replaced with the arguments that follow the format string.
             * %s is replaced by "Peter", %d is replaced by 10. %s
             * specifies a string, and %d specifies an integer value. All
             * other characters are simply used as-is.
             */

            formatter.format("%s age is %d", "Peter", 10);
            System.out.println(formatter.out());
            formatter.close();
        }

    }

    Output:

    Peter age is 10

    Refer: 
    https://docs.oracle.com/javase/8/docs/api/index.html?java/util/Formatter.html

    Click the below link to download the code:
    https://sites.google.com/site/javaspringram2019/java_spring_2019/FormatterDemo_Intro.zip?attredirects=0&d=1

    Github Link:
    https://github.com/ramram43210/Java_Spring_2019/tree/master/Java_2019/FormatterDemo_Intro

    Bitbucket Link:
    https://bitbucket.org/ramram43210/java_spring_2019/src/ef6f73b2185c28cb9cd0149bcd1e9fa0a5b2bdf3/Java_2019/FormatterDemo_Intro/?at=master

    See also:

  • All JavaEE Videos Playlist
  • All JavaEE Videos
  • All JAVA EE Links
  • Spring Tutorial
  • Servlets Tutorial
  • All Design Patterns Links
  • JDBC Tutorial
  • Java Collection Framework Tutorial
  • JAVA Tutorial
  • Kids Tutorial
  • Cooking Tutorial
  • Spring + JdbcTemplate + How to retrieve auto-generated keys


    Click here to watch on Youtube:
    https://www.youtube.com/watch?v=rbi3TkO0q5U&list=UUhwKlOVR041tngjerWxVccw

    Click the below Image to Enlarge:

    Spring + JdbcTemplate + How to retrieve auto-generated keys

    Employee.sql

    CREATE DATABASE org_db;


    CREATE TABLE `employee` (
      `EMPLOYEE_ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
      `NAME` VARCHAR(100) NOT NULL,
      `AGE` INT(10) NOT NULL,
      `SALARY` INT(10) DEFAULT NULL,
      PRIMARY KEY (`EMPLOYEE_ID`)
    ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

    pom.xml

    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <groupId>com.ram.core</groupId>
        <artifactId>SpringDemo</artifactId>
        <packaging>jar</packaging>
        <version>1.0-SNAPSHOT</version>
        <name>SpringDemo</name>
        <url>http://maven.apache.org</url>

        <properties>
            <spring.version>5.0.5.RELEASE</spring.version>
        </properties>

        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>3.8.1</version>
                <scope>test</scope>
            </dependency>

            <!-- Spring 5 dependencies -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <!-- MySQL database driver -->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.11</version>
            </dependency>

        </dependencies>

    </project>

    EmployeeDAO.java

    package com.ram.employee.dao;

    public interface EmployeeDAO
    {
        public void retriveAutoGeneratedKey();
    }

    EmployeeDAOImpl.java

    package com.ram.employee.dao.impl;

    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;

    import org.springframework.jdbc.core.PreparedStatementCreator;
    import org.springframework.jdbc.core.support.JdbcDaoSupport;
    import org.springframework.jdbc.support.GeneratedKeyHolder;
    import org.springframework.jdbc.support.KeyHolder;

    import com.ram.employee.dao.EmployeeDAO;

    public class EmployeeDAOImpl
            extends JdbcDaoSupport implements EmployeeDAO
    {

        public void retriveAutoGeneratedKey()
        {
            final String INSERT_SQL = "INSERT INTO EMPLOYEE "
                    + "(NAME, AGE,SALARY) VALUES (?, ?, ?)";

            KeyHolder keyHolder = new GeneratedKeyHolder();
            getJdbcTemplate().update(new PreparedStatementCreator()
            {
                public PreparedStatement createPreparedStatement(
                        Connection connection) throws SQLException
                {
                    PreparedStatement ps = connection.prepareStatement(
                            INSERT_SQL, new String[] { "id" });
                    ps.setString(1, "Rob");
                    ps.setInt(2, 12);
                    ps.setInt(3, 9090);
                    return ps;
                }
            }, keyHolder);

            System.out.println(
                    "Auto generated Key is = " + keyHolder.getKey());
        }

    }

    applicationContext.xml

    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">


        <bean id="dataSource"
            class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver" />
            <property name="url" value="jdbc:mysql://localhost:3306/org_db" />
            <property name="username" value="root" />
            <property name="password" value="root" />
        </bean>

        <bean id="employeeDAO" class="com.ram.employee.dao.impl.EmployeeDAOImpl">
            <property name="dataSource" ref="dataSource" />
        </bean>
     
    </beans>

    App.java

    package com.ram.core;

    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;

    import com.ram.employee.dao.EmployeeDAO;

    public class App
    {
        public static void main(String[] args)
        {
            ApplicationContext context = new ClassPathXmlApplicationContext(
                    "applicationContext.xml");

            EmployeeDAO employeeDAO = (EmployeeDAO) context
                    .getBean("employeeDAO");
            employeeDAO.retriveAutoGeneratedKey();
        }
    }

    Output:

    Feb 20, 2019 10:36:51 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
    INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@736e9adb: startup date [Wed Feb 20 10:36:51 IST 2019]; root of context hierarchy
    Feb 20, 2019 10:36:52 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
    INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
    Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
    Feb 20, 2019 10:36:52 AM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
    INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
    Wed Feb 20 10:36:53 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    Auto generated Key is = 10

    Click the below link to download the code:
    https://sites.google.com/site/javaspringram2019/java_spring_2019/SpringDemo_Retrive_auto_key.zip?attredirects=0&d=1

    Github Link:
    https://github.com/ramram43210/Java_Spring_2019/tree/master/Spring_2019/SpringDemo_Retrive_auto_key

    Bitbucket Link:
    https://bitbucket.org/ramram43210/java_spring_2019/src/8f8b5563b7f2921ed260908e4906103995d9c6cc/Spring_2019/SpringDemo_Retrive_auto_key/?at=master

    See also:

  • All JavaEE Videos Playlist
  • All JavaEE Videos
  • All JAVA EE Links
  • Spring Tutorial
  • Servlets Tutorial
  • All Design Patterns Links
  • JDBC Tutorial
  • Java Collection Framework Tutorial
  • JAVA Tutorial
  • Kids Tutorial
  • Cooking Tutorial
  • Spring + JdbcTemplate + How to create a table


    Click here to watch on Youtube:
    https://www.youtube.com/watch?v=S2EyOdg7dZM&list=UUhwKlOVR041tngjerWxVccw

    Click the below Image to Enlarge:

    Spring + JdbcTemplate + How to create a table

    Employee.sql

    CREATE DATABASE org_db;


    pom.xml

    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <groupId>com.ram.core</groupId>
        <artifactId>SpringDemo</artifactId>
        <packaging>jar</packaging>
        <version>1.0-SNAPSHOT</version>
        <name>SpringDemo</name>
        <url>http://maven.apache.org</url>

        <properties>
            <spring.version>5.0.5.RELEASE</spring.version>
        </properties>

        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>3.8.1</version>
                <scope>test</scope>
            </dependency>

            <!-- Spring 5 dependencies -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring.version}</version>
            </dependency>

            <!-- MySQL database driver -->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.11</version>
            </dependency>

        </dependencies>

    </project>

    EmployeeDAO.java

    package com.ram.employee.dao;

    public interface EmployeeDAO
    {
        public void createTable();
    }

    EmployeeDAOImpl.java

    package com.ram.employee.dao.impl;

    import org.springframework.jdbc.core.support.JdbcDaoSupport;

    import com.ram.employee.dao.EmployeeDAO;

    public class EmployeeDAOImpl
            extends JdbcDaoSupport implements EmployeeDAO
    {

        public void createTable()
        {
            String sql = "create table Address (id integer, city varchar(100))";
            getJdbcTemplate().execute(sql);
        }

    }

    applicationContext.xml

    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">


        <bean id="dataSource"
            class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver" />
            <property name="url" value="jdbc:mysql://localhost:3306/org_db" />
            <property name="username" value="root" />
            <property name="password" value="root" />
        </bean>

        <bean id="employeeDAO" class="com.ram.employee.dao.impl.EmployeeDAOImpl">
            <property name="dataSource" ref="dataSource" />
        </bean>
     
    </beans>

    App.java

    package com.ram.core;

    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;

    import com.ram.employee.dao.EmployeeDAO;

    public class App
    {
        public static void main(String[] args)
        {
            ApplicationContext context = new ClassPathXmlApplicationContext(
                    "applicationContext.xml");

            EmployeeDAO employeeDAO = (EmployeeDAO) context
                    .getBean("employeeDAO");
            employeeDAO.createTable();
            System.out.println("Table is created successfully.");
        }
    }

    Output:

    Feb 20, 2019 9:52:03 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
    INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@35d176f7: startup date [Wed Feb 20 09:52:03 IST 2019]; root of context hierarchy
    Feb 20, 2019 9:52:04 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
    INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
    Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
    Feb 20, 2019 9:52:05 AM org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
    INFO: Loaded JDBC driver: com.mysql.jdbc.Driver
    Wed Feb 20 09:52:16 IST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    Table is created successfully.

    Click the below link to download the code:
    https://sites.google.com/site/javaspringram2019/java_spring_2019/SpringDemo_create_table.zip?attredirects=0&d=1

    Github Link:
    https://github.com/ramram43210/Java_Spring_2019/tree/master/Spring_2019/SpringDemo_create_table

    Bitbucket Link:
    https://bitbucket.org/ramram43210/java_spring_2019/src/8f8b5563b7f2921ed260908e4906103995d9c6cc/Spring_2019/SpringDemo_create_table/?at=master

    See also:

  • All JavaEE Videos Playlist
  • All JavaEE Videos
  • All JAVA EE Links
  • Spring Tutorial
  • Servlets Tutorial
  • All Design Patterns Links
  • JDBC Tutorial
  • Java Collection Framework Tutorial
  • JAVA Tutorial
  • Kids Tutorial
  • Cooking Tutorial