Skip to main content

Q) Binding of parameters?



A)
->Supply values to the place holders (question marks (?)) is nothing but binding of parameters.
->these parameters are known as “in parameters”.
“in parameters” are those parameters whose values are not supply at query compilation time, instead, supplied at query execution time.
->Binding of parameters is done by calling Setxxx(int index,value) on PreparedStatement object. The first argument of the method is question mark number (starting number is 1) in the query. The 2nd argument id value.
->Setxxx() methods are mirror methods of the getxxx methods of ResultSet.

Ex:
ps1.SetInt(1,1001);
ps1.SetString(2,”prince”);
ps1.SetFloat(3,7000);
ps2.SetFloat(1,500);
ps2.SetInt(2,1001);

Comments

Post a Comment

Popular posts from this blog

Q) What is JDBC driver? What is its role in java database connection?

A) ->A translation software written in java according o JDBC specification is nothing but “JDBC driver”. -> JDBC driver implements JDBC API. Use single API. JDBC driver role: They are 4 roles   1)       Establishing connection between JDBC client and database server. 2)       Receiving JDBC method calls made by JDBC client while performing database (CRUD) operations. 3)       Translating java method calls into DBMS understandable calls and forwarding them to database server. 4)       Receiving the results from database server. Translating them into java format and handling over the same to the JDBC client.
Post a Comment
Read more

Q) What is ODBC?

A) ->open database connectivity is a technology from MS that enables any language program (other than java) to communication with database Management System. ->in java program ODBC is directly not allowed for the fallowing reasons 1) OS dependency 2) Procedural oriented approach 3) Security thread
Post a Comment
Read more

Q) What is MyEclipse?

A) ->MyEclipse is one of the IDEs (Integrated Development Environment) used in software industry to develop java based applications. ->using My Eclipse IDE we can develop, deploy, execute, debug and test java applications.
Post a Comment
Read more