xueshengjiemian.java

java写的xuesheng信息管理系统！欢迎下载使用

import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class Xueshengjiemian extends JFrame
{
	
	JPanel p0=new JPanel();	
	JPanel p1=new JPanel();	
	JPanel p2=new JPanel();
	JPanel p3=new JPanel();
	JPanel p4=new JPanel();
	JPanel p5=new JPanel();
	JPanel p6=new JPanel();
	
    JLabel  Lab1=new JLabel("学号:");
	JLabel  Lab2=new JLabel("姓名:");
	JLabel  Lab3=new JLabel("出生日期:");
	JLabel  Lab4=new JLabel("性别:");
	JLabel  Lab5=new JLabel("电话:");
	JLabel  Lab6=new JLabel("班级:");
	JLabel  Lab7=new JLabel("地址:");
	JLabel  Lab8=new JLabel("简历:");
	JLabel  Lab9=new JLabel("系名:");
	
	JLabel jlabel=new JLabel("个人信息");
	JTextField  text1=new JTextField(24);
	JTextField  text2=new JTextField(24);
	JTextField  text3=new JTextField(22);
	JTextField  text4=new JTextField(24);
	JTextField  text5=new JTextField(24);
	JTextField  text6=new JTextField(24);
	JTextField  text7=new JTextField(24);                    
    JTextField  text8=new JTextField(24);
    JTextField  text9=new JTextField(24);
    
	
	JButton b1=new JButton("选修课程");
	JButton b2=new JButton("修改信息");
	JButton b3=new JButton("选课查询");
	
	public Xueshengjiemian()
	
	{  
		
		super("学生界面");
		this.setBounds(400,300,480,390);
	 add(p0, BorderLayout.EAST);
	 p0.setLayout(new BorderLayout(1,2));
	
     p0.add("North",p1);
     p0.add("South",p2);
     
     p6.setLayout(new BorderLayout(1,2));
     p6.add("West",p5);
     p6.add("Center",p0);
     
     JLabel jl = null; 
     ImageIcon img = null; 
	 img = new ImageIcon("fengche.jpg"); 
     jl = new JLabel(img); 
     p1.setLayout(new BorderLayout()); 
     p1.add(jl, BorderLayout.CENTER); 
     p2.setLayout(new GridLayout(3,1));
     p2.add(b1);
     p2.add(b2);
 	 p2.add(b3);
	
	
	
	
	add(p5, BorderLayout.WEST);
	p5.setLayout(new GridLayout(2,1,2,2));
	p5.add(p3);  
    p5.add(p4);  
	
	
    p3.setLayout(new FlowLayout(6,3,2));
    p3.add(Lab1);
    p3.add(text1);
	p3.add(Lab2);
    p3.add(text2);    
    p3.add(Lab3);
    p3.add(text3);  
    p3.add(Lab4);
    p3.add(text4);
    p3.add(Lab5);
    p3.add(text5);  
    p3.add(Lab6);
    p3.add(text6); 
   
    
    p4.setLayout(new FlowLayout(6,2,1));
    p4.add(Lab7);
    p4.add(text7);  
    p4.add(Lab8);
    p4.add(text8); 
    p4.add(Lab9);
    p4.add(text9);  
   
    
    String url="jdbc:odbc:stuinf";
	String sql="select * from Student";
	
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}
	catch(java.lang.ClassNotFoundException e)
	{	
	}
	try
	{
		Connection con=DriverManager.getConnection(url,"","");
		Statement stmt=con.createStatement();

			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next())
			{
			String s1=rs.getString("Sno");
			String s2=rs.getString("Sname");
			String s3=rs.getString("Sbirthday");
			String s4=rs.getString("Ssex");
			String s5=rs.getString("Stel");
			String s6=rs.getString("Sclass");
			String s7=rs.getString("Saddress");
			String s8=rs.getString("Sresume");
			String s9=rs.getString("Sdepartment");
			
			System.out.print(s1+","+s2+","+s3+","+s4+","+s5+","+s6+","+s7+","+s8+","+s9);//判断输出结果
				
			JTextField j1=new Denglu().getF1();
			
			if(j1.getText().equals(s1))
			{
				
				text1.setText(s1);
				text2.setText(s2);
				text3.setText(s3);
				text4.setText(s4);
				text5.setText(s5);
				text6.setText(s6);
				text7.setText(s7);
				text8.setText(s8);
				text9.setText(s9);
				
				System.out.print("sdfsdfsdfsdfdsf");
				break;
			}
			
			}
		stmt.close();
		con.close();
	
	}
	catch(SQLException ex)
	{
		System.out.print(ex.getMessage());
	}

    
    
    b1.addActionListener(   //添加的事件处理
			new ActionListener()
			{

				public void actionPerformed(ActionEvent e) 
				{
					
					//catch(SQLException ex)
					{
						//System.out.print(ex.getMessage());
					}
					
					
				}
				
			}
			);
	}
}