zhuce.java

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

import javax.swing.*;

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

public class Zhuce 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();
	JPanel p7=new JPanel();
	
	
	JLabel jlabel=new JLabel("欢迎注册(带*的必填)");
	JLabel  lab1=new JLabel("学号*");
	JLabel  lab10=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);
	JTextField  text8=new JTextField(8);
	
	//JTextField  text7=new JTextField(20);
	//JTextField  text8=new JTextField(20);
	
	JTextArea jtextarea1=new JTextArea(3,50);
	JTextArea jtextarea2=new JTextArea(3,50);
	
	JButton b1=new JButton("确定");
	JButton b2=new JButton("返回");
	
	
	public Zhuce()
	{
		super("欢迎注册：");
		this.setBounds(200,240,800,300);
		this.add("North",p0);
		this.add("Center",p1);
		this.add("South",p7);

		//add(p1, BorderLayout.NORTH);
		p1.add(jlabel);
		
		p1.add(p2);
	    p1.add(p3);
	    p1.add(p4);
	    p1.add(p5);
	    p1.add(p6);

		p2.add(lab1);p2.add(text1);
		p2.add(lab10);p2.add(text8);
		
		p3.add(lab2);p3.add(text2);
		p3.add(lab3);p3.add(text3);
		p4.add(lab4);p4.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);
		    
	    b1.addActionListener(   //添加的事件处理
				new ActionListener()
				{

					public void actionPerformed(ActionEvent e) 
					{
						
						String t1="'"+text1.getText().trim()+"'";
						String t10="'"+text8.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="'"+jtextarea1.getText().trim()+"'";
						String t8="'"+jtextarea2.getText().trim()+"'";
						String t9="'"+text7.getText().trim()+"'";
						
						//String t1="'"+text8.getText().trim()+"'";
						
					     final String url="jdbc:odbc:stuinf";
						
						String sqltianjia="INSERT INTO  Student values(" + t1 + "," + t10 + "," +t2 + "," + t3 + "," + t4 + "," + t5 + "," + t6 + "," + t7 + "," + t8 + "," + t9 + ")";
						
						try
						{
							Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						}
						catch(java.lang.ClassNotFoundException e1)
						{	
						}
						try
						{
							
							Connection con=DriverManager.getConnection(url,"","");
							Statement stmt=con.createStatement();
							System.out.println(sqltianjia);
								stmt.executeUpdate(sqltianjia);
																
								Chenggong cg=new Chenggong();
								cg.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
								cg.setVisible(true);
								
								
								//System.out.print("成功！");
								//jlabel.setText("成功！") ;
							
							stmt.close();
							con.close();
						
						}
						catch(SQLException ex)
						{
							System.out.print(ex.getMessage());
					       	}						
					  }
				}
				);
	    
	          b2.addActionListener(
				
				new ActionListener()
						{
		        public void actionPerformed(ActionEvent e)
				  {
		        	Denglu denglu=new Denglu();
					denglu.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
					denglu.setVisible(true);
				    Zhuce.this.dispose();
								
					  }
		          }
				);
	       }
   }