uas

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

public class MainProgram extends JFrame{

	private JPanel mPanelMahasiswa = new JPanel();

	/* Form Mahasiswa */
	private static JLabel mLblNim = new JLabel("NIM");
	private static JLabel mLblNama = new JLabel("Nama");
	private static JLabel mLblJurusan = new JLabel("NIM");
	private static JLabel mLblTeknik = new JLabel("Nama");
	private static JTextField txtNim = new JTextField();
	private static JTextField txtNama = new JTextField();
	private static JTextField txtJurusan = new JTextField();
	private static JTextField txtTeknik = new JTextField();
	private static JButton mBtnSaveMahasiswa = new JButton("Tambah");
	private static JButton mBtnLihatMahasiswa = new JButton("Lihat");
	private static JButton mBtnHapusMahasiswa = new JButton("Hapus");
	private static JButton mBtnUbahMahasiswa = new JButton("Ubah");

	/* Form Petugas */
	private static JLabel mLblNip = new JLabel("NIP");
	private static JLabel mLblNamaPetugas = new JLabel("Nama");
	private static JButton mBtnSavePetugas = new JButton("Tambah");
	private static JButton mBtnLihatPetugas = new JButton("Lihat");
	private static JButton mBtnHapusPetugas = new JButton("Hapus");
	private static JButton mBtnUbahPetugas = new JButton("Ubah");

	/* Form Buku */
	private static JLabel mLblNoBuku = new JLabel("NIP");
	private static JLabel mLblTglPinjam = new JLabel("Nama");
	private static JLabel mLblTglKembali = new JLabel("Nama");
	private static JLabel mLblPengarang = new JLabel("Nama");
	private static JLabel mLblJudul = new JLabel("Nama");
	private static JButton mBtnSaveBuku = new JButton("Tambah");
	private static JButton mBtnLihatBuku = new JButton("Lihat");
	private static JButton mBtnHapusBuku = new JButton("Hapus");
	private static JButton mBtnUbahBuku = new JButton("Ubah");

	/* Connection to mysql */
	String mDriver = "com.mysql.jdbc.Driver";
	String mConnection = "jdbc:mysql://localhost:3306/buku";
	String user = "root";
	String pass = "";



	public MainProgram(){
		super("Aplikasi Peminjaman Buku");
		setSize(800,800);
		mPanelMahasiswa.setLayout(null);
		mPanelMahasiswa.setSize(400,400);
		setSize(800,600);
		setDefaultCloseOperation(EXIT_ON_CLOSE);
		getContentPane().add(mPanelMahasiswa);
		mLblNim.setBounds(20,20,100,20);
		mLblNama.setBounds(20,50,100,20);
		mLblJurusan.setBounds(20,80,100,20);
		mLblTeknik.setBounds(20,110,100,20);
		txtNim.setBounds(140,20,100,20);
		txtNama.setBounds(140,50,100,20);
		txtJurusan.setBounds(140,80,100,20);
		txtTeknik.setBounds(140,110,100,20);
		mBtnSaveMahasiswa.setBounds(20,140,100,20);
		mPanelMahasiswa.add(mLblNim);
		mPanelMahasiswa.add(mLblNama);
		mPanelMahasiswa.add(mLblJurusan);
		mPanelMahasiswa.add(mLblTeknik);
		mPanelMahasiswa.add(txtNim);
		mPanelMahasiswa.add(txtNama);
		mPanelMahasiswa.add(txtJurusan);
		mPanelMahasiswa.add(txtTeknik);
		mPanelMahasiswa.add(mBtnSaveMahasiswa);
		setVisible(true);

		try{
			Class.forName(mDriver);
			System.out.println("Berhasil");
		} catch (Exception e){
			System.out.println(e);
		}

		mBtnSaveMahasiswa.addActionListener(new ActionListener(){
		public void actionPerformed(ActionEvent e){
			try {
				String nim = txtNim.getText();
				String nama = txtNama.getText();
				String jurusan = txtJurusan.getText();
				String teknik = txtTeknik.getText();
				Connection conn = DriverManager.getConnection(mConnection, user, pass);
				String query = "INSERT INTO mahasiswa (nim, nama, jurusan, teknik) VALUES ('"+ nim +"','"+ nama +"','"+ jurusan +"','"+ teknik +"')";
				Statement st = conn.createStatement();
				st.executeUpdate(query);
			} catch (Exception f){
				System.out.println(f);
			}
			}
		});

	}

	public static void main(String[] args){
		MainProgram mp = new MainProgram();

	}

}