JDBC statement

JDBC Statement object

  •  JDBC statement help us to issue SQL query to the database and
    Retrieve data from database.
  • There are three different type of JDBC statement
  • 1. java.sql.Statement
    2. java.sql.PrepareStatement
    3. java.sql.CallableStatement
    
  • Once we create JDBC statement then we must invoke any of below method to issue SQL query.
Method to issue different types of SQL query.
int executeupdate()

  • It is used to execute other then select
    query(Means insert,update or delete)
  • It return number of rows affected in terms of integer

Resultset executequery()

  •  It is used to execute select query
  • It return DB result in form of Resultset Object

boolean execute()

  • It is used to execute any type of sql query
  •  It return true if result of type DB Result
  • It returns false if result is type of integer
Note:
if we use boolean execute() method then we must make use of
Getupdatecount() OR
Getresultset() method to Retrieve actual Result
Java program to fetch data from mysql database
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
 
package com.spy.javaforlearn;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import com.mysql.jdbc.Driver;
 
public class Myfirstjdbcprog 
{
 
	public static void main(String[] args)
	{
 
		Connection con=null;
		Statement stmt=null;
		ResultSet rs=null;
 
 
		try
		{
 
			/*
			 * 1. load the driver
			 */
 
		     Driver rf1 = new Driver();
 
		     DriverManager.registerDriver(rf1);
 
 
		     /*
		      * 2. get the db connection via driver
		      * 
		      * dburl-protocol:subprotocol:subname
                      * Protocol: JDBC
                      * Subprotocol:mysql( it's depends on database)
		      * subname consist:
		      * --hostname
		      * --port number;
		      * --db name
		      * --user & password		      
		     */
 
 
 
 
	String url="jdbc:mysql://localhost:3306/test?user=root&password=root";
        con=DriverManager.getConnection(url);
 
 
		/*
		 * 
		 * 3. issues sql query via connection
		 * 
		 */
 
 
		String query="select *from student_detail";
		stmt=con.createStatement();
		rs=stmt.executeQuery(query);
 
 
		/*
		 * 
		 *4. process the result return by sql query
                 *
		 */
 
 
		while(rs.next())
		  {
			String id=rs.getString("user_id");
			String f_name=rs.getString("f_name");
			String l_name=rs.getString("l_name");
 
 
			System.out.println("user_id:"+id);
			System.out.println("first name:"+f_name);
			System.out.println("last name:"+l_name);
 
			System.out.println("*******************");
 
		   }
 
		}
 
		catch(SQLException e)
		{
			e.printStackTrace();
		}
 
		/*
                 *  5. Close all JDBC object in Finally block
                 */
		finally
		{
			try
			{
			if(con!=null)
			   {
			    con.close();
			   }
			if(stmt!=null)
			  {
			  stmt.close();
			  }
 
			if(rs!=null)
			  {
			    rs.close();
			  }
		     }
 
			catch(SQLException e)
 
			   {
				e.printStackTrace();
			   }
 
			}			
		}	
	}
 
output:
 
user_id:1
first name:bhavesh
last name:lakhani
*******************
user_id:2
first name:vivel
last name:patel
*******************
user_id:3
first name:abhilash1
last name:shah
*******************

Leave a Reply

Your email address will not be published. Required fields are marked *