spring mvc 与数据库连接

最新推荐文章于 2021-05-07 16:13:45 发布

瞬间爆炸

最新推荐文章于 2021-05-07 16:13:45 发布

阅读量276

点赞数

分类专栏： java 文章标签：数据库测试 java

本文链接：https://blog.csdn.net/qq949527860/article/details/84827467

版权

java 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

servlet.xml配置:

[img]http://dl2.iteye.com/upload/attachment/0121/3750/d972c084-12c0-3e5c-89d6-007bac6250c5.jpg[/img]
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";
}
}

表：

[img]http://dl2.iteye.com/upload/attachment/0121/3752/18a74185-f703-352e-afc8-f1125b770600.jpg[/img]

结果：

[img]http://dl2.iteye.com/upload/attachment/0121/3754/22b9f67f-7300-3d20-a75b-2e8f91f7251c.png[/img]