asset.java

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

/**
 * @author Administrator
 *
 */
/**
 * @author smw
 *
 */
package com.accp.view;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

import com.accp.db.DBManager;
import com.accp.model.LoginModel;
import java.awt.Rectangle;
public class Asset{
	private DefaultComboBoxModel a;  //大类
	private DefaultComboBoxModel b;  //小类
	private DefaultComboBoxModel c;  //资产状态 是否已借出
	static String str;
	/**
	 * //此为固定资产管理的界面。
	 * @author Administrator
	 */
public void frame(){
		/**
		 * //固定资产增加界面。
		 */
	//此为查询sql大类 结果rs传到combobox内
		LoginModel lm=new LoginModel();
		a=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.querysql("select distinct catename from CATEGORY");
			int row=0;
			while(rs.next())
			   {
				   int i=0; 
				   if(row==0){  //只得到第一个值,作为参数传给combobox2,使其联动
					   str=rs.getString(1);
				      }
				   	a.addElement(rs.getString(1));
				   i++;row++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }
		//此为查询sql小类 结果rs传到combobox2内
		b=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.querysql("select distinct subcatename from CATEGORY where catename='"+str+"'");
			   while(rs.next())
			   {
				   int i=0;
				   b.addElement(rs.getString(1));
				   i++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }	
		//此为查询sql固定资产状态, 结果rs传到combobox3内
		c=new DefaultComboBoxModel();
		try{
			 ResultSet rs = null;
				rs=lm.querysql("select distinct status from Asset");
				   while(rs.next())
				   {
					   int i=0;
					   	c.addElement(rs.getString(8));
					   i++;
				   }	
			}catch (SQLException e)
	        {
	       // e.printStackTrace();
	        }
		final JFrame frame=new JFrame("固定资产管理");
		JPanel panel=new JPanel();
		panel.setBounds(new Rectangle(3, 0, 696, 500));
		panel.setLayout(null);
		JLabel lb=new JLabel();
		lb.setText("资产编号:");
		lb.setBounds(new Rectangle(64, 85, 80, 21));
		JLabel lb2=new JLabel();
		lb2.setText("大类:");
		lb2.setBounds(new Rectangle(64, 124, 80, 21));
		JLabel lb3=new JLabel();
		lb3.setText("购入日期:");
		lb3.setBounds(new Rectangle(64, 204, 80, 21));
		JLabel lb4=new JLabel();
		lb4.setText("样式:");
		lb4.setBounds(new Rectangle(64, 165, 80, 21));
		JLabel lb5=new JLabel();
		lb5.setText("操作员:");
		lb5.setBounds(new Rectangle(64, 247, 80, 21));
		JLabel lb6=new JLabel();
		lb6.setText("资产名称:  ");
		lb6.setBounds(new Rectangle(229, 85, 80, 21));
		JLabel lb7=new JLabel();
		lb7.setText("备注:");
		lb7.setBounds(new Rectangle(229, 247, 80, 21));
		JLabel lb8=new JLabel();
		lb8.setBounds(new Rectangle(229, 204, 80, 21));
		lb8.setText("状态:");
		JLabel lb9=new JLabel();
		lb9.setBounds(new Rectangle(229, 165, 80, 21));
		lb9.setText("价格:");
		JLabel lb10=new JLabel();
		lb10.setBounds(new Rectangle(229, 124, 80, 21));
		lb10.setText("小类:");
		
		final JTextField jtx1 = new JTextField(8);
		jtx1.setBounds(new Rectangle(131, 86, 77, 20));
		final JTextField jtx2= new JTextField(8);
		jtx2.setBounds(new Rectangle(306, 85, 77, 20));
		final JTextField jtx3 = new JTextField(8);
		jtx3.setBounds(new Rectangle(306, 166, 77, 20));
		final JTextField jtx4 = new JTextField(8);
		jtx4.setBounds(new Rectangle(131, 167, 77, 20));
		final JTextField jtx5 = new JTextField(8);
		jtx5.setBounds(new Rectangle(306, 246, 77, 20));
		final JTextField jtx6 = new JTextField(8);
		jtx6.setBounds(new Rectangle(131, 247, 77, 20));
		final JTextField jtx7 = new JTextField(8);
		jtx7.setBounds(new Rectangle(131, 207, 77, 20));
		JButton btok=new JButton("增加");
		btok.setBounds(new Rectangle(107, 296, 106, 23));
	    JButton btcan=new JButton("取消");
	    btcan.setBounds(new Rectangle(286, 296, 100, 23));
	    final JComboBox cb=new JComboBox(a);
	    cb.setBounds(new Rectangle(131, 124, 77, 25));
	    final	JComboBox cb2=new JComboBox(b);
	    cb2.setBounds(new Rectangle(308, 124, 78, 25));
	    final	JComboBox cb3=new JComboBox(c); 
	    cb3.setBounds(new Rectangle(308, 204, 73, 23));
	    cb3.addItem("1");
	    cb3.addItem("0");
	    panel.add(lb);  
	    panel.add(jtx1);
	    panel.add(lb2);
		panel.add(jtx2);
		panel.add(lb3);
		panel.add(cb); 
		panel.add(lb4);
		panel.add(cb2);
		panel.add(lb5);
		panel.add(jtx3);
		panel.add(lb6);
		panel.add(jtx4);
		panel.add(lb7);
		panel.add(jtx5);
		panel.add(lb8);
		panel.add(cb3);
		panel.add(lb9);
		panel.add(jtx6);
		panel.add(lb10);
		panel.add(jtx7);
		panel.add(btok);
		panel.add(btcan);
		
//		监听cmbobox1选择事件		
		cb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent ae){
				str=(String)cb.getSelectedItem();
				//System.out.println(str); 
					b=new DefaultComboBoxModel();
						try{
						 ResultSet rs = null;
						 LoginModel lm=new LoginModel();
							rs=lm.querysql("select distinct subcateid from CATEGORY where cateid='"+str+"'");
							   while(rs.next())
							   {
								   int i=0;
								   	b.addElement(rs.getString(1));
								   i++;
							   }	
						}catch (SQLException e)
				        {
				       // e.printStackTrace();
				        }	
						
						//小类与大类下拉框联动
						cb2.setModel(b);
				
		    } 
		 } 
	); 
		
		

//监听确定按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			LoginModel ab=new LoginModel();
			
				if(ab.asset_insert(jtx1.getText(),jtx2.getText(),cb.getSelectedItem().toString().trim(),
	        		   cb2.getSelectedItem().toString().trim(),jtx3.getText().trim(),jtx4.getText().trim(),jtx5.getText(),
	        		   cb3.getSelectedItem().toString().trim(),jtx6.getText().trim(),jtx7.getText().trim()))
				{
					JOptionPane.showMessageDialog(null, "增加成功");
				}else{
					JOptionPane.showMessageDialog(null, "增加失败");
				}
					
				}
			}
		);
//监听取消按钮事件
		btcan.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			  frame.dispose();
			}
		});
		frame.setLayout(null);
		frame.getContentPane().add(panel);
		frame.setSize(750,500);
		frame.setVisible(true);
		frame.setLocation(200,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 abc=new LoginModel();
				if(abc.asset_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(200,120);
		frame.setResizable(false);
	}

	public void frame3(){
		/**
		 * //固定资产修改界面。
		 */
	//此为查询sql大类 结果rs传到combobox内
		LoginModel lm=new LoginModel();
		a=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.querysql("select distinct cateid from CATEGORY");
			   while(rs.next())
			   {
				   int i=0;
				   	a.addElement(rs.getString(1));
				   i++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }
		//此为查询sql小类 结果rs传到combobox2内
		b=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.querysql("select distinct subcateid from CATEGORY");
			   while(rs.next())
			   {
				   int i=0;
				   	b.addElement(rs.getString(1));
				   i++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }	
		//此为查询sql固定资产状态, 结果rs传到combobox3内
		c=new DefaultComboBoxModel();
		try{
			 ResultSet rs = null;
				rs=lm.querysql("select distinct status from Asset");
				   while(rs.next())
				   {
					   int i=0;
					   	c.addElement(rs.getString(8));
					   i++;
				   }	
			}catch (SQLException e)
	        {
	       // e.printStackTrace();
	        }
		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("小类:");
		JLabel lb5=new JLabel();
		lb5.setText("样式:");
		JLabel lb6=new JLabel();
		lb6.setText("价格:  ");
		JLabel lb7=new JLabel();
		lb7.setText("购入日期:");
		JLabel lb8=new JLabel();
		lb8.setText("状态:");
		JLabel lb9=new JLabel();
		lb9.setText("操作员:");
		JLabel lb10=new JLabel();
		lb10.setText("备注:");
		
		final JTextField jtx1 = new JTextField(8);
		final JTextField jtx2= new JTextField(8);
		final JTextField jtx3 = new JTextField(8);
		final JTextField jtx4 = new JTextField(8);
		final JTextField jtx5 = new JTextField(8);
		final JTextField jtx6 = new JTextField(8);
		final JTextField jtx7 = new JTextField(8);
		JButton btok=new JButton("增加");
	    JButton btcan=new JButton("取消");
	    final	JComboBox cb=new JComboBox(a);
	    final	JComboBox cb2=new JComboBox(b);
	    final	JComboBox cb3=new JComboBox(c);
	    cb3.addItem("1");
	    cb3.addItem("0");
	    panel.add(lb);  
	    panel.add(jtx1);
	    panel.add(lb2);
		panel.add(jtx2);
		panel.add(lb3);
		panel.add(cb); 
		panel.add(lb4);
		panel.add(cb2);
		panel.add(lb5);
		panel.add(jtx3);
		panel.add(lb6);
		panel.add(jtx4);
		panel.add(lb7);
		panel.add(jtx5);
		panel.add(lb8);
		panel.add(cb3);
		panel.add(lb9);
		panel.add(jtx6);
		panel.add(lb10);
		panel.add(jtx7);
		panel.add(btok);
		panel.add(btcan);
		
//		监听cmbobox1选择事件		
		cb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent ae){
				str=(String)cb.getSelectedItem();
				//System.out.println(str); 
					b=new DefaultComboBoxModel();
						try{
						 ResultSet rs = null;
						 LoginModel lm=new LoginModel();
							rs=lm.querysql("select distinct subcateid from CATEGORY where cateid='"+str+"'");
							   while(rs.next())
							   {
								   int i=0;
								   	b.addElement(rs.getString(1));
								   i++;
							   }	
						}catch (SQLException e)
				        {
				       // e.printStackTrace();
				        }	
						
						//小类与大类下拉框联动
						cb2.setModel(b);
				
		    } 
		 } 
	); 
		
		

//监听确定按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
			LoginModel ab=new LoginModel();
			
				if(ab.asset_update(jtx1.getText(),jtx2.getText(),cb.getSelectedItem().toString(),
	        		   cb2.getSelectedItem().toString().trim(),jtx3.getText(),jtx4.getText(),jtx5.getText(),
	        		   cb3.getSelectedItem().toString().trim(),jtx6.getText(),jtx7.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(350,300);
		frame.setLocation(190,120);
		frame.setVisible(true);
		frame.setResizable(false);
	}
	


	public void frame4(){
		/**
		 * //固定资产查询界面。
		 * @author Administrator
		 *
		 */
		JFrame frame=new JFrame("固定资产查询");
		DBManager db=new DBManager();
		/*
		*如果要创建一个表。构造的参数是什么？
		*
		*/
		JTable table=new JTable(db.getTableModel("select assetid as 资产编号,asset_name as 资产名称,cateid as 大类编号,subcateid as 小类编号,model as 样式,price as 价格, purchase_date as 购入日期,status as 状态,useby as 借用人,remark as 备注 from asset"));
		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, 1)).trim();
				//实例一个修改窗体对象。并传入三个参数
			//	Info in=new Info(strid,strin);			
				
			}			
		});
		JScrollPane scrollPane=new JScrollPane(table);

		frame.getContentPane().add(scrollPane);
		frame.pack();
		frame.setLocation(200,120);
		frame.setSize(800,200);
		frame.setVisible(true);

	}
}