///////////////////////username



       try{
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/Penjualan?zeroDateTimeBehavior=convertToNull","root","");
       Statement state= conn.createStatement();

       String sql="SELECT * FROM multyuser where Username="+"'"+username.getText()+"'"+"and Password="+"'"+password.getText()+"'";
       ResultSet rs = state.executeQuery(sql);
       String test3 = null;
       String test4 = null;
       String test5 = null;
       while(rs.next()){
       test3 = rs.getString(3);
       test4 = rs.getString(4);
       test5 = rs.getString(5);
       }
        if(!test3.equals(null)&& !test4.equals(null))
        {
            if ("Owner".equals(test5)) {
                this.setVisible(false);
                new Menu().setVisible(true);}
            else{
            this.setVisible(false);
            new MenuM().setVisible(true);
            }
        }
        else {
         JOptionPane.showMessageDialog(null,"Username Password Salah");
            username.setText("");
            password.setText("");
            username.requestFocus();
                }
       }
       catch (Exception e)
       {
           JOptionPane.showMessageDialog(null,"Error:UsernameOrPassword salah"+e.getMessage());
       }


///////////////////////InputDataMAster



       DefaultTableModel model=(DefaultTableModel) TableB.getModel();
       model.addRow(new Object[]{NoB.getText(),NamaB.getText(),quanP.getText(),Harga.getText(),tgl.getText()});
       try{
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Penjualan?zeroDateTimeBehavior=convertToNull","root","");
            Statement st = conn.createStatement();
            String sql = "INSERT INTO datamaster VALUES('"+NoB.getText()+"','"
                +NamaB.getText()+"','"+quanP.getText()+"','"
                +Harga.getText()+"','"+tgl.getText()+"')";
            st.executeUpdate(sql);
            st.close();
            conn.close();
            JOptionPane.showMessageDialog(null, "Data telah diinput");
        } catch (Exception e) { JOptionPane.showMessageDialog(null, "gagal"+e.getMessage()); }


////////////////////////////////Laporan


try{
            Object header[]={"No Faktur","No Barang","Quantity","Nama Pembelian","Tanggal","Total Harga"};
            DefaultTableModel data = new DefaultTableModel(null,header);
            TableL.setModel(data);
            String nofak = faktur.getText();

            try{
                Class.forName("com.mysql.jdbc.Driver").newInstance();
                Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/Penjualan?zeroDateTimeBehavior=convertToNull","root","");
                Statement state= conn.createStatement();
                Statement statement= conn.createStatement();
                String sql="SELECT * FROM jualan where Nofak="+"'"+nofak+"'";
                ResultSet rs = state.executeQuery(sql);
                while(rs.next()){

                    int test1 = rs.getInt(1);
                    String test2 = rs.getString(2);
                    int test3 = rs.getInt(3);
                    String test4 = rs.getString(4);
                    String test5 = rs.getString(5);
                    String ss="SELECT * FROM datamaster where NoBarang="+"'"+test2+"'";
                    ResultSet rs2 = statement.executeQuery(ss);

                    int data4 = 0;
                    while(rs2.next()){
                        data4=rs2.getInt(4);
                    }
                    data4 = data4*test3;
                    String test[]={String.valueOf(test1),test2,String.valueOf(test3),test4,test5,String.valueOf(data4)};
                    data.addRow(test);

                }
            }
            catch (Exception e)
            {
                JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
            }
        }
        catch (Exception e)
        {
            JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
        }