dbclass.java

用户可以登陆注册对房屋信息的增删改查功能

package com.qhit.kgdyffje.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * 单例模式 
 * 数据库连接类
 * @author Administrator
 *
 */
public class DBClass {
	private static DBClass dbclass=null;
	private Connection conn=null;
	private static final String DB_DRIVER_CONSTANT="oracle.jdbc.driver.OracleDriver";
	private static final String DB_URL_CONSTANT="jdbc:oracle:thin:@localhost:1521:oracle9i";
	private static final String DB_USERNAME_CONSTANT="kgdyffje";
	private static final String DB_USERPWD_CONSTANT="tiger";
	private DBClass(){
		try{
			Class.forName(DB_DRIVER_CONSTANT);
			conn=DriverManager.getConnection(DB_URL_CONSTANT,DB_USERNAME_CONSTANT,DB_USERPWD_CONSTANT);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	public Connection getConnectionInstance(){
		return conn;
	}
	public static DBClass getDBClassInstance(){
		if(dbclass==null){
			dbclass=new DBClass();
		}
		return dbclass;
	}
}