JAVA - MS Access Connectivuty
import java.io.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
public class leave extends Applet
{
String empid = new String();
String empname = new String();
String empalloted = new String();
String emptaken = new String();
String empbalance = new String();
String emprole = new String();
String co = new String();
String result = new String();
String temp = new String();
String query = "SELECT Name FROM leavedetails WHERE Emp_id = ";
int count=0;
Label emp = new Label("Emp-Id");
TextField idtf = new TextField (10);
Button display = new Button(" Show ");
Button clear = new Button(" Clear ");
public void init()
{
add(emp);
add(idtf);
add(display);
add(clear);
display.addActionListener(new bleave());
clear.addActionListener(new clean());
}
class clean implements ActionListener
{
public void actionPerformed (ActionEvent ae)
{
idtf.setText("");
}
}
class bleave implements ActionListener
{
public void actionPerformed(ActionEvent ae)
{
int len;
co = ":";
temp = idtf.getText();
len=temp.length();
if(len == 0)
{
idtf.setText("Enter Emp-Id");
repaint();
}
else
{
temp = idtf.getText();
if( temp.equals("Enter Emp-Id") )
{
idtf.setText("Enter Emp-Id");
}
else
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect =
DriverManager.getConnection("jdbc:odbc:leave","","");
Statement stmt = connect.createStatement();
query = query + temp +";";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
result = result + rs.getString(1);
}
connect.close();
}
catch(ClassNotFoundException cnfe){}
catch(SQLException se){}
count=1;
empid = "Emp-Id ";
empname = "Name ";
empalloted = "Alloted Days ";
emptaken = "Taken ";
empbalance = "Balance ";
emprole="Role ";
repaint();
query = query + temp +";";
System.out.println(query);
}
}
}
}
public void paint(Graphics g)
{
if( count ==1 )
{
g.drawString(empid,40,80);
g.drawString(co,130,80);
g.drawString(idtf.getText() ,150,80);
g.drawString(empname,40,100);
g.drawString(co,130,100);
g.drawString(result,150,100);
g.drawString(emprole,40,120);
g.drawString(co,130,120);
g.drawString(empalloted,40,140);
g.drawString(co,130,140);
g.drawString(emptaken,40,160);
g.drawString(co,130,160);
g.drawString(empbalance,40,180);
g.drawString(co,130,180);
count=0;
}
else
{
}
}
}
