server.port=8181

spring.datasource.url = jdbc:mysql://localhost:3306/my_sample_schema
spring.datasource.username = qwerty
spring.datasource.password = qwerty
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.driverClassName=com.mysql.jdbc.Driver
debug=true

package com.example;
....all imports...

@SpringBootApplication
public class Test123Application extends SpringBootServletInitializer  {

  public static void main(String[] args) {
        SpringApplication.run(Test123Application.class, args);
    }
}

package com.example.controller;
 ....all imports...

@Controller
public class TestController {

    @RequestMapping(value = "/")
     public String  demofunction(){
      return "dummytemplate";
   }

    @RequestMapping("/default")
     public String demofunction2(Model model){
        Docrepo docrepo = new Docrepoimpl();
        List<Docmaster> listContact = docrepo.list();
        model.addAttribute("listContact", listContact);
        return "dummytemplate2";
 }
}

package com.example.repository;
----all imports---

    @Configuration
    @Repository
    public class Docrepoimpl implements Docrepo{

        @Autowired
        private JdbcTemplate jdbcTemplate;


        public void adddoctor(Docmaster doc){

            String sql = "INSERT INTO docmastertable (docid,name,yoe,speciality,degree,college,hospital,regno)"
                         + " VALUES (?,?,?,?,?,?,?,?)";
            jdbcTemplate.update(sql, doc.getdocid(), doc.getname(),doc.getyoe(), doc.getspeciality(),doc.getdegree(),doc.getcollege(),doc.gethospital(),doc.getregno());
        }

        public List <Docmaster> list(){
            String sql = "SELECT * FROM docmastertable";

            if(jdbcTemplate != null)
                System.out.println("jdbc seems ok...");
            else
                System.out.println("jdbc is null...");

            List<Docmaster> listContact = jdbcTemplate.query(sql, new  RowMapper<Docmaster>() {

                @Override
                public Docmaster mapRow(ResultSet rs, int rowNum) throws SQLException {
                    Docmaster doc = new Docmaster();
                    doc.setdocid(rs.getString("docid"));
                    doc.setname(rs.getString("name"));
                    doc.setyoe(rs.getInt("yoe"));
                    doc.setspeciality(rs.getString("speciality"));
                    doc.setdegree(rs.getString("degree"));
                    doc.setcollege(rs.getString("college"));
                    doc.sethospital(rs.getString("hospital"));
                    doc.setregno(rs.getString("regno"));
                    return doc;
                }
            });
            return listContact;
        }
    }