?? database.java
字號:
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
label24 = new JLabel(" Name");
c3.add(label24);
text24 = new JTextField(10);
c3.add(text24);
label34 = new JLabel(" Regtration #");
c3.add(label34);
text34 = new JTextField(10);
c3.add(text34);
label44 = new JLabel(" Marks");
c3.add(label44);
text44 = new JTextField(10);
c3.add(text44);
save24 = new JButton("Save");
c3.add(save24);
save24.addActionListener(this);
exit24 = new JButton("Exit");
c3.add(exit24);
exit24.addActionListener(this);
ahsanf2.setVisible(true);
}
else if( e.getSource() == b25 )
{
JFrame ahsanf2 = new JFrame("Record Finding");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
exit25 = new JButton("Exit");
exit25.addActionListener(this);
find25 = new JButton("Record");
find25.addActionListener(this);
label25 = new JLabel("Name ");
label35 = new JLabel(" Registration");
text25 = new JTextField(10);
text35 = new JTextField(10);
c3.add(label25);
c3.add(text35);
c3.add(label35);
c3.add(text25);
c3.add(exit25);
c3.add(find25);
ahsanf2.setVisible(true);
}
else if( e.getSource() == find25 )
{
JFrame ahsanf9 = new JFrame("Required Record ");
Toolkit thekit = ahsanf9.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf9.setBounds(a.width/7,a.height/7,a.width/5,a.height/5);
Container c0 = ahsanf9.getContentPane();
c0.setLayout(new FlowLayout());
JTextField find100,find108,find128;
find100 = new JTextField(10);
JLabel label100,label108,label128;
label100 = new JLabel("Name");
c0.add(label100);
c0.add(find100);
find108 = new JTextField(10);
label108 = new JLabel(" Reg #");
c0.add(label108);
c0.add(find108);
find128 = new JTextField(10);
label128 = new JLabel("Marks");
c0.add(label128);
c0.add(find128);
ahsanf9.setVisible(true);
String name,reg,marks;
int rowadd;
Connection con;
Statement stmt;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:ahsan");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(" select * from Assignment where Reg_no = '" + text25.getText() + "' ");
Statement statement = con.createStatement();
while(rs.next())
{
marks = rs.getString("Marks");
name = rs.getString("NAME");
reg = rs.getString("Reg_no");
System.out.println(" Marks=" + marks + " , NAME = "+ name + " ,Reg_no=" + reg);
//System.out.println(" ID=" + id + " , NAME = "+ name);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}
text35.setText("");
text25.setText("");
stmt.close();
con.close();
}
catch(Exception lie)
{
System.out.println(" exception caught " + lie);
}
}
else if( e.getSource() == exit25 )
{
System.exit(0);
}
else if( e.getSource() == exit28 )
{
System.exit(0);
}
else if( e.getSource() == b26 )
{
JFrame ahsanf2 = new JFrame("Delete Record");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
deltex26 = new JTextField(10);
dellab26 = new JLabel("Name");
deltex36 = new JTextField(10);
dellab36 = new JLabel(" Registration #");
delete26 = new JButton("Delete");
c3.add(dellab26);
c3.add(deltex26);
c3.add(dellab36);
c3.add(deltex36);
exit26 = new JButton("Exit");
exit26.addActionListener(this);
delete26.addActionListener(this);
c3.add(delete26);
c3.add(exit26);
ahsanf2.setVisible(true);
}
else if( e.getSource() == exit26 )
{
System.exit(0);
}
else if( e.getSource() == delete26 )
{
String sql;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
Statement stmt = conn.createStatement();
sql = "SELECT * FROM Assignment WHERE Reg_no = '" + deltex36.getText() + "'";
ResultSet rs = stmt.executeQuery(sql);
rs.next();
sql = "DELETE * FROM Assignment WHERE Reg_no = '" + deltex36.getText() + "'";
stmt.executeUpdate(sql);
sql = "DELETE * FROM Assignment WHERE Name = '" + deltex26.getText() + "'";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
deltex26.setText(" ");
deltex36.setText(" ");
}catch(Exception dqele)
{
System.out.println(dqele);
}
}
else if( e.getSource() == exit30 )
{
System.exit(0);
}
else if( e.getSource() == delete30 )
{
String sql;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
Statement stmt = conn.createStatement();
sql = "SELECT * FROM Attendance WHERE Reg_no = '" + deltex40.getText() + "'";
ResultSet rs = stmt.executeQuery(sql);
rs.next();
sql = "DELETE * FROM Attendance WHERE Reg_no = '" + deltex40.getText() + "'";
stmt.executeUpdate(sql);
sql = "DELETE * FROM Attendance WHERE Name = '" + deltex30.getText() + "'";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
deltex30.setText(" ");
deltex40.setText(" ");
}catch(Exception dqale)
{
System.out.println(dqale);
}
}
else if( e.getSource() == b27 )
{
System.exit(0);
}
else if( e.getSource() == b28 )
{
JFrame ahsanf2 = new JFrame("Insert Record");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
label28 = new JLabel(" Name");
c3.add(label28);
text28 = new JTextField(10);
c3.add(text28);
label38 = new JLabel(" Regtration #");
c3.add(label38);
text38 = new JTextField(10);
c3.add(text38);
label48 = new JLabel(" Marks");
c3.add(label48);
text48 = new JTextField(10);
c3.add(text48);
save28 = new JButton("Save");
c3.add(save28);
save28.addActionListener(this);
exit28 = new JButton("Exit");
c3.add(exit28);
exit28.addActionListener(this);
ahsanf2.setVisible(true);
}
else if( e.getSource() == save28 )
{
int id;
String name;
int rowadd;
Connection con;
Statement stmt;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:ahsan");
stmt = con.createStatement();
ResultSet rs= stmt.executeQuery(" select * from Attendance");
Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Attendance VALUES( '"+text28.getText()+"',"+Integer.parseInt(text38.getText())+","+Integer.parseInt(text48.getText())+" )");
stmt.close();
con.close();
text28.setText(" ");
text38.setText(" ");
text48.setText(" ");
}
catch(Exception eabe)
{
System.out.println(" exception caught " + eabe);
}
}
else if( e.getSource() == b29 )
{
JFrame ahsanf2 = new JFrame("Finding Record");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
exit29 = new JButton("Exit");
exit29.addActionListener(this);
find29 = new JButton("Record");
find29.addActionListener(this);
label29 = new JLabel("Name ");
label39 = new JLabel(" Registration");
text29 = new JTextField(10);
text39 = new JTextField(10);
c3.add(label29);
c3.add(text39);
c3.add(label39);
c3.add(text29);
c3.add(exit29);
c3.add(find29);
ahsanf2.setVisible(true);
}
else if( e.getSource() == find29 )
{
JFrame ahsanf9 = new JFrame("Required Record ");
Toolkit thekit = ahsanf9.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf9.setBounds(a.width/7,a.height/7,a.width/5,a.height/5);
Container c0 = ahsanf9.getContentPane();
c0.setLayout(new FlowLayout());
JTextField find100,find108,find128;
find100 = new JTextField(10);
JLabel label100,label108,label128;
label100 = new JLabel("Name");
c0.add(label100);
c0.add(find100);
find108 = new JTextField(10);
label108 = new JLabel(" Reg #");
c0.add(label108);
c0.add(find108);
find128 = new JTextField(5);
label128 = new JLabel("Attendance %");
c0.add(label128);
c0.add(find128);
ahsanf9.setVisible(true);
String name,reg,marks;
int rowadd;
Connection con;
Statement stmt;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:ahsan");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(" select * from Attendance where Reg_no = '" + text29.getText() + "' ");
Statement statement = con.createStatement();
while(rs.next())
{
marks = rs.getString("Attendance");
name = rs.getString("NAME");
reg = rs.getString("Reg_no");
System.out.println(" Attendance percentage =" + marks + " , NAME = "+ name + " ,Reg_no=" + reg);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}
text39.setText("");
text29.setText("");
stmt.close();
con.close();
}
catch(Exception llie)
{
System.out.println(" exception caught " + llie);
}
}
else if( e.getSource() == exit29 )
{
System.exit(0);
}
else if( e.getSource() == b30 )
{
JFrame ahsanf2 = new JFrame("select any one");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
deltex30 = new JTextField(10);
dellab30 = new JLabel(" Name");
deltex40 = new JTextField(10);
dellab40 = new JLabel(" Registration #");
delete30 = new JButton("Delete");
c3.add(dellab30);
c3.add(deltex30);
c3.add(dellab40);
c3.add(deltex40);
exit30 = new JButton("Exit");
exit30.addActionListener(this);
delete30.addActionListener(this);
c3.add(delete30);
c3.add(exit30);
ahsanf2.setVisible(true);
}
else if( e.getSource() == b31 )
{
System.exit(0);
}
else if( e.getSource() == b2)
{
JFrame ahsanf1 = new JFrame("2nd SESSIONAL");
Toolkit thekit = ahsanf1.getToolkit();
Dimension a1 =thekit.getScreenSize();
ahsanf1.setBounds(a1.width/5,a1.height/5,a1.width/3,a1.height/3);
Container c2 = ahsanf1.getContentPane();
c2.setLayout(new GridLayout(4, 9));
b12 = new JButton( "INSERT RECORD" );
c2.add(b12);
b12.addActionListener(this);
b13 = new JButton( "FIND RECORD" );
c2.add(b13);
b13.addActionListener(this);
b14 = new JButton( "DELETE" );
c2.add(b14);
b14.addActionListener(this);
b15 = new JButton( "EXIT" );
c2.add(b15);
b15.addActionListener(this);
ahsanf1.setVisible(true);
}
else if( e.getSource() == b3)
{
JFrame ahsanf2 = new JFrame("FINAL");
Toolkit thekit = ahsanf2.getToolkit();
Dimension a2 =thekit.getScreenSize();
ahsanf2.setBounds(a2.width/5,a2.height/5,a2.width/3,a2.height/3);
Container c3 = ahsanf2.getContentPane();
c3.setLayout(new GridLayout(4,9));
b16 = new JButton( "INSERT RECORD" );
c3.add(b16);
b16.addActionListener(this);
b17 = new JButton( "FIND RECORD" );
c3.add(b17);
b17.addActionListener(this);
b18 = new JButton( "DELETE" );
c3.add(b18);
b18.addActionListener(this);
b19 = new JButton( "EXIT" );
c3.add(b19);
b19.addActionListener(this);
ahsanf2.setVisible(true);
}
else if( e.getSource() ==b4)
{
JFrame ahsanf4 = new JFrame("QUIZES");
Toolkit thekit = ahsanf4.getToolkit();
Dimension a4 =thekit.getScreenSize();
ahsanf4.setBounds(a4.width/5,a4.height/5,a4.width/3,a4.height/3);
Container c4 = ahsanf4.getContentPane();
c4.setLayout(new GridLayout(4, 9));
b20 = new JButton( "INSERT RECORD" );
c4.add(b20);
b20.addActionListener(this);
b21 = new JButton( "FIND RECORD" );
c4.add(b21);
b21.addActionListener(this);
b22 = new JButton( "DELETE" );
c4.add(b22);
b22.addActionListener(this);
b23 = new JButton( "EXIT" );
c4.add(b23);
b23.addActionListener(this);
ahsanf4.setVisible(true);
}
else if(e.getSource() == b5)
{
JFrame ahsanf5 = new JFrame("ASSIGNMENT");
Toolkit thekit = ahsanf5.getToolkit();
Dimension a5 =thekit.getScreenSize();
ahsanf5.setBounds(a5.width/5,a5.height/5,a5.width/3,a5.height/3);
Container c5 = ahsanf5.getContentPane();
c5.setLayout(new GridLayout(4, 9));
b24 = new JButton( "INSERT RECORD" );
c5.add(b24);
b24.addActionListener(this);
b25 = new JButton( "FIND RECORD" );
c5.add(b25);
b25.addActionListener(this);
b26 = new JButton( "DELETE" );
c5.add(b26);
b26.addActionListener(this);
b27 = new JButton( "EXIT" );
c5.add(b27);
b27.addActionListener(this);
ahsanf5.setVisible(true);
}
else if( e.getSource() == b6)
{
JFrame ahsanf6 = new JFrame("ATTENDANCE");
Toolkit thekit = ahsanf6.getToolkit();
Dimension a6 =thekit.getScreenSize();
ahsanf6.setBounds(a6.width/5,a6.height/5,a6.width/3,a6.height/3);
Container c6 = ahsanf6.getContentPane();
c6.setLayout(new GridLayout(4,9));
b28 = new JButton( "INSERT RECORD" );
c6.add(b28);
b28.addActionListener(this);
b29 = new JButton( "FIND RECORD" );
c6.add(b29);
b29.addActionListener(this);
b30 = new JButton( "DELETE" );
c6.add(b30);
b30.addActionListener(this);
b31 = new JButton( "EXIT" );
c6.add(b31);
b31.addActionListener(this);
ahsanf6.setVisible(true);
}
else if( e.getSource() == b7)
{
System.exit(0);
}
}
public static void main ( String [] args )
{
DataBase ahsan = new DataBase();
ahsan.addWindowListener( new WindowAdapter() {
public void windowClosing( WindowEvent e )
{
System.exit( 0 );
}
}
);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -