tyj.java

学生信息管理系统

    p3.add(b3); 
    add(p1,"North"); 
    add(p2,"Center"); 
    add(p3,"South"); 
    setSize(300,250); 
    setBackground(Color.cyan); 
  } 
  public void actionPerformed(ActionEvent e){ 
  	if(e.getSource()==b1){ 
  	    try{ 
  	    	String num,name,sex,subject,grade,born; 
  	        con=DriverManager.getConnection("jdbc:odbc:data","",""); 
  	        ResultSet rs=sql.executeQuery("SELECT * FROM jesse "); 
  	        while(rs.next()){ 
  		        num=rs.getString("学号"); 
  		        name=rs.getString("姓名"); 
  		        sex=rs.getString("性别"); 
  		        subject=rs.getString("专业"); 
  		        grade=rs.getString("年级"); 
  		        born=rs.getString("出生"); 
  		        if(num.equals(t1.getText().trim())){ 
  			        t2.setText(name); 
  			        t3.setText(sex); 
  			        t4.setText(subject); 
  			        t5.setText(grade); 
  			        t6.setText(born); 
  			        break; 
  		        } 
  		    } 
  	        con.close(); 
  	     } 
  	     catch(SQLException ee){} 
  	} 
  	if(e.getSource()==b2){ 
  		try{update();} 
  		catch(SQLException ee){} 
  	} 
  	if(e.getSource()==b3){ 
  		t2.setText(" "); 
  		t3.setText(" "); 
  		t4.setText(" "); 
  		t5.setText(" "); 
  		t6.setText(" "); 
  	} 
  } 
  public void update() throws SQLException{ 
  	String s1="'"+t1.getText().trim()+"'"; 
  	String s2="'"+t2.getText().trim()+"'"; 
  	String s3="'"+t3.getText().trim()+"'"; 
  	String s4="'"+t4.getText().trim()+"'"; 
  	String s5="'"+t5.getText().trim()+"'"; 
  	String s6="'"+t6.getText().trim()+"'"; 
  	String temp="UPDATE jesse SET 姓名 ="+s2+", 性别="+s3+", 专业="+s4+", 年级="+s5+", 出生="+s6+" WHERE 学号="+s1; 
  	con=DriverManager.getConnection("jdbc:odbc:data","",""); 
  	sql.executeQuery(temp); 
  	con.close(); 
  } 
} 
class Delete extends Panel implements ActionListener{ 
  Connection con; 
  Statement sql; 
  TextField t1,t2,t3,t4,t5,t6; 
  Button b; 
  Box baseBox,bv1,bv2; 
  Delete(){ 
  	try{ 
  		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
  		} 
  	catch(ClassNotFoundException e){} 
    try{ 
    	con=DriverManager.getConnection("jdbc:odbc:data","",""); 
    	sql=con.createStatement(); 
    } 
    catch(SQLException ee){} 
    setLayout(new BorderLayout()); 
    b=new Button("删除"); 
    b.setBackground(Color.cyan); 
    b.addActionListener(this); 
    t1=new TextField(8); 
    t1.addActionListener(this); 
    t2=new TextField(16); 
    t3=new TextField(16); 
    t4=new TextField(16); 
    t5=new TextField(16); 
    t6=new TextField(16); 
    t2.setEditable(false); 
    t3.setEditable(false); 
    t4.setEditable(false); 
    t5.setEditable(false); 
    t6.setEditable(false); 
    Panel p1=new Panel(),p2=new Panel(); 
    p1.add(new Label("输入要删除的学号")); 
    p1.add(t1); 
    p1.add(b); 
    bv1=Box.createVerticalBox(); 
  	bv1.add(new Label("姓名")); 
  	bv1.add(Box.createVerticalStrut(8)); 
  	bv1.add(new Label("性别")); 
  	bv1.add(Box.createVerticalStrut(8)); 
  	bv1.add(new Label("专业")); 
  	bv1.add(Box.createVerticalStrut(8)); 
  	bv1.add(new Label("年级")); 
  	bv1.add(Box.createVerticalStrut(8)); 
  	bv1.add(new Label("出生")); 
  	bv1.add(Box.createVerticalStrut(8)); 
  	bv2=Box.createVerticalBox(); 
  	bv2.add(t2); 
  	bv2.add(Box.createVerticalStrut(8)); 
  	bv2.add(t3); 
  	bv2.add(Box.createVerticalStrut(8)); 
  	bv2.add(t4); 
  	bv2.add(Box.createVerticalStrut(8)); 
  	bv2.add(t5); 
  	bv2.add(Box.createVerticalStrut(8)); 
  	bv2.add(t6); 
  	bv2.add(Box.createVerticalStrut(8)); 
  	baseBox=Box.createHorizontalBox(); 
  	baseBox.add(bv1); 
  	baseBox.add(Box.createHorizontalStrut(10)); 
  	baseBox.add(bv2); 
  	p2.add(baseBox); 
  	add(p1,"North"); 
  	add(p2,"Center"); 
  	setSize(300,250); 
  	setBackground(Color.green); 
  } 
  public void actionPerformed(ActionEvent e){ 
  	if(e.getSource()==t1){ 
  		try{delete();} 
  	    catch(SQLException ee){} 
  	} 
  	else if(e.getSource()==b){ 
  	    int n=JOptionPane.showConfirmDialog(this,"确定要删除该学号及全部信息吗?","确定",JOptionPane.YES_NO_OPTION); 
  	    if(n==JOptionPane.YES_OPTION){ 
  	   	    try{ 
  	   	    	String s1="'"+t1.getText().trim()+"'"; 
  	   	        String temp="DELETE FROM jesse WHERE 学号="+s1; 
  	            con=DriverManager.getConnection("jdbc:odbc:data","",""); 
  	            sql.executeUpdate(temp); 
  	            con.close(); 
  	           } 
  	        catch(SQLException ee){} 
  	    } 
  	    else if(n==JOptionPane.NO_OPTION){} 
    } 
  } 
  public void delete() throws SQLException{ 
  	String num,name,sex,subject,grade,born; 
  	con=DriverManager.getConnection("jdbc:odbc:data","",""); 
  	ResultSet rs=sql.executeQuery("SELECT * FROM jesse "); 
  	while(rs.next()){ 
  		num=rs.getString("学号"); 
  		name=rs.getString("姓名"); 
  		sex=rs.getString("性别"); 
  		subject=rs.getString("专业"); 
  		grade=rs.getString("年级"); 
  		born=rs.getString("出生"); 
  		if(num.equals(t1.getText().trim())){ 
  			t2.setText(name); 
  			t3.setText(sex); 
  			t4.setText(subject); 
  			t5.setText(grade); 
  			t6.setText(born); 
  			break; 
  		} 
  	} 
  	con.close(); 
  }	 
} 
public class tyj extends Frame implements ActionListener{ 
  MenuBar bar=null; 
  Menu menu1,menu2,menu3,menu4,menu5; 
  MenuItem item1,item2,item3,item4,item5; 
  Add zengjia; 
  Query chaxun; 
  Update gengxin; 
  Delete shanchu; 
  tyj(){ 
  	super("欢迎进入学生信息管理系统"); 
  	zengjia=new Add(); 
  	chaxun=new Query(); 
    gengxin=new Update(); 
    shanchu=new Delete(); 
    bar=new MenuBar(); 
    menu1=new Menu("信息录入"); 
    menu2=new Menu("信息查询"); 
    menu3=new Menu("信息更新"); 
    menu4=new Menu("信息删除"); 
    menu5=new Menu("退出系统"); 
    item1=new MenuItem("录入"); 
    item2=new MenuItem("查询"); 
    item3=new MenuItem("更新"); 
    item4=new MenuItem("删除"); 
    item5=new MenuItem("退出"); 
    menu1.add(item1); 
    menu2.add(item2); 
    menu3.add(item3); 
    menu4.add(item4); 
    menu5.add(item5); 
    bar.add(menu1); 
    bar.add(menu2); 
    bar.add(menu3); 
    bar.add(menu4); 
    bar.add(menu5); 
    setMenuBar(bar); 
    item1.addActionListener(this); 
    item2.addActionListener(this); 
    item3.addActionListener(this); 
    item4.addActionListener(this); 
    item5.addActionListener(this); 
    Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER); 
    String s=" "; 
    Font f=new Font(s,Font.BOLD,22); 
    label.setFont(f); 
    label.setBackground(Color.GREEN); 
    label.setForeground(Color.BLUE); 
    add(label,"Center"); 
    setVisible(true); 
    setSize(320,300); 
  } 
  public void actionPerformed(ActionEvent e){ 
  	if(e.getSource()==item1){ 
  		removeAll(); 
  		add(zengjia,"Center"); 
  		validate(); 
  	} 
   if(e.getSource()==item2){ 
  		removeAll(); 
  		add(chaxun,"Center"); 
  		validate(); 
  	} 
   if(e.getSource()==item3){ 
  		removeAll(); 
  		add(gengxin,"Center"); 
  		validate(); 
  	} 
   if(e.getSource()==item4){ 
  		removeAll(); 
  		add(shanchu,"Center"); 
  		validate(); 
  	} 
  	if(e.getSource()==item5){ 
  		removeAll(); 
  		setBackground(Color.GREEN); 
  		Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER); 
  		String s=" "; 
        Font f=new Font(s,Font.BOLD,22); 
        label.setFont(f); 
        label.setForeground(Color.BLUE); 
        add(label,"Center"); 
        validate(); 
  	} 
  } 
  public static void main(String[] args) 
  { 
  	tyj jesse=new tyj(); 
  	jesse.setVisible(true); 
  	jesse.addWindowListener(new WindowAdapter(){ 
  		public void windowClosing(WindowEvent e){ 
  			System.exit(0); 
  		} 
  	}); 
  } 
}