
public class AllContact extends javax.swing.JFrame {
/** Creates new form AllContact */
public AllContact() {
initComponents();
try{
Connection1 con =new Connection1();
Connection conobj=con.open();
String stat="select * from contact";
PreparedStatement pst = conobj.prepareStatement(stat);
ResultSet rs=pst.executeQuery();
ResultSetMetaData rsm=rs.getMetaData();
int rr=0;
while(rs.next()){
rr++;
}int rows=0;
Object data[][]=new Object[rr][4];
for(int j=0;rows>0;j++)
{
data[j][0]="";
data[j][1]="";
data[j][2]="";
data[j][3]="";
rows--;
}
rs=pst.executeQuery();
int i=0;
while(rs.next())
{
data[i][0]=rs.getInt(1);
data[i][1]=rs.getString(2);
data[i][2]=rs.getString(3);
data[i][3]=rs.getDate(4);
i++;
}
rows=i;
jTable1.setModel(new javax.swing.table.DefaultTableModel(
data,
new String [] {
"name", "num"
}
) { boolean[] canEdit = new boolean [] { false, false };
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jTable1.setAutoResizeMode(javax.swing.JTable.AUTORESIZEOFF);
jTable1.getTableHeader().setReorderingAllowed(false);
}catch(Exception e)
{
}
}