Book Image

SPRING COOKBOOK

Book Image

SPRING COOKBOOK

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
SPRING COOKBOOK
May, 2015 | 234 pages
No titles found
Table of Contents (19 chapters)
Spring Cookbook
Spring Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Creating a Spring Application
Creating a Spring Application
Introduction
Installing Java, Maven, Tomcat, and Eclipse on Mac OS
Installing Java, Maven, Tomcat, and Eclipse on Ubuntu
Installing Java, Maven, Tomcat, and Eclipse on Windows
Creating a Spring web application
Running a Spring web application
Using Spring in a standard Java application
2
Defining Beans and Using Dependency Injection
Defining Beans and Using Dependency Injection
Introduction
Defining a bean explicitly with @Bean
Defining a bean implicitly with @Component
Using a bean via dependency injection with @Autowired
Using a bean directly
Listing all beans
Using multiple configuration classes
3
Using Controllers and Views
Using Controllers and Views
Introduction
Associating a route to a controller method
Using a JSP view
Passing attributes from a controller to a JSP view
Using dynamic route parameters in a controller method
Using a common prefix for the routes of a controller
Using a page template with Tiles
Executing some code before and after controllers using interceptors
Building multilingual pages
4
Querying a Database
Querying a Database
Introduction
Connecting to a database
Creating a DAO class
Calling a DAO method from a controller class
Saving an object
Retrieving an object
Retrieving a list of objects
Retrieving a list of objects with their dependencies
Updating an object
Deleting an object
Finding the number of results for an SQL query
Saving a list of objects at once
Reverting incomplete database modifications using transactions
Using Hibernate for powerful object persistence and querying
5
Using Forms
Using Forms
Introduction
Displaying and processing a form
Getting a submitted form value using a controller method argument
Setting a form's default values using a model object
Saving form data in an object automatically
Using text, textarea, password, and hidden fields
Using a select field
Using a checkbox
Using a list of checkboxes
Using a list of radio buttons
Validating a form using annotations
Uploading a file
6
Managing Security
Managing Security
Introduction
Enabling Spring Security
Authenticating users using the default login page
Authenticating users using a custom login page
Authenticating users using a database
Adding a logout link
Using public folders
Authorizing only users with a specific role to view some pages
Displaying page elements only to authenticated users in views
Using HTTPS with Tomcat
7
Unit Testing
Unit Testing
Introduction
Unit testing with JUnit 4
Unit testing with TestNG 6
Simulating dependencies with mocks using Mockito
Unit testing with JUnit 4 using Spring's application context
Unit testing with TestNG 6 using Spring's application context
Unit testing with transactions
Unit testing controller methods
8
Running Batch Jobs
Running Batch Jobs
Introduction
Installing and configuring Spring Batch
Creating a job
Executing a job from the command line
Executing a job from a controller method
Using job parameters
Executing a system command
Scheduling a job
Creating a read/process/write step
Reading an XML file
Generating a CSV file
Reading from a database
Unit testing batch jobs
9
Handling Mobiles and Tablets
Handling Mobiles and Tablets
Introduction
Installing Spring Mobile
Detecting mobiles and tablets
Switching to the normal view on mobiles
Using different JSP views for mobiles automatically
Using a .mobi domain name on mobiles
Using an m. subdomain on mobiles
Using a different domain name on mobiles
Using a subfolder path on mobiles
10
Connecting to Facebook and Twitter
Connecting to Facebook and Twitter
Introduction
Creating a Facebook app
Creating a test Facebook app and test users
Connecting to Facebook
Retrieving a Facebook user's profile
Retrieving the list of friends of a Facebook user
Posting a Facebook status update
Posting a link to Facebook
Posting a custom object to Facebook
Creating a Twitter application
Connecting to Twitter
Retrieving a user's Twitter profile
Retrieving the tweets of a Twitter user
Posting a tweet to Twitter
Sending a private message to another Twitter user
11
Using the Java RMI, HTTP Invoker, Hessian, and REST
Using the Java RMI, HTTP Invoker, Hessian, and REST
Introduction
Creating a Java RMI service
Querying an existing Java RMI service
Creating an HTTP Invoker service
Querying an existing HTTP Invoker service
Creating a Hessian service
Querying an existing Hessian service
Creating a REST service
Querying an existing REST service
12
Using Aspect-oriented Programming
Using Aspect-oriented Programming
Introduction
Creating a Spring AOP aspect class
Measuring the execution time of methods using an around advice
Logging method arguments using a before advice
Logging methods' return values using an after-returning advice
Logging exceptions using an after-throwing advice
Using an after advice to clean up resources
Making a class implement an interface at runtime using an introduction
Setting the execution order of the aspects
Index
Index

Finding the number of results for an SQL query

In this recipe, we will add a DAO method to quickly get the number of results for an SQL query without actually loading the rows in the memory.

How to do it…

Use an SQL count(*) function and get the value directly using the queryForObject() method with a second argument specifying Long as the returned type:

public long countMinorUsers() {
  String sql = "select count(*) from age < 18";
  return jdbcTemplate.queryForObject(sql, Long.class);
}
Previous Section
End of Section 12
Next Section