dbconn.java

oa办公管理系统。一些小型的企业办公管理用的系统。一个月废寝忘食的结果。

/**
 * DBConn.java , Created on 2008-10-20
 */
package com.soft.util;
/**
 * JDBC连接数据库
 * 
 * @version 1.0
 * @author liu
 * @since JDK1.5
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class DBConn {

	
	private String url = "jdbc:oracle:thin:@10.10.16.72:1521:soft";//连接字符串 
	private String userName = "oa";							 	//用户名
	private String password = "oa";							 	//密码
	private Connection conn = null;
	
	/**
	 * @return database connection 
	 */
	public Connection getConnection()
	{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection(url,userName,password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
		return conn;
	}
	/** 
	 * @close database connection
	 */
	public void closeConn()
	{   
		try{
			if(conn!=null)
			{
				conn.close();
			}
		}catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	
}