spring jdbc mysql_spring-jdbc连接mysql数据库

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));

代码下载