user.java.bak

辽宁交通专科学校０３级大三的一个课程设计学生成绩管理信息系统．赵磊

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
class  User extends JFrame implements ActionListener
{
	JFrame f=new JFrame("用户注册");
    JLabel lb1=new JLabel("用户名:",Label.LEFT);
	JLabel lb2=new JLabel("密码:",Label.LEFT);
	JLabel lb3=new JLabel("重复密码:",Label.LEFT);
	JButton bt1=new JButton("确定");
    JButton bt2=new JButton("取消");
	JTextField T1 = new JTextField(15);
    JPasswordField T2 = new JPasswordField(15);
    JPasswordField T3= new JPasswordField(15);
    Container cp=f.getContentPane();
 public User(){
  cp.setBackground(Color.orange);
  bt1.setBackground(Color.pink);
  bt2.setBackground(Color.pink);
  cp.setLayout(null);
  cp.add(lb1);lb1.setBounds(20,10,100,30);
  cp.add(T1);T1.setBounds(120,10,100,30);
  cp.add(lb2);lb2.setBounds(20,50,100,30);
  cp.add(T2);T2.setBounds(120,50,100,30);
  cp.add(lb3);lb3.setBounds(20,90,100,30);
  cp.add(T3);T3.setBounds(120,90,100,30);
  cp.add(bt1);bt1.setBounds(50,130,80,30);
  cp.add(bt2);bt2.setBounds(160,130,80,30);
  bt1.addActionListener(this);
  bt2.addActionListener(this);
  f.setBounds(400,300,300,200);
  f.setVisible(true);
  }
	public static void main(String[] args) 
	{
		String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	     String conURL="jdbc:odbc:Xsstudent";
	      try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	     catch(Exception e){System.out.println("加载驱动失败");}
		 User df=new User();
	}

public void actionPerformed(ActionEvent e){
  if (e.getSource()==bt2){f.setVisible(false);}
  if (e.getSource()==bt1){
	  try{
		  Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent");
          Statement s=con.createStatement();
		  String  str="select * from user where id='"+T1.getText()+"'";
		  ResultSet rs=s.executeQuery(str);
		 	
		  boolean isexit=false;
            try{
			isexit=rs.next();
			
			}catch(Exception ee){}
            	     
		  if(isexit)
		 { 
		  JOptionPane.showMessageDialog(this,"用户名已存在");
		  T1.setText(null);}
		  else{	
			
			String s1=T2.getText();
	        String s2=T3.getText();
	          if (s1.equals(s2)){
	              try{
		           Connection con1=DriverManager.getConnection("jdbc:odbc:Xstudent");
                     Statement b=con1.createStatement();
		           String str1="insert into user values ('"+T1.getText()+"','"+T2.getText()+"')";
                    b.executeUpdate(str1);
		            T1.setText(null);
		            T2.setText(null);
		           T3.setText(null);
				    JOptionPane.showMessageDialog(this,"恭喜你注册成功！");
		           b.close();	
	               con1.close();
                   }catch(Exception ee)
		            {System.out.println("错误信息:"+ee.getMessage());}
		            }                      
               else{
			     JOptionPane.showMessageDialog(this,"密码输入错误，请重新输入密码");
		         T2.setText(null);
		         T3.setText(null);}
		                      } 
	     }
  
   catch(Exception ee)
		    {System.out.println("错误信息:"+ee.getMessage());}
  
 }
}
}