spring mvc 与数据库连接

servlet.xml配置:


controller代码：
@Controller
@RequestMapping(value="/test")
public class MainContrlller {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @RequestMapping(value = "/hello", method = RequestMethod.GET)
    public String index() {
        System.out.println(jdbcTemplate.queryForInt("select COUNT(*) from demo_org"));
        return "test";
    }
}


表：



结果：