In the following program a procedure called getMe is executed using CallableStatement where a value is sent and another value is accessed. Here x is IN number and y is OUT number. CallableStatement along with PreparedStatement is fully discussed in Difference between Statement, PreparedStatement, CallableStatement. Example on Execute procedure CallableStatement Following is the SQL procedure. …
In the following program, an Employee record is inserted using PreparedStatement(executing dynamic SQL statements). PreparedStatement along with CallableStatement is fully discussed in Difference between Statement, PreparedStatement, CallableStatement. Example on PreparedStatement JDBC import java.sql.*; import java.io.*; public class PreparedDemo { public static void main(String args[]) throws Exception { Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); Connection con = DriverManager.getConnection(“jdbc:odbc:snrao”, “scott”, “tiger”); // …
Statement vs PreparedStatement vs CallableStatement We know earlier, Statement interface works as a courier service between a Java (JDBC) program and database. There comes 3 types Statement interfaces in JDBC API doing the same job but used for different purposes. Let us see how they differ in Statement vs PreparedStatement vs CallableStatement and use them …
Difference Statement PreparedStatement CallableStatement Read More »
Drop Table JDBC Following Drop Table JDBC code deletes the table Employee. All the records also deleted with the table. drop table SQL command is used. Example on Drop Table JDBC import java.sql.*; public class DeleteTable { public static void main(String args[]) throws Exception { // 3 standard JDBC statements as usual Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); Connection con=DriverManager.getConnection(“jdbc:odbc:snrao”,”scott”,”tiger”); …
What is metadata of a table? The number of columns, data type of each column, name of each column, primary keys etc. constitutes the metadata of a table. Actual data refers the records in the table. Using JDBC, metadata of a table can be retrieved. The ResultSetMetaData interface can hold the metadata of the table …
After inserting and deleting records, let us make one more program that updates the salary of a record. In this program, GUI environment is used to take employee ID and display the result. The output is planned to display the particulars like employee id, name, old salary and new salary after updating and the amount …
Delete Record JDBC Example. The Employee ID is taken from keyboard input. Example on Delete Record JDBC Example import java.sql.*; import java.io.*; public class DeleteRecord { public static void main(String args[]) throws Exception { // to take input from the user BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); System.out.println(“Please Enter the ID no:”); String str=br.readLine(); int …
Select Records JDBC Example: To retrieve records from Employee table in Oracle Database. By the time this program is executed, see some records exist in Employee table. Example on Select Records JDBC Example import java.sql.*; public class RetrieveRecords { public static void main(String args[]) throws Exception { // standard 3 JDBC statements Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); Connection con …
To take record particulars from keyboard and insert them in the Employee table. Note: See that there exists an Employee table by the time this program is executed. This can be done with Create Table. Example on Insert Record JDBC Keyboard Input import java.sql.*; // for JDBC classes import java.io.*; // for keyboard reading public …
In the following program on Insert Record JDBC Example, 3 records are inserted in the Employee table in Oracle database. Note: See that there exists an Employee table by the time this program is executed. This can be done with Create Table Example on Insert Record JDBC Example import java.sql.*; public class InsertingRecords { public …
Create Table JDBC In the following Create Table JDBC code, a new Employee table in Oracle database is created. The Employee table with fields empid, empname and empsal is created using DSN snrao. Note: Before going into the program, it is advised to go through JDBC Programming Basic Steps where the meaning of Connection, Statement …
Learn JDBC Programming Basic Steps After learning what is JDBC, let us see how to write and learn JDBC program. The whole Learn JDBC Program can be divided into 8 basic steps. Import the java.sql package Load the driver Establish the connection with the database using the driver Create a "Statement" object Send a SQL …
After knowing what is JDBC in JDBC tutorial, let us know drivers and JDBC Driver Types as they are required in each JDBC programming. What is a driver and JDBC Driver Types? Driver is a software which connects two dissimilar software components or software and hardware. Dissimilar (or heterogeneous) means, they differ in each and …
Before going into the definition, let us see some scenario. Suppose you go to a Bank ATM center (I call it as a ATM client) to know your account balance. You insert the card, type the pin number, click a button, you will get a small print out. You are happy; but let us see …
