Login dan Register Jframe Netbeans 8.2 sederhana

Login Jframe Variables Name :

• Login Button : jButton1
• EXIT : jButton2
• Jtextfile(Enter Username : txtuser
• JPasswordField : txtpass
• Jlabel (Create a new account) : txtclick

Login Script :

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        try {
            Connection c = KoneksiDatabase.getKoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * FROM logindb where username='"+txtuser.getText() + "' and password='"+ txtpass.getText() +"'";

            ResultSet r = s.executeQuery(sql);

            int baris = 0;
            while (r.next()) {
                baris = r.getRow();
            }

            if (baris ==1) {
                JOptionPane.showMessageDialog(null,"Berhasil Login");
                dispose();
                new Home ().setVisible(true);
            }else {
                JOptionPane.showMessageDialog(null,"GAGAL LOGIN");
            }

        } catch (SQLException e) {

        }

Exit Script :

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        System.exit(0);
    }    

Create new account Script(event > mouse > mouseclicked) :

 private void txtclickMouseClicked(java.awt.event.MouseEvent evt) {                                     
        this.setVisible(false);
        new FormRegistrasi ().setVisible(true);
    }     

Register Jframe Variables Name :

• Jtextfield (Username) : txtuser
• Jpasswordfield (Password) : txtpass
• Jtextfield (Email) : txtemail
• registrasi Jbutton : btnregistrasi
• back Jbutton : btnback

Registrasi Jbutton Script :

private void btnregistrasiActionPerformed(java.awt.event.ActionEvent evt) {                                             
        try {
            if (txtuser.getText().equals("")|| txtpass.getPassword().equals("")||
                txtemail.getText().equals("")){
    JOptionPane.showMessageDialog(this,"Data Tidak Boleh Kosong","Pesan", JOptionPane.ERROR_MESSAGE);
    hapuslayar();
    }else{
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost/dshopdb","root","");
    st = con.createStatement();
    String simpan = "insert into logindb values ('"+txtuser.getText()+"','"
            + String.valueOf(txtpass.getPassword())+"','"+txtemail.getText()+"')";
    st=con.createStatement();
    int SA = st.executeUpdate(simpan);
    JOptionPane.showMessageDialog(this, "Registrasi Berhasil");
    this.setVisible(false);
    new Login().setVisible(true);
            }
    }catch (Exception e){
        JOptionPane.showMessageDialog(this, "Akun Sudah Ada",
        "Pesan",JOptionPane.WARNING_MESSAGE);
    hapuslayar();
    }
    }       

Back Jbutton Script :

private void btnbackActionPerformed(java.awt.event.ActionEvent evt) {                                       
        this.setVisible(false);
        new Login ().setVisible(true);
    }