1.Without using applet
import java.sql.*;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
public class Sem3Results
{
public static void main(String[] args)
{
System.out.println("Enter Your IDNo");
try
{
BufferedReader bufferRead = new BufferedReader(new InputStreamReader(System.in));
String s = bufferRead.readLine();
Connection conn = DriverManager.getConnection("jdbc:odbc:FirstData");
Statement stmt = conn.createStatement();
String strSelect = "select * from Sem3Results where IDNo ="+s;
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");
System.out.println("IDNo :12141146"+IDNo);
System.out.println("Name :"+Name);
System.out.println("English :" + ENGLISH);
System.out.println("II Language :" + IILANG);
System.out.println("Mathematics :" + MATHEMATICS);
System.out.println("Statistics :"+ STATISTIC);
System.out.println("Computer Science :"+COMPUTERSCIENCE);
System.out.println("Mathematics PR :"+MATHEMATICSPR);
System.out.println("Statistics PR :"+STATISTICSPR);
System.out.println("Computer Science PR :"+COMPUTERSCIENCEPR);
System.out.println("Total :"+TOTAL);
System.out.println("Rank :"+TPOSITION);
System.out.println("Grand Total :"+GrandTOTAL);
System.out.println("Rank :"+GPOSITION);
System.out.println("Percentage :"+PERCENTAGE);
break;
}
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(IOException e)
{
e.printStackTrace();
}
}
}
2. With Applet
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);
}
}
My question is code(1) is executing correctly and retrieving data.
code(2) is executing correctly and failed to retrieve data from database.
Note: Both codes are similar and shows similar output.
There are taken from same database and table too.