Code is below it executing without an error but not retrieving data from sql data base.
Would you please check my code and give solution ASAP
import java.sql.*;
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
public class Sem3ResultsApplet extends Applet implements ItemListener,ActionListener,MouseListener
{
Label LIDNo;
TextField IDNo;
Button GO;
String Name;
int ENGLISH;
int IILANG;
int MATHEMATICS;
int STATISTIC;
int COMPUTERSCIENCE;
int MATHEMATICSPR;
int STATISTICSPR;
int COMPUTERSCIENCEPR;
int TOTAL;
int TPOSITION;
int GrandTOTAL;
int GPOSITION;
float PERCENTAGE;
public void init()
{
LIDNo = new Label("Enter Your IDNo :",Label.LEFT);
IDNo = new TextField(8);
GO = new Button("GO");
add(LIDNo);
add(IDNo);
add(GO);
IDNo.addActionListener(this);
GO.addActionListener(this);
addMouseListener(this);
}
public void mouseClicked(MouseEvent me) {
}
public void mouseEntered(MouseEvent me) {
}
public void mouseExited(MouseEvent me) {
}
public void mouseReleased(MouseEvent me) {
}
public void mousePressed(MouseEvent me) {
}
public void actionPerformed(ActionEvent ae)
{
String str = ae.getActionCommand();
if (ae.getSource() == GO)
{
try
{
Connection conn = DriverManager.getConnection("jdbc:odbc:FirstData");
Statement stmt = conn.createStatement();
String strSelect = "select * from Sem3Results where IDNo ="+IDNo.getText();
ResultSet rset = stmt.executeQuery(strSelect);
while(rset.next())
{
int IDNo= rset.getInt("IDNo");
String Name= rset.getString("Name");
int ENGLISH= rset.getInt("ENGLISH");
int IILANG= rset.getInt("IILANG");
int MATHEMATICS= rset.getInt("MATHEMATICS");
int STATISTIC= rset.getInt("STATISTIC");
int COMPUTERSCIENCE= rset.getInt("COMPUTERSCIENCE");
int MATHEMATICSPR= rset.getInt("MATHEMATICSPR");
int STATISTICSPR= rset.getInt("STATISTICSPR");
int COMPUTERSCIENCEPR= rset.getInt("COMPUTERSCIENCEPR");
int TOTAL= rset.getInt("TOTAL");
int TPOSITION= rset.getInt("TPOSITION");
int GrandTOTAL= rset.getInt("GrandTOTAL");
int GPOSITION= rset.getInt("GPOSITION");
float PERCENTAGE= rset.getFloat("PERCENTAGE");
break;
}
repaint();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
public void itemStateChanged(ItemEvent ie) {
repaint();
}
public void paint(Graphics g)
{
g.drawString("IDNo :12141146"+IDNo.getText(),100,100);
g.drawString("Name :"+Name,100,120);
g.drawString("ENGLISH :"+ENGLISH,100,140);
g.drawString("IILANG :"+IILANG,100,160);
g.drawString("MATHEMATICS :"+MATHEMATICS,100,180);
g.drawString("STATISTICS :"+STATISTIC,100,200);
g.drawString("COMPUTERSCIENCE :"+COMPUTERSCIENCE,100,220);
g.drawString("MATHEMATICSPR :"+MATHEMATICSPR,100,240);
g.drawString("STATISTICSPR :"+STATISTICSPR,100,260);
g.drawString("COMPUTERSCIENCEPR :"+COMPUTERSCIENCEPR,100,280);
g.drawString("TOTAL :"+TOTAL,100,300);
g.drawString("TPOSITION :"+TPOSITION,100,320);
g.drawString("GrandTOTAL :"+GrandTOTAL,100,340);
g.drawString("GPOSITION :"+GPOSITION,100,360);
g.drawString("PERCENTAGE :"+PERCENTAGE,100,380);
}
}