4. Querying a Database | SPRING COOKBOOK

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

SPRING COOKBOOK

By : Jerome Jaglale, Yilmaz

4 (3)

SPRING COOKBOOK

4 (3)

By: Jerome Jaglale, Yilmaz

Overview of this book

This book is for you if you have some experience with Java and web development (not necessarily in Java) and want to become proficient quickly with Spring.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. Creating a Spring Application

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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

12. 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

Retrieving an object

In this recipe, we create a DAO method to retrieve a database row, which we will use to create an object.

How to do it…

Use an SQL select query and create an object from the result using RowMapper:

In the DAO class, add an inline class implementing RowMapper. This class defines how to generate a User object from a database row:

private class UserMapper implements RowMapper<User> {
  public User mapRow(ResultSet row, int rowNum) throws SQLException {
    User user = new User();

    user.setId(row.getLong("id"));
    user.setFirstName(row.getString("first_name"));
    user.setAge(row.getInt("age"));
    
    return user;
  }
}

Add a DAO method which will perform an SQL select query and use a UserMapper object to generate a User object:

public User findById(Long id) {
  String sql = "select * from user where id=?";
  User user = jdbcTemplate.queryForObject(sql, new Object[]{id}, new UserMapper());
  return user;
}

How it works…

The queryForObject() method uses the UserMapper...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

SPRING COOKBOOK

Search

Your notes and bookmarks