Thursday 25 December 2008

Pemanggilan data dari J Table

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {

int row = jTable1.getSelectedRow();
String a="",b="",c="",d="",f="",g="",h="",p="",j="",k="",l="",o="";

try{
Connection con = DriverManager.getConnection("jdbc:odbc:kitra","","");
String sql =" select * from barang where kd_brg='"+tabmode.getValueAt(row, 0).toString()+"'";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
a = rs.getString("kd_brg");
b = rs.getString("nm_brg");
c = rs.getString("no_sj");
d = rs.getString("tgl_masuk");
f = rs.getString("satuan");
g = rs.getString("hrg_sat");
h = rs.getString("ket");
}
}catch(Exception e){}
jTextField1.setText(a);
jTextField2.setText(b);
jComboBox1.setSelectedItem(f);
jTextField3.setText(c);
jTextField4.setText(d);
jTextField5.setText(g);
jTextField6.setText(h);
jTextField1.requestFocus();
int ht = tabmode.getRowCount();
for (int i = 0;i < ht;i++){tabmode.removeRow(0);}
jScrollPane1.setVisible(false);
}

No comments:

Post a Comment