Answer / p.kodanda rami reddy

After loading the driver in order to refer the what kind of
database u communicate we Establish the connection with the
help of a static method called GETCONNECTION this is from
DRIVER MAMAGER.GETCONNECTION. accepting arguments as JDBC
URL ,USER NAME , PASSWORD
EX: DriverManager.getConnection
("jdbc:odbc:sid","scott","tiger");
here jdbc,odbc,sid -> is url and sid is service id.
scott - > is user name.
tiger - > is password.

Answer / mathivanan

Connection is the second step of JDBC followed by
Driver_Loading. It gives the connection between the
database Driver's Manager and our java program.

Syntax: Connection con_obj = DriverManager.getConnection
("url", "login_name", "password");

Answer / suresh kumar

to create connection first we have to load the driver using
class.forName(drivername)
then register the driver using DriverManager.getConnection()
afterwards you can create Statement object and u can
execute the qurey

Answer / vikky jain

i think the one of easiest way to create a connection is
that we have to perform following steps

1. we have to define what is driver name, url address of
database , user name and password of database .
like it

String driverName = "com.mysql.jdbc.Driver";
String url ="jdbc:mysql://localhost:3309/test";
String userid ="root";
String password ="1234";


after it we have to load drivers whatever name we given above
//driver loading
Class.forName(driverName);


after loading drivers we need to get the connection by using
this

con = DriverManager.getConnection(url, userid, password);

if value of con is not null then connection has been created
where con is an object of Connection class.
if the value is null it means that there may be some
trouble in database connectivity so it may throw an error
named SQLException

Answer / ramu

. To create connection first we have to load the driver using
class.forName(drivername)
. Get a connection to the database using DriverManager.getConnection()
after wards you can create Statement object and u can
execute the query

What are the differences between resultset and rowset?

0 Answers  

How can you make a connection?

0 Answers  

Which is better odbc or jdbc?

0 Answers  

Why are we using blob datatypes in jdbc?

0 Answers  

How many types of JDBC drivers are there and what are they?

2 Answers   TCS,

If you are truncated using JDBC, how can you that how much data is truncated?

0 Answers  

any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

0 Answers  

What is the difference between triggers and procedures?

1 Answers  

Does sql allow null values ? Can we use it within where clause ?

0 Answers  

How the information about db(database) can be retrieved?

3 Answers  

Explain about DSN?

0 Answers   Infosys,

What is a jdbc url?

0 Answers