【maven+spring+mysql】数据源配置
1. maven pom.xml中添加
mysql
mysql-connector-java
5.1.30
commons-dbcp
commons-dbcp
1.4
2. 配置数据源(DBCP)
3. 连接测试
package com.lh.springtest02.section5;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.sql.DataSource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunne