Java Database

For MySQL Connector/J, the database connection URL syntax is given below:

jdbc:mysql://[host][,failoverhost...]
[:port]/[database]
[?propertyName1][=propertyValue1]
[&propertyName2][=propertyValue2]...

• host: Port is host’s name & port no. of that computer which host database. Port and host default values are 3306 and 127.0.0.1 , if not specified,
• database is database name to connect. Without default database connection is made, if not specified.
• failover is standby database name (J supports failover/ MySQL Connector).
• propertyName=propertyValue presents an ampersand-separated properties list. Such attributes make you able to instruct the MySQL Connector/J for performing certain tasks.