Spring中的DataSource配置

最新推荐文章于 2022-12-23 10:08:48 发布

iteye_8224

最新推荐文章于 2022-12-23 10:08:48 发布

阅读量121

点赞数

分类专栏： Spring 文章标签： java 数据库

本文链接：https://blog.csdn.net/iteye_8224/article/details/82538479

版权

Spring 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

原文地址：Spring中的DataSource配置~~ 作者：奋进的雨滴

Spring中我们使用的数据源可以是多种,用户可以选择,也可以自己定义~~ZteDataSource.java就是自己定义的数据源~~
其中有dbcp和c3p0常用的数据源...在使用的时候,应该特别注意配置中Property节点下的name的值...每种数据源的配置都是不一样的...

applicationContext.xml // ####### //

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

ZteDataSource // ####### //

package com.zte;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import javax.sql.DataSource;

public class ZteDataSource implements DataSource {

private String driverClass;
private String driverUrl;
private String username;
private String password;

public ZteDataSource() {
super();
// TODO Auto-generated constructor stub
}

public Connection getConnection() throws SQLException {
  // TODO Auto-generated method stub
  Connection conn = null;
  try {
   Class.forName(driverClass);
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

  conn =DriverManager.getConnection(driverUrl,username,password);

  return conn;
}

public Connection getConnection(String username, String password)
   throws SQLException {
  // TODO Auto-generated method stub
  Connection conn = null;
  try {
   Class.forName(driverClass);
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

  conn =DriverManager.getConnection(driverUrl,username,password);

  return conn;
}

public PrintWriter getLogWriter() throws SQLException {
// TODO Auto-generated method stub
return null;
}

public int getLoginTimeout() throws SQLException {
// TODO Auto-generated method stub
return 0;
}

public void setLogWriter(PrintWriter arg0) throws SQLException {
// TODO Auto-generated method stub

}

public void setLoginTimeout(int arg0) throws SQLException {
// TODO Auto-generated method stub

}

public String getDriverClass() {
return driverClass;
}

public void setDriverClass(String driverClass) {
this.driverClass = driverClass;
}

public String getDriverUrl() {
return driverUrl;
}

public void setDriverUrl(String driverUrl) {
this.driverUrl = driverUrl;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

}

测试代码片段: TestMain.java

   //数据源
   String dataSourceId="dataSource_zte"; //dataSource_zte
//   String dataSourceId="dataSource_c3p0";//c3p0DataSource
//   String dataSourceId="dataSource"; //dataSource_dbcp
   DataSource ds = (DataSource) context.getBean(dataSourceId);
   System.out.println("Connection:" + ds.getConnection());