package quary;
/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */import java.awt.*;import java.awt.event.*;import java.util.*;import javax.swing.*;import tools.*;import op.*;
public class kind extends JPanel { private JButton btn_mx = new JButton(); private JScrollPane jScrollPane1 = new JScrollPane(); private DBConnection dcon = null; private JTable table; private Mytable model; private String tempID = ""; private String tempUser = ""; HashMap KindMap = new HashMap(); JTabbedPane jTabbedPane1 = new JTabbedPane(); JComboBox cbmkind; JButton btn_return = new JButton(); public kind() { try { jbInit(); } catch (Exception ex) { ex.printStackTrace(); } }
private void jbInit() throws Exception { model = new Mytable(4); model.setTitle(getTitle()); if (getKindsList() != null) { cbmkind = new JComboBox(getKindsList()); if (cbmkind.getSelectedItem() != null) { model.setContent(getContents(cbmkind.getSelectedItem().toString(). trim())); } else { model.setContent(getContents("")); }
}
table = new JTable(model); table.setRowSelectionAllowed(false); this.setLayout(null); btn_mx.setBounds(new Rectangle(229, 22, 92, 32)); btn_mx.setToolTipText(""); btn_mx.setText("详细情况");
jScrollPane1.setBounds(new Rectangle(15, 71, 477, 223)); jTabbedPane1.setBounds(new Rectangle( -44, 86, 5, 5)); cbmkind.setBounds(new Rectangle(42, 21, 148, 33)); btn_return.setBounds(new Rectangle(359, 22, 90, 31)); btn_return.setText("返回"); this.add(jScrollPane1); this.add(jTabbedPane1); this.add(cbmkind); this.add(btn_mx); this.add(btn_return); this.setSize(500, 400); jScrollPane1.getViewport().add(table); //行选择编号改变 table.addMouseListener(new MouseListener() { public void mouseClicked(MouseEvent e) { if (table.getSelectedRow() != -1 && table.getSelectedColumn() != -1) { tempID = table.getValueAt(table.getSelectedRow(), 0). toString(); if(table.getValueAt(table.getSelectedRow(), 6) == null) { tempUser = ""; }else { tempUser = table.getValueAt(table.getSelectedRow(), 6). toString(); } } else { tempID = ""; } }
public void mousePressed(MouseEvent e) { }
public void mouseReleased(MouseEvent e) { }
public void mouseEntered(MouseEvent e) { }
public void mouseExited(MouseEvent e) { } }); btn_mx.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if (tempID.trim().length() == 0) { JOptionPane.showMessageDialog(table, "请选择要操作的记录");
} else { mxCard(); } } }); btn_return.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { returnQuary(); } }); cbmkind.addItemListener(new ItemListener() { public void itemStateChanged(ItemEvent e) { choice(); } }); }
//mxCard(); private void mxCard() { dcon = new DBConnection(); String sql = "select * from Action where asset_id = '" + tempID + "'"; if (!dcon.isNull(sql)) { AssetFullDialog afd = new AssetFullDialog(tempID); Dimension frmsize = getSize(); Point loc = getLocation(); afd.setLocation((frmsize.width - afd.WIDTH) / 2 + loc.x, (frmsize.height - afd.HEIGHT) / 2 + loc.y); afd.setSize(350, 330); afd.setModal(true); afd.setVisible(true); } else { sql = "select employee_id from Employee where employee_name='" + tempUser + "'"; Vector v = dcon.select(sql); String userid = ((Vector) v.get(0)).get(0).toString().trim(); AssetReturn ar = new AssetReturn(tempUser, tempID,userid); Dimension frmsize = getSize(); Point loc = getLocation(); ar.setLocation((frmsize.width - ar.WIDTH) / 2 + loc.x, (frmsize.height - ar.HEIGHT) / 2 + loc.y); ar.setSize(350, 450); ar.updownHiden(); ar.setModal(true); ar.setVisible(true);
} }
//changed private void choice() { model.setContent(getContents(cbmkind.getSelectedItem().toString(). trim())); tempID = ""; table.updateUI(); this.updateUI(); }
private String[] getKindsList() { dcon = new DBConnection(); String sql = "select b.childkind_id,b.childkind_name from asset as a, childkind as b where(a.childkind_id = b.childkind_id) group by b.childkind_id,b.childkind_name"; Vector v = dcon.select(sql); int count = v.size(); String[] s = new String[count]; for (int i = 0; i < count; i++) { String id = ((Vector) v.get(i)).get(0).toString().trim(); String name = ((Vector) v.get(i)).get(1).toString().trim(); s[i] = name; KindMap.put(name, id); } return s; }
//get id private String getKindsID(String name) { KindMap.get(name); if (KindMap.get(name) != null) { return KindMap.get(name).toString().trim(); } return ""; }
//return Quarry private void returnQuary() { this.removeAll(); quary q = new quary(); this.add(q); this.updateUI(); }
//获取表格的列表 private String[] getTitle() {
dcon = new DBConnection(); String sql = "select a.asset_id as 编号, a.asset_name as 名称,a.asset_type as 类型,a.asset_price as 单价,a.asset_buytime as 购买时间,a.asset_status as 状态,b.employee_name as 用户,a.remark as 备注,a.childkind_id as 科目 from asset as a left join employee as b on a.asset_user = b.employee_id order by a.asset_id asc "; return dcon.getColumnname(sql); }
//获取表格的内容 private Vector getContents(String name) { String id = getKindsID(name); dcon = new DBConnection(); String sql = "select a.asset_id as 编号, a.asset_name as 名称,a.asset_type as 类型,a.asset_price as 单价,a.asset_buytime as 购买时间,a.asset_status as 状态,b.employee_name as 用户,a.remark as 备注,a.childkind_id as 科目 from asset as a left join employee as b on a.asset_user = b.employee_id where a.childkind_id = '" + id + "' order by a.asset_id asc "; return dcon.select(sql); }
}
