Java connecting to database programs explained in simple terms and screenshots
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 …
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 …
Importance Data Source Name DSN JDBC DSN stands for Data Source Name. It links or bridges the JDBC driver (JdbcOdbcDriver) with ODBC driver (Microsoft ODBC for Oracle). Create DSN before executing the program and following are the steps with Window wizard screen shots. Go to Control Panel and click over Performance and Maintenance option. Select …
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 …
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 …
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 …
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 …
Infact, without closing Connection object, any number of operations can be performed on the database. Here, three operations, Insert Update Delete Record JDBC are performed in a single program. You have seen earlier inserting record, updating record and deleting record in separate programs. For basics, it is advised to go through Basic Steps of JDBC …
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 …
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 …
ResultSet Types Concurrency JDBC Overloaded createStatement() Method (knowledge required for ResultSet Types Concurrency JDBC). Before going into programming it is required to know more about createStatement() method of Connection interface. This method can have parameters. You know the following Statement object creation earlier. Statement stmt = con.createStatement(); The createStatement() method of Connection interface returns an …
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”); …
You retrieved records from database earlier in Select Records Example by iterating the records with the ResultSet object as follows. In the same example, you also have seen the ResultSet cursor movement in while loop. while(res.next()) { System.out.println(res.getInt(1) + “\t” + res.getString(2) + “\t” + res.getDouble(3)); } The above loop prints the records from top …
Batch Update JDBC If 10 records of Employee are to be inserted, writing 10 times insert command is very slow in performance as 10 times the JDBC program should hit the database. To improve the performance, all the 10 insert statements can be converted into a batch and executed at a time. In this case, …
To store a file in Oracle table though JDBC (Insert File JDBC) Before going into execution, create table by name office with columns FILEID (number) and FILENAME (CLOB). Example on Insert File JDBC import java.sql.*; public class FileInsert { public static void main(String args[]) throws Exception { Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); Connection con = DriverManager.getConnection(“jdbc:odbc:snrao”, “scott”, “tiger”); PreparedStatement …
You have seen earlier how to store a file in database table office. Let us retrieve the file (Retrieve File JDBC), "Expenditure.txt" from table and write into another file "Liabilities.txt". Example in Retrieve File JDBC import java.io.*; import java.sql.*; public class RetrieveFile { public static void main(String[] args) throws Exception { Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”); Connection con = …
Insert Image JDBC : In this code, an image is inserted into table with JDBC. The table name is "marriage" and column name is "photo". So, by the time this program is executed, create a table marriage and a column photo of data type "long raw". For images, I/O streams are used. Example on Insert …
In the previous code XXXXXX, an image of juggler.gif is inserted in the table marriage. In this program let us read and print. To print, either Frame or Applet window is required. Here, Retrieve Image JDBC, Frame is used. import java.sql.*; import java.io.*; import java.awt.*; public class RetrieveImage extends Frame { public static void main(String …
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 »
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”); // …
