Dear All,
Sorry banget nih tanya2 program java, lagi bingung pengen coba koneksikan Java
dengan MY Sql tapi gagal terus....!
Saya punya code Java, tapi setiap di running selalu muncul pesan "TIDAK DAPAT
DETEKSI MYSQL.JDBC".Itu sudah pasti koneksi gagal.
Saya sudah buat parameter CLASSPATH dengan Variable value : C:\mmmysql.
Thank's banget ya untuk jalurnya......
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class frmCuti extends JFrame
{
private Container konten = new Container();
private JPanel panel1 = new JPanel();
private JLabel lblTitle = new JLabel();
private JLabel lblSpace1 = new JLabel();
private JLabel lblSpace2 = new JLabel();
private JLabel lblSpace3 = new JLabel();
private JLabel lblSpace4 = new JLabel();
private JLabel lblJenis = new JLabel();
String sJenis[] = {"Tahunan","Khusus","Besar"};
private JComboBox cmbJenis = new JComboBox(sJenis);
private JLabel lblNRP = new JLabel();
private JTextField txtNRP = new JTextField(20);
private JLabel lblNama = new JLabel();
private JTextField txtNama = new JTextField(20);
private JLabel lblTglMasuk = new JLabel();
private JTextField txtTglMasuk = new JTextField(20);
private JLabel lblCuti = new JLabel();
private JTextField txtCuti = new JTextField(20);
private JLabel lblAlamat = new JLabel();
private JTextField txtAlamat = new JTextField(20);
private JLabel lblAlasan = new JLabel();
private JTextField txtAlasan = new JTextField(20);
private JLabel lblStatus = new JLabel();
private ButtonGroup grpStatus = new ButtonGroup();
private JRadioButton rdTtp = new JRadioButton("Tetap");
private JRadioButton rdKntr = new JRadioButton("Kontrak");
private JRadioButton rdTrn = new JRadioButton("Training");
private JPanel panel2 = new JPanel();
private JLabel lblDept = new JLabel();
String sDept[] = {"Acounting", "Finance", "IT", "Purchasing", "PPC"};
private JList lstDept;
private JLabel lblJabatan = new JLabel();
String sJabatan[] = {"Direktur", "Manager","Foreman","Leader","Operator"};
private JList lstJabatan;
private JPanel panel3 = new JPanel();
private JButton cmdAdd = new JButton("Tambah");
private JButton cmdSave = new JButton("Update");
private JButton cmdDel = new JButton("Hapus");
private JButton cmdFind = new JButton("Cari");
private JButton cmdExit = new JButton("Exit");
private JPanel panel4 = new JPanel();
String dbUrl = "jdbc:mysql://localhost/dbCuti?user=root&password=";
private Statement st;
ResultSet RS;
frmCuti()
{
super("PT.Hanken Indonesia");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setLocation(10,100);
this.setSize(940,380);
setResizable(false);
konten=getContentPane();
konten.setLayout(new FlowLayout(FlowLayout.CENTER));
lblTitle.setFont(new Font("Tahoma",Font.BOLD,14));
lblTitle.setForeground(Color.BLUE);
lblTitle.setText("Form Permohonan Cuti");
lblJenis.setText("Jenis Cuti : ");
lblNRP.setText("NRP");
lblNama.setText("Nama");
lblTglMasuk.setText("Tgl. Masuk Kerja");
lblAlamat.setText("Alamat");
lblCuti.setText("Sisa Cuti");
lblStatus.setText("Status Karyawan");
lblDept.setText("Sec/Dept");
lblJabatan.setText("Jabatan");
lblAlasan.setText("Alasan Cuti");
panel1.setLayout(new GridLayout(5,4));
panel1.add(lblTitle);
panel1.add(lblSpace1);
panel1.add(lblSpace2);
panel1.add(lblSpace3);
panel1.add(lblSpace4);
cmbJenis.setSelectedIndex(1);
cmbJenis.setMaximumRowCount(3);
panel1.add(lblJenis);
panel1.add(cmbJenis);
panel1.add(lblNRP);
panel1.add(txtNRP);
panel1.add(lblNama);
panel1.add(txtNama);
panel1.add(lblCuti);
panel1.add(txtCuti);
panel1.add(lblTglMasuk);
panel1.add(txtTglMasuk);
panel1.add(lblAlamat);
panel1.add(txtAlamat);
panel1.add(lblAlasan);
panel1.add(txtAlasan);
panel2.setLayout(new GridLayout(1,4));
lstDept = new JList(sDept);
lstDept.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
panel2.add(lblDept);
panel2.add(new JScrollPane(lstDept));
lstJabatan = new JList(sJabatan);
lstJabatan.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
panel2.add(lblJabatan);
panel2.add(new JScrollPane(lstJabatan));
panel3.setLayout(new GridLayout(2,4));
panel3.add(lblStatus);
grpStatus.add(rdTtp);
grpStatus.add(rdKntr);
grpStatus.add(rdTrn);
panel3.add(rdTtp);
panel3.add(rdKntr);
panel3.add(rdTrn);
panel3.add(lblSpace1);
itemHandler itemHandler = new itemHandler();
panel3.add(cmdAdd);
cmdAdd.addActionListener(itemHandler);
panel3.add(cmdSave);
cmdSave.addActionListener(itemHandler);
panel3.add(cmdDel);
cmdDel.addActionListener(itemHandler);
panel3.add(cmdFind);
cmdFind.addActionListener(itemHandler);
panel3.add(cmdExit);
cmdExit.addActionListener(itemHandler);
panel4.setLayout(new BorderLayout());
panel4.add(panel1, BorderLayout.NORTH);
panel4.add(panel2, BorderLayout.CENTER);
panel4.add(panel3, BorderLayout.SOUTH);
konten.add(panel4, BorderLayout.EAST);
show();
ConnectToDatabase();
}
private class itemHandler implements ActionListener
{public void actionPerformed(ActionEvent e)
{Object obj=e.getSource();
if(obj==cmdSave)
{
String sTampil;
sTampil="Jenis Cuti : ";
sTampil+=cmbJenis.getItemAt(cmbJenis.getSelectedIndex());
sTampil+= "\nNRP : " + txtNRP.getText();
sTampil+= "\nNama : " + txtNama.getText();
sTampil+= "\nTgl. Masuk Kerja : " + txtTglMasuk.getText();
sTampil+= "\nAlamat: " + txtAlamat.getText();
sTampil+= "\nSisa Cuti: " + txtCuti.getText();
sTampil+= "\nSec/Dept : ";
if (lstDept.isSelectedIndex(0)) sTampil+= sDept[0];
if (lstDept.isSelectedIndex(1)) sTampil+= sDept[1];
if (lstDept.isSelectedIndex(2)) sTampil+= sDept[2];
if (lstDept.isSelectedIndex(3)) sTampil+= sDept[3];
if (lstDept.isSelectedIndex(4)) sTampil+= sDept[4];
sTampil+= "\nJabatan : ";
if (lstJabatan.isSelectedIndex(0)) sTampil+= sJabatan[0];
if (lstJabatan.isSelectedIndex(1)) sTampil+= sJabatan[1];
if (lstJabatan.isSelectedIndex(2)) sTampil+= sJabatan[2];
if (lstJabatan.isSelectedIndex(3)) sTampil+= sJabatan[3];
if (lstJabatan.isSelectedIndex(4)) sTampil+= sJabatan[4];
JOptionPane.showMessageDialog(null, sTampil , "PT. ABC",
JOptionPane.INFORMATION_MESSAGE);
}
else {System.exit (0);}
}
}
private void ConnectToDatabase()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
Connection Conn = DriverManager.getConnection(dbUrl);
st = Conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE
);
} catch (Exception e) {
JOptionPane.showMessageDialog
(null,"Tidak Dapat Deteksi MYSQL.JDBC","JDBC",
JOptionPane.PLAIN_MESSAGE);
System.exit(0);
}
}
public static void main(String args[])
{
new frmCuti();
}
}
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
$$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
:: SPONSOR -----------------------------------------------
Web hosting 1GB space cuma Rp. 65ribu/bln
Multiple website, free domain name. http://www.rakdata.com
----------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
