Get all updates of Java4s
Follow Us: Email Newsletter

Spring JdbcTemplate Select Query Examples

Spring »on Feb 11, 2012 { 8 Comments } By Sivateja

Let us see how to use spring JdbcTemplate select query

Files Required

  • spconfig.xml

Directory Structure




See the xml file.. actually our beam is id3, which needs JdbcTemplate to use the methods so i have given <ref bean=”id2″/>, and JdbcTemplate(id2) class need DriverManagerDataSource help so i have given <ref bean=”id1“/>, hope you got it.

You Might Also Like

  ♦ About Author ♦

Full Stack( Java/J2EE & UI/UX ) Developer and founder of Java4s - Get It Yourself, A popular Java/J2EE Programming Blog. Sign-up for the Email Newsletter for your daily dose of Java tutorials.


8 Responses to “Spring JdbcTemplate Select Query Examples”
  1. Raja says:

    In instead of iterating the list trough Iterator its better to use for-each loop then code will be like

      public void loadAll()
          List l = jt.queryForList(“select * from countries”);
          for (Object o : l)

  2. Java4s says:


    Yeah we can use either Iterator or Foreach, actually its depends, will not possible in all the cases :-)

  3. 1.How can i connect with sql database please tell me….. can i create tabe in mysql with Spring framework…

    Give me one-one example like oracle database

  4. Divya says:

    1.How to get the values from Login form and
    2.How to check that the person is valid user or not by using JdbcTemplate……. plz explain it with a small Login web application

  5. Harshitha says:

    Hi I am getting the foolowing error: Error creating bean with name ‘id3′

  6. Giri says:

    Check configuration file what u given for bean id.

    might be wrong name u given

  7. Sangeetha says:

    Hi, Please make sure your have added respective driver jar. ex : for db2 , we need to add “db2jcc-9.jar”

  8. Shiva says:

    Exception in thread “main” java.lang.NoSuchMethodError: org.springframework.core.CollectionFactory.createLinkedCaseInsensitiveMapIfPossible(I)Ljava/util/Map;

    I am getting above error tell the process to resolve


By posting your answer, you agree to our comments policy.
What would you like to learn today?
Browse these popular technologies
Hibernate spring struts Servlets ajax Log4j jQuery Json Core Java Web Services AngularJs
Most Recent Tutorials
Hibernate_Logo Hibernate Recent Posts Spring_Logo Spring Recent Posts Struts_Logo Struts Recent Posts
Useful LinksCurrent & UpComing Tutorials
  Web Services [ SOAP ], JSP
Contact | About Us | Privacy Policy | Advertise With Us

© 2010 - 2017 Java4s - Get It Yourself.
The content is copyrighted to Sivateja Kandula and may not be reproduced on other websites.