Senin, 11 Juni 2012

TUGAS



import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class fLogin extends JFrame{
    JLabel luser, lpass;
    JTextField tuser, tpass;
    JButton blogin;
    JPanel panelform, paneltombol;

    String url = "jdbc:mysql://localhost/praktikum";
    String username = "root";
    String password = "";
    Connection conn;
    Statement st;

    public fLogin(){
        setTitle("LOGIN PLEASE");
        setSize(250,150);
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        setVisible(true);

        luser = new JLabel("USERNAME");
        lpass = new JLabel("PASSWORD");
        tuser = new JTextField(9);
        tpass = new JTextField(50);
        blogin = new JButton("LOGIN");
        panelform = new JPanel(new GridLayout(2, 2));
        paneltombol = new JPanel(new FlowLayout());

        setLayout(new BorderLayout());
        add(panelform, BorderLayout.NORTH);
        panelform.add(luser);
        panelform.add(tuser);
        panelform.add(lpass);
        panelform.add(tpass);
        add(paneltombol, BorderLayout.SOUTH);
        paneltombol.add(blogin);

        blogin.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                masukkanData();
            }
        });
    }

    public void masukkanData(){
        try{
           
                Class.forName("com.mysql.jdbc.Driver");
                conn = DriverManager.getConnection(url,username,password);
                st = conn.createStatement();
                String sql = "select * from mhs where username = '" +tuser.getText()+ "' and password = '" +tpass.getText()+ "'";
                ResultSet rs =st.executeQuery(sql);
                if (rs.next() != false){
                    String nama = rs.getString("username");
                    JOptionPane.showMessageDialog(null, "selamat datang "+nama, "Hasil", JOptionPane.INFORMATION_MESSAGE);
                }else{
                    JOptionPane.showMessageDialog(null, "Username atau password salah", "Hasil", JOptionPane.INFORMATION_MESSAGE);
                }
                st.close();
                conn.close();
        }catch (SQLException ex){
                System.out.print(ex);
                JOptionPane.showMessageDialog(null, "SQL salah!", "Hasil", JOptionPane.INFORMATION_MESSAGE);
            }catch (ClassNotFoundException ex){
                JOptionPane.showMessageDialog(null, "driver tidak ditemukan", "Hasil", JOptionPane.ERROR_MESSAGE);
            }
     }

     public static void main(String[] args) {
         fLogin a = new fLogin();
     }
}