connection = DriverManager.getConnection(DATABASE_URL,'"+userid +"','"+password+"');

[renu]

Hi


I want the user id and password to be users input values .

How can i do that in this line.
It is pointing to an error if i write the variables userid and password .

   public static void main(String[] args) throws ClassNotFoundException {
:
:
//          Calling the procedure to enter the correct user_id
			String userid = f_userid(scan);	
//          Calling the procedure to enter the correct password
			String password = f_password(scan);
connection = DriverManager.getConnection(DATABASE_URL,userid,password);  ----> how can i use the userid and password given by user at the console be used here ....
                                                                                                                   // every different user has his own userid and password
}//end of main
private static String f_userid(Scanner scan) {
		System.out.println("Enter user id : ");
		String user_id = scan.next();  //Scan the input 
		int userlen = user_id.length();
		while(userlen != 5){	
			System.out.println("The user id is less than 5 characters long .PLEASE ENTER RIGHT USERID ");
			System.out.println("Please enter userid again of 5 characters length : ");
			user_id = scan.next();  //Scan the input 
			userlen = user_id.length();
			System.out.println("The given user id is :"+user_id);
		}
		return user_id;
	}

[Fubarable]

This won't work:

connection = DriverManager.getConnection(DATABASE_URL,'"+userid +"','"+password+"');

because

DATABASE_URL,'"+userid +"','"+password+"'

isn't a valid String

So as the parameter for this method must be a String (if that's the overload that you're using), you'll need to provide it with a valid String.

One solution is to use one of the other overloads for this method. The API will show you how.

[renu]

This won't work:

connection = DriverManager.getConnection(DATABASE_URL,'"+userid +"','"+password+"');

because

DATABASE_URL,'"+userid +"','"+password+"'

isn't a valid String

So as the parameter for this method must be a String (if that's the overload that you're using), you'll need to provide it with a valid String.

One solution is to use one of the other overloads for this method. The API will show you how.

Can you pls help me , on how to pass the username and password to the connection object .

Thanks in advance

[RamyaSivakanth]

Use the below method properly
static Connection getConnection(String url, String user, String password)
Attempts to establish a connection to the given database URL.

for the above method u have to pass 3 parameters. example u should use like this
String databaseurl = "some url"
String userid = "test",
String password = "test"

So u have to use the above string like this below for the api method
DriverManager.getConnection(databaseurl,userid,pas sword)