..:::KALENDER AKADEMIK GANJIL 2012/2013:::..

1. Kuliah semester genap tahun 2011/2012 berakhir 02 Juni 2012 2. Minggu Tenang tgl 04 Juni s/d 09 Juni 2012
3. Ujian semester genap 2011/2012 Mulai Tanggal 11 Juni s/d 23 Juni 2012 4. Ujian sistem kombinasi Mulai Tanggal 25 Juni s/d 30 Juni 2012
5. Pengumpulan skripsi semester genap 2011/2012 paling lambat tanggal : 28 Juni 2012
6. Pembayaran uang kuliah semester ganjil 2012/2013 04 Juni s/d 6 Juli 2012,dengan distribusi :     - Sistem Informasi                       04 Juni s/d 04 Juli 2012
    - Sistem Komputer                       04 Juni s/d 02 Juli 2012
    - Mnj Informatika                        04 Juni s/d 02 Juli 2012
    - Teknik Informatika                   04 Juni s/d 03 Juli 2012
    - Desain Komunikasi Visual         04 Juni s/d 06 Juli 2012
    - Fekon (Akt-S1 Dan Mnj-S1)     04 Juni s/d 05 Juli 2012
    - Psikologi                                     04 Juni s/d 06 Juli 2012
    - Teknik ( I, E, A, S )                   04 Juni s/d 06 Juli 2012
    - Fak.PTIK                                   04 Juni s/d 06 Juli 2012
6. Pelaksanaan PA Online mulai tgl 30 Juli s/d 05 Agustus 2012 Untuk Semua Program Studi 7. Awal Kuliah Semester Ganjil 2012/2013 Tanggal : 27 Agustus 2012 

http://upi-yptk.ac.id

Cara Meningkatkan Kecepatan Browser Firefox

    Keunggulan browser firefox yang disinyalir sebagai browser tercepat yang ada, juga memiliki dukungan pihak ke 3 atau add-ons. Tahukah anda meskipun firefox sudah cepat dapat dioptimalkan lagi caranya sebagai berikut:

1. Buka firefox

2. Pada address bar ketik about:config kemudian enter. Jika keluar tombol I’ll be careful, I promise!
Klik saja.



3. Klik kanan di layar firefox yang anda lihat (klik di mana saja) kemudian pilih new lalu integer

4. pada kotak dialog New Integer value isi dengan nglayout.initialpaint.delay kemudian isi nilainya (value) dengan 0 (nol)

5. kemudian cari tulisan network.http.pipelining klik 2x agar berubah menjadi true

6. Lalu cari tulisan network.http.pipelining.maxrequests kemudian klik 2x lalu isi dengan nomor antara 10 – 30.

7. Restart Firefix


GAMPANG KAN.....
SELAMAT MENCOBA YA...

TUGAS AKHIR OOP,,,
simpan,edit,hapus dan keluar

1. syintak di java
import java.sql.*;
import javax.swing.*;
import javax.swing.JTable.*;


public class FrameMenu extends javax.swing.JFrame {
String user = "root";
String host = "localhost";
String db = "mhs";
String site="";
private Object lapor;
   
    public FrameMenu() {
        initComponents();
    }

private void tampilDATA(){
String[] columnNames={"BP","NAMA","JURUSAN","FAKULTAS","NILAI UTS","NILAI UAS","NILAI HURUF"};
JTable table=new JTable(getData(),columnNames);
}


   
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                         
    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        tbp = new javax.swing.JTextField();
        tnm = new javax.swing.JTextField();
        tjuru = new javax.swing.JTextField();
        tfak = new javax.swing.JTextField();
        tuts = new javax.swing.JTextField();
        tuas = new javax.swing.JTextField();
        thrf = new javax.swing.JTextField();
        bsimpan = new javax.swing.JButton();
        bedit = new javax.swing.JButton();
        bhapus = new javax.swing.JButton();
        bkeluar = new javax.swing.JButton();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTable2 = new javax.swing.JTable();

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jLabel1.setText("NO BP");

        jLabel2.setText("NAMA");

        jLabel3.setText("JURUSAN");

        jLabel4.setText("FAKULTAS");

        jLabel5.setText("NILAI UTS");

        jLabel6.setText("NILAI UAS");

        jLabel7.setText("NILAI HURUF");

        tbp.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tbpKeyPressed(evt);
            }
        });

        tuas.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                tuasKeyPressed(evt);
            }
        });

        bsimpan.setText("SIMPAN");
        bsimpan.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bsimpanActionPerformed(evt);
            }
        });

        bedit.setText("EDIT");
        bedit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                beditActionPerformed(evt);
            }
        });

        bhapus.setText("HAPUS");
        bhapus.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bhapusActionPerformed(evt);
            }
        });

        bkeluar.setText("KELUAR");
        bkeluar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bkeluarActionPerformed(evt);
            }
        });

        jTable2.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "BP", "NAMA", "UTS", "UAS", "HURUF"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane2.setViewportView(jTable2);
        jTable2.getColumnModel().getColumn(0).setHeaderValue("BP");
        jTable2.getColumnModel().getColumn(1).setHeaderValue("NAMA");
        jTable2.getColumnModel().getColumn(2).setHeaderValue("UTS");
        jTable2.getColumnModel().getColumn(3).setHeaderValue("UAS");
        jTable2.getColumnModel().getColumn(4).setHeaderValue("HURUF");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 639, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addContainerGap())
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel1)
                                    .addComponent(jLabel2)
                                    .addComponent(jLabel3)
                                    .addComponent(jLabel4))
                                .addGap(85, 85, 85)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(tfak)
                                    .addComponent(tjuru)
                                    .addComponent(tnm)
                                    .addComponent(tbp, javax.swing.GroupLayout.DEFAULT_SIZE, 165, Short.MAX_VALUE)))
                            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel6)
                                    .addComponent(jLabel5)
                                    .addComponent(jLabel7))
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 171, Short.MAX_VALUE)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(thrf)
                                    .addComponent(tuas, javax.swing.GroupLayout.Alignment.TRAILING)
                                    .addComponent(tuts, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 65, Short.MAX_VALUE))))
                        .addGap(179, 179, 179)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                .addComponent(bhapus, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(bedit, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(bsimpan, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 86, Short.MAX_VALUE))
                            .addComponent(bkeluar))
                        .addGap(317, 317, 317))))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(23, 23, 23)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(tbp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(bsimpan))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(tnm, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(bedit))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(tjuru, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(bhapus))
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGap(18, 18, 18)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel4)
                            .addComponent(tfak, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(18, 18, 18)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel5)
                            .addComponent(tuts, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(18, 18, 18)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel6)
                            .addComponent(tuas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(18, 18, 18)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel7)
                            .addComponent(thrf, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 121, Short.MAX_VALUE)
                        .addComponent(bkeluar)
                        .addGap(29, 29, 29)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(30, 30, 30))
        );

        pack();
    }// </editor-fold>                       

    private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) {                                       
       this.dispose();
    }                                      

    private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {                                      
    try{
Class.forName("com.mysql.jdbc.Driver");
site="jdbc:mysql://" + host + "/" + db + "?user=" + user;
Connection koneksi=DriverManager.getConnection(site);
Statement st=koneksi.createStatement();
int psn=st.executeUpdate("delete from data "+" where bp="+"'"+tbp.getText()+"'");
if (psn>0){
JOptionPane.showMessageDialog(this, "DATA BERHASIL DI HAPUS");
bersih();

}
st.close();
koneksi.close();
}
catch(SQLException e){
JOptionPane.showMessageDialog(this,"GAGAL HAPUS" + e);
}
catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(this,"jdbc Driver tidak ditemukan");
}
tampilDATA();


    }                                     

    private void beditActionPerformed(java.awt.event.ActionEvent evt) {                                     
     try{
Class.forName("com.mysql.jdbc.Driver");
site="jdbc:mysql://" + host + "/" + db + "?user=" + user;
Connection koneksi=DriverManager.getConnection(site);
Statement st=koneksi.createStatement();

int psn=st.executeUpdate("update data "+" " +
"set nm="+"'"+tnm.getText()+"',"+
"juru="+"'"+tjuru.getText()+"',"+
"faku="+"'"+tfak.getText()+"',"+
"uts="+"'"+tuts.getText()+"'," +
"uas="+"'"+tuas.getText()+"',"  +
"huruf="+"'"+thrf.getText()+"'"+
"where bp="+"'"+tbp.getText()+"'");
if (psn>0){
JOptionPane.showMessageDialog(this, "DATA BERHASIL DI EDIT");
bersih();
}
st.close();
koneksi.close();
}
catch(SQLException e){
JOptionPane.showMessageDialog(this,"GAGAL EDIT" + e);
}
catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(this,"jdbc Driver tidak ditemukan");
}
tampilDATA();

    }                                    

    private void tbpKeyPressed(java.awt.event.KeyEvent evt) {                              
      int ASCII=evt.getKeyCode();
if(ASCII==10)
{
try{
Class.forName("com.mysql.jdbc.Driver");
site="jdbc:mysql://" + host + "/" + db + "?user=" + user;
Connection koneksi=DriverManager.getConnection(site);
Statement st=koneksi.createStatement();
ResultSet tampil = st.executeQuery("select * from data where bp='"+tbp.getText()+"'");
while(tampil.next())
{
tnm.setText(tampil.getString("nm"));
tjuru.setText(tampil.getString("juru"));
tfak.setText(tampil.getString("faku"));
tuts.setText(tampil.getString("uts"));
tuas.setText(tampil.getString("uas"));
thrf.setText(tampil.getString("huruf"));
tampil.close();
st.close();
}
}
catch(SQLException e){}
catch(ClassNotFoundException e){}
tuts.requestFocus();
}

    }                             

    private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {                                       
        try{
Class.forName("com.mysql.jdbc.Driver");
site="jdbc:mysql://" + host + "/" + db + "?user=" + user;
Connection koneksi=DriverManager.getConnection(site);
Statement st=koneksi.createStatement();
int psn=st.executeUpdate("insert into data"+"(bp,nm,juru,faku,uts,uas,huruf) values" +
"("+"'"+tbp.getText()+"'," +
" "+"'"+tnm.getText()+"',"+
"'"+"'"+tjuru.getText()+"',"+
"'"+"'"+tfak.getText()+"'," +
"'"+"'"+tuts.getText()+"',"+
"'"+"'"+tuas.getText()+"',"+
"'"+"'"+thrf.getText()+"')");
if (psn>0){
JOptionPane.showMessageDialog(this, "DATA BEHASIL DISIMPAN");
bersih();
}
st.close();
koneksi.close();

}
catch(SQLException e){
JOptionPane.showMessageDialog(this,"GAGAL MENYIMPAN" + e);
}
catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(this,"jdbc Driver tidak ditemukan");
}
tampilDATA();

    }                                      

    private void tuasKeyPressed(java.awt.event.KeyEvent evt) {                               
 int ASCII=evt.getKeyCode();
if(ASCII==10)
{
int a = Integer.parseInt(tuts.getText());
int b = Integer.parseInt(tuas.getText());
String huruf="";
int jml = (a + b)/2;

if (jml>=80){
huruf="A";
}else if (a>=65){
huruf="B";
}else if (jml>=55){
huruf="C";
}else if (jml>=45){
huruf="D";
}else{
huruf="E";
}
thrf.setText(huruf);
}
    }                              






    private Object[][] getData(){
Object[][] data=null;
try{
Class.forName("com.mysql.jdbc.Driver");
site="jdbc:mysql://" + host + "/" + db + "?user=" + user;
Connection koneksi=DriverManager.getConnection(site);
Statement st=koneksi.createStatement();
ResultSet hasil=st.executeQuery("Select bp,nm,juru,faku,huruf from data");
hasil.last();
int rowCount =hasil.getRow();
hasil.beforeFirst();
data= new Object[rowCount][5];
int no=-1;
while (hasil.next()){
no=no+1;
data[no][0]=hasil.getString(1);
data[no][1]=hasil.getString(2);
data[no][2]=hasil.getString(3);
data[no][3]=hasil.getString(4);
data[no][4]=hasil.getString(5);
data[no][5]=hasil.getString(6);
data[no][6]=hasil.getString(7);
}
st.close();
}
catch (SQLException e){}
catch (ClassNotFoundException e){}
return data;
}

private void bersih(){
tbp.setText("");
tnm.setText("");
tjuru.setText("");
tfak.setText("");
tuts.setText("");
tuas.setText("");
thrf.setText("");
tbp.requestFocus();
}




    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new FrameMenu().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                    
    private javax.swing.JButton bedit;
    private javax.swing.JButton bhapus;
    private javax.swing.JButton bkeluar;
    private javax.swing.JButton bsimpan;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable2;
    private javax.swing.JTextField tbp;
    private javax.swing.JTextField tfak;
    private javax.swing.JTextField thrf;
    private javax.swing.JTextField tjuru;
    private javax.swing.JTextField tnm;
    private javax.swing.JTextField tuas;
    private javax.swing.JTextField tuts;
    // End of variables declaration                  

}











2.syintak SQL


CREATE TABLE `data` (
`bp` VARCHAR(14) NOT NULL,
`nm` VARCHAR(30) NOT NULL,
`juru` VARCHAR(20) NOT NULL,
`faku` VARCHAR(20) NOT NULL,
`uts` INT(5) DEFAULT '0' NOT NULL,
`uas` INT(5) DEFAULT '0' NOT NULL,
`huruf` CHAR(3) NOT NULL,
PRIMARY KEY (`bp`)
);