ඉක්මණින්ම ST II Assignment ගොඩ දාගන්නත් එපැයිනේ - Part 1

ඉක්මනින්ම Login Form එකක් නිර්මාණය කරගෙන, mySQL Database එකත් එක්ක connect වෙන්න ඕනෑ කරන Class file හදලා, Connection එක establish කරලා, System එකට උවමනා කරන නියම coded Login එකක් හදා ගමු. 


සැ.යු. - Interface Design එක ගැන සලකා නැත. මුලිකම පෙනුම පමණි.
එක් එක් coding කුමක් සඳහාද යන්න තේරුම් ගැනීම ඔබ සතුය.


Quick - Login, DB Connectivity
Download File Size - 8.21MB
After Extract File - 787MB
Duration - 18min 21s

http://www.mediafire.com/?tif9ol9ldeze732



/////////////////////////////////////////////////////////////////////////////////////////////////


    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        int index = jComboBox1.getSelectedIndex();
        String username = jTextField1.getText();
        String password = new String(jPasswordField1.getPassword());
        if(index==1){
            try {
                ResultSet rst = DB_Access.getData("select * from travelguide where username='"+username+"' and password='"+password+"'");
                rst.first();
                if(rst.getString(1).equals(username) && rst.getString(1).equals(username)){
                    Home_TG tg = new  Home_TG(username);
                    tg.setVisible(true);
                }else{
                    JOptionPane.showMessageDialog(this, "Invalid User Access","error",0);
                } 
            } catch (SQLException ex) {
                JOptionPane.showMessageDialog(this, "No User Found","error",0);
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
            }
        }else if(index==2){
            try {
                ResultSet rst = DB_Access.getData("select * from transportofficer where username='"+username+"' and password='"+password+"'");
                rst.first();
                if(rst.getString(1).equals(username) && rst.getString(1).equals(username)){
                    Home_TO to = new  Home_TO(username);
                    to.setVisible(true);
                }else{
                    JOptionPane.showMessageDialog(this, "Invalid User Access","error",0);
                }
            } catch (SQLException ex) {
                JOptionPane.showMessageDialog(this, "No User Found","error",0);
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
            }
        }else{
            JOptionPane.showMessageDialog(this, "Please select a designation","Error",0);
        }
    }