View Javadoc

1   /**
2    * Copyright 2010-2012 The Kuali Foundation
3    *
4    * Licensed under the Educational Community License, Version 2.0 (the "License");
5    * you may not use this file except in compliance with the License.
6    * You may obtain a copy of the License at
7    *
8    * http://www.opensource.org/licenses/ecl2.php
9    *
10   * Unless required by applicable law or agreed to in writing, software
11   * distributed under the License is distributed on an "AS IS" BASIS,
12   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   * See the License for the specific language governing permissions and
14   * limitations under the License.
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  }