sqlcon.java

一套大型Office网络办公系统

/**
* Copyright (c) 2002 CODEFAD.com
* All right reserved.
*
* Description:easyOffice
*
* Author: Chu Daping 2002-5-10 16:43
*
*/

package com.codefad.easyoffice.db;

import java.io.*;
import java.sql.*;

public class SqlCon 
{
	private Connection con = null;
	
    public SqlCon()
	{
		BulidConnection();
	}
	
	private void BulidConnection()
	{
            try
              {
              Class.forName("org.gjt.mm.mysql.Driver");
              con = DriverManager.getConnection("jdbc:mysql://localhost:3306/easyOA","root","");
              //("jdbc:mysql://218.212.146.8/cfan_db?useUnicode=true&characterEncoding=ISO-8859-1","cfan","cfanpasswd");
			  }
            catch(Exception ex)
                 {
                 System.out.print("poolman not found exception occur.Massage is:");
                 System.out.print(ex.toString());
                 }
	}

	public Connection getConnection()
	{ 
		if(con == null)
			BulidConnection();

		return this.con;
	}	

	public void close() throws java.sql.SQLException
	{
		try{
			con.close(); 				
			con =  null;
		}
		catch(SQLException sex)
		{	
			System.out.println(sex.toString());
		}	
	}
}