?? database.java
字號:
exit13.addActionListener(this);
find13 = new JButton("Record");
find13.addActionListener(this);
label13 = new JLabel("Name ");
label23 = new JLabel(" Registration");
text13 = new JTextField(10);
text23 = new JTextField(10);
c3.add(label13);
c3.add(text13);
c3.add(label23);
c3.add(text23);
c3.add(exit13);
c3.add(find13);
ahsanf2.setVisible(true);
}
//find 13 find 13 b13
else if( e.getSource() == find13 )
{
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 2ndses where Reg_no = '" + text23.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);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}
text13.setText("");
text23.setText("");
stmt.close();
con.close();
}
catch(Exception ie)
{
System.out.println(" exception caught " + ie);
}
}
else if( e.getSource() == b14 )
{
JFrame ahsanf2 = new JFrame("Enter To Delete In 2nd Sessional");
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());
deltex14 = new JTextField(10);
dellab14 = new JLabel(" Name");
deltex24 = new JTextField(10);
dellab24 = new JLabel(" Registration #");
delete14 = new JButton("Delete");
c3.add(dellab14);
c3.add(deltex14);
c3.add(dellab24);
c3.add(deltex24);
exit14 = new JButton("Exit");
exit14.addActionListener(this);
delete14.addActionListener(this);
c3.add(delete14);
c3.add(exit14);
ahsanf2.setVisible(true);
}
else if( e.getSource() == exit13 )
{
System.exit(0);
}
else if( e.getSource() == b15 )
{
System.exit(0);
}
else if( e.getSource() == b16 )
{
JFrame ahsanf16 = new JFrame("Enter Record In Final");
Toolkit thekit = ahsanf16.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf16.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);
Container c16 = ahsanf16.getContentPane();
c16.setLayout(new FlowLayout());
label16 = new JLabel(" Name");
c16.add(label16);
text16 = new JTextField(10);
c16.add(text16);
label26 = new JLabel(" Regtration #");
c16.add(label26);
text26 = new JTextField(10);
c16.add(text26);
label36 = new JLabel(" Marks ");
c16.add(label36);
text36 = new JTextField(10);
c16.add(text36);
save16 = new JButton("Save");
c16.add(save16);
save16.addActionListener(this);
exit16 = new JButton("Exit");
c16.add(exit16);
exit16.addActionListener(this);
ahsanf16.setVisible(true);
}
else if( e.getSource() == b17 )
{
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());
exit17 = new JButton("Exit");
exit17.addActionListener(this);
find17 = new JButton("Record");
find17.addActionListener(this);
label17 = new JLabel("Name ");
label27 = new JLabel(" Registration");
text17 = new JTextField(10);
text27 = new JTextField(10);
c3.add(label17);
c3.add(text17);
c3.add(label27);
c3.add(text27);
c3.add(exit17);
c3.add(find17);
ahsanf2.setVisible(true);
System.out.println("insert");
}
// find17
else if( e.getSource() == find17 )
{
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 Final where Reg_no = '" + text27.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);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}
text17.setText("");
text27.setText("");
stmt.close();
con.close();
}
catch(Exception ie)
{
System.out.println(" exception caught " + ie);
}
}
else if( e.getSource() == b18 )
{
JFrame ahsanf2 = new JFrame("Enter To Delete In Final");
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());
deltex18 = new JTextField(10);
dellab18 = new JLabel("Name");
deltex28 = new JTextField(10);
dellab28 = new JLabel(" Registration #");
delete18 = new JButton("Delete");
c3.add(dellab18);
c3.add(deltex18);
c3.add(dellab28);
c3.add(deltex28);
exit18 = new JButton("Exit");
exit18.addActionListener(this);
delete18.addActionListener(this);
c3.add(delete18);
c3.add(exit18);
ahsanf2.setVisible(true);
}
else if( e.getSource() == exit14 )
{
System.exit(0);
}
else if( e.getSource() == exit18 )
{
System.exit(0);
}
else if( e.getSource() == b19 )
{
System.exit(0);
}
else if( e.getSource() == b20 )
{
JFrame ahsanf2 = new JFrame("Insert Record in Quizes");
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());
label20 = new JLabel(" Name");
c3.add(label20);
text20 = new JTextField(10);
c3.add(text20);
label30 = new JLabel(" Registration #");
c3.add(label30);
text30 = new JTextField(10);
c3.add(text30);
label40 = new JLabel(" Marks ");
c3.add(label40);
text40 = new JTextField(10);
c3.add(text40);
save20 = new JButton("Save");
c3.add(save20);
save20.addActionListener(this);
exit20 = new JButton("Exit");
c3.add(exit20);
exit20.addActionListener(this);
ahsanf2.setVisible(true);
}
else if( e.getSource() == save20 )
{
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 Quiz");
Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Quiz VALUES( '"+text20.getText()+"',"+Integer.parseInt(text30.getText())+","+Integer.parseInt(text40.getText())+" )");
stmt.close();
con.close();
text20.setText(" ");
text30.setText(" ");
text40.setText(" ");
}
catch(Exception be)
{
System.out.println(" exception caught " + be);
}
}
else if( e.getSource() == exit20 )
{
System.exit(0);
}
else if( e.getSource() == save24 )
{
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 Assignment");
Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Assignment VALUES( '"+text24.getText()+"',"+Integer.parseInt(text34.getText())+","+Integer.parseInt(text44.getText())+" )");
stmt.close();
con.close();
text24.setText(" ");
text34.setText(" ");
text44.setText(" ");
}
catch(Exception abe)
{
System.out.println(" exception caught " + abe);
}
}
else if( e.getSource() == exit24 )
{
System.exit(0);
}
else if( e.getSource() == b21 )
{
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());
exit21 = new JButton("Exit");
exit21.addActionListener(this);
find21 = new JButton("Record");
find21.addActionListener(this);
label211 = new JLabel("Name ");
label311 = new JLabel(" Registration");
text211 = new JTextField(10);
text311 = new JTextField(10);
c3.add(label211);
c3.add(text311);
c3.add(label311);
c3.add(text211);
c3.add(exit21);
c3.add(find21);
ahsanf2.setVisible(true);
}
else if( e.getSource() == find21 )
{
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 Quiz where Reg_no = '" + text211.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);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}
text311.setText("");
text211.setText("");
stmt.close();
con.close();
}
catch(Exception iie)
{
System.out.println(" exception caught " + iie);
}
}
else if( e.getSource() == exit21 )
{
System.exit(0);
}
else if( e.getSource() == b22 )
{
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());
deltex22 = new JTextField(10);
dellab22 = new JLabel(" Name");
deltex32 = new JTextField(10);
dellab32 = new JLabel(" Registration #");
delete22 = new JButton("Delete");
c3.add(dellab22);
c3.add(deltex22);
c3.add(dellab32);
c3.add(deltex32);
exit22 = new JButton("Exit");
exit22.addActionListener(this);
delete22.addActionListener(this);
c3.add(delete22);
c3.add(exit22);
ahsanf2.setVisible(true);
}
else if( e.getSource() == exit22 )
{
System.exit(0);
}
else if( e.getSource() == delete22 )
{
String sql;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
Statement stmt = conn.createStatement();
sql = "SELECT * FROM Quiz WHERE Reg_no = '" + deltex32.getText() + "'";
ResultSet rs = stmt.executeQuery(sql);
rs.next();
sql = "DELETE * FROM Quiz WHERE Reg_no = '" + deltex32.getText() + "'";
stmt.executeUpdate(sql);
sql = "DELETE * FROM Quiz WHERE Name = '" + deltex22.getText() + "'";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
deltex22.setText(" ");
deltex32.setText(" ");
}catch(Exception diele)
{
System.out.println(diele);
}
}
else if( e.getSource() == b23 )
{
System.exit(0);
}
else if( e.getSource() == b24 )
{
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);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -