registerdia.java

使用java连接server sql 2000 的一个小作业

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();
              }
              
          }
      
}