dataconnect.java

来自「手机在线系统 采用Java 中的J2ME, JSP 跟MySql 运行环」· Java 代码 · 共 82 行

/**
 * @(#)DataConnect.java	
 * Copyright (c) 2004-2005 wuhua of workroom Inc. All Rights Reserved.
 * @version 	1.0, 10/05/2004
 * @author 	饶荣庆
 * @author 	余煜辉
 */

package com.j2me.data;

import java.sql.*;
import java.util.*;


/*
 *此类是用来连接数据库的类，并提供一些方法为以后使用
 */
public class DataConnect
{
	public String error = null;
	public Connection con;

	public DataConnect()
	{}

	/*连接方法*/
	public void connect() 
		throws ClassNotFoundException, SQLException, Exception
	{
		try
		{
			Class.forName("org.gjt.mm.mysql.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost/wuhua?user=root&password=123&useUnicode=true&characterEncoding=ISO8859_1");
		}
		catch(ClassNotFoundException e)
		{
			error = "ClassNotFoundException: Driver can not be found.";
			throw new ClassNotFoundException(error);
		}
		catch(SQLException sqlexception)
		{
			error = "SQLException: Could not connect to database.";
			throw new SQLException(error);
		}
		catch(Exception e)
		{
			error = "Exception: An unknow error occurred while connectiong to database.";
			throw new Exception(error);
		}
	}
    
	/*连接方法*/
	public  Connection getConnect() 
	{
		try
		{
			this.connect();
		}
		catch(Exception e)
		{}
		return con;
	}

	/*注销连接方法*/
	public void disconnect()
		throws SQLException
	{
		try
		{
			if (con != null)
			{
				con.close();
			}
		}
		catch(SQLException sqlexception)
		{
			error = "SQLException: Unable to close the database connection.";
			throw new SQLException(error);
		}
	}

}