阅读背景:

JDBC连接MySQL或Oracle数据库(通过从属性文件jdbc.properties读,用Java的Property类)

来源:互联网 


JDBCTest.java 源代码如下:

package com.jdbc.entity;import java.io.InputStream;import java.sql.Connection;import java.sql.Date;import java.sql.Driver;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.List;import java.util.Properties;import org.junit.Test;public class JDBCTest {	public Connection getConnection() throws Exception{		String driverClass = null;		String jdbcUrl = null;		String user = null;		String password = null;				//读取类路径下的 jdbc.properties 文件		InputStream in = 				getClass().getClassLoader().getResourceAsStream("jdbc.properties");		Properties properties = new Properties();		properties.load(in);		driverClass = properties.getProperty("driver");		jdbcUrl = properties.getProperty("jdbcUrl");		user = properties.getProperty("user");		password = properties.getProperty("password");				Driver driver = 				(Driver) Class.forName(driverClass).newInstance();				Properties info = new Properties();		info.put("user", user);		info.put("password", password);				//通过 Driver 的 connect 方法获取数据库连接. 		Connection connection = driver.connect(jdbcUrl, info);				return connection;	}		@Test	public void testGetConnection() throws Exception{		System.out.println(getConnection());	}}package com.jdb



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: