JButton next = new JButton(">>");
JButton prev = new JButton("<<");
JButton input = new JButton("INPUT");
JButton del = new JButton("DELETE");

JTextField tf3 = new JTextField(8);
JTextField tf4 = new JTextField(8);


JPanel p1 = new JPanel();
JPanel p2 = new JPanel();
JPanel p3 = new JPanel();
JPanel p4 = new JPanel();
JPanel p5 = new JPanel();
JPanel p6 = new JPanel();


JTextArea ta1 = new JTextArea();
JTextArea ta2 = new JTextArea();


public void koneksiDatabase(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        koneksi = DriverManager.getConnection("jdbc:mysql://localhost/finalproject","root","");
        stat = koneksi.createStatement();

    }catch(Exception e){
        System.out.println(e.getMessage());
    }
}

public void data(){
    try{
        hasil = stat.executeQuery("Select * from mslist");

        if(hasil.next()){
            tf1.setText(hasil.getString(1));
            tf2.setText(hasil.getString(2));

            }
    }catch(Exception e){

    }
}



public void setMenu(){

    p4.setLayout(new BorderLayout());

    p5.setLayout(new GridLayout(2,2));
    p5.add(new JLabel("Add new movie code : "));
    p5.add(tf3);
    p5.add(new JLabel("Add new movie list : "));
    p5.add(tf4);

    p6.setLayout(new FlowLayout());
    p6.add(input);
    p6.add(new JLabel(""));
    p6.add(del);

    p4.add(p5,"North");
    p4.add(p6,"South");
}
    @Override
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==next){
            try{
            hasil.next();
            tf1.setText(hasil.getString(1));
            tf2.setText(hasil.getString(2));
            }catch(Exception f){
            }

            }else if(e.getSource()==prev){
                try{
                hasil.previous();
                tf1.setText(hasil.getString(1));
                tf2.setText(hasil.getString(2));
    }catch(Exception a){

    }
    }else if(e.getSource()==input){
        String temp = tf3.getText();
        String temp2 = tf4.getText();
        try{
            stat.executeUpdate("INSERT INTO mslist VALUES (\"" + temp + "\', \"" +temp2 + "\')");
            JOptionPane.showMessageDialog(null, "Success!","Attention!",JOptionPane.INFORMATION_MESSAGE);
        }catch(Exception v){

        }

    }
    }
}