مرحبا:الكود التالي لازم يعطيني عدد العناصر بجدول
int i=jComboBox1.getSelectedIndex();
long y=jComboBox2.getSelectedIndex();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:Archive");
Statement s = c.createStatement();
ResultSet r1;ResultSet r2;
int total,same, myID;
r1 =s.executeQuery("select count(*) from Normal_Post ");
total=r1.getInt("NormalPost_ID");
//r2 =s.executeQuery("select count (NormalPost_ID) from Normal_Post where year="+y);
//same=r2.getInt("NormalPost_ID");
// myID=total-same;
jTextField1.setText(Integer.toString(total));
s.close();
c.close();
}
catch(Exception ex){
System.out.println(ex);
}بس عم يظهرلي exception :column not found
