koneksi database

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package yanu.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;

/**
*
* @author yanuarjava
*/
public class koneksi {
static Connection conn=null;


public static Connection getKoneksi(){
try{
Class.forName("com.mysql.jdbc.Driver");
try{
String url="jdbc:mysql://localhost:3306/database";
String user="user";
String pass="password";
conn=DriverManager.getConnection(url,user,pass);
System.out.println("koneksi berhasil");
}catch(SQLException e){
JOptionPane.showMessageDialog(null, "database error..\n"+e.getMessage());
}
}catch(ClassNotFoundException e){
JOptionPane.showMessageDialog(null, "Class Tidak Ditemukan..\n"+e.getMessage());
}
return conn;
}

}

konfigurasi router RIP versi 2

pada router 1

Router>enable
Router#configure terminal
Router(config)#hostname R1
R1(config)#enable secret password
R1(config)#interface fastethernet 0/0
R1(config-if)#ip address 192.168.0.1 255.255.255.0
R1(config-if)#no shutdown
R1(config-if)#exit
R1(config)#interface s2/0
R1(config-if)#ip address 172.16.0.1 255.255.255.252
R1(config-if)#clock rate 64000
R1(config-if)#no shut
R1(config-if)#end

pindah ke router 2

Router>enable
Router#configure terminal
Router(config)#hostname R2
R2(config)#enable secret password
R2(config)#interface fastethernet 0/0
R2(config-if)#ip address 192.168.1.1 255.255.255.0
R2(config-if)#no shutdown
R2(config-if)#exit
R2(config)#interface s2/0
R2(config-if)#ip address 172.16.0.2 255.255.255.252
R2(config-if)#no shut
R12(config-if)#end

pindah ke router 1

Router#configure terminal
R1(config)#router rip
R1(config-router)#ver 2
R1(config-router)#network 192.168.0.0
R1(config-router)#network 172.16.0.0
R1(config-router)#no auto-summary
R1(config)#end
R1#copy running-config startup-config

pindah router 2

Router#configure terminal
R2(config)#router rip
R2(config-router)#ver 2
R2(config-router)#network 192.168.1.0
R2(config-router)#network 172.16.0.0
R2(config-router)#no auto-summary
R2(config)#end
R2#copy running-config startup-config

berikut adalah tutorial videonya dan contoh projecnya

konfigurasi router static

pada router 1

Router>enable
Router#configure terminal
Router(config)#hostname R1
R1(config)#enable secret password
R1(config)#interface fastethernet 0/0
R1(config-if)#ip address 192.168.0.1 255.255.255.0
R1(config-if)#no shutdown
R1(config-if)#exit
R1(config)#interface s2/0
R1(config-if)#ip address 172.16.0.1 255.255.255.252
R1(config-if)#clock rate 64000
R1(config-if)#no shut
R1(config-if)#end

pindah ke router 2

Router>enable
Router#configure terminal
Router(config)#hostname R2
R2(config)#enable secret password
R2(config)#interface fastethernet 0/0
R2(config-if)#ip address 192.168.1.1 255.255.255.0
R2(config-if)#no shutdown
R2(config-if)#exit
R2(config)#interface s2/0
R2(config-if)#ip address 172.16.0.2 255.255.255.252
R2(config-if)#no shut
R12(config-if)#end

pindah ke router 1

Router#configure terminal
R1(config)#ip route 192.168.1.0 255.255.255.0 172.16.0.1
R1(config)#end
R1#copy running-config startup-config

pindah router 2

Router#configure terminal
R2(config)#ip route 192.168.0.0 255.255.255.0 172.16.0.2
R2(config)#end
R2#copy running-config startup-config

berikut adalah tutorial video dan contoh project

konfigurasi 2 komputer with packet tracher

pertama buka paket tracher
buat 2 buah komputer
buat koneksi (alt+c) menggunakan kabel cross
klik pada komputer pertama.
klik destop
pilih ip configuration
pilih static
masukkan ip address misal 192.168.0.2
masukkan subnet mask misal 255.255.255.0
masukkan default gateway 192.168.0.1
klik komputer kedua
pilih menu destop
pilih ip configurasi
pilih static
masukkan ip address 192.169.0.3
masukkan subnet mask 255.255.255.0
masukkan default gateway 192.168.0.1
sudah selesai sekarang tinggal bagaimana mengetahui konek pa gak.

caranya:

masuk komputer pertama
pilih destop
pilih command prompt
ketik ping 192.168.0.3
kalau hasilnya replay from 192.168.0.3: bytes=.... time=....ms TTL=..... (ini berarti konek sudah)

tapi jika hasilnnya request time out atau destination host uncrecable (berati gak konek) ulangi lagi.