employeemanager.java

这是我在北大青鸟accp4.0 第一学期 的java 项目<员工管理系统>,采用db,model,view,三层关系. 连接数据库驱动为jdbc 用eclipse完成的手写的窗体代码,

package com.accp.view;

import com.accp.db.*;

import java.awt.Rectangle;
import java.awt.event.*;

import javax.swing.*;
//此为操作员登录系统后，选择用户管理菜单，修改密码。
import com.accp.model.LoginModel;
public class employeemanager{
	/**
	 * 此为职工管理界面。
	 * @author Administrator
	 *
	 *
	 */
	DBManager db=new DBManager();
	public void frame(){
		
	final	JTextField txt1;
	final	JTextField txt2;
	final	JTextField txt3;
	final	JTextField txt4;
	final JFrame frame=new JFrame("职工管理");
		JPanel panel=new JPanel();
		panel.setLayout(null);
		JLabel lb=new JLabel();
		lb.setText("职工编号:");
		lb.setBounds(new Rectangle(353, 50, 59, 21));
		JLabel lb2=new JLabel();
		lb2.setText("职工姓名: ");
		lb2.setBounds(new Rectangle(353, 90, 59, 21));
		JLabel lb3=new JLabel();
		lb3.setText("职务: ");
		lb3.setBounds(new Rectangle(353, 130, 59, 21));
		JLabel lb4=new JLabel();
		lb4.setText("备注:");
		lb4.setBounds(new Rectangle(353, 170, 59, 21));
		txt1 = new JTextField(10);
		txt1.setBounds(new Rectangle(423, 50, 77, 20));
		txt2 = new JTextField(10);
		txt2.setBounds(new Rectangle(423, 90, 77, 20));
		txt3 = new JTextField(10);
		txt3.setBounds(new Rectangle(423, 130, 77, 20));
	    txt4 = new JTextField(10);
		txt4.setBounds(new Rectangle(423, 170, 77, 20));
		JButton btok=new JButton("增加");
		btok.setBounds(new Rectangle(353, 210, 81, 23));
	    JButton btcan=new JButton("取消");
	    btcan.setBounds(new Rectangle(433, 210, 81, 23));
	    JButton btdel=new JButton("删除");
		btdel.setBounds(new Rectangle(353, 250, 81, 23));
		JButton btedit=new JButton("修改");
		btedit.setBounds(new Rectangle(433, 250, 81, 23));
		
		final	JTable table=new JTable(db.getTableModel("select empno as 职工编号,ename as 职工姓名,position as 职位,remarks as 备注 from employee"));
		table.getTableHeader().setReorderingAllowed(false);   
		 table.getTableHeader().setResizingAllowed(false);     
		table.addMouseListener(new MouseAdapter(){			
			public void mouseClicked(MouseEvent e) {
			int rn=((JTable)e.getSource()).getSelectedRow();//得到行
				int cn=((JTable)e.getSource()).getSelectedColumn();//得到列
				//用getValueAt(row,col)方法得到所选行的1列的值
				int strid=Integer.parseInt((String.valueOf(((JTable)e.getSource()).getValueAt(rn, 0))));
				//用getValueAt(row,col)方法得到所选行的2列的值
				String strin=String.valueOf(((JTable)e.getSource()).getValueAt(rn, 0)).trim().toString();
			   txt1.setText(strin);	
			   txt2.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 1)).trim().toString());
			   txt3.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 2)).trim().toString());
			   txt4.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 3)).trim().toString());
			}			
		});
		JScrollPane scrollPane=new JScrollPane(table);
		scrollPane.setBounds(new Rectangle(6, 39, 340, 328));
	    panel.setBounds(new Rectangle(5, 5, 581, 502));
		panel.add(lb);
		panel.add(txt1);
		panel.add(lb2);
		panel.add(txt2);
		panel.add(lb3);
		panel.add(txt3);
		panel.add(lb4);
		panel.add(txt4);
		panel.add(btok);
		panel.add(btcan);
		panel.add(btdel);
		panel.add(btedit);
		panel.add(scrollPane);
//监听增加按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				LoginModel lm=new LoginModel();
			if(lm.employeemanager_insert(txt1.getText(), txt2.getText(), txt3.getText(), txt4.getText())){
				JOptionPane.showMessageDialog(null, "增加成功");
				table.setModel(db.getTableModel("select empno as 职工编号,ename as 职工姓名,position as 职位,remarks as 备注 from employee"));
			    txt1.setText("");
			    txt2.setText("");
			    txt3.setText("");
			    txt4.setText("");
			}else{
				JOptionPane.showMessageDialog(null, "增加失败");
				  txt1.setText("");
				    txt2.setText("");
				    txt3.setText("");
				    txt4.setText("");
				}
			}
		});
//监听取消按钮事件
	
		btcan.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			  frame.dispose();
			}
		});
		
//监听删除按钮事件
	
		btdel.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				LoginModel lm=new LoginModel();
				if(lm.employeemanager_del(txt1.getText())){
					JOptionPane.showMessageDialog(null, "删除成功");
					table.setModel(db.getTableModel("select empno as 职工编号,ename as 职工姓名,position as 职位,remarks as 备注 from employee"));
					}else{
					JOptionPane.showMessageDialog(null, "删除失败");
					}
				}
			 
		}
	);
		
//监听修改按钮事件
		btedit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				LoginModel lm=new LoginModel();
			if(lm.employeemanager_update(txt1.getText(), txt2.getText(), txt3.getText(), txt4.getText())){
				JOptionPane.showMessageDialog(null, "修改成功");
				table.setModel(db.getTableModel("select empno as 职工编号,ename as 职工姓名,position as 职位,remarks as 备注 from employee"));
				}else{
				JOptionPane.showMessageDialog(null, "修改失败");
				}
			}
		});
		
		
		frame.setLayout(null);
		frame.getContentPane().add(panel);
		frame.setSize(600,450);
		frame.setVisible(true);
		frame.setLocation(260,120);
		frame.setResizable(false);
		
		
		
}
	
	
	public void frame2(){
		/*
		 *  职工删除界面
		 * */
		final JFrame frame=new JFrame("职工删除");
		JPanel panel=new JPanel();
		JLabel lb=new JLabel();
		lb.setText("输入要删除的职工编号:         ");
		final JTextField txt1 = new JTextField(18);
		JButton btok=new JButton("删除");
	    JButton btcan=new JButton("取消");
		panel.add(lb);
		panel.add(txt1);
		panel.add(btok);
		panel.add(btcan);
//监听删除按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				LoginModel lm=new LoginModel();
				if(lm.employeemanager_del(txt1.getText())){
					JOptionPane.showMessageDialog(null, "删除成功");
					}else{
					JOptionPane.showMessageDialog(null, "删除失败");
					}
				}
			 
		}
	);
//监听取消按钮事件
		btcan.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			  frame.dispose();
			}
		});
		frame.getContentPane().add(panel);
		frame.setSize(250,250);
		frame.setVisible(true);
		frame.setLocation(230,120);
		frame.setResizable(false);
	}

	public void frame3(){
		/*
		 * 职工更新,修改界面
		 * */
		final JFrame frame=new JFrame("职工修改");
		JPanel panel=new JPanel();
		JLabel lb=new JLabel();
		lb.setText("职工编号:         ");
		JLabel lb2=new JLabel();
		lb2.setText("职工姓名:         ");
		JLabel lb3=new JLabel();
		lb3.setText("        职务:         ");
		JLabel lb4=new JLabel();
		lb4.setText("        备注:         ");
		final JTextField txt1 = new JTextField(10);
		final JTextField txt2 = new JTextField(10);
		final JTextField txt3 = new JTextField(10);
		final JTextField txt4 = new JTextField(10);
		JButton btok=new JButton("确定更新");
	    JButton btcan=new JButton("取消");
		panel.add(lb);
		panel.add(txt1);
		panel.add(lb2);
		panel.add(txt2);
		panel.add(lb3);
		panel.add(txt3);
		panel.add(lb4);
		panel.add(txt4);
		panel.add(btok);
		panel.add(btcan);
//监听增加按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				LoginModel lm=new LoginModel();
			if(lm.employeemanager_update(txt1.getText(), txt2.getText(), txt3.getText(), txt4.getText())){
				JOptionPane.showMessageDialog(null, "更新成功");
				}else{
				JOptionPane.showMessageDialog(null, "更新失败");
				}
			}
		});
//监听取消按钮事件
		btcan.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			  frame.dispose();
			}
		});
		frame.getContentPane().add(panel);
		frame.setSize(250,250);
		frame.setVisible(true);
		frame.setLocation(230,120);
		frame.setResizable(false);
	}
	

	public void frame4(){
		/*
		 * 职工查询界面
		 * */
		JFrame frame4=new JFrame("职工查询");
		DBManager db=new DBManager();
	final	JTable table=new JTable(db.getTableModel("select empno as 职工编号,ename as 职工姓名,position as 职位,remarks as 备注 from employee"));
		table.addMouseListener(new MouseAdapter(){			
			public void mouseClicked(MouseEvent e) {
				//第一种取行和列的方法
				//int row=((JTable)e.getSource()).rowAtPoint(e.getPoint());
				//int col=((JTable)e.getSource()).columnAtPoint(e.getPoint());
				//String str=String.valueOf(((JTable)e.getSource()).getValueAt(row, col));
				//第二种取行和列的方法
			
				int rn=((JTable)e.getSource()).getSelectedRow();//得到行
				int cn=((JTable)e.getSource()).getSelectedColumn();//得到列
				//用getValueAt(row,col)方法得到所选行的1列的值
				int strid=Integer.parseInt((String.valueOf(((JTable)e.getSource()).getValueAt(rn, 0))));
				//用getValueAt(row,col)方法得到所选行的2列的值
			
				String strin=String.valueOf(((JTable)e.getSource()).getValueAt(rn, 0)).trim();
				//实例一个修改窗体对象。并传入三个参数
		
			}			
		});
		 final 	JScrollPane scrollPane=new JScrollPane(table);
	 	frame4.setLocation(230,120);
		frame4.getContentPane().add(scrollPane);
		frame4.setSize(600,200);
		frame4.setVisible(true);
	
	}
	
	
}