how to take database as parameter to connect to mysql database server

Question

import java.sql.*;
class ConnectSql
{
    static Connection cont(String db)throws Exception
    {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/"+db+","root","xyz" );  
        return(con);
    }
}

I am facing a problem in compiling this function and this 7th line is i suppose a problem is there an syntax error.If so please tell me.Here i want to take the name of database as parameter received from calling function.When i gave the exact name of database instead of parameter it worked,but not after i passed parameter in connection line.

Madhawa Priyashantha · Accepted Answer · 2015-07-13 10:59:07Z

1

it should be

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/"+db,"root","xyz" );

problem is

"+db+"

you have extra " mark

edited Jul 13, 2015 at 10:59

answered Jul 13, 2015 at 10:47

Madhawa Priyashantha

9,8907 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SatyaTNV · Accepted Answer · 2015-07-13 10:51:35Z

0

Connection con=null;

String DB_URL = "jdbc:mysql://localhost:3306/";
String USER = "abc";//db user name
String PASS = "abc";//db password     


public synchronized Connection getConnection(String dbname)
{
 try
    {
      Class.forName("com.mysql.jdbc.Driver");//loading mysql driver 
      con = DriverManager.getConnection(DB_URL+dbname,USER,PASS);//connecting to mysql
    }
    catch(Exception e)
    {
        e.printStackTrace();
    }
    return con;
}

edited Jul 13, 2015 at 10:51

answered Jul 13, 2015 at 10:48

SatyaTNV

4,1373 gold badges17 silver badges32 bronze badges

1 Comment

Virat Srivastava Over a year ago

Actually i wanted to take the input of dbname from user

Collectives™ on Stack Overflow

how to take database as parameter to connect to mysql database server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related