Bind Data form Database in JTable.
public void addtable()
{
j=new JFrame("INVENTORY");
int rowsize=getsize();
System.out.println(""+rowsize);
String cols[]=new String[]{"Product_name","Quantity","Price","TotalPrice","Date"};
String rows[][]=new String[rowsize][5];
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:naveen&jyoti","sa","jyoti7");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from product");
int x=0;
while(rs.next()/*&&x<6*/)
{
System.out.println("first next");
String pro=rs.getString("product_name");
Float qua=rs.getFloat("quantity");
Float pri=rs.getFloat("price");
Float tp=rs.getFloat("totalprice");
Date dt=rs.getDate("date");
rows[x][0]=""+pro;
rows[x][1]=""+qua;
rows[x][2]=""+pri;
rows[x][3]=""+tp;
rows[x][4]=""+dt;
x++;
}
jt=new JTable(rows,cols);
jsp=new JScrollPane(jt);
j.add(jsp);
j.setVisible(true);
j.setSize(450,450);
//j.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
/*jph=new JPanel();
jpb=new JPanel();
jpb.setLayout(new GridLayout(2,2));
jph.add(jsp);
System.out.println("Done");
jpb.add(b1);
jpb.add(b2);
jpb.add(b3);
jpb.add(b4);
//jifi.setLayout(new CardLayout());
jifi.add(jph,BorderLayout.CENTER);
jifi.add(jpb,BorderLayout.SOUTH);
jifi.setVisible(true);*/
}
catch (Exception ex)
{
}
}
private int getsize()
{
int count=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:naveen&jyoti","sa","jyoti7");
Statement stmt=con.createStatement();
String query="select * from product";
ResultSet rs= stmt.executeQuery(query);
while(rs.next())
{
count++;
}
return count;
}
catch(Exception e)
{
return count;
}
}
