maven依赖包引入
com.alibaba
fastjson
1.2.73
mysql
mysql-connector-java
8.0.21
org.springframework
spring-aop
5.2.8.RELEASE
org.springframework
spring-beans
4.3.12.RELEASE
org.springframework
spring-context
4.3.12.RELEASE
org.springframework
spring-core
4.3.12.RELEASE
org.springframework
spring-jdbc
4.3.12.RELEASE
com.alibaba
druid
1.1.22
配置文件 applicationContext.xml
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
jdbc.properties
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://112.19.82.122:3306/xxx?useunicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
查询dao定义
@Component
public class UserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
public List query() {
List result = jdbcTemplate.query("select * from tb_user limit 2", new BeanPropertyRowMapper(User.class));
return result;
}
}
测试
ClassPathXmlApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
UserDao userDao = applicationContext.getBean("userDao", UserDao.class);
List query = userDao.query();
System.out.println( JSON.toJSONString(query));
代码下载