java database connectivity - jdbc part-2
DESCRIPTION
JDBC Part-2, This was made by Prof. Chitrakant Banchhor Very Descriptive,Easy to Understand Thank You Sir......TRANSCRIPT
![Page 1: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/1.jpg)
Working with JDBCWorking with JDBCBy
CHITRAKANT BANCHHOR
![Page 2: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/2.jpg)
ReferencesReferences
![Page 3: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/3.jpg)
ConnectionConnection
StatementStatement
JDBC InterfacesJDBC Interfaces
StatementStatement
DatabaseMetaDataDatabaseMetaData
![Page 4: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/4.jpg)
Connection InterfaceConnection Interface
Transaction processingTransaction processingCreate objects for
executing SQL statementsCreate objects for
executing SQL statements
methods for
Transaction processingTransaction processing
Create objects forexecuting stored
procedures
Create objects forexecuting stored
procedures
Create objects forexecuting SQL statements
Create objects forexecuting SQL statements
It can not directly be created in code; instead, the Connection interface is created by theDriver.connect() method.
![Page 5: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/5.jpg)
createStatement()createStatement()
public Statement createStatementcreateStatement( )( ) throws SQLExceptionpublic Statement createStatementcreateStatement( )( ) throws SQLException
This method creates a Statement object associated with this Connection session.
public Statement createStatementcreateStatement( )( ) throws SQLException
public Statement createStatementcreateStatement ((intint resultSetTyperesultSetType,, intint resultSetConcurresultSetConcur
))throws SQLException
public Statement createStatementcreateStatement ((intint resultSetTyperesultSetType,, intint resultSetConcurresultSetConcur
))throws SQLException
![Page 6: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/6.jpg)
prepareStatementprepareStatement
public PreparedStatement prepareStatementprepareStatement((String sqlsql
)) throws SQLException
public PreparedStatement prepareStatementprepareStatement((String sqlsql
)) throws SQLException
This method provides a PreparedStatement object to be associated with this Connection session.
public PreparedStatement prepareStatementprepareStatement((String sqlsql
)) throws SQLException
public PreparedStatement prepareStatementprepareStatement ((String sqlsql,,int resultSetTyperesultSetType,,int resultSetConcurresultSetConcur
)) throws SQLException
public PreparedStatement prepareStatementprepareStatement ((String sqlsql,,int resultSetTyperesultSetType,,int resultSetConcurresultSetConcur
)) throws SQLException
![Page 7: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/7.jpg)
The StatementStatement Interface
• The Connection object connects to the database.
• To execute SQL statements and get results back from the database, wemust use the Statement object.
![Page 8: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/8.jpg)
Statement object creationStatement object creation
It can not be created directlyIt can not be created directly
It is created by the method of theConnection object
It is created by the method of theConnection object
It is created by the method of theConnection object
It is created by the method of theConnection object
The createStatement() methodreturns a Statement object as a
return value
The createStatement() methodreturns a Statement object as a
return value
![Page 9: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/9.jpg)
execution methods used with a Statement objectexecution methods used with a Statement object
1. It allows us to execute the Statement when we do notknow if it is a query or an update.
2. It may return multiple results.
3. Use getResultSet to retrieve the ResultSet.
boolean executeexecute(
String Sql)
Executes the SQL string and returns a singleResultSet object.Executes the SQL string and returns a singleResultSet object.
Executes a SQL string, which must be anINSERT,UPDATE, DELETE, or a statement thatdoesn’t return anything.
Executes a SQL string, which must be anINSERT,UPDATE, DELETE, or a statement thatdoesn’t return anything.
ResultSet executeQueryexecuteQuery(
String Sql)
int executeUpdateexecuteUpdate(
String Sql)
![Page 10: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/10.jpg)
Example:Example: SelectSelect
![Page 11: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/11.jpg)
![Page 12: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/12.jpg)
![Page 13: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/13.jpg)
Example: InsertExample: Insert
![Page 14: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/14.jpg)
Example: DeleteExample: Delete
![Page 15: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/15.jpg)
Example: Create TableExample: Create Table -- 11
![Page 16: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/16.jpg)
Example: Create TableExample: Create Table -- 22
![Page 17: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/17.jpg)
![Page 18: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/18.jpg)
JDBC withJDBC with MySqlMySql
![Page 19: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/19.jpg)
Required SoftwareRequired Software
![Page 20: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/20.jpg)
MySqlMySql connector with Tomcatconnector with Tomcat
• Copy in Tomcat’s lib folder
![Page 21: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/21.jpg)
Create Table :Create Table : MySqlMySql
![Page 22: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/22.jpg)
Delete Table:Delete Table: MySqlMySql
![Page 23: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/23.jpg)
Inserting values inInserting values in MySQLMySQL database tabledatabase table
![Page 24: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/24.jpg)
Select:Select: MySqlMySql
![Page 25: Java DataBase Connectivity - JDBC Part-2](https://reader033.vdocuments.us/reader033/viewer/2022042514/557ddc1ad8b42a83568b45d7/html5/thumbnails/25.jpg)
Thank You!Thank You!Thank You!Thank You!