import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
public class DatabaseRough extends JFrame implements ActionListener
{
JFrame f,abc,pqr,abq,rtf,rog,ros;
JPanel ab1,ab2,p1,p2,p3,p4,a1,a2,b1,b2,po1,po2,pol1,pol2,poh1,poh2;
JTabbedPane tp,bq,bqr,adp,post,pot,pog;
JButton zp1,zp2,zp3,zpg1,zpg2,zpg3,zpq1,zpq2,zpq3,z1,z2,z3,sub1,can1,dis1,jb2,jb21,disp,studentbtn,miprojectbtn,maprojectbtn,seminarbtn,submitback,career1,career2,dispcareer,req,stubtn;
JLabel dp1,dp2,dp3,dp4,dp5,dpg1,dpg2,dpg3,dpg4,dpg5,dpq1,dpq2,dpq3,dpq4,dpq5,pb1,pb2,pb3,pb4,pb5,pb6,pb7,pb8,pb9,pb10,pb11,ro1,ro2,ro3,l1,l2,l3,jl2,jl3,jl4,jl5,jl6,jl7;
JTextField gp1,gp2,gp3,gp4,gp5,gpg1,gpg2,gpg3,gpg4,gpg5,gpq1,gpq2,gpq3,gpq4,gpq5,g1,g2,g3,g4,g5,g6,g7,g8,g9,g10,g11,fi1,fi2,fi3,tf1,tf2,jt2,jt3,jt4,jt5,jt6,jt7;
// MAIN LAYOUT
DatabaseRough()
{
f=new JFrame("DATABASE DETAILED");
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
tp=new JTabbedPane();
studentbtn = new JButton(" STUDENT DETAILS ");
miprojectbtn = new JButton(" MINOR PROJECT PROFILE ");
maprojectbtn = new JButton(" MAJOR PROJECT PROFILE ");
seminarbtn = new JButton(" SEMINAR PROFILE ");
submitback = new JButton(" DISPLAY ");
career2 = new JButton(" CAREER > 60 % ");
career1 = new JButton(" CAREER < 60 % ");
dispcareer = new JButton(" DISPLAY CAREER ");
req = new JButton(" RECRUITMENT DETAIL ");
stubtn = new JButton(" STUDENT DETAIL ");
l1=new JLabel(" FILTERING OPTION : ");
l2=new JLabel(" ENTER THE NUMBER OF BACKLOGS : ");
tf1=new JTextField(2);
l3=new JLabel(" ENTER THE CAREER PERCENTAGE : ");
tf2=new JTextField(2);
p1.add(studentbtn);
p1.add(miprojectbtn);
p1.add(maprojectbtn);
p1.add(seminarbtn);
p2.add(career1);
p2.add(career2);
p2.add(l3);
p2.add(tf2);
p2.add(dispcareer);
p3.add(l1);
p3.add(l2);
p3.add(tf1);
p3.add(submitback);
p4.add(req);
p4.add(stubtn);
miprojectbtn.addActionListener(this);
career1.addActionListener(this);
career2.addActionListener(this);
dispcareer.addActionListener(this);
studentbtn.addActionListener(this);
req.addActionListener(this);
stubtn.addActionListener(this);
submitback.addActionListener(this);
maprojectbtn.addActionListener(this);
seminarbtn.addActionListener(this);
}
// "SEMINAR PROFILE " LAYOUT of "STUDENT PROFILE Section"
public class seminar extends JFrame
{
public seminar()
{
try
{
ros = new JFrame("STUDENT DETAILS ....");
poh1 = new JPanel();
poh2 = new JPanel();
pog = new JTabbedPane();
ros.getContentPane().add(pog);
pog.addTab(" ADD NEW ...",poh1);
pog.addTab(" DISPLAY ...",poh2);
dpg1=new JLabel("Name of the Student :");
dpg2=new JLabel("Year :");
dpg3=new JLabel("Branch :");
dpg4=new JLabel("Seminar Topic :");
dpg5=new JLabel("Abstract :");
gpg1=new JTextField(20);
gpg2=new JTextField(4);
gpg3=new JTextField(20);
gpg4=new JTextField(20);
gpg5=new JTextField(900);
zpg1=new JButton("SUBMIT");
zpg2=new JButton("CANCEL");
zpg3=new JButton("DISPLAY RECORDS");
poh1.add(dpg1);poh1.add(gpg1);
poh1.add(dpg2);poh1.add(gpg2);
poh1.add(dpg3);poh1.add(gpg3);
poh1.add(dpg4);poh1.add(gpg4);
poh1.add(dpg5);poh1.add(gpg5);
poh1.add(zpg1);poh1.add(zpg2);
poh2.add(zpg3);
ros.setSize(500,500);
ros.setVisible(true);
ros.repaint();
// HANDLES WHEN "CANCEL" BUTTON IS CLICKED
zpg2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==zpg2)
{
ros.dispose();
}
}
});
zpg3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==zpg3)
{
// object refrence of "report" is used
JFrame frm = new viewseminar();
frm.setSize(600, 600);
frm.setLocation(50,50);
frm.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF RECRUIMENT DETAIL(RECRUITMENT SECTION) IS CLICKED
zpg1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==zpg1)
{
String value1=gpg1.getText();
String value2=gpg2.getText();
String value3=gpg3.getText();
String value4=gpg4.getText();
String value5=gpg5.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into seminar(name,year,branch,topic,abstract) values(?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.executeUpdate();
JOptionPane.showMessageDialog(ros,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(ros,"Error in submitting data!");
}
}
}
});
}
catch(Exception exe){}
}
}
// DISPLAY SEMINAR PROJECT RECORDS(SEMIANR PROFILE) IN STUDENT PROFILE SECTION
public class viewseminar extends JFrame
{
PreparedStatement ps;
Connection con;
ResultSet rs;
Statement st;
JLabel l1;
String nam,br,topic,abs;
int yr;
int rows = 0;
Object data1[][];
JScrollPane scroller;
JTable table;
public viewseminar()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
st = con.createStatement ();
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=st.executeQuery("SELECT * from seminar");
while(rs.next())
{
nam = rs.getString(1);
yr = rs.getInt(2);
br = rs.getString(3);
topic = rs.getString(3);
abs = rs.getString(3);
rows++;
}
data1=new Object[rows][5];
Object[] Colheads={"name","year","branch","seminar-topic","abstract"};
rs=st.executeQuery("Select * from seminar");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<5;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
}
try{
data1=new Object[rows][5];
Object[] Colheads={"name","year","branch","seminar-topic","abstract"};
rs=st.executeQuery("Select * from seminar");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<5;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}
catch(Exception e)
{
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// "MAJOR PROJECT PROFILE " LAYOUT of "STUDENT PROFILE Section"
public class majorpp extends JFrame
{
public majorpp()
{
try
{
rog = new JFrame("STUDENT DETAILS ....");
pol1 = new JPanel();
pol2 = new JPanel();
pot = new JTabbedPane();
rog.getContentPane().add(pot);
pot.addTab(" ADD NEW ...",pol1);
pot.addTab(" DISPLAY ...",pol2);
dpq1=new JLabel("Name of the Student :");
dpq2=new JLabel("Year :");
dpq3=new JLabel("Branch :");
dpq4=new JLabel("Project Name :");
dpq5=new JLabel("Abstract :");
gpq1=new JTextField(20);
gpq2=new JTextField(4);
gpq3=new JTextField(20);
gpq4=new JTextField(20);
gpq5=new JTextField(900);
zpq1=new JButton("SUBMIT");
zpq2=new JButton("CANCEL");
zpq3=new JButton("DISPLAY RECORDS");
pol1.add(dpq1);pol1.add(gpq1);
pol1.add(dpq2);pol1.add(gpq2);
pol1.add(dpq3);pol1.add(gpq3);
pol1.add(dpq4);pol1.add(gpq4);
pol1.add(dpq5);pol1.add(gpq5);
pol1.add(zpq1);pol1.add(zpq2);
pol2.add(zpq3);
rog.setSize(500,500);
rog.setVisible(true);
rog.repaint();
// HANDLES WHEN "CANCEL" BUTTON IS CLICKED
zpq2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==zpq2)
{
rog.dispose();
}
}
});
zpq3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==zpq3)
{
// object refrence of "report" is used
JFrame frm = new viewmajor();
frm.setSize(600, 600);
frm.setLocation(50,50);
frm.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF RECRUIMENT DETAIL(RECRUITMENT SECTION) IS CLICKED
zpq1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==zpq1)
{
String value1=gpq1.getText();
String value2=gpq2.getText();
String value3=gpq3.getText();
String value4=gpq4.getText();
String value5=gpq5.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into major(name,year,branch,prjname,abstract) values(?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.executeUpdate();
JOptionPane.showMessageDialog(rog,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(rog,"Error in submitting data!");
}
}
}
});
}
catch(Exception exe){}
}
}
// DISPLAY MINOR PROJECT RECORDS(MINOR PROJECT PROFILE) IN STUDENT PROFILE SECTION
public class viewmajor extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,pnam,br,abs;
int yr;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from major";
public viewmajor()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
ps=con.prepareStatement(que);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
yr = rs.getInt(2);
br = rs.getString(3);
pnam = rs.getString(4);
abs = rs.getString(5);
rows++;
}
data1=new Object[rows][5];
Object[] Colheads={"name","year","branch","project name","abstract"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// "MINOR PROJECT PROFILE " LAYOUT of "STUDENT PROFILE Section"
public class minorpp extends JFrame
{
public minorpp()
{
try
{
rtf = new JFrame("STUDENT DETAILS ....");
po1 = new JPanel();
po2 = new JPanel();
post = new JTabbedPane();
rtf.getContentPane().add(post);
post.addTab(" ADD NEW ...",po1);
post.addTab(" DISPLAY ...",po2);
dp1=new JLabel("Name of the Student :");
dp2=new JLabel("Year :");
dp3=new JLabel("Branch :");
dp4=new JLabel("Project Name :");
dp5=new JLabel("Abstract :");
gp1=new JTextField(20);
gp2=new JTextField(4);
gp3=new JTextField(20);
gp4=new JTextField(20);
gp5=new JTextField(900);
zp1=new JButton("SUBMIT");
zp2=new JButton("CANCEL");
zp3=new JButton("DISPLAY RECORDS");
po1.add(dp1);po1.add(gp1);
po1.add(dp2);po1.add(gp2);
po1.add(dp3);po1.add(gp3);
po1.add(dp4);po1.add(gp4);
po1.add(dp5);po1.add(gp5);
po1.add(zp1);po1.add(zp2);
po2.add(zp3);
rtf.setSize(500,500);
rtf.setVisible(true);
rtf.repaint();
// HANDLES WHEN "CANCEL" BUTTON IS CLICKED
zp2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==zp2)
{
rtf.dispose();
}
}
});
zp3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==zp3)
{
// object refrence of "report" is used
JFrame frm = new viewminor();
frm.setSize(600, 600);
frm.setLocation(50,50);
frm.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF RECRUIMENT DETAIL(RECRUITMENT SECTION) IS CLICKED
zp1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==zp1)
{
String value1=gp1.getText();
String value2=gp2.getText();
String value3=gp3.getText();
String value4=gp4.getText();
String value5=gp5.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into minor(name,year,branch,prjname,abstract) values(?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.executeUpdate();
JOptionPane.showMessageDialog(rtf,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(rtf,"Error in submitting data!");
}
}
}
});
}
catch(Exception exe){}
}
}
// DISPLAY MINOR PROJECT RECORDS(MINOR PROJECT PROFILE) IN STUDENT PROFILE SECTION
public class viewminor extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,pnam,br,abs;
int yr;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from minor";
public viewminor()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
ps=con.prepareStatement(que);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
yr = rs.getInt(2);
br = rs.getString(3);
pnam = rs.getString(4);
abs = rs.getString(5);
rows++;
}
data1=new Object[rows][5];
Object[] Colheads={"name","year","branch","project name","abstract"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// "RECRUITMENT DETAIL" LAYOUT of Recruitment Section
public class Recui extends JFrame
{
public Recui()
{
try
{
pqr = new JFrame("RECRUITMENT DETAILS ....");
b1 = new JPanel();
b2 = new JPanel();
bqr = new JTabbedPane();
pqr.getContentPane().add(bqr);
bqr.addTab(" ADD NEW ...",b1);
bqr.addTab(" DISPLAY ...",b2);
ro1=new JLabel(" Name of the Company : ");
ro2=new JLabel(" No. of rounds conducted in interviews : ");
ro3=new JLabel(" Interview Question : ");
fi1=new JTextField(20);
fi2=new JTextField(2);
fi3=new JTextField(900);
sub1=new JButton("SUBMIT");
can1=new JButton("CANCEL");
dis1=new JButton("DISPLAY RECORDS");
b1.add(ro1);b1.add(fi1);
b1.add(ro2);b1.add(fi2);
b1.add(ro3);b1.add(fi3);
b1.add(sub1);b1.add(can1);// Adding Cancel Button
b2.add(dis1);
pqr.setSize(500,500);
pqr.setVisible(true);
pqr.repaint();
// HANDLES WHEN "CANCEL" BUTTON IS CLICKED
can1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==can1)
{
pqr.dispose();
}
}
});
dis1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==dis1)
{
// object refrence of "report" is used
JFrame frm1 = new review();
frm1.setSize(600, 600);
frm1.setLocation(50,50);
frm1.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF RECRUIMENT DETAIL(RECRUITMENT SECTION) IS CLICKED
sub1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==sub1)
{
String value1=fi1.getText();
String value2=fi2.getText();
String value3=fi3.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into recruitment(name,rounds,question) values(?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.executeUpdate();
JOptionPane.showMessageDialog(pqr,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(pqr,"Error in submitting data!");
}
}
}
});
}
catch(Exception ep){}
}
}
// DIPLAY SECTION OF RECRUITMENT DETAIL(RECRUITMENT SECTION)
public class review extends JFrame
{
PreparedStatement ps;
Connection con;
ResultSet rs;
Statement st;
JLabel l1;
String nam,ques;
int round;
int rows = 0;
Object data1[][];
JScrollPane scroller;
JTable table;
public review()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
st = con.createStatement ();
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=st.executeQuery("SELECT * from recruitment");
while(rs.next())
{
nam = rs.getString(1);
round = rs.getInt(2);
ques = rs.getString(3);
rows++;
}
data1=new Object[rows][3];
Object[] Colheads={"name","rounds","question"};
rs=st.executeQuery("Select * from recruitment");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<3;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
}
try{
data1=new Object[rows][3];
Object[] Colheads={"name","rounds","question"};
rs=st.executeQuery("Select * from recruitment");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<3;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}
catch(Exception e)
{
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// "STUDENT DETAIL" LAYOUT of Recruitment Section
public class Auto extends JFrame
{
public Auto()
{
try
{
abc = new JFrame("STUDENT DETAILS ....");
a1 = new JPanel();
a2 = new JPanel();
bq = new JTabbedPane();
abc.getContentPane().add(bq);
bq.addTab(" ADD NEW ...",a1);
bq.addTab(" DISPLAY ...",a2);
jl2=new JLabel("Name of the Student :");
jl3=new JLabel("Year :");
jl4=new JLabel("Branch of the Student :");
jl5=new JLabel("Name of the Company :");
jl6=new JLabel("Package (in Rs) :");
jl7=new JLabel("Posting Location :");
jt2=new JTextField(25);
jt3=new JTextField(4);
jt4=new JTextField(20);
jt5=new JTextField(20);
jt6=new JTextField(12);
jt7=new JTextField(25);
jb2=new JButton("SUBMIT");
jb21=new JButton("CANCEL");
disp=new JButton("DISPLAY RECORDS");
a1.add(jl2);a1.add(jt2);
a1.add(jl3);a1.add(jt3);
a1.add(jl4);a1.add(jt4);
a1.add(jl5);a1.add(jt5);
a1.add(jl6);a1.add(jt6);
a1.add(jl7);a1.add(jt7);
a1.add(jb2);a1.add(jb21);a2.add(disp);
abc.setSize(500,500);
abc.setVisible(true);
abc.repaint();
jb21.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==jb21)
{
abc.dispose();
}
}
});
disp.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==disp)
{
// object refrence of "report" is used
JFrame frm6 = new report();
frm6.setSize(600, 600);
frm6.setLocation(50,50);
frm6.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
jb2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==jb2)
{
String value1=jt2.getText();
String value2=jt3.getText();
String value3=jt4.getText();
String value4=jt5.getText();
String value5=jt6.getText();
String value6=jt7.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into recstudent(name,year,branch,company,package,location) values(?,?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.setString(6,value6);
st.executeUpdate();
JOptionPane.showMessageDialog(abc,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(abc,"Error in submitting data!");
}
}
}
});
}
catch(Exception exe){}
}
}
// DISPLAY SECTION OF STUDENT DETAIL(RECRUITMENT SECTION)
public class report extends JFrame
{
PreparedStatement ps;
Connection con;
ResultSet rs;
Statement st;
JLabel l1;
String nam,brn,com,loc;
int yr,pac;
int rows = 0;
Object data1[][];
JScrollPane scroller;
JTable table;
public report()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
st = con.createStatement ();
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=st.executeQuery("SELECT * from recstudent");
while(rs.next())
{
nam = rs.getString(1);
yr = rs.getInt(2);
brn = rs.getString(3);
com = rs.getString(4);
pac = rs.getInt(5);
loc = rs.getString(6);
rows++;
}
data1=new Object[rows][6];
Object[] Colheads={"name","year","branch","company","package","location"};
rs=st.executeQuery("Select * from recstudent");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<6;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
}
try{
data1=new Object[rows][6];
Object[] Colheads={"name","year","branch","company","package","location"};
rs=st.executeQuery("Select * from recstudent");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<8;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}
catch(Exception e)
{
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// "STUDENT DETAIL" LAYOUT of "STUDENT PROFILE Section"
public class Student extends JFrame
{
public Student()
{
try
{
abq = new JFrame("STUDENT DETAILS ....");
ab1 = new JPanel();
ab2 = new JPanel();
adp = new JTabbedPane();
abq.getContentPane().add(adp);
adp.addTab(" ADD NEW ...",ab1);
adp.addTab(" DISPLAY ...",ab2);
pb1=new JLabel("Name of the Student :");
pb2=new JLabel("Guardian's Name :");
pb3=new JLabel("Registration Number :");
pb4=new JLabel("Branch :");
pb5=new JLabel("Year :");
pb6=new JLabel("Address :");
pb7=new JLabel("Phone Number :");
pb8=new JLabel("Semister Average :");
pb9=new JLabel("No. of Backlogs :");
pb10=new JLabel("Last Qualifiacation :");
pb11=new JLabel("Career Percentage :");
g1=new JTextField(20);
g2=new JTextField(20);
g3=new JTextField(10);
g4=new JTextField(20);
g5=new JTextField(4);
g6=new JTextField(40);
g7=new JTextField(11);
g8=new JTextField(3);
g9=new JTextField(3);
g10=new JTextField(25);
g11=new JTextField(2);
z1=new JButton("SUBMIT");
z2=new JButton("CANCEL");
z3=new JButton("DISPLAY RECORDS");
ab1.add(pb1);ab1.add(g1);
ab1.add(pb2);ab1.add(g2);
ab1.add(pb3);ab1.add(g3);
ab1.add(pb4);ab1.add(g4);
ab1.add(pb5);ab1.add(g5);
ab1.add(pb6);ab1.add(g6);
ab1.add(pb7);ab1.add(g7);
ab1.add(pb8);ab1.add(g8);
ab1.add(pb9);ab1.add(g9);
ab1.add(pb10);ab1.add(g10);
ab1.add(pb11);ab1.add(g11);
ab1.add(z1);ab1.add(z2);
ab2.add(z3);
abq.setSize(500,500);
abq.setVisible(true);
abq.repaint();
// HANDLES WHEN "CANCEL" BUTTON IS CLICKED
z2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==z2)
{
abq.dispose();
}
}
});
z3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
// HANDLES WHEN "DISPLAY BUTTON" OF STUDENT DETAIL(RECRUITMENT SECTION) IS CLICKED
if(ae.getSource()==z3)
{
// object refrence of "report" is used
JFrame frm = new viewstudent();
frm.setSize(600, 600);
frm.setLocation(50,50);
frm.setVisible(true);
}
}
});
// HANDLES WHEN "SUBMIT" BUTTON OF RECRUIMENT DETAIL(RECRUITMENT SECTION) IS CLICKED
z1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==z1)
{
String value1=g1.getText();
String value2=g2.getText();
String value3=g3.getText();
String value4=g4.getText();
String value5=g5.getText();
String value6=g6.getText();
String value7=g7.getText();
String value8=g8.getText();
String value9=g9.getText();
String value10=g10.getText();
String value11=g11.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
PreparedStatement st=con.prepareStatement("insert into studentpro(name,gname,regno,branch,year,address,phno,avgsemmark,backlog,qualify,careerpercent) values(?,?,?,?,?,?,?,?,?,?,?)");
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.setString(5,value5);
st.setString(6,value6);
st.setString(7,value7);
st.setString(8,value8);
st.setString(9,value9);
st.setString(10,value10);
st.setString(11,value11);
st.executeUpdate();
JOptionPane.showMessageDialog(abq,"Data is successfully inserted into database.");
con.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(abq,"Error in submitting data!");
}
}
}
});
}
catch(Exception exe){}
}
}
// DISPLAY STUDENT RECORDS(STUDENT DETAILS) IN STUDENT PROFILE SECTION
public class viewstudent extends JFrame
{
PreparedStatement ps;
Connection con;
ResultSet rs;
Statement st;
JLabel l1;
String nam,gnam,br,add,qual;
int yr,regno,phno,backl;
float avgsem,caer;
int rows = 0;
Object data1[][];
JScrollPane scroller;
JTable table;
public viewstudent()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}catch(Exception e){}
try {
st = con.createStatement ();
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=st.executeQuery("SELECT * from studentpro");
while(rs.next())
{
nam = rs.getString(1);
gnam = rs.getString(2);
regno = rs.getInt(3);
br = rs.getString(4);
yr = rs.getInt(5);
add = rs.getString(6);
phno = rs.getInt(7);
avgsem = rs.getFloat(8);
backl = rs.getInt(9);
qual = rs.getString(10);
caer = rs.getFloat(11);
rows++;
}
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=st.executeQuery("Select * from studentpro");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
}
try{
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=st.executeQuery("Select * from studentpro");
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
JTable table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
JScrollPane jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}
catch(Exception e)
{
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// DISPLAY STUDENT CAREER RECORDS WHEN "CAREER > 60" BUTTON OF CAREER SECTION IS CLICKED
public class viewcar2 extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,gnam,br,add,qual;
int yr,regno,phno,backl;
float avgsem,caer;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from studentpro where careerpercent >= 60";
public viewcar2()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}
catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
try {
ps=con.prepareStatement(que);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
gnam = rs.getString(2);
regno = rs.getInt(3);
br = rs.getString(4);
yr = rs.getInt(5);
add = rs.getString(6);
phno = rs.getInt(7);
avgsem = rs.getFloat(8);
backl = rs.getInt(9);
qual = rs.getString(10);
caer = rs.getFloat(11);
rows++;
}
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// DISPLAY STUDENT CAREER RECORDS WHEN "CAREER < 60" BUTTON OF CAREER SECTION IS CLICKED
public class viewcar1 extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,gnam,br,add,qual;
int yr,regno,phno,backl;
float avgsem,caer;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from studentpro where careerpercent <= 60";
public viewcar1()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}
catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
try {
ps=con.prepareStatement(que);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
gnam = rs.getString(2);
regno = rs.getInt(3);
br = rs.getString(4);
yr = rs.getInt(5);
add = rs.getString(6);
phno = rs.getInt(7);
avgsem = rs.getFloat(8);
backl = rs.getInt(9);
qual = rs.getString(10);
caer = rs.getFloat(11);
rows++;
}
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// DISPLAY STUDENT CAREER RECORDS WHEN "DISPLAY CAREER" BUTTON OF CAREER SECTION IS CLICKED
public class viewcareer extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,gnam,br,add,qual;
String value2 = tf2.getText();
int yr,regno,phno,backl;
float avgsem,caer;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from studentpro where careerpercent = ?";
public viewcareer()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}
catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
try {
ps=con.prepareStatement(que);
ps.setString(1,value2);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
gnam = rs.getString(2);
regno = rs.getInt(3);
br = rs.getString(4);
yr = rs.getInt(5);
add = rs.getString(6);
phno = rs.getInt(7);
avgsem = rs.getFloat(8);
backl = rs.getInt(9);
qual = rs.getString(10);
caer = rs.getFloat(11);
rows++;
}
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
// DISPLAY BACKLOG STUDENT RECORDS WHEN "DISPLAY" BUTTON OF BACKLOG SECTION IS CLICKED
public class viewbackstudent extends JFrame
{
PreparedStatement ps;
Connection con = null;
ResultSet rs;
JLabel l1;
String nam,gnam,br,add,qual;
String value2 = tf1.getText();
int yr,regno,phno,backl;
float avgsem,caer;
int rows = 0;
Object data1[][];
JScrollPane jsp;
JTable table;
String que = "select * from studentpro where backlog = ?";
public viewbackstudent()
{
Container cp = getContentPane();
cp.setLayout(new BorderLayout());
setSize(600,600);
setLocation(50,50);
setLayout(new BorderLayout());
setTitle("Student Report");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
}
catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
try {
ps=con.prepareStatement(que);
ps.setString(1,value2);
//Creating Statement Object.
}
catch (SQLException sqlex) { //If Problem then Show the User a Message.
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
//Closing the Form.
}
try{
rs=ps.executeQuery();
while(rs.next())
{
nam = rs.getString(1);
gnam = rs.getString(2);
regno = rs.getInt(3);
br = rs.getString(4);
yr = rs.getInt(5);
add = rs.getString(6);
phno = rs.getInt(7);
avgsem = rs.getFloat(8);
backl = rs.getInt(9);
qual = rs.getString(10);
caer = rs.getFloat(11);
rows++;
}
data1=new Object[rows][11];
Object[] Colheads={"name","gname","reg no","branch","year","address","phone number","semester mark","No. of backlogs","last qualification","career Average"};
rs=ps.executeQuery();
for(int i1=0;i1<rows;i1++)
{
rs.next();
for(int j1=0;j1<11;j1++)
{
data1[i1][j1]=rs.getString(j1+1);
}
}
table=new JTable(data1,Colheads);
int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
getContentPane().add(jsp);
}catch(Exception e)
{
JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading Form.");
dispose ();
}
setVisible(true);
//setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
public void actionPerformed(ActionEvent e)
{
// HANDLES WHEN "STUDENT DETAIL" BUTTON OF RECRUITMENT SECTION IS CLICKED
if(e.getSource()==stubtn)
{
Auto s=new Auto();
}
// HANDLES WHEN "RECUITMENT DETAIL" BUTTON OF RECUITMENT SECTION IS CLICKED
else if(e.getSource()==req)
{
Recui qw = new Recui();
}
// HANDLES WHEN "STUDENT DETAIL" BUTTON OF STUDENT PROFILE SECTION IS CLICKED
else if(e.getSource()==studentbtn)
{
Student so = new Student();
}
// HANDLES WHEN "DISPLAY" BUTTON OF BACKLOG SECTION IS CLICKED
else if(e.getSource()==submitback)
{
viewbackstudent so = new viewbackstudent();
}
// HANDLES WHEN "DISPLAY CAREER" BUTTON OF CAREER SECTION IS CLICKED
else if(e.getSource()==dispcareer)
{
viewcareer so = new viewcareer();
}
// HANDLES WHEN " CAREER > 60 " BUTTON OF CAREER SECTION IS CLICKED
else if(e.getSource()==career1)
{
viewcar1 so = new viewcar1();
}
// HANDLES WHEN " CAREER < 60 " BUTTON OF CAREER SECTION IS CLICKED
else if(e.getSource()==career2)
{
viewcar2 so = new viewcar2();
}
// HANDLES WHEN " MINOR PROJECT PROFILE " BUTTON OF STUDENT SECTION IS CLICKED
else if(e.getSource()==miprojectbtn)
{
minorpp so = new minorpp();
}
// HANDLES WHEN " MAJOR PROJECT PROFILE " BUTTON OF STUDENT SECTION IS CLICKED
else if(e.getSource()==maprojectbtn)
{
majorpp so = new majorpp();
}
// HANDLES WHEN " SEMINAR PROFILE " BUTTON OF STUDENT SECTION IS CLICKED
else if(e.getSource()==seminarbtn)
{
seminar ab = new seminar();
}
}
void dis()
{
f.getContentPane().add(tp);
tp.addTab("STUDENT PROFILE SECTION",p1);
tp.addTab("CAREER LIST SECTION",p2);
tp.addTab("BACKLOG LIST SECTION",p3);
tp.addTab("STUDENT RECRUITMENT SECTION",p4);
f.setSize(720,280);
f.setVisible(true);
f.setResizable(true);
}
// MAIN FUNCTION IS HERE
public static void main(String z[])
{
DatabaseRough pro=new DatabaseRough();
pro.dis();
}
}