1、配置pom.xml
com.alibaba
druid
1.1.6
2、创建JdbcConfig类
package com.itzheng.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
@Configuration //声明一个类作为配置类,代替xml文件
public class JdbcConfig {
@Bean //声明在方法上,将方法返回值加入Bean容器,代替标签
public DataSource dataSource(){
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName(driverClassName);
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
return dataSource;
}
}
3、jdbc.properties
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/itzheng
jdbc.username=root
jdbc.password=123
4、在JdbcConfig类当中读取jdbc.properties
package com.itzheng.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import javax.sql.DataSource;
@Configuration //声明一个类作为配置类,代替xml文件
@PropertySource(“classpath:jdbc.properties”)
public class JdbcConfig {
@Value(“${jdbc.url}”)
String url;
@Value(“${jdbc.driverClassName}”)
String driverClassName;
@Value(“${jdbc.username}”)
String username;
@Value(“${jdbc.password}”)
String password;
最后
笔者已经把面试题和答案整理成了面试专题文档
外链图片转存中…(img-r4VCsGJl-1721136247621)]
[外链图片转存中…(img-8z8EAj8D-1721136247622)]
[外链图片转存中…(img-NpzOmDOR-1721136247622)]
[外链图片转存中…(img-mIEcRvvU-1721136247623)]