lendborrow.java

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

package com.accp.view;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JMenuItem;
import javax.swing.JPopupMenu;
import javax.swing.JPanel;
import javax.swing.JOptionPane;
import com.accp.db.DBManager;
import com.accp.model.LoginModel;
import java.awt.Rectangle;
public class lendborrow {
	private DefaultComboBoxModel a;
	private DefaultComboBoxModel b;
	/**
	 * //此为借用和归还管理的界面。
	 * @author Administrator
	 *
	 */

	public void frame(){
		/**
		 * //此为借用界面
		 */
		
		//此为查询empno 然后传到借用人combobox内
		LoginModel lm=new LoginModel();
		a=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.queryborrowuser();
			   while(rs.next())
			   {
				   int i=0;
				   	a.addElement(rs.getString(1));
				   i++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }
		
		
	
		final JFrame frame=new JFrame("借用和归还管理");
		JPanel panel=new JPanel();
		panel.setBounds(new Rectangle( -3, 0, 402, 301));
		panel.setLayout(null);
		JLabel lb=new JLabel();
		lb.setText("资产编号:");
		lb.setBounds(new Rectangle(85, 37, 75, 27));
		JLabel lb2=new JLabel();
		lb2.setText("借用人:");
		lb2.setBounds(new Rectangle(231, 37, 66, 27));
		JLabel lb3=new JLabel();
		lb3.setText("借用日期:");
		lb3.setBounds(new Rectangle(85, 72, 80, 27));
		JLabel lb4=new JLabel();
		lb4.setText("归还日期:");
		lb4.setBounds(new Rectangle(231, 72, 66, 27));
		JLabel lb5=new JLabel();
		lb5.setText("是否归还:");
		lb5.setBounds(new Rectangle(85, 112, 64, 27));
		JLabel lb6=new JLabel();
		lb6.setText("操作员:  ");
		lb6.setBounds(new Rectangle(231, 112, 70, 27));
		JLabel lb7=new JLabel();
		lb7.setText("备注:");
		lb7.setBounds(new Rectangle(85, 147, 67, 27));
		final JTextField jtx1 = new JTextField(10);
		jtx1.setBounds(new Rectangle(149, 45, 71, 21));
		final JTextField jtx2= new JTextField(10);
		jtx2.setBounds(new Rectangle(149, 77, 71, 21));
		final JTextField jtx3 = new JTextField(10);
		jtx3.setBounds(new Rectangle(289, 77, 71, 21));
		final JTextField jtx4 = new JTextField(10);
		jtx4.setBounds(new Rectangle(289, 112, 71, 21));
		final JTextField jtx5 = new JTextField(10);
		jtx5.setBounds(new Rectangle(149, 147, 71, 21));
		JButton btok=new JButton("借用");
		btok.setBounds(new Rectangle(95, 200, 81, 23));
	    JButton btcan=new JButton("取消");
	    btcan.setBounds(new Rectangle(223, 199, 81, 23));
	    final	JComboBox cb=new JComboBox(a);
	    cb.setBounds(new Rectangle(291, 45, 71, 23));
	    final	   JComboBox cb2=new JComboBox();
	    cb2.addItem("1");
	    cb2.addItem("0");
	    cb2.setBounds(new Rectangle(148, 115, 73, 23));
	    panel.add(lb);  
	    panel.add(jtx1);
	    panel.add(lb2);
		panel.add(cb);
		panel.add(lb3);
		panel.add(jtx2); 
		panel.add(lb4);
		panel.add(jtx3);
		panel.add(lb5);
		panel.add(cb2);
		panel.add(lb6);
		panel.add(jtx4);
		panel.add(lb7);
		panel.add(jtx5);
		panel.add(btok);
		panel.add(btcan);
//监听确定按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
            LoginModel a=new LoginModel();
      int i=a.lendborrow_insert(jtx1.getText().trim(),cb.getSelectedItem().toString().trim(),
          		  jtx2.getText().trim(),jtx3.getText().trim(),cb2.getSelectedItem().toString().trim(),
          		  jtx4.getText().trim(),jtx5.getText().trim());
        
          if(i==0){
        	    JOptionPane.showMessageDialog(null, "已被借出");
          }else if(i<0)
          {
        	    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(400,300);
		frame.setVisible(true);
		frame.setLocation(280,120);
		frame.setResizable(false);
		
		
		
	}
	public void frame2(){
		/**
		 * //此为归还界面
		 */

		
		//此为查询empno 然后传到借用人combobox内
		LoginModel lm=new LoginModel();
		a=new DefaultComboBoxModel();
		try{
		 ResultSet rs = null;
			rs=lm.queryborrowuser();
			   while(rs.next())
			   {
				   int i=0;
				   	a.addElement(rs.getString(1));
				   i++;
			   }	
		}catch (SQLException e)
        {
       // e.printStackTrace();
        }
		
		
	
		final JFrame frame=new JFrame("借用和归还管理");
		JPanel panel=new JPanel();
		panel.setBounds(new Rectangle( -3, 0, 402, 301));
		panel.setLayout(null);
		JLabel lb=new JLabel();
		lb.setText("资产编号:");
		lb.setBounds(new Rectangle(85, 37, 75, 27));
		JLabel lb2=new JLabel();
		lb2.setText("借用人:");
		lb2.setBounds(new Rectangle(231, 37, 66, 27));
		JLabel lb3=new JLabel();
		lb3.setText("借用日期:");
		lb3.setBounds(new Rectangle(85, 72, 80, 27));
		JLabel lb4=new JLabel();
		lb4.setText("归还日期:");
		lb4.setBounds(new Rectangle(231, 72, 66, 27));
		JLabel lb5=new JLabel();
		lb5.setText("是否归还:");
		lb5.setBounds(new Rectangle(85, 112, 64, 27));
		JLabel lb6=new JLabel();
		lb6.setText("操作员:  ");
		lb6.setBounds(new Rectangle(231, 112, 70, 27));
		JLabel lb7=new JLabel();
		lb7.setText("备注:");
		lb7.setBounds(new Rectangle(85, 147, 67, 27));
		final JTextField jtx1 = new JTextField(10);
		jtx1.setBounds(new Rectangle(149, 45, 71, 21));
		final JTextField jtx2= new JTextField(10);
		jtx2.setBounds(new Rectangle(149, 77, 71, 21));
		final JTextField jtx3 = new JTextField(10);
		jtx3.setBounds(new Rectangle(289, 77, 71, 21));
		final JTextField jtx4 = new JTextField(10);
		jtx4.setBounds(new Rectangle(289, 112, 71, 21));
		final JTextField jtx5 = new JTextField(10);
		jtx5.setBounds(new Rectangle(149, 147, 71, 21));
		JButton btok=new JButton("归还");
		btok.setBounds(new Rectangle(95, 200, 81, 23));
	    JButton btcan=new JButton("取消");
	    btcan.setBounds(new Rectangle(223, 199, 81, 23));
	    final	JComboBox cb=new JComboBox(a);
	    cb.setBounds(new Rectangle(291, 45, 71, 23));
	    final	   JComboBox cb2=new JComboBox();
	    cb2.addItem("1");
	    cb2.addItem("0");
	    cb2.setBounds(new Rectangle(148, 115, 73, 23));
	    panel.add(lb);  
	    panel.add(jtx1);
	    panel.add(lb2);
		panel.add(cb);
		panel.add(lb3);
		panel.add(jtx2); 
		panel.add(lb4);
		panel.add(jtx3);
		panel.add(lb5);
		panel.add(cb2);
		panel.add(lb6);
		panel.add(jtx4);
		panel.add(lb7);
		panel.add(jtx5);
		panel.add(btok);
		panel.add(btcan);
//监听确定按钮事件
		btok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
            LoginModel a=new LoginModel();
      int i=a.lendborrow_insert(jtx1.getText().trim(),cb.getSelectedItem().toString().trim(),
          		  jtx2.getText().trim(),jtx3.getText().trim(),cb2.getSelectedItem().toString().trim(),
          		  jtx4.getText().trim(),jtx5.getText().trim());
        
          if(i==0){
        	    JOptionPane.showMessageDialog(null, "已被借出");
          }else if(i<0)
          {
        	    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(400,300);
		frame.setVisible(true);
		frame.setLocation(280,120);
		frame.setResizable(false);
		
		
		
	}
	public void frame3(){
		/**
		 * //此为查询界面
		 */
		JFrame frame=new JFrame("查询");
		DBManager db=new DBManager();
	//	final JPanel panel=new JPanel();
	
		/*
		*如果要创建一个表。构造的参数是什么？
		*
		*/
		final JTable table=new JTable(db.getTableModel("select assetid as 资产编号,empno as 借用人,usedate as 借用日期,retdate as 归还日期,isreturn as 是否归还,lender as 操作员,remarks as 备注 from LEND"));
		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);		
				
			}			
		});
	     final 	JScrollPane scrollPane=new JScrollPane(table);
		frame.setLocation(280,120);
		frame.getContentPane().add(scrollPane);
		frame.setSize(800,330);
		frame.setVisible(true);
	}
	
	
	
	
}