studentmanage.java

通过JAVA语言编写的学生信息管理系统

        input.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e) {
        		cardlayout1.show(p,"Input");
        		it1.setText("");it2.setText("");it4.setText("");it5.setText("");it6.setText("");
        	}
        });   
        change.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e) {
        		cardlayout1.show(p,"Change");
        		ct1.setText("");ct2.setText("");crb1.setSelected(true);crb2.setSelected(false);ct4.setText("");ct5.setText("");ct6.setText("");
        		cb2.setEnabled(false);
        	}
        });    
        delete.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e) {
        		cardlayout1.show(p,"Delete");
        		dt1.setText("");dt2.setText("");drb1.setSelected(false);dt4.setText("");dt5.setText("");dt6.setText("");
        	}
        });    
        find.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e) {
        		Findmessage F=new Findmessage();
        	}
        }); 
        about.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		cardlayout1.show(p,"About");

        	}
        });
        
        //重置按钮事件
        ib2.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		it1.setText("");it2.setText("");it4.setText("");it5.setText("");it6.setText("");
        	}
        }); 
        cb3.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		ct1.setEditable(true);
        		ct1.setText("");ct2.setText("");crb1.setSelected(true);crb2.setSelected(false);ct4.setText("");ct5.setText("");ct6.setText("");
        		cb2.setEnabled(false);
        	}
        }); 
        db3.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		dt1.setText("");dt2.setText("");drb1.setSelected(false);dt4.setText("");dt5.setText("");dt6.setText("");
        		db2.setEnabled(false);
        	}
        }); 	
        
        
        //设置录入按钮事件    
        ib1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent E) {
        		try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException e){
					System.out.println("SQLException:"+e.getMessage());
				}
				try{
					Connection con = DriverManager.getConnection("jdbc:odbc:DB");
					Statement stmt = con.createStatement();				
					String sqlstr = "insert into student values('"+it1.getText()+"','"+it2.getText()+"','"+gettext()+"','"+it4.getText()+"','"+it5.getText()+"','"+it6.getText()+"')";
					stmt.executeUpdate(sqlstr);
					stmt.close();
					con.close();
					JOptionPane.showMessageDialog(null,"学生记录添加成功!", "提示信息",JOptionPane.INFORMATION_MESSAGE);
				}
				catch(SQLException e){
					JOptionPane.showMessageDialog(null, e.getMessage(), "警告",JOptionPane.WARNING_MESSAGE);				
				}
			}
        });  
        
        //开始修改按钮事件
        cb1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent E) {
        		
        		try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException e){
					System.out.println("SQLException: "+e.getMessage());
				}
				try{	
					Connection con = DriverManager.getConnection("jdbc:odbc:DB");
					Statement stmt = con.createStatement();
					ResultSet rs = stmt.executeQuery("select * from student");
					
					while(rs.next()){
						if(ct1.getText().equals(rs.getString("Stuno"))){
							ct2.setText(rs.getString("Stuname"));
							if(rs.getString("Stusex").equals("男")){
								crb1.setSelected(true);
							}
							else {crb2.setSelected(true);}
							ct4.setText(rs.getString("Stuspecialy"));
							ct5.setText(rs.getString("Stugread"));
							ct6.setText(rs.getString("Stubirth"));
							ct1.setEditable(false);
							cb2.setEnabled(true);
							break;
						}
						else if(ct1.getText().equals("")){
							JOptionPane.showMessageDialog(null,"请输入学号进行修改!", "警告",JOptionPane.WARNING_MESSAGE);
							break;
						}		
					}	
					rs.close();
					stmt.close();
					con.close();
						
				}
				catch(SQLException e){	
					JOptionPane.showMessageDialog(null,e.getMessage(), "警告",JOptionPane.WARNING_MESSAGE);
				}
			}
        }); 
        //录入修改按钮事件
        cb2.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent E) {
        		try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException e){
					System.out.println("SQLException:"+ e.getMessage());
				}
				try{
					String str=gettext();
					Connection con = DriverManager.getConnection("jdbc:odbc:DB");
					Statement stmt = con.createStatement();
					String sql = "update student set Stuno='"+ct1.getText()+"',Stuname = '"+ct2.getText()+"',Stuspecialy='"+ct4.getText()+"',Stugread='"+ct5.getText()+"',Stubirth='"+ct6.getText()+"'"+"where Stuno ='"+ct1.getText()+"'";
					stmt.executeUpdate(sql);
					if(crb1.isSelected()){sql="update student set Stusex='男'"+"where Stuno ='"+ct1.getText()+"'";}
					else{sql="update student set Stusex='女'"+"where Stuno ='"+ct1.getText()+"'";}
					stmt.executeUpdate(sql);
					stmt.close();
					con.close();
					JOptionPane.showMessageDialog(null,"记录更新成功!", "提示信息",JOptionPane.INFORMATION_MESSAGE);
				}
				catch(SQLException e){
					JOptionPane.showMessageDialog(null,e.getMessage(), "警告",JOptionPane.WARNING_MESSAGE);;
				}
			}
        });
     
        //显示按钮事件
		 db1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent E) {
        		try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException e){
					System.out.println("SQLException: "+e.getMessage());
				}
				try{	
					Connection con = DriverManager.getConnection("jdbc:odbc:DB");
					Statement stmt = con.createStatement();
					ResultSet rs = stmt.executeQuery("select * from student where Stuno='"+dt1.getText()+"'");
					while(rs.next()){
						if(dt1.getText().equals(rs.getString("Stuno"))){
							dt2.setText(rs.getString("Stuname"));
							if(rs.getString("Stusex").equals("男")){
								drb1.setSelected(true);
							}
							else {drb2.setSelected(true);}
							dt4.setText(rs.getString("Stuspecialy"));
							dt5.setText(rs.getString("Stugread"));
							dt6.setText(rs.getString("Stubirth"));
							String sql = "delete from student where Stuno='"+dt1.getText()+"'";
							break;
						}	
					}
					if(dt1.getText().equals("")){
						JOptionPane.showMessageDialog(null,"请输入学号进行删除记录的操作!", "警告",JOptionPane.WARNING_MESSAGE);
					}
					rs.close();
					stmt.close();
					con.close();
					db2.setEnabled(true);
				}
				catch(SQLException e){	
					JOptionPane.showMessageDialog(null,e.getMessage(), "警告",JOptionPane.WARNING_MESSAGE);
				}
			}
        });  
        //删除按钮事件 
        db2.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent E) {
        		try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(ClassNotFoundException e){
					System.out.println("SQLException: "+e.getMessage());
				}
				try{	
					if(dt1.getText().equals("")||dt2.getText().equals("")){
						JOptionPane.showMessageDialog(null,"删除失败!", "提示信息",JOptionPane.INFORMATION_MESSAGE);
					}
					else{
						Connection con = DriverManager.getConnection("jdbc:odbc:DB");
						Statement stmt = con.createStatement();
						if(JOptionPane.showConfirmDialog(null,"单击'是'删除该记录,单击'否'取消该操作!","警告",JOptionPane.YES_NO_OPTION,JOptionPane.WARNING_MESSAGE)==JOptionPane.YES_OPTION){
							String sql = "delete from student where Stuno='"+dt1.getText()+"'";
							stmt.executeUpdate(sql);
							JOptionPane.showMessageDialog(null,"该条记录已被删除成功!", "提示信息",JOptionPane.INFORMATION_MESSAGE);
							stmt.close();
							con.close();
						}
					}	
				}
				catch(SQLException e){	
					JOptionPane.showMessageDialog(null,e.getMessage(), "警告",JOptionPane.WARNING_MESSAGE);
				}
			}
        });                                                   
	}
	//获得单选框文本的方法
	String gettext(){
		if (irb1.isSelected()||crb1.isSelected()||drb1.isSelected())
			return "男";	
		else
			return "女";
	}
	//主方法
	public static void main(String args[]){
		Studentmanage stu=new Studentmanage();
	}	
}