SEARCHING RECORD FROM DATABASE USING RESULT SET & PREPARED STATEMENT IN JAVA IN HINDI
SHOWING RECORD IN DATABASE USING RESULT SET & PREPARED STATEMENT IN JAVA IN HINDI
HOW TO INSERT, UPDATE , DELETE , SEARCH RECORD IN JAVA
HOW TO SEARCH RECORD ON CLICK IN JAVA USRE FORM
EASY TO MAKE SEARCH BUTTON IN JAVA DESKTOP APPLICATION 2017
how to make java application
how to use insert button in java
how to insert record in java
how to connect java with sql server
how to make desktop application in java
how to make school management system in java
how to use java netbeans to make desktop application
desktop application in java
how to make jframe in java
how to search record in jframe
how to update record in jframe
how to delete record in jframe
=====================
CODE
=====================
public void ShowRecord(){
try {
String sql = "select EmpName,EmpDepartment,EmpSalary,Doj,Email,Gender,[status],Dol from empinfo where empid='" + txtempid.getText() + "' ";
pst = con.prepareStatement(sql);
rs = pst.executeQuery();
if (rs.next()) {
txtempname.setText(rs.getString(1));
ComboDep.setSelectedItem(rs.getString(2));
txtempsalary.setText(rs.getString(3));
txtempdoj.setText(rs.getString(4));
txtemail.setText(rs.getString(5));
String gender = rs.getString(6);
if (gender.equalsIgnoreCase("male")) {
malebtn.setSelected(true);
}
if (gender.equalsIgnoreCase("female")) {
femalebtn.setSelected(true);
}
String state = rs.getString(7);
if (state.equalsIgnoreCase("working")) {
status.setSelected(false);
}
if (state.equalsIgnoreCase("left")) {
status.setSelected(true);
}
txtdol.setText(rs.getString(8));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(this, e);
}
}
HOW TO MAKE EMPLOYEE MANAGEMENT SYSTEM ON JAVA
More Relevant videos (Desktop application)
• How to make Java Desktop Application how to make user form more attractive using mouseEnter event
https://www.youtube.com/watch?v=1uRbKtNi3sA
• How to make Desktop Application how to add Items in Combobox and add Column in jtable
https://www.youtube.com/watch?v=IVjUQe_OWwo
• How to make java Desktop Application how to use jTable , Radio button & Group button
https://www.youtube.com/watch?v=8zSLJfta-dM
• How to make Desktop Application - How to make GUI on java in Urdu/hindi
https://www.youtube.com/watch?v=buGArtryr_U
• How to make Java Desktop Application How to use jpanel in Java Desktop Application (2)
https://www.youtube.com/watch?v=Npvw9wP3Cfo
• How to make Java Desktop Application How to use jpanel in Java Desktop Application (1)
https://www.youtube.com/watch?v=33_u6UaZzQM
• How to make Java Desktop Application - How to login on Enter key pressed in Java in Urdu/Hindi
https://www.youtube.com/watch?v=eCHb_VUkIcE
• Java Desktop Application - How to show and hide password in java in Urdu/Hindi
https://www.youtube.com/watch?v=jJtVgxcrHe8
• Java Desktop Application - How to make Login Form in java in Urdu/Hindi
https://www.youtube.com/watch?v=zi7LfGq00oo
• Java Desktop Application - How to make Exit Button & Minimize Button in java
https://www.youtube.com/watch?v=ms0BoZkVS5k
• Java Desktop Application - How to make Splash screen in java in urdu & hindi
https://www.youtube.com/watch?v=ZHpXkeBAsP0
• HOW TO MAKE DESKTOP JAVA APPLICATION SUCH AS SCHOOL MANAGEMENT SYSTEM
https://www.youtube.com/watch?v=bS5sTT9-yB0
• HOW TO UPDATE RECORD IN JAVA USER FORM AND HOW TO MAKE UPDATE BUTTON IN JAVA
https://youtu.be/1vXjP1PIUOo