Spring jdbcTemplate.queryForInt example


      Click here to attend Spring Framework 4.x and certification course with a discount

public int getALertCountForUser(final String email) {
 
 int count = this.jdbcTemplate.queryForInt("select count(a.idalert) " +
 " FROM kameroom.alert a, kameroom.user u " +
 " WHERE u.iduser = a.iduser AND u.email = ?", new Object[]{email}); 
 return count;

 }
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s