mysqldb.java

java的搜索引擎的创建与索引工具

/*
 * 创建日期 2005-7-19
 * Company: Java天下
 * Author: java_zhangyu
 */
package com.db;

import java.sql.*;

import javax.naming.InitialContext;
import javax.sql.DataSource;

/**
 * 
 * @author liujinchao
 *
 * MySql连接数据库
 */

public class MySqlDb {

	protected static MySqlDb mySqlDb = null;
	
	/**
	 * 获取实例的方法
	 * 
	 * @return 
	 */
	public synchronized static MySqlDb getInstance()
	{
		if(mySqlDb == null)
		{
			mySqlDb = new MySqlDb();
		}
		return mySqlDb;
	}
	
	public Connection getConnection(String dbName) throws Exception{
	
		Connection conn = null;
		
		try {
			//数据库用户名
			
			//String userName="root";
			String userName="ODBC";
			
			//密码
			
			//String userPasswd="root";
			String userPasswd="";
			
			//联结字符串
			
			String url="jdbc:mysql://127.0.0.1/"+dbName+"?user="+userName+"&password="+userPasswd;
			 
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			
			conn = DriverManager.getConnection(url);		
		}catch(Exception e)
		{
			System.out.println("mySql数据库连接出错>>>>>>>" + e.getMessage().toString());
		}
		return conn;
    } 
	
	public Connection getConnectionDS(String jndiName) throws Exception{
		
		Connection conn = null;
		
		try {
			InitialContext ctx = new InitialContext();
			DataSource ds = (DataSource) ctx.lookup("java:comp/env/" + jndiName);
			conn = ds.getConnection();
		}catch(Exception e)
		{
			System.out.println("mySql数据库连接出错>>>>>>>" + e.getMessage().toString());
		}
		return conn;
    } 
}