spring5(6) -DI 通过xml配置装配 -2

一.配置数据库连接池

  1.先拷jar包
  2在数据库中创建一个学生表
  3.配置
  4.测试

1.拷jar包

本人使用的是 mysql-connector-java-8.0.12.jar     druid-1.1.5.jar   把它们拷到lib文件路径下并build path

2.在数据库中创建一个学生表

自己在数据库的客户端简单创建吧，挺简单的，这里就不给出了。

3.配置代码

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<!-- 配置一个durid的连接池 -->
<bean id = "dataSource" class ="com.alibaba.druid.pool.DruidDataSource"
       init-method = "init" destroy-method="close">
  <property name = "driverClassName" value =""/>
  <property name = "url" value ="jdbc:mysql://localhost:3306/springLearn"/>
  <property name = "username" value ="root"/>
  <property name = "password" value ="wu0224ying"/>
  <property name = "initialSize" value ="2"/>

</bean>

</beans>

3.测试代码

import static org.junit.jupiter.api.Assertions.*;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.sql.DataSource;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;

import com.alibaba.druid.pool.DruidDataSource;

import lombok.Cleanup;


@SpringJUnitConfig
public class AutoTest {

   @Autowired
   private  DataSource ds;
   
   @Test
   void test() throws Exception {
           
   @Cleanup    
   Connection conn = ds.getConnection();
   @Cleanup
   PreparedStatement ps =  conn.prepareStatement("select * from Student");
   @Cleanup
   ResultSet rs = ps.executeQuery();
   while(rs.next()) {
       System.out.print(rs.getInt("id")+"  ");
       System.out.print(rs.getString("name")+"  ");
       System.out.println(rs.getInt("age"));
   }
   }
}

output:

1  keen  22
2  sophie  23