gerenjiemian.java

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

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

import javax.swing.*;

 class Gerenjiemian 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();
	JPanel p7=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);
	
	JButton b1=new JButton("修改");
	JButton b2=new JButton("返回");
	
	
	public Gerenjiemian()
	{
		super("个人信息：");
		this.setBounds(200,240,800,300);
		this.add("Center",p1);
		

		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);
		
		add(p7, BorderLayout.SOUTH);
		 p7.add(b1);
		 p7.add(b2);
		
		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 s0=rs.getString("Spwd");
				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());
		}

		b2.addActionListener(
				new ActionListener()
				{
					public void actionPerformed(ActionEvent arg0)
					{
						Chaxun chaxun=new Chaxun();
						chaxun.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
						chaxun.setVisible(true);
						
						Gerenjiemian.this.dispose();
					
					}	
				}
		);
		
		
		b1.addActionListener(    //修改的事件处理
				
				
				new ActionListener()
				{

					public void actionPerformed(ActionEvent e1) 
					{
					
					
						
						final String url="jdbc:odbc:stuinf";
						String mm=text1.getText().trim();
						
						System.out.println(mm);
						String sqlshanchu="Delete  from Student where sno='"+mm+"'";
						try
						{
							Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						}
						catch(java.lang.ClassNotFoundException e)
						{	
						}
						try
						{
							
							Connection con=DriverManager.getConnection(url,"","");
							Statement stmt=con.createStatement();

								int rs=stmt.executeUpdate(sqlshanchu);
																				
							
							stmt.close();
							con.close();
						
						}
						catch(SQLException ex)
						{
							System.out.print(ex.getMessage());
						}
						
						
					String t1="'"+text1.getText().trim()+"'";
					String t2="'"+text2.getText().trim()+"'";
					String t3="'"+text3.getText().trim()+"'";
					String t4="'"+text4.getText().trim()+"'";
					String t5="'"+text5.getText().trim()+"'";
					String t6="'"+text6.getText().trim()+"'";
					String t7="'"+text7.getText().trim()+"'";
					String t8="'"+jtextarea1.getText().trim()+"'";
					String t9="'"+jtextarea2.getText().trim()+"'";
					//String t9="'"+text10.getText().trim()+"'";
					String t10="'"+123456+"'";
				
					
					String sqltianjia="INSERT INTO  Student values(" + t1 + "," + t10 + "," +t2 + "," + t3 + "," + t4 + "," + t5 + "," + t6 + "," + t8 + "," + t9 + "," + t7 + ")";
					
									
					
					try
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					}
					catch(java.lang.ClassNotFoundException e)
					{	
					}
					try
					{
						
						Connection con=DriverManager.getConnection(url,"","");
						Statement stmt=con.createStatement();
						System.out.println(sqltianjia);
						stmt.executeUpdate(sqltianjia);
						
						Xiugaichenggong cg=new Xiugaichenggong();
						cg.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
						cg.setVisible(true);
							
						
						stmt.close();
						con.close();
					
					}
					catch(SQLException ex)
					{
						System.out.print(ex.getMessage());
					}
					
					
				}
				
			}

		
		
		);
		
					
	}
}