cover /** * Write a description of class Cover here. * * @author (your name) * @version (a version number or a date) * class buat loading page * 14 Jun 2009 * dxdx * */ import java.awt.*; import javax.swing.*; import java.awt.event.*; import javax.swing.border.LineBorder; public class Cover extends JWindow { // instance variables - replace the example below with your own private Dimension dimensi1=Toolkit.getDefaultToolkit().getScreenSize(); private JLabel labelLogo1=new JLabel(new ImageIcon("foto/01.jpg")); private JProgressBar barisProg1=new JProgressBar(); private int time1=0; private Timer timer1; /** * Constructor for objects of class Cover */ Cover() { Color warna=Color.gray; barisProg1.setValue(0); barisProg1.setPreferredSize(new Dimension(100,15)); barisProg1.setBackground(Color.white); barisProg1.setIndeterminate(true); barisProg1.setStringPainted(true); barisProg1.setBorder(new LineBorder(warna,0)); labelLogo1.setBorder(new LineBorder(warna,0)); getContentPane().add(labelLogo1,BorderLayout.NORTH); getContentPane().add(barisProg1,BorderLayout.CENTER); timer1 = new Timer(50,new ActionListener() { public void actionPerformed(ActionEvent evt) { time1++; barisProg1.setValue(time1); if(barisProg1.getPercentComplete()==1.0) { timer1.stop(); setVisible(false); new Login(); } } }); timer1.start(); pack(); setLocation(dimensi1.width/2-getWidth()/2, dimensi1.height/2-getHeight()/2); show(); } public static void main(String[] args) { new Cover(); } } login /** * Write a description of class Login here. * Login page * @author dxdx * @version 16 jun 2009 */ import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; public class Login extends JFrame implements ActionListener { private JPanel jpLogin=new JPanel(); private JLabel lblUser=new JLabel("ID"), lblNama=new JLabel("Nama"); private JTextField txtUser=new JTextField(); private JTextField txtNama=new JTextField(); private JButton btnAdd=new JButton("Add"); private JButton btnDelete=new JButton ("Delete"); Login() { super("Simpan & Hapus"); setSize(250,200); jpLogin.setLayout(null); setLocation((Toolkit.getDefaultToolkit().getScreenSize().width-getWidth())/2, (Toolkit.getDefaultToolkit().getScreenSize().height-getHeight())/2); lblUser.setBounds(15,20,100,25); lblNama.setBounds(15,55,100,25); txtUser.setBounds(90,20,120,25); txtNama.setBounds(90,55,120,25); btnAdd.setBounds(15,110,85,25); btnDelete.setBounds(110,110,85,25); txtUser.setHorizontalAlignment(JTextField.LEFT); txtNama.setHorizontalAlignment(JTextField.LEFT); btnAdd.setEnabled(true); btnAdd.addActionListener(this); btnDelete.addActionListener(this); jpLogin.add(lblUser); jpLogin.add(txtUser); jpLogin.add(lblNama); jpLogin.add(txtNama); jpLogin.add(btnAdd); jpLogin.add(btnDelete); getContentPane().add(jpLogin); setVisible(true); } public void actionPerformed(ActionEvent ae) { if(ae.getSource()==btnAdd) { Simpan(); } if(ae.getSource()==btnDelete) { Hapus(); } } void Simpan() { String idUser=txtUser.getText(); String nmUser=txtNama.getText(); try { Class.forName("com.mysql.jdbc.Driver"); try { String URL = "jdbc:mysql://localhost/data"; String user = "root"; String pwd = "dxdx"; Connection conn = DriverManager.getConnection(URL,user,pwd); Statement sttmt = conn.createStatement(); String sql="insert into data values ('"+txtUser.getText() +"','"+txtNama.getText()+"');"; sttmt.executeUpdate(sql); JOptionPane.showMessageDialog(null,"Berhasil disimpan"); new Tampil(); conn.close(); } catch (Exception e2) { System.out.println("Koneksi Error"); } } catch (Exception e1) { System.out.println("Driver not found"); } } void Hapus() { try { Class.forName("com.mysql.jdbc.Driver"); try { String URL = "jdbc:mysql://localhost/data"; String user = "root"; String pwd = "dxdx"; Connection conn = DriverManager.getConnection(URL,user,pwd); Statement sttmt = conn.createStatement(); String sql="delete from data where id='"+txtUser.getText()+"';"; sttmt.executeUpdate(sql); JOptionPane.showMessageDialog(null,"Berhasil dihapus"); new Tampil(); conn.close(); } catch (Exception e2) { System.out.println("Koneksi Error"); } } catch (Exception e1) { System.out.println("Driver not found"); } } } input /** * Write a description of class Login here. * Login page * @author dxdx * @version 16 jun 2009 */ import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; public class Input extends JFrame { private JPanel jpLogin=new JPanel(); private JLabel lblUser=new JLabel("ID"), lblNama=new JLabel("Nama"); private JTextField txtUser=new JTextField(); private JTextField txtNama=new JTextField(); private JButton btnAdd=new JButton("Add"); private JButton btnDelete=new JButton ("Delete"); Input() { super("input"); setSize(250,200); jpLogin.setLayout(null); setLocation((Toolkit.getDefaultToolkit().getScreenSize().width-getWidth())/2, (Toolkit.getDefaultToolkit().getScreenSize().height-getHeight())/2); lblUser.setBounds(15,20,100,25); lblNama.setBounds(15,55,100,25); txtUser.setBounds(90,20,120,25); txtNama.setBounds(90,55,120,25); btnAdd.setBounds(15,110,85,25); btnDelete.setBounds(110,110,85,25); txtUser.setHorizontalAlignment(JTextField.LEFT); txtNama.setHorizontalAlignment(JTextField.LEFT); btnAdd.setEnabled(true); jpLogin.add(lblUser); jpLogin.add(txtUser); jpLogin.add(lblNama); jpLogin.add(txtNama); jpLogin.add(btnAdd); jpLogin.add(btnDelete); getContentPane().add(jpLogin); setVisible(true); } } tampil /** * Write a description of class Login here. * Login page * @author dxdx * @version 16 jun 2009 */ import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.util.*; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; public class Tampil extends JFrame { private JPanel jpTampil=new JPanel(); String[] strJdl={"ID","Nama"}; DefaultTableModel tblModel= new DefaultTableModel(null, strJdl); JTable tabel1= new JTable(); JScrollPane skrTabel=new JScrollPane(); Tampil() { super("Tampil"); setSize(550,250); jpTampil.setLayout(null); setLocation((Toolkit.getDefaultToolkit().getScreenSize().width-getWidth())/2, (Toolkit.getDefaultToolkit().getScreenSize().height-getHeight())/2); tabel1.setModel(tblModel); skrTabel.getViewport().add(tabel1); skrTabel.setBounds(15,20,500,150); jpTampil.add(skrTabel); getContentPane().add(jpTampil); try { tampilTabel(); } catch (Exception e) {} setVisible(true); } void tampilTabel() throws Exception { try { Class.forName("com.mysql.jdbc.Driver"); try { String URL = "jdbc:mysql://localhost/data"; String user = "root"; String pwd = "dxdx"; Connection conn = DriverManager.getConnection(URL,user,pwd); Statement sttmt = conn.createStatement(); String sql="select * from data;"; ResultSet r=sttmt.executeQuery(sql); while (r.next()) { String id=r.getString("id"); String nm=r.getString("nama"); String[] data={id,nm}; tblModel.addRow(data); } conn.close(); } catch (Exception e2) { System.out.println("Koneksi Error"); } } catch (Exception e1) { System.out.println("Driver not found"); } } }