title: Use JDBCTemplate in spring framework
body: <p>I want to add actualEffort group by projet_id for that I tried below code but in code getJdbcTemplate,queryForObject showing underlined even I have imported package called</p>
  
  <pre><code>import javax.sql.DataSource
  
  import org.springframework.jdbc.core.JdbcTemplate;
  </code></pre>
  
  <p>coding</p>
  
  <pre><code>public int findTotal(){
      String sql = "select sum(actual_effort) from task group by project_id";
      int total = getJdbcTemplate().queryForInt(sql);
      return total;
  }
  </code></pre>