wiki - workassis

SQL getting items not in a list

SQL getting items not in a list

In the bellow example, getting list of person id not exist in the given list

For strings (varchars)

 

tested in PostgreSQL

  Like
By bm on September 1, 2017 | postgresql, SQL | A comment?

WordPress enable SESSION

Enable session

Add the following code in function.php to enable session in wordpress

 

  Like
By bm on August 30, 2017 | php, wordpress | A comment?

Create a basic java spring boot application

This is a basic example for beginners for creating a basic java spring boot application using ‘spring-boot-starter-parent’.

In this tutorial I am using Spring tool suite as my IDE.

Step I. Create a Maven project

I.1:  File->New -> Maven Project (You can do it by write clicking in the blank space of Package Explorer )

I.2: I have selected ‘create a simple project ( skip archetye selection)’ this allow me to kip the Archetype selection

I.3 : Setting group id and artifact id and other project related details

Done with the maven project creation, you can see the IDE automatically create the project folder structure like bellow .

You can see the project details in pom.xml file

 

Add the spring boot dependency

Update the project

write click on project folder->Maven->Update Project

After update we can see JRe updated to 1.8 and added Maven Dependencies

 

Now we can create our application entry point

Crate a class like bellow (sselect the tic ‘public static void main’ to auto generate the function)

Right click in Package Explorer -> New ->Class

Then add @SpringBootApplication annotation to the class and add SpringApplication.run(MyApp.class, args); inside the main function

Now we can create our controller 

Right click in Package Explorer -> New ->Class

 

Add the following code in the file

You are done

Now we can run our application You can press the Green *Play button    Or  you can right click the project folder and select the Run As – >Java Application

Tadaaaaa! Our project is running

Now we can hit the url

We and run Spring boot application from command line also by using the command  mvn spring-boot:run

 

Done


Note

If you are getting the error “Exception in thread “main” java.lang.NoClassDefFoundError: ch/qos/logback/classic/turbo/TurboFilter ” please add the logback-classic dependency in pom file

 

1 Like
By bm on July 19, 2017 | Java, Spring boot | A comment?
Tags: , ,

Spring boot: skip unit test

 

1 Like
By bm on June 13, 2017 | Spring boot | A comment?

Spring boot : Run Spring boot application from command line

Run Spring boot application from command line

ref: –spring-boot-docs

 

  Like
By bm on June 12, 2017 | Spring boot | A comment?

spring boot : Accept date in URL param

Option 1

 

Option 2

 

2 Likes
By bm on | Spring boot | A comment?

Ajax
Android
Android XML
ArrayList
Browser
Css
Drupal 8
Eclipse