1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package org.springframework.jdbc.datasource;
17
18 import java.sql.Connection;
19
20 import javax.sql.DataSource;
21
22 import org.junit.Test;
23 import org.kuali.common.jdbc.JdbcUtils;
24 import org.slf4j.Logger;
25 import org.slf4j.LoggerFactory;
26
27 public class DriverManagerDataSourceTest {
28
29 private static final Logger logger = LoggerFactory.getLogger(DriverManagerDataSourceTest.class);
30
31 protected DataSource getMySQLDataSource(String url, String username, String password) {
32 DriverManagerDataSource dmsd = new DriverManagerDataSource();
33 dmsd.setDriverClassName("com.mysql.jdbc.Driver");
34 dmsd.setUrl(url);
35 dmsd.setUsername(username);
36 dmsd.setPassword(password);
37 return dmsd;
38 }
39
40 @Test
41 public void test() {
42 try {
43 DataSource dataSource = getMySQLDataSource("jdbc:mysql://localhost", "root", null);
44 Connection conn = DataSourceUtils.doGetConnection(dataSource);
45 logger.info(conn + "");
46 JdbcUtils.closeQuietly(dataSource, conn);
47 } catch (Exception e) {
48 e.printStackTrace();
49 }
50
51 }
52
53 }