useradd.java

图书馆管理系统：该系统的开发主要包括用户登陆

import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.sql.*;

public class userAdd extends JFrame implements ActionListener
{
	public userAdd()
	{
		setTitle("添加用户");
		setSize(200,200);
		gl=new GridLayout(6,4,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		id=new JLabel("读者ID");
		userlbl=new JLabel("用户名");
		passwordlbl=new JLabel("密码");
		confirmlbl=new JLabel("确认密码");
		powerlbl=new JLabel("登陆权限");
		zjh=new JLabel("证件号");
		gh=new JLabel("工号");
		bzrq=new JLabel("办证时间(2000-0-0)");
		gqsj=new JLabel("过期时间(2000-0-0)");
		yj=new JLabel("押金");
		idtex=new JTextField("");
		usertex=new JTextField("");
		zjhtex=new JTextField("");
		ghtex=new JTextField("");
		bzrqtex=new JTextField("");
		gqsjtex=new JTextField("");
		yjtex=new JTextField("");
		passwordtex=new JPasswordField("");
		confirmtex=new JPasswordField("");
		String[] str={"用户"};
		powercob=new JComboBox(str);
		addbtn=new JButton("确认");
		cancelbtn=new JButton("取消");
		panel.add(id);
		panel.add(idtex);
		panel.add(userlbl);
		panel.add(usertex);
		panel.add(passwordlbl);
		panel.add(passwordtex);
		panel.add(confirmlbl);
		panel.add(confirmtex);
		panel.add(zjh);
		panel.add(zjhtex);
		panel.add(gh);
		panel.add(ghtex);
		panel.add(bzrq);
		panel.add(bzrqtex);
		panel.add(gqsj);
		panel.add(gqsjtex);
		panel.add(yj);
		panel.add(yjtex);
		panel.add(powerlbl);
		panel.add(powercob);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			if(idtex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"读者ID不能为空!");
			return;
		    }			
			if(usertex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
		}
		String  s=new String(passwordtex.getPassword()).trim();
		if(s.equals(""))
		{
			JOptionPane.showMessageDialog(null,"密码名不能为空!");
			return;
		}
		String confirm=new String(confirmtex.getPassword()).trim();
		if(confirm.equals("")||!(confirm.equals(s)))
		{
			JOptionPane.showMessageDialog(null,"密码不一样");
			confirmtex.setText("");
			usertex.setText("");
			passwordtex.setText("");
			return;
		}
		String power=(String)powercob.getSelectedItem();
			{
			String strsql=("insert into 读者权限表(读者ID,用户名,密码,权限) values ('"+idtex.getText().trim()+"','"+usertex.getText().trim()+"','"+s+"','"+power+"')");
			String sql=("insert into 借阅证表(读者ID,证件号,工号,办证时间,过期日期,押金) values ('"+idtex.getText().trim()+"','"+zjhtex.getText().trim()+"','"+ghtex.getText().trim()+"','"+bzrqtex.getText().trim()+"','"+gqsjtex.getText().trim()+"','"+yjtex.getText().trim()+"')"); 
			System.out.println(strsql);
			System.out.println(sql);			
			boolean success=db.executeSql(strsql)&db.executeSql(sql);
			if(!success){
				JOptionPane.showMessageDialog(null,"添加用户不成功，请重新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		if(source==cancelbtn)
		{
			this.dispose();
			return;
		}
	}
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		}
	
	private JLabel id;
	private JLabel userlbl;
	private JLabel passwordlbl;
	private JLabel confirmlbl;
	private JLabel powerlbl;
	private JLabel zjh;
	private JLabel gh;
	private JLabel bzrq;
	private JLabel gqsj;
	private JLabel yj;
	private JTextField idtex;
	private JTextField usertex;
	private JTextField zjhtex;
	private JTextField ghtex;
	private JTextField bzrqtex;
	private JTextField gqsjtex;
	private JTextField yjtex;
	private JPasswordField passwordtex;
	private JPasswordField confirmtex;
	private JComboBox powercob;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private ResultSet rs;
	private DBManager db=new DBManager();
}