spring简单应用

<?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-2.5.xsd">

<!-- 
	<bean id="dbConnection" class="cn.veryedu.db.DBConnection">
		<constructor-arg>
			<value>oracle.jdbc.driver.OracleDriver</value>
		</constructor-arg>
		<property name="userName">
			<value>scott</value>
		</property>
		<property name="userPwd">
			<value>tiger</value>
		</property>
		<property name="url">
			<value>jdbc:oracle:thin:@localhost:1521:RENWEN</value>
		</property>
	</bean>
	
	
	<bean id="dbConnection1" class="cn.veryedu.db.DBConnection1">
		<constructor-arg>
			<list>
				<value>oracle.jdbc.driver.OracleDriver</value>
				<value>jdbc:oracle:thin:@localhost:1521:RENWEN</value>
				<value>scott</value>
				<value>tiger</value>
			</list>
		</constructor-arg>
	</bean>	

	<bean id="dbConnection2" class="cn.veryedu.db.DBConnection2">
		<constructor-arg>
			<list>
				<value>oracle.jdbc.driver.OracleDriver</value>
				<value>jdbc:oracle:thin:@localhost:1521:RENWEN</value>
				<value>scott</value>
				<value>tiger</value>
			</list>
		</constructor-arg>
	</bean>	
 
 	<bean id="dbConnection3" class="cn.veryedu.db.DBConnection3">
		<constructor-arg>
			<map>
				<entry key="driver">
					<value>oracle.jdbc.driver.OracleDriver</value>
				</entry>
				<entry key="url">
					<value>jdbc:oracle:thin:@localhost:1521:RENWEN</value>
				</entry>
				<entry key="userName">
					<value>scott</value>
				</entry>
				<entry key="userPwd">
					<value>tiger</value>
				</entry>				
			</map>
		</constructor-arg>
	</bean>	
-->
	
	<bean id="dbConnection4" class="cn.veryedu.db.DBConnection4">
		<constructor-arg>
			<props>
				<prop key="driver">oracle.jdbc.driver.OracleDriver</prop>
				<prop key="url">jdbc:oracle:thin:@localhost:1521:RENWEN</prop>
				<prop key="userName">scott</prop>
				<prop key="userPwd">tiger</prop>
			</props>
			
		</constructor-arg>
	</bean>	
</beans>

 

 

package cn.veryedu.db;

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

public class DBConnection {
	//JDBC 的 URL地址
	private String url = null;
	
	//Driver驱动名
	private String driverName = null;
	
	//用户名
	private String userName = null;
	
	//密码
	private String userPwd = null;
	
	public DBConnection(String driverName) {
		this.driverName = driverName;
		try {
			Class.forName(driverName);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(url, userName, userPwd);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	public String getUrl() {
		return url;
	}

	public void setUrl(String url) {
		this.url = url;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getUserPwd() {
		return userPwd;
	}

	public void setUserPwd(String userPwd) {
		this.userPwd = userPwd;
	}
	
}

 

 

package cn.veryedu.db;

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

public class DBConnection1 {
	/*
	 * dbConfig[0] = driverName;
	 * dbConfig[1] = url;
	 * dbConfig[2] = userName;
	 * dbConfig[3] = userPwd;
	 */
	private String[] dbConfig = null;
	
	public DBConnection1(String[] argDBConfig){
		this.dbConfig = argDBConfig;
		/*
		for(int i = 0; i < dbConfig.length; i++) {
			System.out.println("dbConfig["+i+"] == " + dbConfig[i]);
		}
		*/
		
		try {
			Class.forName(dbConfig[0]);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
	}
	
	public Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(dbConfig[1], dbConfig[2], dbConfig[3]);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	
}

 

 

package cn.veryedu.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

public class DBConnection2 {
	/*
	 * dbConfig.0 = driverName;
	 * dbConfig.1 = url;
	 * dbConfig.2 = userName;
	 * dbConfig.3 = userPwd;
	 */
	private List dbConfig = null;
	
	public DBConnection2(List argDBConfig){
		this.dbConfig = argDBConfig;
		
		for(int i = 0; i < dbConfig.size(); i++) {
			System.out.println("dbConfig["+i+"] == " + dbConfig.get(i));
		}
		
		try {
			Class.forName(dbConfig.get(0).toString());
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
	}
	
	public Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(dbConfig.get(1).toString(), dbConfig.get(2).toString(), dbConfig.get(3).toString());
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
}

 

 

package cn.veryedu.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Map;

public class DBConnection3 {

	/*
	 * k=driver value=....
	 * k=url
	 * k=userName
	 * k=userpwd
	 */
	private Map dbConfig = null;

	public DBConnection3(Map dbConfig) {
		this.dbConfig = dbConfig;
		System.out.println("dbConfig = " + dbConfig.getClass());
		try {
			Class.forName((String) dbConfig.get("driver"));
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(dbConfig.get("url").toString(), dbConfig.get("userName").toString(), dbConfig.get("userPwd").toString());
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	
}

 

 

package cn.veryedu.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Map;
import java.util.Properties;

public class DBConnection4 {
	/*
	 * k=driver value=....
	 * k=url
	 * k=userName
	 * k=userpwd
	 */
	private Properties dbConfig = null;

	public DBConnection4(Properties dbConfig) {
		this.dbConfig = dbConfig;
		System.out.println(dbConfig.getClass());
		try {
			Class.forName((String) dbConfig.get("driver"));
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public Connection getConnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(dbConfig.get("url").toString(), dbConfig.get("userName").toString(), dbConfig.get("userPwd").toString());
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
}