📄 category_manager.java
字号:
package com.accp.view;
import com.accp.db.*;
import java.awt.event.*;
import java.awt.Rectangle;
import javax.swing.*;
//此为资产类别管理界面。
import com.accp.model.LoginModel;
public class category_manager{
/**
* 资产类别管理界面。
* @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 cateid as 主类编号,catename as 主类名称,subcateid as 子类编号,subcatename as 子类名称 from CATEGORY"));
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();
txt1.setText(strin);
txt2.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 1)).trim());
txt3.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 2)).trim());
txt4.setText(String.valueOf(((JTable)e.getSource()).getValueAt(rn, 3)).trim());
}
});
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.category_manager_insert(txt1.getText(), txt2.getText(), txt3.getText(), txt4.getText())){
JOptionPane.showMessageDialog(null, "增加成功");
table.setModel(db.getTableModel("select cateid as 主类编号,catename as 主类名称,subcateid as 子类编号,subcatename as 子类名称 from CATEGORY"));
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.category_manager_del(txt1.getText(),txt3.getText())){
JOptionPane.showMessageDialog(null, "删除成功");
table.setModel(db.getTableModel("select cateid as 主类编号,catename as 主类名称,subcateid as 子类编号,subcatename as 子类名称 from CATEGORY"));
}else{
JOptionPane.showMessageDialog(null, "删除失败");
}
}
}
);
//监听修改按钮事件
btedit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
LoginModel lm=new LoginModel();
if(lm.category_manager_update(txt1.getText(), txt2.getText(), txt3.getText(), txt4.getText())){
JOptionPane.showMessageDialog(null, "修改成功");
table.setModel(db.getTableModel("select cateid as 主类编号,catename as 主类名称,subcateid as 子类编号,subcatename as 子类名称 from CATEGORY"));
}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.category_manager_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.setResizable(false);
frame.setLocation(260,120);
}
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.category_manager_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.setLocation(260,120);
frame.setVisible(true);
frame.setResizable(false);
}
public void frame4(){
/*
* 资产类别查询界面
* */
JFrame frame=new JFrame("资产类别查询");
// frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
DBManager db=new DBManager();
/*
*如果要创建一个表。构造的参数是什么？
*
*/
JTable table=new JTable(db.getTableModel("select cateid as 主类编号,catename as 主类名称,subcateid as 子类编号,subcatename as 子类名称 from CATEGORY"));
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.setSize(600,200);
frame.setVisible(true);
frame.setLocation(260,120);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -