userregrster.java

学生成绩管理系统,可以修改

import java.awt.*;
import javax.swing.*;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserRegrster extends JFrame implements ActionListener{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	 JLabel jLabel1;
	 JLabel jLabel2;
	 JLabel jLabel4;
	 private JLabel jLabel5;
	 JButton jButton2;
	 JButton jButton1;
	 JComboBox jComboBox1;
     JPasswordField jPasswordField2;
     JPasswordField jPasswordField1;
	 JLabel jLabel3;
	 JTextField jTextField1;
              public UserRegrster(){
            	     this.setBounds(431, 223, 278, 309);
            		 this.setLayout(null);
                	 this.setTitle("用户注册");
                	 this.setResizable(false);
                	 this.setVisible(true);
                	 {
                		 jLabel1 = new JLabel();
                		 getContentPane().add(jLabel1);
                		 jLabel1.setText("用户名:");
                		 jLabel1.setBounds(51, 31, 47, 15);
                	 }
                	 {
                		 jTextField1 = new JTextField();
                		 getContentPane().add(jTextField1);
                		 jTextField1.setText("");
                		 jTextField1.setBounds(125, 27, 115, 22);
                	 }
                	 {
                		 jLabel2 = new JLabel();
                		 getContentPane().add(jLabel2);
                		 jLabel2.setText("密码:");
                		 jLabel2.setBounds(51, 70, 47, 15);
                	 }
                	 {
                		 jPasswordField1 = new JPasswordField();
                		 getContentPane().add(jPasswordField1);
                		 jPasswordField1.setText("");
                		 jPasswordField1.setBounds(125, 66, 115, 22);
                	 }
                	 {
                		 jLabel3 = new JLabel();
                		 getContentPane().add(jLabel3);
                		 jLabel3.setText("确认密码:");
                		 jLabel3.setBounds(51, 118, 62, 15);
                	 }
                	 {
                		 jPasswordField2 = new JPasswordField();
                		 getContentPane().add( jPasswordField2);
                		 jPasswordField2.setText("");
                		 jPasswordField2.setBounds(125, 114, 115, 22);
                	 }
                	 {
                		 jLabel4 = new JLabel();
                		 getContentPane().add(jLabel4);
                		 jLabel4.setText("管理权限:");
                		 jLabel4.setBounds(51, 178, 57, 15);
                	 }
                	 {
                		 ComboBoxModel jComboBox1Model = 
                			 new DefaultComboBoxModel(
                					 new String[] { "系统管理员", "录入员" ,"统计员","学生"});
                		 jComboBox1 = new JComboBox();
                		 getContentPane().add(jComboBox1);
                		 jComboBox1.setModel(jComboBox1Model);
                		 jComboBox1.setBounds(125, 172, 115, 26);
                	 }
                	 {
                		 jButton1 = new JButton();
                		 getContentPane().add(jButton1);
                		 jButton1.setText("确定");
                		 jButton1.addActionListener(this);
                		 jButton1.setBounds(57, 228, 68, 22);
                	 }
                	 {
                		 jButton2 = new JButton();
                		 getContentPane().add(jButton2);
                		 jButton2.setText("取消");
                 		 jButton2.addActionListener(this);
                		 jButton2.setBounds(156, 228, 64, 22);
                	 }
                	 {
                		 jLabel5 = new JLabel();
                		 getContentPane().add(jLabel5);
                		 jLabel5.setText("");
                		 jLabel5.setIcon(new ImageIcon(getClass().getClassLoader().getResource("mww.jpg")));
                		 jLabel5.setBounds(-101, -38, 1326, 700);
                	 }
              }
  public void actionPerformed(ActionEvent e)
          	     {
          		if(e.getSource()==jButton2)
          		 {    
          			   this.dispose();
          		   }
          		else if(e.getSource()==jButton1)
          		  {  
          			try
          			{
          				String strSQL="select * from [user1] where UserName='"+
          				jTextField1.getText().trim()+"'";
          				if(jTextField1.getText().trim().equals(""))
          				{
          					JOptionPane.showMessageDialog(null,"用户名不能为空！");
          				}
          				else if(jPasswordField1.getText().trim().equals(""))
          				{
          					JOptionPane.showMessageDialog(null,"密码不能为空！");
          				}
          				else if(!jPasswordField1.getText().trim().equals( jPasswordField2.getText().trim()))
          				{
          					JOptionPane.showMessageDialog(null,"两次输入的密码不一致！");
          				}
          				else
          				{
          				        if(db.getResult(strSQL).first())
          				         {
          					          JOptionPane.showMessageDialog(null,"此用户已经存在，请重新输入用户名！");
          				         }
          				         else 
          				           {
          				         	strSQL="insert into [user1](UserName,PassWord,Power) values('"+jTextField1.getText().trim()+"','"+
          				            jPasswordField1.getText().trim()+"','"+ jComboBox1.getSelectedItem()+"')";
          				         
          				         	if(db.updateSql(strSQL))
          				         	 {  
          				         	   int result=JOptionPane.showOptionDialog(null, "注册用户成功是否要返回登陆界面呢?", "系统提示", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, new String[] {"是","否"}, "否");
          					           if(result==JOptionPane.YES_OPTION){
          		        			       new UserLogin();
          		        			       this.dispose();
          					           }
          					           else{
          					        	  db.closeConnection();//关闭连接数据库
          					        	   this.dispose();
          					           }
          				         	 }
          				         }
          				   }
          			}
          			catch(SQLException sqle)
          			{
          				System.out.println(sqle.toString());
          			 }
          			catch(Exception ex)
          			 {
          				System.out.println(ex.toString());
          			 }
          		}
       }
}