xueshengxinxi.java

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

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

 class Xueshengxinxi extends JFrame
{

	JPanel p1=new JPanel();
	JPanel p2=new JPanel();
	JPanel p3=new JPanel();
	JPanel p4=new JPanel();
	JPanel p5=new JPanel();
	JPanel p6=new JPanel();
	JButton bu1=new JButton("请点击跳转至操作界面");
	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("系");
	JTextField  text1=new JTextField(10);
	JTextField  text2=new JTextField(10);
	JTextField  text3=new JTextField(10);
	JTextField  text4=new JTextField(10);
	JTextField  text5=new JTextField(10);
	JTextField  text6=new JTextField(10);
	JTextField  text7=new JTextField(10);
	
	JTextArea jtextarea1=new JTextArea(3,50);
	JTextArea jtextarea2=new JTextArea(3,50);
	
	public Xueshengxinxi()
	{
		super("你的信息：");
		this.setSize(800,300);
		this.add("Center",p1);
		this.add("South",bu1);

		p1.add(p2);
	    p1.add(p3);
	    p1.add(p4);
	    p1.add(p5);
	    p1.add(p6);

		p2.add(lab1);p2.add(text1);
		p2.add(lab2);p2.add(text2);
		p3.add(lab3);p3.add(text3);
		p3.add(lab4);p3.add(text4);
		p4.add(lab5);p4.add(text5);
		p4.add(lab6);p4.add(text6);
		p4.add(lab9);p4.add(text7);
		
		p5.add(lab7);
		p5.add(jtextarea1);
		p6.add(lab8);
		p6.add(jtextarea2);
		
		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);
					jtextarea1.setText(s7);
					jtextarea2.setText(s8);
					text7.setText(s9);
			
					
					System.out.print("sdfsdfsdfsdfdsf");
					break;
				}
				
				}
			stmt.close();
			con.close();
		
		}
		catch(SQLException ex)
		{
			System.out.print(ex.getMessage());
		}

		bu1.addActionListener(
				new ActionListener()
				{
					public void actionPerformed(ActionEvent arg0)
					{
						Xinxicaozuo caozuo=new Xinxicaozuo();
						caozuo.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
						caozuo.setVisible(true);
						
						Xueshengxinxi.this.dispose();
					
					}	
				}
		);
	
	}
}