# 驅(qū)動(dòng)名這樣寫
jdbc.driver=com.mysql.cj.jdbc.Driver
# url這樣寫
jdbc.url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
# 數(shù)據(jù)庫用戶名
jdbc.username=root
# 數(shù)據(jù)密碼
jdbc.password=password 

<context:property-placeholder location="db.properties"/>

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 <property name="driverClassName" value="${jdbc.driver}"/>
 <property name="url" value="${jdbc.url}"/>
 <property name="username" value="${jdbc.username}"/>
 <property name="password" value="${jdbc.password}"/>
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
 <property name="dataSource" ref="dataSource"/>
 <!-- 寫一些數(shù)據(jù)庫的配置, 因?yàn)槲覜]用到, 所以用不著 -->
 <!-- <property name="configLocation" value="sqlMapConfig.xml"/> -->
 <property name="mapperLocations" value="com/dao/mapper/*.xml"/>
</bean>

<!-- 掃描所有dao -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
 <property name="basePackage" value="com.dao" />
 <!-- 單數(shù)據(jù)源可以不寫sqlSessionFactoryBeanName屬性 -->
 <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>

public interface UserDao {
 public List<User> selAll();
}

<mapper namespace="com.dao.UserDao">
 <select id="selAll" resultType="com.entity.User">
  select * from user
 </select>
</mapper>

@Test
public void selAll() {
 ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
 UserDao userDao = context.getBean(UserDao.class);
 List<User> list = userDao.selAll();
 System.out.println(list);
}