© 2014 Firstsoft Technologies (P) Limited. login
Hi 'Guest'
Home SiteMap Contact Us Disclaimer
enggedu
Quick Links
Easy Studies

After Employee Validation Retriew the Corresponding Employee Detail from Database Using Java

Description:

This program gets the employee id as input from the user and retrieves the corresponding employee details from the table. This program connects with the database using the data source name and retrieves the details of the corresponding employee id. If the given empid is match with the data available in the table,it returns the corresponding employee details otherwise it will return null. displayUserDetails() is used to get the employee details.

After Employee Validation Retriew the Corresponding Employee Detail from Database Using Java :

import javax.swing.*; import java.sql.*; public class UserDetails extends javax.swing.JFrame { private String empid=null; private String read=null; private String write=null; private String read_write=null; private boolean result=false; private ButtonGroup bgroup=new ButtonGroup(); public UserDetails() { initComponents(); userInitComponents(); } public void userInitComponents(){ combo_read.setVisible(false); combo_write.setVisible(false); combo_read_write.setVisible(false); bgroup.add(combo_read); bgroup.add(combo_write); bgroup.add(combo_read_write); setBounds(0,0,800,600); } private void initComponents() { jPanel1 = new javax.swing.JPanel(); jPanel2 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); text_empid = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); text_id = new javax.swing.JTextField(); text_read = new javax.swing.JTextField(); text_write = new javax.swing.JTextField(); text_read_write = new javax.swing.JTextField(); combo_read = new javax.swing.JCheckBox(); combo_write = new javax.swing.JCheckBox(); combo_read_write = new javax.swing.JCheckBox(); button_getdetails = new javax.swing.JButton(); getContentPane().setLayout(null); addWindowListener(new java.awt.event.WindowAdapter() { public void windowClosing(java.awt.event.WindowEvent evt) { exitForm(evt); } }); jPanel1.setLayout(null); jPanel1.setBackground(new java.awt.Color(182, 175, 147)); jPanel1.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED)); jPanel2.setLayout(null); jPanel2.setBackground(new java.awt.Color(182, 175, 147)); jPanel2.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.LOWERED)); jLabel1.setText("Employee Id"); jPanel2.add(jLabel1); jLabel1.setBounds(10, 10, 80, 30); text_empid.setText(" "); text_empid.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.LOWERED)); jPanel2.add(text_empid); text_empid.setBounds(160, 10, 110, 30); jLabel2.setText("Employee ID"); jPanel2.add(jLabel2); jLabel2.setBounds(10, 60, 80, 30); jLabel3.setText("Read Permission"); jPanel2.add(jLabel3); jLabel3.setBounds(10, 100, 100, 30); jLabel4.setText("Write Permission"); jPanel2.add(jLabel4); jLabel4.setBounds(10, 140, 100, 30); jLabel5.setText("Read/Write Permission"); jPanel2.add(jLabel5); jLabel5.setBounds(10, 180, 140, 30); text_id.setEditable(false); text_id.setForeground(new java.awt.Color(255, 0, 0)); text_id.setText(" "); jPanel2.add(text_id); text_id.setBounds(160, 60, 110, 30); text_read.setEditable(false); text_read.setForeground(new java.awt.Color(255, 0, 0)); text_read.setText(" "); jPanel2.add(text_read); text_read.setBounds(160, 100, 110, 30); text_write.setEditable(false); text_write.setForeground(new java.awt.Color(255, 0, 0)); text_write.setText(" "); jPanel2.add(text_write); text_write.setBounds(160, 140, 110, 30); text_read_write.setEditable(false); text_read_write.setForeground(new java.awt.Color(255, 0, 0)); text_read_write.setText(" "); jPanel2.add(text_read_write); text_read_write.setBounds(160, 180, 110, 30); combo_read.setBackground(new java.awt.Color(182, 175, 147)); combo_read.setText("Read"); jPanel2.add(combo_read); combo_read.setBounds(300, 100, 54, 24); combo_write.setBackground(new java.awt.Color(182, 175, 147)); combo_write.setText("Write"); jPanel2.add(combo_write); combo_write.setBounds(300, 140, 56, 24); combo_read_write.setBackground(new java.awt.Color(182, 175, 147)); combo_read_write.setText("Read/Write"); jPanel2.add(combo_read_write); combo_read_write.setBounds(300, 180, 88, 24); jPanel1.add(jPanel2); jPanel2.setBounds(200, 80, 490, 240); button_getdetails.setText("Show"); button_getdetails.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED)); button_getdetails.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { button_getdetailsActionPerformed(evt); } }); jPanel1.add(button_getdetails); button_getdetails.setBounds(340, 340, 80, 30); getContentPane().add(jPanel1); jPanel1.setBounds(0, 0, 800, 600); pack(); } private void button_getdetailsActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_button_getdetailsActionPerformed // Add your handling code here: empid=text_empid.getText().trim(); if(empid.equals("")||empid.equals(null)){ JOptionPane.showMessageDialog(this,"Please enter Employee ID"); } else{ result=getUserDetails(); if(result){ displayUserDetails(); } else{ JOptionPane.showMessageDialog(this,"No such Employee ID :"+empid); } } }//GEN-LAST:event_button_getdetailsActionPerformed private void exitForm(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_exitForm System.exit(0); }//GEN-LAST:event_exitForm public boolean getUserDetails(){ Connection dbcon=null; PreparedStatement pstmt=null; ResultSet rs=null; String user=null; boolean result=false; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbcon=DriverManager.getConnection("jdbc:odbc:intrusionserver","scott","tiger"); pstmt=dbcon.prepareStatement("select * from Access_Permission where empid=?"); pstmt.setInt(1,Integer.parseInt(empid)); rs=pstmt.executeQuery(); if(rs.next()){ empid=String.valueOf(rs.getInt(1)); read=rs.getString(2); write=rs.getString(3); read_write=rs.getString(4); result=true; } else{ result=false; } } catch(ClassNotFoundException e){ e.printStackTrace(); } catch(SQLException e){ e.printStackTrace(); } finally{ try{ dbcon.close(); } catch(SQLException e){ e.printStackTrace(); } } return result; } public static void main(String args[]) { new UserDetails().show(); } public void displayUserDetails(){ text_id.setText(empid.toUpperCase()); text_read.setText(read.toUpperCase()); text_write.setText(write.toUpperCase()); text_read_write.setText(read_write.toUpperCase()); } public int storeDataBase(){ Connection dbcon=null; PreparedStatement pstmt=null; String user=null; int result=0; boolean read=combo_read.isSelected(); boolean write=combo_write.isSelected(); boolean read_write=combo_read_write.isSelected(); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbcon=DriverManager.getConnection("jdbc:odbc:intrusionserver","scott","tiger"); pstmt=dbcon.prepareStatement("update Access_Permission set read=?,write=?,read_write=? where empid=?"); pstmt.setString(1,String.valueOf(read)); pstmt.setString(2,String.valueOf(write)); pstmt.setString(3,String.valueOf(read_write)); pstmt.setString(4,empid); System.out.println("Set All Parameters"); System.out.println("Emp id:"+empid); System.out.println("Updated Values"); System.out.println("Read :"+read); System.out.println("Write :"+write); System.out.println("Read/Write"+read_write); result=pstmt.executeUpdate(); System.out.println("Update Completed"); } catch(ClassNotFoundException e){ e.printStackTrace(); } catch(SQLException e){ e.printStackTrace(); } finally{ try{ dbcon.close(); } catch(SQLException e){ e.printStackTrace(); } } return result; } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel1; private javax.swing.JCheckBox combo_write; private javax.swing.JTextField text_id; private javax.swing.JTextField text_read; private javax.swing.JCheckBox combo_read; private javax.swing.JButton button_getdetails; private javax.swing.JTextField text_empid; private javax.swing.JTextField text_write; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel3; private javax.swing.JTextField text_read_write; private javax.swing.JLabel jLabel2; private javax.swing.JCheckBox combo_read_write; private javax.swing.JLabel jLabel1; // End of variables declaration//GEN-END:variables }

Sample ScreenShot:

 
SLogix Student Projects

⇓Student Projects⇓
⇑Student Projects⇑
bottom