Java Database Connectivity #2 | Search Data In MySQL Table Using Java JDBC | ARBXCodex 2019

Java Database Connectivity Tutorial 2. Search data in the MySQL table from Java JDBC using Database Connectivity.
Tutorial By: Arpan Bhattacharya

WATCH IT FIRST:
Java Database Connectivity #1 (Adding data in MySQL tables) :- https://youtu.be/IHPHAVuzhhY

#JavaDatabaseConnectivity #SearchData #ARBXCodeX
----------------------------------------------------------------
IMPORTANT CODES:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String phone = jTextField1.getText();
if(phone.equals(""))
{
jTextField2.setText("");
jTextField3.setText(""); //For clearing the other two text fields in retries
JOptionPane.showMessageDialog(this,"Enter Phone Number!");
}
else
{
try{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/arbx","root","root");
Statement stmt = (Statement) con.createStatement();
String query = "SELECT NAME,EMAIL FROM Contact WHERE Mobile='"+phone+"';";
ResultSet rs = stmt.executeQuery(query);
if(rs.next())
{
String Name = rs.getString("Name"); //Getting name from back end
String Email = rs.getString("Email"); //Getting mail from back end
//PRINTING DATA RETRIEVED
jTextField2.setText(Name);
jTextField3.setText(Email);
}
else //if no data found
{
JOptionPane.showMessageDialog(this,"No Data Found!");
}

}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, e.getMessage());
}
}
----------------------------------------------------------------

ABOUT THE CHANNEL:
ARBX CodeX is a programming and Tech solutions YouTube channel by ARBX MediaWorks. Giving tutorials of simple programs for professional use. Plus some Tech Talks. ;)

----------------------------------------------------------------

ALL CHANNELS BY ARBX MediaWorks:

ARBX Endurance (Space):
https://www.youtube.com/channel/UC4MP_tWMF-0MkxClCCnYUMA

ARBX CodeX (Programming & IT):
https://www.youtube.com/channel/UCPv8h9q8yoEaSrpXRg39law

----------------------------------------------------------------
SOCIAL MEDIAS:

Facebook (CodeX) : https://www.facebook.com/ArbxCodeX

Instagram (CodeX): https://www.instagram.com/arbxcodex/

Twitter (CodeX):
https://twitter.com/ArbxCodeX

Facebook (ARBX Mediaworks):
https://www.facebook.com/arbxmediaworks/

Instagram (ARBX MediaWorks):
https://www.instagram.com/arbxmediaworks/

Twitter (ARBX MediaWorks):
https://twitter.com/ArbxMediaworks
-----------------------------------------------------
---------------------------------------------------------
Tutorial By : Arpan Bhattacharya

Channel: ARBX CodeX

By:
ARBX MediaWorks