人员管理系统——java语言

package contacts;import javax.swing.*;import java.awt.*;import java.awt.event.*;public class Main extends JFrame implements ActionListener{	/**	 * 	 */	/**Create the main UI*/	private static final long serialVersionUID = 1L;	JLabel label = new JLabel("用户：",JLabel.RIGHT);	JLabel label1 = new JLabel("密码：",JLabel.RIGHT);	JTextField jtfuser = new JTextField(10);	JPasswordField jtfpassword = new JPasswordField(10);	JButton button = new JButton("登录");	JButton button1 = new JButton("退出");	public Main(){		setTitle("人员管理系统（登录）");		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);		this.setResizable(false);		Container componentPane = this.getContentPane();		setLayout(new FlowLayout());		componentPane.add(label);		componentPane.add(jtfuser);		componentPane.add(label1);		componentPane.add(jtfpassword);		componentPane.add(button);		componentPane.add(button1);				setBounds(476,227,212,150);		setVisible(true);				button1.addActionListener(this);		button.addActionListener(this);	}	public static void main(String[] args) {		// TODO Auto-generated method stub		Main main = new Main();			}	@Override	public void actionPerformed(ActionEvent e) {		// TODO Auto-generated method stub		if(e.getActionCommand()=="退出"){			System.exit(0);		}		if(e.getActionCommand() == "登录"){			new Person();			this.dispose();		}	}}-------------------------package contacts;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.ResultSet;import java.sql.SQLException;public class Person extends JFrame implements ActionListener{		/**	 * 	 */	private static final long serialVersionUID = 1L;		SQLOperator sqlOperator = new SQLOperator();		JMenuBar jMenuBar = new JMenuBar();	JMenu personMenu = new JMenu("人员管理");	JMenu systemMenu = new JMenu("系统");	JMenuItem addItem = new JMenuItem("人员增加");	JMenuItem deleteItem = new JMenuItem("人员删除");	JMenuItem updateItem = new JMenuItem("人员更新");	JMenuItem switchItem = new JMenuItem("切换用户");	JMenuItem exitItem = new JMenuItem("退出");		JLabel label = new JLabel("人员管理系统",JLabel.CENTER);	JLabel jlname = new JLabel("姓名：");	JTextField jtfname = new JTextField("请输入姓名",8);	JButton button = new JButton("查询");	JButton button1 = new JButton("查询全部");	JTable table = new JTable();	JScrollPane jScrollPane = new JScrollPane(table);	public Person(){		setTitle("人员管理系统");		this.setResizable(false);				Container contentPane = this.getContentPane();		personMenu.add(addItem);		personMenu.add(deleteItem);		personMenu.add(updateItem);		systemMenu.add(switchItem);		systemMenu.add(exitItem);		jMenuBar.add(personMenu);		jMenuBar.add(systemMenu);		setJMenuBar(jMenuBar);				label.setFont(new Font("楷体",Font.BOLD,30));		JPanel panel = new JPanel();		panel.setLayout(new FlowLayout());		panel.add(jlname);		panel.add(jtfname);		panel.add(button);		panel.add(button1);		panel.setBackground(new Color(58,104,167));		contentPane.add(label,BorderLayout.NORTH);		contentPane.add(panel,BorderLayout.CENTER);		contentPane.add(jScrollPane,BorderLayout.SOUTH);		setBounds(199,77,819,589);		setVisible(true);				addItem.addActionListener(this);		deleteItem.addActionListener(this);		updateItem.addActionListener(this);		switchItem.addActionListener(this);		exitItem.addActionListener(this);		jtfname.addActionListener(this);		button.addActionListener(this);		button1.addActionListener(this);	}	public void actionPerformed(ActionEvent e){		if(e.getSource() == exitItem){			System.exit(0);		}		if(e.getSource() == switchItem){			this.dispose();			new Main();					}		if(e.getSource() == jtfname || e.getSource() == button){			String name = jtfname.getText();			String sql = "select * from Contacts where name = ?";			String[] names = {name};			ResultSet rs = sqlOperator.query(sql, names);						try {				Utilities.displayResultSet(table, rs);				table.validate();			} catch (SQLException e1) {				// TODO Auto-generated catch block				e1.printStackTrace();			}					}		if(e.getSource() == button1){			String sql = "select * from Contacts";			ResultSet rs = sqlOperator.query(sql);			try{				Utilities.displayResultSet(table, rs);				table.validate();			}catch(SQLException e1){				e1.printStackTrace();			}		}		if(e.getSource() == addItem){			AddContacts addContacts = new AddContacts();			addContacts.setBounds(344,203,307, 345);			addContacts.setVisible(true);					}		if(e.getSource() == deleteItem){			String name;			//这里有Bug			if((name = JOptionPane.showInputDialog(Person.this, "请输入要删除人员姓名：", "人员管理系统", JOptionPane.INFORMATION_MESSAGE)) == null)				return;			if(name.equals("")){				JOptionPane.showMessageDialog(Person.this, "输入的不能为空", "ERROR",JOptionPane.ERROR_MESSAGE);				return;			}							String sql = "delete from Contacts where name = ?";			String[] names = {name};			int i = sqlOperator.update(sql, names);			if(i==1){				JOptionPane.showMessageDialog(Person.this, "成功删除人员"+name, "人员管理系统（删除）", JOptionPane.INFORMATION_MESSAGE);			}else{				JOptionPane.showMessageDialog(Person.this, "要删除的人员不存在", "ERROR", JOptionPane.ERROR_MESSAGE);			}		}	}}-----------package contacts;import javax.swing.*;import java.awt.BorderLayout;import java.awt.Container;import java.awt.FlowLayout;import java.awt.Font;import java.awt.GridLayout;import java.awt.event.*;public class AddContacts extends JFrame implements ActionListener{	SQLOperator sqlOperator = new SQLOperator();		JLabel label = new JLabel("人员管理系统",JLabel.CENTER);	JLabel jlname = new JLabel("姓名：",JLabel.RIGHT);	JLabel jlage = new JLabel("年龄：",JLabel.RIGHT);	JLabel jltel = new JLabel("电话：",JLabel.RIGHT);	JLabel jlqq = new JLabel("QQ:",JLabel.RIGHT);	JTextField jtfname = new JTextField(6);	JTextField jtfage = new JTextField(6);	JTextField jtftel = new JTextField(11);	JTextField jtfqq = new JTextField(12);	JButton button = new JButton("确定");	JButton button1 = new JButton("取消");	Font font = new Font("楷体",Font.BOLD,30);	public AddContacts(){		setTitle("添加");				this.setResizable(false);				Container contentPane = this.getContentPane();				jtfname.setFont(font);		jtfage.setFont(font);		label.setFont(new Font("楷体",Font.BOLD,35));		JPanel panel = new JPanel();		panel.setLayout(new GridLayout(4,2));		panel.add(jlname);		panel.add(jtfname);		panel.add(jlage);		panel.add(jtfage);		panel.add(jltel);		panel.add(jtftel);		panel.add(jlqq);		panel.add(jtfqq);				JPanel panel1 = new JPanel();		panel1.setLayout(new FlowLayout());		panel1.add(button);		panel1.add(button1);				contentPane.add(label,BorderLayout.NORTH);		contentPane.add(panel,BorderLayout.CENTER);		contentPane.add(panel1,BorderLayout.SOUTH);				button.addActionListener(this);		button1.addActionListener(this);		jtfname.addActionListener(this);		jtfage.addActionListener(this);		jtftel.addActionListener(this);		jtfqq.addActionListener(this);			}	@Override	public void actionPerformed(ActionEvent e) {		// TODO Auto-generated method stub		if(e.getSource() == button || e.getSource()==jtfname || e.getSource()==jtfage || e.getSource()==jtftel || e.getSource() == jtfqq){			String[] rows = {jtfname.getText().toString().trim(),jtfage.getText().toString().trim(),jtftel.getText().toString().trim(),jtfqq.getText().toString().trim()};			for(int i = 0;i<rows.length;i++){				if(rows[i].equals("")){					JOptionPane.showMessageDialog(AddContacts.this,"必须填满","ERROR",JOptionPane.INFORMATION_MESSAGE);					return;				}			}			String sql = "insert into Contacts values(?,?,?,?)";			int i = sqlOperator.update(sql, rows);			if(i == 1){				JOptionPane.showMessageDialog(AddContacts.this, "增加人员"+jtfname.getText()+"成功", "人员管理系统", JOptionPane.INFORMATION_MESSAGE);							}else{				JOptionPane.showMessageDialog(AddContacts.this, "添加失败");			}		}		if(e.getSource() == button1){			this.dispose();		}	}}··························package contacts;import java.awt.Component;import java.sql.*;import javax.swing.JOptionPane;public class DBConnection {	public static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";	public static final String URL = "jdbc:sqlserver://LVXIANG\\SQLEXPRESS;DatabaseName=UserInfo";	public static final String USER = "sa";	public static final String PASSWORD = "*************";		static{		try{			Class.forName(DRIVER);		}catch(ClassNotFoundException e){			JOptionPane.showMessageDialog((Component)null, "加载驱动失败","ERROR",JOptionPane.ERROR_MESSAGE);			e.printStackTrace();		}	}	public Connection getConnection(){		Connection conn = null;		try{			conn = DriverManager.getConnection(URL, USER, PASSWORD);		}catch(SQLException e){			JOptionPane.showMessageDialog((Component)null, e.toString());		}		return conn;	}	public void close(Connection conn){		if(conn != null){			try{				conn.close();			}catch(SQLException e){				e.printStackTrace();			}		}	}	public void close(PreparedStatement pstmt){		if(pstmt != null){			try{				pstmt.close();			}catch(SQLException e){				e.printStackTrace();			}		}	}	public void close(ResultSet rs){		if(rs != null){			try{				rs.close();			}catch(SQLException e){				e.printStackTrace();			}		}	}}--------------------------package contacts;import java.sql.*;public class SQLOperator {		DBConnection db = new DBConnection();			public ResultSet query(String sql,Object[] objs){		Connection conn = db.getConnection();		ResultSet rs = null;		PreparedStatement pstmt = null;		try {			pstmt = conn.prepareStatement(sql);			for(int i = 0;i<objs.length;i++){				pstmt.setString(i+1, (String)objs[i]);			}			rs = pstmt.executeQuery();		} catch (SQLException e) {			// TODO Auto-generated catch block			e.printStackTrace();		}		return rs;	}	public ResultSet query(String sql){		Connection conn = db.getConnection();		ResultSet rs = null;		Statement stmt = null;		try{			stmt = conn.createStatement();			rs = stmt.executeQuery(sql);		}catch(SQLException e){			e.printStackTrace();		}		return rs;	}	public int update(String sql,Object[] objs){		Connection conn = db.getConnection();		PreparedStatement pstmt = null;		int row = 0;		try{			pstmt = conn.prepareStatement(sql);			for(int i = 0;i<objs.length;i++){				pstmt.setString(i+1, (String)objs[i]);			}			row = pstmt.executeUpdate();		}catch(SQLException e){			e.printStackTrace();		}finally{			db.close(conn);			db.close(pstmt);		}		return row;	}}···········································package contacts;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.util.Vector;import javax.swing.JOptionPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel; public class Utilities {    /**     * 功能：实现结果集的表格显示     */    public static void displayResultSet(JTable table, ResultSet rs)            throws SQLException {        //       // rs.beforeFirst();// 指针移到第一条记录前面        boolean hasRecords = rs.next();         if (!hasRecords) { // 记录集为空，提示一条消息            JOptionPane.showMessageDialog(table, "无相关记录", "Check your input!",                    JOptionPane.ERROR_MESSAGE);            return;        }         Vector<String> columnHeads = new Vector<String>();// 用于存储表头字段(列名)        Vector<Vector> rows = new Vector<Vector>();// 用于存储记录行        try {            // 获取字段的名称            ResultSetMetaData rsmd = rs.getMetaData();            for (int i = 1; i <= rsmd.getColumnCount(); ++i)                columnHeads.addElement(rsmd.getColumnName(i));             do {// 获取记录集                rows.addElement(getNextRow(rs, rsmd));            } while (rs.next());            // 建立相应的TableModel,并将TableModel应用到Table中显示出来            DefaultTableModel model = new DefaultTableModel(rows, columnHeads);            table.setModel(model);            return;        } catch (SQLException exc) {            JOptionPane.showMessageDialog(table, exc.toString(),                    "Check your input!", JOptionPane.ERROR_MESSAGE);            return;        }    }     /**     * 被displayResultSet(JTable table, ResultSet rs)调用, 以Vector形式返回一个记录行     */    private static Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)            throws SQLException {        Vector<String> currentRow = new Vector<String>();        for (int i = 1; i <= rsmd.getColumnCount(); ++i)            currentRow.addElement(rs.getString(i));        return currentRow; // 返回一条记录    } }