application.property <\/strong>\n<\/p>\n\r\nstudent.db.driver = org.postgresql.Driver\r\nstudent.db.url = jdbc:postgresql:\/\/127.0.0.1:5432\/b6\r\nstudent.db.username = postgres\r\nstudent.db.password = abcd12345\r\n<\/pre>\n\n\tRepository Class<\/strong>\n<\/p>\n\r\n@Repository\r\npublic class StudentRepository {\r\n \r\n public static final String INSERT_STUDENT_QUERY ="INSERT INTO STUDENT(name) VALUES (?)";\r\n public static final String FIND_STUDENT_QUERY ="SELECT * FROM STUDENT";\r\n \r\n @Autowired\r\n public JdbcTemplate jdbcTemplate;\r\n \r\n public void save(String name){\r\n jdbcTemplate.update(INSERT_STUDENT_QUERY,name);\r\n \r\n }\r\n \r\n public List<String> findAll(){\r\n \r\n List<Map<String, Object>> rows= jdbcTemplate.queryForList(FIND_STUDENT_QUERY);\r\n ArrayList<String> list = new ArrayList<String>();\r\n for(Map row:rows){\r\n list.add((String)row.get("name"));\r\n }\r\n \r\n return list;\r\n \r\n }\r\n\r\n}\r\n<\/pre>\n\n\t \n<\/p>\n
\n\tAppConfig.java<\/strong>\n<\/p>\n\r\nimport javax.sql.DataSource;\r\n\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.context.MessageSource;\r\nimport org.springframework.context.annotation.Bean;\r\nimport org.springframework.context.annotation.ComponentScan;\r\nimport org.springframework.context.annotation.Configuration;\r\nimport org.springframework.context.annotation.PropertySource;\r\nimport org.springframework.context.support.ReloadableResourceBundleMessageSource;\r\nimport org.springframework.context.support.ResourceBundleMessageSource;\r\nimport org.springframework.core.env.Environment;\r\nimport org.springframework.jdbc.core.JdbcTemplate;\r\nimport org.springframework.jdbc.datasource.DriverManagerDataSource;\r\nimport org.springframework.web.servlet.config.annotation.EnableWebMvc;\r\nimport org.springframework.web.servlet.view.JstlView;\r\nimport org.springframework.web.servlet.view.UrlBasedViewResolver;\r\n\r\n@Configuration\r\n@ComponentScan("com.teach.koka.javaconfig")\r\n@EnableWebMvc\r\n@PropertySource("classpath:application.properties")\r\npublic class AppConfig {\r\n\r\n\t@Autowired\r\n\tEnvironment env;\r\n\t\r\n\t@Bean\r\n\tpublic UrlBasedViewResolver urlBasedViewResolver(){\r\n\t\tUrlBasedViewResolver viewResolver = new UrlBasedViewResolver();\r\n\t\tviewResolver.setPrefix("\/WEB-INF\/pages\/");\r\n\t\tviewResolver.setSuffix(".jsp");\r\n\t\tviewResolver.setViewClass(JstlView.class);\r\n\t\t\r\n\t\treturn viewResolver;\r\n\t\t\r\n\t}\r\n\t\r\n\t @Bean\r\n\t public MessageSource messageSource() {\r\n\t\t ReloadableResourceBundleMessageSource messageSource = new ReloadableResourceBundleMessageSource();\r\n\t messageSource.setBasenames("application");\r\n\t messageSource.setDefaultEncoding("UTF-8");\r\n\t return messageSource;\r\n\t }\r\n\t \r\n\t \/**\r\n\t\t * An alternative to the DriverManager facility, a DataSource object is\r\n\t\t * the preferred means of getting a connection.\r\n\t\t *\/\r\n\t\t@Bean\r\n\t\tpublic DataSource dataSource(){\r\n\t\t\tDriverManagerDataSource dataSource = new DriverManagerDataSource();\r\n\t\t\tdataSource.setDriverClassName(env.getRequiredProperty("student.db.driver"));\r\n\t\t\tdataSource.setUrl(env.getRequiredProperty("student.db.url"));\r\n\t\t\tdataSource.setUsername(env.getRequiredProperty("student.db.username"));\r\n\t\t\tdataSource.setPassword(env.getRequiredProperty("student.db.password"));\r\n\t\t\t\r\n\t\t\treturn dataSource;\r\n\t\t}<\/strong>\r\n\t\t\r\n\t\t@Bean\r\n\t\tpublic JdbcTemplate jdbcTemplate(){\r\n\t\t\t JdbcTemplate jdbcTemplate = new JdbcTemplate();\r\n\t\t\t jdbcTemplate.setDataSource(dataSource());\r\n\t\t\r\n\t\t\t return jdbcTemplate;\r\n\t\t}<\/strong>\r\n\t\r\n}\r\n<\/pre>\n\n\tController class<\/strong>\n<\/p>\n\r\npackage com.teach.koka.javaconfig.jdbctemplate.controller;\r\n\r\nimport java.util.*;\r\n\r\nimport javax.validation.Valid;\r\n\r\n\r\n\r\n\r\n\r\n\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.stereotype.Controller;\r\nimport org.springframework.ui.Model;\r\nimport org.springframework.validation.BindingResult;\r\nimport org.springframework.web.bind.annotation.ModelAttribute;\r\nimport org.springframework.web.bind.annotation.RequestMapping;\r\nimport org.springframework.web.bind.annotation.RequestMethod;\r\n\r\nimport com.teach.koka.javaconfig.jdbctemplate.model.Student;\r\nimport com.teach.koka.javaconfig.jdbctemplate.repository.StudentRepository;\r\n\r\n\r\n@Controller\r\n@RequestMapping(value="\/student")\r\npublic class StudentController {\r\n\r\n\t@Autowired\r\n\tStudentRepository repository;\r\n\t\r\n\t@RequestMapping(method=RequestMethod.GET)\r\n\tpublic String studentData(Model model){\r\n\t\tStudent student = new Student();\r\n\t\tmodel.addAttribute("student",student);\r\n\t\tmodel.addAttribute("message","Welcome...");\r\n\t\treturn "student-login";\t\t\r\n\t}\r\n\t\r\n\t @RequestMapping(method=RequestMethod.POST)\r\n public String postStudentData(@ModelAttribute("student") @Valid Student student,BindingResult result, Model model){\r\n if(result.hasErrors()){\r\n return "student-login";\r\n }\r\n String text ="Hey Welcome to MVC world...,"+student.getName();\r\n repository.save(student.getName());\r\n model.addAttribute("message",text);\r\n List list = repository.findAll();\r\n model.addAttribute("list",list);\r\n return "success";\r\n }\r\n}\r\n<\/pre>\n\n\t \n<\/p>\n
\n\tIterator on jsp<\/strong>\n<\/p>\n\n\t <\/strong>\n<\/p>\n\r\n<div>\r\n<c:forEach var="student" items="${list}">\r\n <c:out value="${student}"\/><\/br>\r\n<\/c:forEach>\r\n <\/div><\/pre>\n\n\t <\/p>\n","protected":false},"excerpt":{"rendered":"
https:\/\/docs.spring.io\/spring\/docs\/current\/spring-framework-reference\/data-access.html working example: https:\/\/github.com\/teachkoka\/jdbctemplate application.property student.db.driver = org.postgresql.Driver student.db.url = jdbc:postgresql:\/\/127.0.0.1:5432\/b6 student.db.username = postgres student.db.password = abcd12345 Repository Class @Repository public class StudentRepository { public static final String INSERT_STUDENT_QUERY […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-460","post","type-post","status-publish","format-standard","hentry","category-technology"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p70lnf-7q","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=460"}],"version-history":[{"count":9,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/460\/revisions"}],"predecessor-version":[{"id":506,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=\/wp\/v2\/posts\/460\/revisions\/506"}],"wp:attachment":[{"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaizen-koka.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}