import java.sql.DriverManager;
import java.sql.Connection;
import java.util.Properties;
import java.io.InputStream;
import java.io.FileInputStream;

public class DatabaseManagerTrends
{
   public DatabaseManagerTrends()  //the default instructor
   {
 
   }
   /*
    getConnection returns a connection to a database,
    parameter:databasename is the name of which database you want to
        get connection.
   */
   public Connection getDbConnection()
   { 
    Connection con=null;	
    Properties dbProps=new Properties();
     try
    {
      InputStream is=new FileInputStream("/usr/local/tomcat/bin/DB3M.properties");
      dbProps.load(is);
    }
    catch(Exception e)
    {
      System.out.println("error in DatabaseManager3M"+e);
    }
     String driverClasses=dbProps.getProperty("drivers");
     String user=dbProps.getProperty("User");
     String password=dbProps.getProperty("Password");
     String database=dbProps.getProperty("Database");
	System.out.println("3M ? ");
	System.out.println(dbProps.getProperty("Database"));
     
     Drivers=org.gjt.mm.mysql.Driver
Database=Forum3M
User=root
Password=
ProjectName=3M

     
     try{
       Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //register the driver bridge
       //get connection to the database 
        con=DriverManager.getConnection("jdbc:mysql://localhost/"+database+"?user="+user+"&password="+password);
        //con=DriverManager.getConnection("jdbc:mysql://localhost/Forum?user=root");
      }catch(Exception e){
       System.out.println("DatabaseManager3M   "+e);
      }  
      return con;  // return 
   }
  
   
}