www.pudn.com > st.rar > RegisterDia.java


import java.awt.*; 
import java.awt.event.*; 
import javax.swing.*; 
import java.util.*; 
import java.sql.*; 
 
public class RegisterDia extends JDialog implements ActionListener 
{  
      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(); 
      JPanel p8=new JPanel(); 
      JPanel p9=new JPanel(); 
      JTextField UserIDText=new JTextField(15); 
      JTextField UserNameText=new JTextField(15); 
      JPasswordField PassWordText1=new JPasswordField(15); 
      JPasswordField PassWordText2=new JPasswordField(15); 
      JTextField BirthdayText=new JTextField(15); 
      JTextField PhoneText=new JTextField(15); 
      JTextField EmailText=new JTextField(15); 
       
      JButton ok=new JButton("提交"); 
      JButton cancel=new JButton("返回"); 
       ///////////////////////// 
    String sql;  
    Connection conn;  
    Statement stmt;  
    ResultSet rs;  
  
 
     
     
    public RegisterDia() 
    { 
        setModal(true); 
        setBackground(Color.LIGHT_GRAY); 
        Container contentPane=this.getContentPane(); 
        contentPane.setLayout(new GridLayout(9,1)); 
         
        p2.add(new JLabel("帐号:"));p2.add(UserIDText); 
        p3.add(new JLabel("用户名:"));p3.add(UserNameText); 
        p4.add(new JLabel("密码:"));p4.add(PassWordText1); 
        p5.add(new JLabel("重复密码:"));p5.add(PassWordText2); 
        p6.add(new JLabel("生日:"));p6.add(BirthdayText);;p6.add(new JLabel("YYYY-MM-DD")); 
        p7.add(new JLabel("Email:"));p7.add(EmailText); 
        p8.add(new JLabel("电话:"));p8.add(PhoneText); 
        p9.add(ok);p9.add(cancel); 
         
        UserIDText.addActionListener(this); 
        UserNameText.addActionListener(this);         
        PassWordText1.addActionListener(this); 
        PassWordText2.addActionListener(this); 
        BirthdayText.addActionListener(this); 
        EmailText.addActionListener(this); 
        PhoneText.addActionListener(this); 
        ok.addActionListener(this); 
        cancel.addActionListener(this); 
         
        contentPane.add(p1); 
        contentPane.add(p2); 
        contentPane.add(p3); 
        contentPane.add(p4); 
        contentPane.add(p5); 
        contentPane.add(p6); 
        contentPane.add(p7); 
        contentPane.add(p8); 
        contentPane.add(p9); 
         
        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); 
        setSize(500,700); 
         
        Dimension screen=Toolkit.getDefaultToolkit().getScreenSize(); 
        setLocation((screen.width-400)/2,(screen.height-600)/2); 
        setTitle("----------------------------------学生注册-----------------------------"); 
        setResizable(true); 
        setVisible(true);     
         
         
    } 
      public void actionPerformed(ActionEvent e){ 
          if(e.getSource()==ok) 
          { 
              if(UserIDText.getText().trim().equals("")||UserNameText.getText().trim().equals("")||PassWordText1.getText().trim().equals("")) 
              { 
                  JOptionPane.showMessageDialog(null,"请填写完整个人信息!!"); 
                   
                  UserIDText.requestFocus(); 
                  return; 
                   
              } 
              else if(!PassWordText1.getText().equals(PassWordText2.getText())){ 
                  JOptionPane.showMessageDialog(null,"两次输入密码不一致!!"); 
              } 
              else 
                  try{ 
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
               String url="jdbc:odbc:SUMMIT";  
               String user="sa";  
               String password="198662";  
               conn= DriverManager.getConnection(url,user,password); 
               stmt=conn.createStatement();  
               String tem="'"+UserIDText.getText().trim()+"'";              
               tem=tem+","+"'"+UserNameText.getText().trim()+"'";              
               tem=tem+","+"'"+PassWordText1.getText().trim()+"'";              
               tem=tem+","+"'"+BirthdayText.getText().trim()+"'"; 
               tem=tem+","+"'"+EmailText.getText().trim()+"'"; 
               tem=tem+","+"'"+PhoneText.getText().trim()+"'"; 
             
               
               sql="insert into Student(SNO,SNAME,SPASSWD,BIRTHDAY,EMAIL,PHONE)values("+tem+")";  
               if(stmt.executeUpdate(sql)==1){ 
            	    
            	   try{  sql="insert into HomeWork(TOPIC,SNO)values('0','"+UserIDText.getText().trim()+"')"; 
                   if(stmt.executeUpdate(sql)==1){JOptionPane.showMessageDialog(null, "注册成功"); 
                   conn.close(); 
                   stmt.close(); 
                   dispose();} 
                   else{JOptionPane.showMessageDialog(null, "注册失败");System.exit(0);} 
            	   }catch(Exception e5){JOptionPane.showMessageDialog(null,"注册失败");System.exit(0);} 
               } 
               else {JOptionPane.showMessageDialog(null, "注册失败");System.exit(0);} 
                 
                }catch(Exception e1){JOptionPane.showMessageDialog(null,"注册失败");System.exit(0);} 
 
          } 
              if(e.getSource()==cancel) 
              { 
                  this.dispose(); 
                   
              } 
              if(e.getSource()==PhoneText) 
              { 
                  ok.requestFocus(); 
              } 
               
          } 
       
}