1.准备jar包:ojdbc7.jar。java连接oracle11g用的是ojdbc6.jar,但是连接oracle12要用ojdbc7.jar。
2.db.properties文件内容:
jdbcUrl=jdbc:oracle:thin:@//localhost:1521/orcl
username=C##J2EE
password=pwd23
3.连接数据库的具体实现:
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
public class DBUtil {
private static final Log LOG = LogFactory.getLog(DBUtil.class);
private static final ThreadLocal<Connection> TL = new ThreadLocal<>();
private static String username;
private static String password;
private static String jdbcUrl;
static{
InputStream resourceAsStream = DBUtil.cl