open_db.java

来自「心理咨询网站」· Java 代码 · 共 49 行

package cn.aiqinzhe;

import java.sql.*;

public class Open_DB
{ 
	//��ݿ��û���
	String userName="root";
	//��ݿ�����
	String userPassword="a1234567";
	//��ݿ��URL����(l����ݿ���ʹ�õı����ʽ
	String url="jdbc:mysql://localhost:3306/xinli?useUnicode=true&characterEncoding=gb2312";
	//����һ��l�Ӷ���
	Connection dbConn;   
	//������Ϣ��
	String errDesc;
    	
   	public Open_DB()
   	{
   		//��ʼ������
   		errDesc="";
   		dbConn=null;
   	}
   	
	//l����ݿ�
   	public Connection getConn()
   	{   	
	   	try
	   	{ 
			//�������õ����
			Class.forName("org.gjt.mm.mysql.Driver");
			//�����ݿ��l�Ӷ���
			dbConn= DriverManager.getConnection(url,userName,userPassword);
	   	}
	   	catch(Exception ex)
	   	{	   		
	   		dbConn = null;
	   		errDesc=ex.toString();	   		
	   	}
	   	return dbConn;
   }
   
   //��ȡ������Ϣ
   public String getErrDesc()
   {
   		return errDesc;	
   }
}