Snippets Other
Other
Power of PHP, Java Swing ,JDBC for Application Develoment
by: James Smith
|
September 13, 2002
Version: 1
Type: Full Script
Category: Other
License: GNU General Public License
Description: Hi Friends, Thanks for the response u gave me for my previous codes, I am a hardcore PHP Programmer; found PHP the best for Development of Dynamic Websites, But as a programmer getting lots of project of Different Types I found Java very good for Application Development, I saw many sites, nowhere could I find a clear description of how to use Java swing with JDBC, So I wrote this code, which will be very helpful for Application Development Programmers, in fact as u know u can call java applets and java programs from PHP So this could be a great advantage source code
/*
//--------------------Read First Installation Instructions ---------------------
Code By : James Smith
My Email : james_smith73@yahoo.com
================== Directory ============================
make directory james in c: , that is c:\james
place the following files in this directory
download these files from
http://www.geocities.com/james_smith73/james.zip
1. frametest2.java
2. james.mdb
3. sidebar33.jpg
================== Autoexec.bat =========================
step 1 : SET classpath=
step 2 : SET PATH=c:\windows;c:\windows\command;c:\jdk1.2.1\bin;c:\
step 3 : SET JAVA_HOME=c:\jdk1.2.1
================== ODBC Settings ========================
step 4 : click control panel
step 5 : ODBC Data Sources
step 6 : click UserDSN Tab
step 7 : click ADD Button , Select Microsoft Access Driver , Finish
step 8 : Give Datasource Name as "james" , no double quotes
step 9 : use Select and select james.mdb from c:\james\james.mdb
click ok , ok finish
================== Compile ================================
cd c:\james
javac frametest2.java
================= Run ====================================
java frametest2
login 'a' and password 'a' for Accoutant (use this)
login 'p' and password 'p' for Principal
//-------------------
*/
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
public class frametest2 extends JFrame
{
//============================================================ Start Variables ==========
boolean inAnApplet = true;
final boolean shouldFill = true;
final boolean shouldWeightX = true;
final static String MYPANEL1 = " LOGIN ";
final static String MYPANEL2 = " ADD STUDENT DETAILS ";
final static String MYPANEL3 = " MODIFY / DELETE STUDENT DETAILS ";
final static String MYPANEL4 = " STUDENT REPORTS ";
final static String MYPANEL5 = " SEARCH STUDENT DETAILS ";
final static String MYPANEL6 = " VIEW STUDENT DETAILS ";
final static String MYPANEL7 = " GENERATE REPORTS ";
ImageIcon ii = new ImageIcon("sidebar33.jpg");
Font dataFont = new Font("courier new",Font.PLAIN,12);
Font titleFont = new Font("courier new",Font.BOLD,14);
JLabel jLabel, jLabel1, jLabel2, jLabel3, jLabel4, jLabel5, jLabel6;
JLabel jLabel7, jLabel8, jLabel9 ;
JRadioButton jRadiobutton, Male, Female, mMale, mFemale;
ActionListener rlistener = new RadioListener();
JCheckBox jCheckbox, SSLC, PHOTO, CHARCERT, NCCCERT, mSSLC, mPHOTO, mCHARCERT, mNCCCERT;
CheckBoxListener myListener = new CheckBoxListener();
JComboBox jCombobox, jCombobox1, jCombobox2 ,mjCombobox1, mjCombobox2, jCombobox3;
ComboBoxListener cbListener = new ComboBoxListener();
Container contentPane = getContentPane();
JDialog dialog = new JDialog((Frame) null, "! DELETE CONFIRMATION !", true);
Container dialogContentPane = dialog.getContentPane();
GridBagLayout gridbag = new GridBagLayout();
GridBagConstraints c = new GridBagConstraints();
GridBagConstraints c2 = new GridBagConstraints();
ButtonGroup bg = new ButtonGroup();
String sql, sql1, dialogmessage, sr, Namesel, reg_no;
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:james";
String dialogtitle = "Student Record Added";
String dialogf = "LOGIN FAILED";
String dialogm = "DATABASE RECORD UPDATED";
String dialogd = "DATABASE RECORD DELETED";
String Sexsel = "Male";
String Yearsel = "1st PUC";
String Sectionsel = "Section A";
String currname = "";
String tempname = "";
int SSLCsel, PHOTOsel, CHARCERTsel, NCCCERTsel, mSSLCsel, mPHOTOsel, mCHARCERTsel, mNCCCERTsel;
int dialogtype = JOptionPane.PLAIN_MESSAGE;
int tempcnt;
JPanel jPanel, p1, p2, p3;
JTabbedPane tabbedPane = new JTabbedPane();
JTextField jTextfield;
JTextField loginname = new JTextField(40);
JTextField loginpass = new JTextField(40);
JTextField adds_name = new JTextField(20);
JTextField adds_addr = new JTextField(20);
JTextField adds_fname = new JTextField(20);
JTextField mods_fname = new JTextField(20);
JTextField mods_name = new JTextField(20);
JTextField mods_addr = new JTextField(20);
JButton login = new JButton("LOGIN");
JButton DELETEIT = new JButton("YES DELETE");
JButton DONTDELETE = new JButton("NO DELETE");
JButton button, ADDREC, MODIFY, SHOW_STUDENT_LIST, DELETE;
JLabel jLabeldlg = new JLabel("Do You Really want to Delete ?");
Object[] data = new Object[5];
DefaultTableModel defaulttablemodel = new DefaultTableModel();
JTable jtable = new JTable(defaulttablemodel);
//------------------------------------------------------------ End Variables ------------
//============================================================ Start main ===============
public static void main(String args[])
{
frametest2 app = new frametest2();
}
//------------------------------------------------------------ End main -----------------
//============================================================ Start frametest2 =========
public frametest2()
{
super("A TEST APPLICATION");
setup();
pack();
addWindowListener(new WindowEventHandler());
show();
}
//------------------------------------------------------------ End frametest2 ------------
//============================================================ Start setup ===============
void setup()
{
setupMenuBar();
showpane1();
contentPane.add(tabbedPane, BorderLayout.CENTER);
}
//------------------------------------------------------------ End setup -----------------
//============================================================ Start setupMenuBar ========
void setupMenuBar()
{
MenuBar menuBar = new MenuBar();
Menu fileMenu = new Menu("File");
MenuItem fileExit = new MenuItem("Exit");
fileExit.addActionListener(new MenuItemHandler());
fileMenu.add(fileExit);
menuBar.add(fileMenu);
setMenuBar(menuBar);
}
//------------------------------------------------------------ End setupMenuBar-----------
//============================================================ Start showpane1 ============
void showpane1()
{
p1 = new JPanel()
{
public Dimension getPreferredSize()
{
Dimension size = super.getPreferredSize();
size.width = 785;
size.height = 495;
return size;
}
};
p1.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"Login Panel"));
p1.setFont(titleFont);
p1.setLayout(gridbag);
jLabel1 = new JLabel("Enter Username : ");
jLabel1.setFont(dataFont);
c.ipady = 2;
c.ipadx = 2;
c.weighty = 0.0;
c.anchor = GridBagConstraints.WEST;
c.gridwidth = 1;
c.gridx = 0;
c.gridy = 0;
gridbag.setConstraints(jLabel1, c);
p1.add(jLabel1);
loginname = new JTextField(" ");
c.ipady = 2;
c.ipadx = 2;
c.weighty = 0.0;
c.anchor = GridBagConstraints.WEST;
c.gridwidth = 2;
c.gridx = 1;
c.gridy = 0;
gridbag.setConstraints(loginname, c);
p1.add(loginname);
jLabel2 = new JLabel("Enter Password : ");
jLabel2.setFont(dataFont);
c.ipady = 2;
c.ipadx = 2;
c.weighty = 0.0;
c.anchor = GridBagConstraints.WEST;
c.gridwidth = 1;
c.gridx = 0;
c.gridy = 1;
gridbag.setConstraints(jLabel2, c);
p1.add(jLabel2);
loginpass = new JTextField(" ");
c.ipady = 2;
c.ipadx = 2;
c.weighty = 0.0;
c.anchor = GridBagConstraints.WEST;
c.gridwidth = 2;
c.gridx = 1;
c.gridy = 1;
gridbag.setConstraints(loginpass, c);
p1.add(loginpass);
button = new JButton("LOGIN");
c.ipady = 2;
c.ipadx = 2;
c.weighty = 0.0;
c.anchor = GridBagConstraints.CENTER;
c.gridwidth = 1;
c.gridx = 1;
c.gridy = 2;
gridbag.setConstraints(button, c);
p1.add(button);
button.addActionListener(new ButtonHandler());
tabbedPane.addTab(MYPANEL1, p1);
}
//------------------------------------------------------------ End__ showpane1 -----------
//============================================================ Start showpane2 ===========
void showpane2() //ADD STUDENT DETAILS
{
p2 = new JPanel();
p2.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"Add Student Details"));
p2.setLayout(gridbag);
jLabel3 = new JLabel(" Student Name : ");
jLabel3.setFont(dataFont);
c.fill = GridBagConstraints.BOTH;
c.ipady = 2;
c.ipadx = 2;
c.gridx = 0;
c.gridy = 1;
gridbag.setConstraints(jLabel3, c);
p2.add(jLabel3);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 1;
c.gridy = 1;
gridbag.setConstraints(adds_name, c);
p2.add(adds_name);
jLabel4 = new JLabel(" Student Address : ");
jLabel4.setFont(dataFont);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 0;
c.gridy = 2;
gridbag.setConstraints(jLabel4, c);
p2.add(jLabel4);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 1;
c.gridy = 2;
p2.add(adds_addr);
gridbag.setConstraints(adds_addr, c);
jLabel5 = new JLabel(" Father's Name : ");
jLabel5.setFont(dataFont);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 0;
c.gridy = 3;
gridbag.setConstraints(jLabel5, c);
p2.add(jLabel5);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 1;
c.gridy = 3;
gridbag.setConstraints(adds_fname, c);
p2.add(adds_fname);
Male = new JRadioButton("Male",true);
Male.setFont(dataFont);
c.fill = GridBagConstraints.BOTH;
c.ipady = 2;
c.ipadx = 2;
c.gridx = 1;
c.gridy = 4;
gridbag.setConstraints(Male, c);
Male.addActionListener(rlistener);
bg.add(Male);
p2.add(Male);
Female = new JRadioButton("Female",false);
Female.setFont(dataFont);
c.fill = GridBagConstraints.BOTH;
c.ipady = 2;
c.ipadx = 2;
c.gridx = 2;
c.gridy = 4;
gridbag.setConstraints(Female, c);
bg.add(Female);
Female.addActionListener(rlistener);
p2.add(Female);
jLabel6 = new JLabel(" Class : ");
jLabel6.setFont(dataFont);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 0;
c.gridy = 5;
gridbag.setConstraints(jLabel6, c);
p2.add(jLabel6);
jCombobox1 = new JComboBox();
jCombobox1.setFont(dataFont);
jCombobox1.addItem("1st PUC");
jCombobox1.addItem("2nd PUC");
c.fill = GridBagConstraints.BOTH;
c.insets = new Insets(10,0,0,30);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 1;
c.gridy = 5;
jCombobox1.addItemListener(cbListener);
gridbag.setConstraints(jCombobox1, c);
p2.add(jCombobox1);
jCombobox2 = new JComboBox();
jCombobox2.setFont(dataFont);
jCombobox2.addItem("Section A");
jCombobox2.addItem("Section B");
jCombobox2.addItem("Section C");
c.fill = GridBagConstraints.BOTH;
c.insets = new Insets(10,0,0,30);
c.ipady = 2;
c.ipadx = 2;
c.gridx = 2;
c.gridy = 5;
jCombobox2.addItemListener(cbListener);
gridbag.setConstraints(jCombobox2, c);
p2.add(jCombobox2);
SSLC = new JCheckBox("SSLC Marks Card ");
c.fill = GridBagConstraints.BOTH;
c.ipady = 0;
c.ipadx = 0;
c.gridx = 1;
c.gridy = 6;
gridbag.setConstraints(SSLC, c);
SSLC.setFont(dataFont);
SSLC.addItemListener(myListener);
p2.add(SSLC);
PHOTO = new JCheckBox("PHOTO (Passport Size) ");
c.ipady = 0;
c.ipadx = 0;
c.gridx = 2;
c.gridy = 6;
gridbag.setConstraints(PHOTO, c);
PHOTO.setFont(dataFont);
PHOTO.addItemListener(myListener);
p2.add(PHOTO);
CHARCERT = new JCheckBox("Charecter Certificater");
c.ipady = 0;
c.ipadx = 0;
c.gridx = 1;
c.gridy = 7;
gridbag.setConstraints(CHARCERT, c);
CHARCERT.setFont(dataFont);
CHARCERT.addItemListener(myListener);
p2.add(CHARCERT);
NCCCERT = new JCheckBox("NCC Certificate Given");
c.ipady = 0;
c.ipadx = 0;
c.gridx = 2;
c.gridy = 7;
gridbag.setConstraints(NCCCERT, c);
NCCCERT.setFont(dataFont);
NCCCERT.addItemListener(myListener);
p2.add(NCCCERT);
ADDREC = new JButton("SAVE RECORD");
c.ipady = 2;
c.ipadx = 2;
c.gridx = 2;
c.gridy = 8;
gridbag.setConstraints(ADDREC, c);
p2.add(ADDREC);
ADDREC.addActionListener(new ButtonHandler());
jLabel7 = new JLabel(" ", ii, JLabel.CENTER);
c.fill = GridBagConstraints.BOTH;
c.gridwidth = 5;
c.gridx = 0;
c.gridy = 9;
gridbag.setConstraints(jLabel7, c);
p2.add(jLabel7);
tabbedPane.addTab(MYPANEL2, p2);
}
//-------------------------------------------------------------- End showpane2 ---------
void showpane3()
{
p3 = new JPanel();
p3.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"Modify Student Details"));
p3.setLayout(gridbag);
jCombobox3 = new JComboBox();
jCombobox3.addItem("Select Student : ");
jCombobox3.setFont(dataFont);
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 2;
c2.gridy = 1;
gridbag.setConstraints(jCombobox3, c2);
jCombobox3.addItemListener(cbListener);
p3.add(jCombobox3);
JLabel jl8 = new JLabel(" Student Name : ");
jl8.setFont(dataFont);
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 0;
c2.gridy = 1;
gridbag.setConstraints(jl8, c2);
p3.add(jl8);
mods_name = new JTextField(20);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 1;
gridbag.setConstraints(mods_name, c2);
p3.add(mods_name);
JLabel jl9 = new JLabel(" Student Address : ");
jl9.setFont(dataFont);
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 0;
c2.gridy = 2;
gridbag.setConstraints(jl9, c2);
p3.add(jl9);
mods_addr = new JTextField(20);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 2;
gridbag.setConstraints(mods_addr, c2);
p3.add(mods_addr);
jLabel5 = new JLabel(" Father's Name : ");
jLabel5.setFont(dataFont);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 0;
c2.gridy = 3;
gridbag.setConstraints(jLabel5, c2);
p3.add(jLabel5);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 3;
gridbag.setConstraints(mods_fname, c2);
p3.add(mods_fname);
mMale = new JRadioButton("Male",true);
mMale.setFont(dataFont);
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 4;
gridbag.setConstraints(mMale, c2);
mMale.addActionListener(rlistener);
bg.add(mMale);
p3.add(mMale);
mFemale = new JRadioButton("Female",false);
mFemale.setFont(dataFont);
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 2;
c2.gridy = 4;
gridbag.setConstraints(mFemale, c2);
bg.add(mFemale);
mFemale.addActionListener(rlistener);
p3.add(mFemale);
jLabel6 = new JLabel(" Class : ");
jLabel6.setFont(dataFont);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 0;
c2.gridy = 5;
gridbag.setConstraints(jLabel6, c2);
p3.add(jLabel6);
mjCombobox1 = new JComboBox();
mjCombobox1.setFont(dataFont);
mjCombobox1.addItem("1st PUC");
mjCombobox1.addItem("2nd PUC");
c2.fill = GridBagConstraints.BOTH;
c2.insets = new Insets(10,0,0,30);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 5;
mjCombobox1.addItemListener(cbListener);
gridbag.setConstraints(mjCombobox1, c2);
p3.add(mjCombobox1);
mjCombobox2 = new JComboBox();
mjCombobox2.setFont(dataFont);
mjCombobox2.addItem("Section A");
mjCombobox2.addItem("Section B");
mjCombobox2.addItem("Section C");
c2.fill = GridBagConstraints.BOTH;
c2.insets = new Insets(10,0,0,30);
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 2;
c2.gridy = 5;
mjCombobox2.addItemListener(cbListener);
gridbag.setConstraints(mjCombobox2, c2);
p3.add(mjCombobox2);
mSSLC = new JCheckBox("SSLC Marks Card ");
c2.fill = GridBagConstraints.BOTH;
c2.ipady = 0;
c2.ipadx = 0;
c2.gridx = 1;
c2.gridy = 6;
gridbag.setConstraints(mSSLC, c2);
mSSLC.setFont(dataFont);
mSSLC.addItemListener(myListener);
p3.add(mSSLC);
mPHOTO = new JCheckBox("PHOTO (Passport Size) ");
c2.ipady = 0;
c2.ipadx = 0;
c2.gridx = 2;
c2.gridy = 6;
gridbag.setConstraints(mPHOTO, c2);
mPHOTO.setFont(dataFont);
mPHOTO.addItemListener(myListener);
p3.add(mPHOTO);
mCHARCERT = new JCheckBox("Charecter Certificater");
c2.ipady = 0;
c2.ipadx = 0;
c2.gridx = 1;
c2.gridy = 7;
gridbag.setConstraints(mCHARCERT, c2);
mCHARCERT.setFont(dataFont);
mCHARCERT.addItemListener(myListener);
p3.add(mCHARCERT);
mNCCCERT = new JCheckBox("NCC Certificate Given");
c2.ipady = 0;
c2.ipadx = 0;
c2.gridx = 2;
c2.gridy = 7;
gridbag.setConstraints(mNCCCERT, c2);
mNCCCERT.setFont(dataFont);
mNCCCERT.addItemListener(myListener);
p3.add(mNCCCERT);
DELETE = new JButton("DELETE RECORD");
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 1;
c2.gridy = 8;
gridbag.setConstraints(DELETE, c2);
p3.add(DELETE);
DELETE.addActionListener(new ButtonHandler());
MODIFY = new JButton("MODIFY RECORD");
c2.ipady = 2;
c2.ipadx = 2;
c2.gridx = 2;
c2.gridy = 8;
gridbag.setConstraints(MODIFY, c2);
p3.add(MODIFY);
MODIFY.addActionListener(new ButtonHandler());
jLabel7 = new JLabel(" ", ii, JLabel.CENTER);
c2.fill = GridBagConstraints.BOTH;
c2.gridwidth = 5;
c2.gridx = 0;
c2.gridy = 10;
gridbag.setConstraints(jLabel7, c2);
p3.add(jLabel7);
tabbedPane.addTab(MYPANEL3, p3);
accessDBMOD();
}
void showpane4()
{
JPanel p4 = new JPanel();
try
{
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String query = "SELECT StudentID, Name, Address, FName FROM student_det";
ResultSet rs = statement.executeQuery(query);
ResultSetMetaData rmeta = rs.getMetaData();
int numColumns=rmeta.getColumnCount();
for(int i=1;i<=numColumns;++i)
{
if(i<=numColumns)
{
defaulttablemodel.addColumn(rmeta.getColumnName(i));
}
}
while(rs.next())
{
for(int i=1;i<=numColumns;++i)
{
if(i<=numColumns)
{
tempname = rs.getString(i);
tempcnt=i-1;
data[tempcnt] = tempname;
}
}
defaulttablemodel.addRow(data);
}
}
catch(Exception ex)
{
//
}
p4.add(new JScrollPane(jtable));
tabbedPane.addTab(MYPANEL4, p4);
}
void showpane5()
{
JPanel p5 = new JPanel();
jLabel = new JLabel(" Inside Panel 5 ");
jLabel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"ONE TEST"));
p5.add(jLabel);
jLabel2 = new JLabel(" Inside Panel 55 ");
jLabel2.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"ONE TEST 22"));
p5.add(jLabel2);
tabbedPane.addTab(MYPANEL5, p5);
}
void showpane6()
{
JPanel p6 = new JPanel();
jLabel = new JLabel(" Inside Panel 6 ");
p6.add(jLabel);
tabbedPane.addTab(MYPANEL6, p6);
}
void showpane7()
{
JPanel p7 = new JPanel();
jLabel = new JLabel(" Inside Panel 7 ");
p7.add(jLabel);
tabbedPane.addTab(MYPANEL7, p7);
}
void showpane2345()
{
showpane2();
showpane3();
showpane4();
showpane5();
}
void showpane67()
{
showpane6();
showpane7();
}
void accessDB()
{
try
{
String var1 = loginname.getText();
var1 = var1.trim();
String var2 = loginpass.getText();
var2 = var2.trim();
sql = "SELECT * FROM login WHERE username='"+var1+"' AND password='"+var2+"'";
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
boolean hasResults = statement.execute(sql);
if(hasResults)
{
ResultSet result = statement.getResultSet();
if(result!=null)
{
displayResults(result);
}
connection.close();
}
}
catch(Exception ex)
{
}
}
void accessDBMod(String nsel)
{
try
{
sql = "SELECT * FROM student_det WHERE Name='"+nsel+"'";
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
boolean hasResults = statement.execute(sql);
if(hasResults)
{
ResultSet result = statement.getResultSet();
if(result!=null)
{
displayResultsMod(result);
}
connection.close();
}
}
catch(Exception ex)
{
}
}
void accessDBDel(String nsel)
{
try
{
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
sql = "DELETE FROM student_det WHERE Name='"+nsel+"'";
statement.executeUpdate(sql);
connection.close();
mjCombobox1.setSelectedIndex(0);
mjCombobox2.setSelectedIndex(0);
mods_name.setText(" ");
mods_addr.setText(" ");
mods_fname.setText(" ");
mSSLC.setSelected(false);
mPHOTO.setSelected(false);
mNCCCERT.setSelected(false);
mCHARCERT.setSelected(false);
mMale.doClick();
}
catch(Exception ex)
{
}
}
void displayResults(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta = r.getMetaData();
int foundrec = 0;
int numColumns=rmeta.getColumnCount();
while(r.next())
{
String param3 = r.getString(3).trim();
if (param3.equals("Accounts"))
{
foundrec = 1;
tabbedPane.removeTabAt(0);
showpane2345();
}
else if(param3.equals("Principal"))
{
foundrec = 1;
tabbedPane.removeTabAt(0);
showpane67();
}
}
if(foundrec==0)
{
dialogmessage = "Please Re-Login";
dialogtype = JOptionPane.INFORMATION_MESSAGE;
JOptionPane.showMessageDialog((Component) null, dialogmessage, dialogf, dialogtype);
loginname.setText(" ");
loginpass.setText(" ");
}
}
void displayResultsMod(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta = r.getMetaData();
int foundrec = 0;
int numColumns=rmeta.getColumnCount();
String text2="";
String text3="";
String text4="";
String text5="";
String text6="";
String text7="";
String text8="";
int int9=0;
int int10=0;
int int11=0;
int int12=0;
while(r.next())
{
reg_no=r.getString(2);
text3+=r.getString(3);
text4+=r.getString(4);
text5+=r.getString(5);
text6+=r.getString(6);
text7+=r.getString(7);
text8+=r.getString(8);
int9=r.getInt(9);
int10=r.getInt(10);
int11=r.getInt(11);
int12=r.getInt(12);
}
currname = text3;
mods_name.setText(text3);
mods_addr.setText(text4);
mods_fname.setText(text5);
text6 = text6.trim();
if (text6.equals("Male"))
{
mMale.doClick();
}
else
{
mFemale.doClick();
}
text7 = text7.trim();
if (text7.equals("2nd PUC"))
{
mjCombobox1.setSelectedIndex(1);
}
else
{
mjCombobox1.setSelectedIndex(0);
}
text8 = text8.trim();
if (text8.equals("Section A"))
{
mjCombobox2.setSelectedIndex(0);
}
else if(text8.equals("Section B"))
{
mjCombobox2.setSelectedIndex(1);
}
else
{
mjCombobox2.setSelectedIndex(2);
}
if(int9==1)
{
mSSLC.setSelected(true);
}
else
{
mSSLC.setSelected(false);
}
if(int10==1)
{
mPHOTO.setSelected(true);
}
else
{
mPHOTO.setSelected(false);
}
if(int11==1)
{
mCHARCERT.setSelected(true);
}
else
{
mCHARCERT.setSelected(false);
}
if(int12==1)
{
mNCCCERT.setSelected(true);
}
else
{
mNCCCERT.setSelected(false);
}
}
void accessDBADD()
{
try
{
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String query = "SELECT * FROM student_det";
ResultSet rs = statement.executeQuery(query);
int cnt = 0;
while (rs.next())
{
cnt++;
}
cnt = cnt+1;
char ys = Yearsel.charAt(0);
char ss = Sectionsel.charAt(8);
reg_no = "02-PCM-"+ys+""+ss+"-"+cnt;
sql = "INSERT INTO student_det (StudentID, Name, Address, FName, Sex, Yearsel, Sectionsel, SSLC, PHOTO, CHARCERT, NCCCERT) VALUES ('"+reg_no+"','"+adds_name.getText()+"','"+adds_addr.getText()+"','"+adds_fname.getText()+"','"+Sexsel+"','"+Yearsel+"','"+Sectionsel+"',"+SSLCsel+","+PHOTOsel+","+CHARCERTsel+","+NCCCERTsel+")";
statement.executeUpdate(sql);
connection.close();
dialogmessage = " "+adds_name.getText().toUpperCase()+" has Registration Number : "+reg_no;
dialogtype = JOptionPane.INFORMATION_MESSAGE;
JOptionPane.showMessageDialog((Component) null, dialogmessage, dialogtitle, dialogtype);
jCombobox1.setSelectedIndex(0);
jCombobox2.setSelectedIndex(0);
String snametemp = adds_name.getText();
jCombobox3.addItem(adds_name.getText());
adds_name.setText(" ");
adds_addr.setText(" ");
adds_fname.setText(" ");
SSLC.setSelected(false);
PHOTO.setSelected(false);
NCCCERT.setSelected(false);
CHARCERT.setSelected(false);
Male.doClick();
}
catch(Exception ex)
{
}
}
void accessDBMOD()
{
try
{
sql = "SELECT Name FROM student_det ORDER BY Name";
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
boolean hasResults = statement.execute(sql);
if(hasResults)
{
ResultSet result = statement.getResultSet();
if(result!=null)
{
displayResultsMOD(result);
}
connection.close();
}
}
catch(Exception ex)
{
}
}
void updateDB()
{
try
{
sql = "UPDATE student_det SET Name='"+mods_name.getText()+"', Address='"+mods_addr.getText()+"', FName='"+mods_fname.getText()+"', Sex='"+Sexsel+"', Yearsel='"+Yearsel+"', Sectionsel='"+Sectionsel+"', SSLC="+mSSLCsel+", PHOTO="+mPHOTOsel+", CHARCERT="+mCHARCERTsel+", NCCCERT="+mNCCCERTsel+" WHERE StudentID='"+reg_no+"'";
Class.forName(driver);
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
connection.close();
dialogmessage = " "+mods_name.getText().toUpperCase()+" Record is Updated ";
dialogtype = JOptionPane.INFORMATION_MESSAGE;
JOptionPane.showMessageDialog((Component) null, dialogmessage, dialogm, dialogtype);
}
catch(Exception ex)
{
}
}
void displayResultsMOD(ResultSet r) throws SQLException
{
ResultSetMetaData rmeta = r.getMetaData();
int numColumns=rmeta.getColumnCount();
while(r.next())
{
for(int i=1;i<=numColumns;++i)
{
if(i<=numColumns)
{
jCombobox3.addItem(r.getString(i));
}
}
}
}
//=========================================================== START ButtonHandler ========
class ButtonHandler implements ActionListener
{
public void actionPerformed(ActionEvent ev)
{
String s=ev.getActionCommand();
if(s=="LOGIN")
{
accessDB();
}
else if(s=="SAVE RECORD")
{
accessDBADD();
String snametemp = adds_name.getText();
}
else if(s=="MODIFY RECORD")
{
String temp_mname = mods_name.getText().trim();
String temp_currname = currname.trim();
if(temp_mname.equals(temp_currname))
{
}
else
{
jCombobox3.addItem(mods_name.getText());
}
updateDB();
}
else if(s=="DELETE RECORD")
{
dialogContentPane.setLayout(new FlowLayout());
dialogContentPane.add(jLabeldlg);
jLabeldlg.setFont(titleFont);
dialogContentPane.add(DELETEIT);
DELETEIT.addActionListener(new ButtonHandler());
dialogContentPane.add(DONTDELETE);
DONTDELETE.addActionListener(new ButtonHandler());
dialog.setBounds(300, 200, 250, 120);
dialog.show();
}
else if(s=="YES DELETE")
{
dialog.dispose();
Namesel = jCombobox3.getSelectedItem().toString();
accessDBDel(Namesel);
}
else if(s=="NO DELETE")
{
dialog.dispose();
}
}
}
//=========================================================== END__ ButtonHandler ========
//=========================================================== START MenuItemHandler ======
class MenuItemHandler implements ActionListener
{
public void actionPerformed(ActionEvent ev)
{
String s=ev.getActionCommand();
if(s=="Exit")
{
System.exit(0);
}
}
}
//=========================================================== END__ MenuItemHandler ======
//=========================================================== START WindowEventHandler ===
class WindowEventHandler extends WindowAdapter
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}
//=========================================================== END__ WindowEventHandler ===
//=========================================================== START RadioListener ========
class RadioListener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
Sexsel = e.getActionCommand();
}
}
//=========================================================== END__ RadioListener ========
//=========================================================== START RadioListener ========
class ComboBoxListener implements ItemListener
{
public void itemStateChanged(ItemEvent e)
{
sr = (String)e.getItem();
if (e.getSource().equals(jCombobox1))
{
Yearsel = jCombobox1.getSelectedItem().toString();
}
if (e.getSource().equals(mjCombobox1))
{
Yearsel = mjCombobox1.getSelectedItem().toString();
}
if (e.getSource().equals(jCombobox2))
{
Sectionsel = jCombobox2.getSelectedItem().toString();
}
if (e.getSource().equals(mjCombobox2))
{
Sectionsel = mjCombobox2.getSelectedItem().toString();
}
if (e.getSource().equals(jCombobox3))
{
Namesel = jCombobox3.getSelectedItem().toString();
accessDBMod(Namesel);
}
}
}
//=========================================================== END__ RadioListener ========
//=========================================================== START CheckBoxListener =====
class CheckBoxListener implements ItemListener
{
public void itemStateChanged(ItemEvent e)
{
Object source = e.getItemSelectable();
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==SSLC))
{
SSLCsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==SSLC))
{
SSLCsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==PHOTO))
{
PHOTOsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==PHOTO))
{
PHOTOsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==NCCCERT))
{
NCCCERTsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==NCCCERT))
{
NCCCERTsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==CHARCERT))
{
CHARCERTsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==CHARCERT))
{
CHARCERTsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mSSLC))
{
mSSLCsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mSSLC))
{
mSSLCsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mPHOTO))
{
mPHOTOsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mPHOTO))
{
mPHOTOsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mNCCCERT))
{
mNCCCERTsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mNCCCERT))
{
mNCCCERTsel = 0;
}
if ((e.getStateChange() == ItemEvent.SELECTED) && (source==mCHARCERT))
{
mCHARCERTsel = 1;
}
if ((e.getStateChange() == ItemEvent.DESELECTED) && (source==mCHARCERT))
{
mCHARCERTsel = 0;
}
}
}
//=========================================================== END CheckBoxListener =====
}
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
