?? mainframe.java~198~
字號:
package zcgl;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
import java.awt.Font;
import java.awt.Rectangle;
import javax.swing.border.TitledBorder;
import java.awt.FlowLayout;
import com.borland.jbcl.layout.VerticalFlowLayout;
import javax.swing.border.Border;
import com.borland.jbcl.layout.PaneLayout;
import com.borland.jbcl.layout.*;
import java.awt.GridBagLayout;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class MainFrame extends JFrame {
JPanel contentPane;
JMenuBar jMenuBar1 = new JMenuBar();
JMenu jMenuFile = new JMenu();
JMenuItem jMenuFileExit = new JMenuItem();
JMenuItem jMenuItem1 = new JMenuItem();
JMenuItem jMenuItem2 = new JMenuItem();
JMenu jMenu1 = new JMenu();
JMenuItem jMenuItem3 = new JMenuItem();
JMenuItem jMenuItem4 = new JMenuItem();
JMenuItem jMenuItem5 = new JMenuItem();
JMenu jMenu2 = new JMenu();
JMenuItem jMenuItem6 = new JMenuItem();
JMenuItem jMenuItem7 = new JMenuItem();
JMenuItem jMenuItem8 = new JMenuItem();
JPanel jPanel1 = new JPanel();
TitledBorder titledBorder1 = new TitledBorder("");
JLabel jLabel1 = new JLabel();
JTextField txtFindId = new JTextField();
VerticalFlowLayout verticalFlowLayout1 = new VerticalFlowLayout();
JLabel jLabel2 = new JLabel();
JTextField txtFindName = new JTextField();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JPanel jPanel2 = new JPanel();
JLabel jLabel3 = new JLabel();
JTextField txtJyDate = new JTextField();
JLabel jLabel4 = new JLabel();
JTextField txtName = new JTextField();
JLabel jLabel5 = new JLabel();
JTextField txtZcId = new JTextField();
JLabel jLabel6 = new JLabel();
JTextField txtStyle = new JTextField();
JLabel jLabel7 = new JLabel();
JTextField txtDlId = new JTextField();
JLabel jLabel8 = new JLabel();
JTextField txtZlId = new JTextField();
JLabel jLabel9 = new JLabel();
JTextField txtGhDate = new JTextField();
JLabel jLabel10 = new JLabel();
JTextField txtPrice = new JTextField();
JLabel jLabel11 = new JLabel();
JTextField txtGrDate = new JTextField();
JLabel jLabel12 = new JLabel();
JTextField txtStatus = new JTextField();
JLabel jLabel13 = new JLabel();
JTextField txtGrR = new JTextField();
JLabel jLabel14 = new JLabel();
JTextField txtContent = new JTextField();
JLabel jLabel15 = new JLabel();
JTextField txtJyR = new JTextField();
JLabel jLabel16 = new JLabel();
JTextField txtReturn = new JTextField();
JScrollPane jScrollPane1 = new JScrollPane();
JTable table;
DefaultTableModel tm;
JMenu jMenu3 = new JMenu();
JMenuItem jMenuItem9 = new JMenuItem();
JMenuItem jMenuItem10 = new JMenuItem();
Connection con = null;
Statement smt = null;
ResultSet rs = null;
JButton jButton3 = new JButton();
JMenu jMenu4 = new JMenu();
JMenuItem jMenuItem11 = new JMenuItem();
public MainFrame() {
try {
setDefaultCloseOperation(EXIT_ON_CLOSE);
Object[] o = {"資產編號", "資產名稱", "大類編號", "子類編號", "樣式", "價格", "購入日期",
"狀態", "購入人", "備注"};
tm = new DefaultTableModel(o, 0);
table = new JTable(tm);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
/**
* Component initialization.
*
* @throws java.lang.Exception
*/
private void jbInit() throws Exception {
titledBorder1 = new TitledBorder("詳細信息");
contentPane = (JPanel) getContentPane();
contentPane.setLayout(null);
setSize(new Dimension(753, 554));
setTitle("資產管理系統");
jMenuFile.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
jMenuFile.setText("固定資產管理");
jMenuFileExit.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuFileExit.setText("增加");
jMenuFileExit.addActionListener(new
MainFrame_jMenuFileExit_ActionAdapter(this));
jMenuItem1.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem1.setText("刪除");
jMenuItem1.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this));
jMenuItem2.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem2.setText("修改");
jMenuItem2.addActionListener(new MainFrame_jMenuItem2_actionAdapter(this));
jMenu1.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
jMenu1.setText("職工管理");
jMenuItem3.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem3.setText("增加");
jMenuItem3.addActionListener(new MainFrame_jMenuItem3_actionAdapter(this));
jMenuItem4.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem4.setText("刪除");
jMenuItem4.addActionListener(new MainFrame_jMenuItem4_actionAdapter(this));
jMenuItem5.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem5.setText("修改");
jMenuItem5.addActionListener(new MainFrame_jMenuItem5_actionAdapter(this));
jMenu2.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
jMenu2.setText("資產類別管理");
jMenuItem6.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem6.setText("增加");
jMenuItem6.addActionListener(new MainFrame_jMenuItem6_actionAdapter(this));
jMenuItem7.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem7.setText("刪除");
jMenuItem7.addActionListener(new MainFrame_jMenuItem7_actionAdapter(this));
jMenuItem8.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem8.setText("修改");
jMenuItem8.addActionListener(new MainFrame_jMenuItem8_actionAdapter(this));
jPanel1.setBorder(titledBorder1);
jPanel1.setPreferredSize(new Dimension(110, 79));
jPanel1.setBounds(new Rectangle(9, 13, 169, 322));
jPanel1.setLayout(verticalFlowLayout1);
jLabel1.setText("以資產編號查詢");
jLabel2.setText("以資產名稱查詢");
jButton1.setText("查 詢");
jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
jButton2.setText("查 詢");
jButton2.addActionListener(new MainFrame_jButton2_actionAdapter(this));
jPanel2.setBorder(titledBorder1);
jPanel2.setBounds(new Rectangle(192, 13, 536, 323));
jPanel2.setLayout(null);
jLabel3.setText("資產名稱");
jLabel3.setBounds(new Rectangle(315, 24, 52, 21));
jLabel4.setText("資產編號");
jLabel4.setBounds(new Rectangle(40, 25, 66, 15));
txtJyDate.setBounds(new Rectangle(375, 221, 124, 22));
txtName.setBounds(new Rectangle(375, 23, 124, 22));
jLabel5.setText("大類編號");
jLabel5.setBounds(new Rectangle(40, 61, 63, 26));
txtZcId.setBounds(new Rectangle(98, 22, 91, 22));
jLabel6.setText("子類編號");
jLabel6.setBounds(new Rectangle(315, 67, 77, 15));
txtStyle.setBounds(new Rectangle(98, 101, 91, 22));
jLabel7.setText("樣式");
jLabel7.setBounds(new Rectangle(40, 91, 63, 36));
txtDlId.setBounds(new Rectangle(98, 62, 91, 22));
jLabel8.setText("價格");
jLabel8.setBounds(new Rectangle(315, 101, 51, 23));
txtZlId.setBounds(new Rectangle(375, 63, 124, 22));
jLabel9.setText("購入日期");
jLabel9.setBounds(new Rectangle(40, 139, 62, 21));
txtGhDate.setBounds(new Rectangle(98, 259, 91, 22));
jLabel10.setText("狀態");
jLabel10.setBounds(new Rectangle(315, 147, 48, 15));
txtPrice.setBounds(new Rectangle(375, 106, 124, 22));
jLabel11.setText("購入人");
jLabel11.setBounds(new Rectangle(40, 181, 48, 15));
txtGrDate.setBounds(new Rectangle(98, 141, 91, 22));
jLabel12.setText("備注");
jLabel12.setBounds(new Rectangle(315, 185, 48, 15));
txtStatus.setBounds(new Rectangle(375, 143, 124, 22));
jLabel13.setText("借用人");
jLabel13.setBounds(new Rectangle(40, 222, 48, 15));
txtGrR.setBounds(new Rectangle(98, 180, 91, 22));
jLabel14.setText("借用日期");
jLabel14.setBounds(new Rectangle(315, 226, 48, 14));
txtContent.setBounds(new Rectangle(375, 180, 124, 22));
jLabel15.setText("歸還日期");
jLabel15.setBounds(new Rectangle(40, 264, 48, 15));
txtJyR.setBounds(new Rectangle(98, 220, 91, 22));
jLabel16.setText("是否歸還");
jLabel16.setBounds(new Rectangle(315, 265, 48, 15));
txtReturn.setBounds(new Rectangle(375, 261, 124, 22));
jScrollPane1.setBounds(new Rectangle(9, 335, 718, 159));
jScrollPane1.addMouseListener(new MainFrame_jScrollPane1_mouseAdapter(this));
jMenu3.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
jMenu3.setText("資產借用管理");
jMenuItem9.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem9.setText("借用固定資產");
jMenuItem9.addActionListener(new MainFrame_jMenuItem9_actionAdapter(this));
jMenuItem10.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem10.setText("歸還固定資產");
jMenuItem10.addActionListener(new MainFrame_jMenuItem10_actionAdapter(this));
jButton3.setText("查詢所有記錄");
jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
table.addMouseListener(new MainFrame_table_mouseAdapter(this));
jMenu4.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
jMenu4.setText("用戶管理");
jMenuItem11.setFont(new java.awt.Font("宋體", Font.PLAIN, 12));
jMenuItem11.setText("修改口令");
jMenuItem11.addActionListener(new MainFrame_jMenuItem11_actionAdapter(this));
jMenuBar1.add(jMenuFile);
jMenuBar1.add(jMenu1);
jMenuBar1.add(jMenu2);
jMenuBar1.add(jMenu3);
jMenuBar1.add(jMenu4);
jMenuFile.add(jMenuFileExit);
jMenuFile.add(jMenuItem1);
jMenuFile.add(jMenuItem2);
jMenu1.add(jMenuItem3);
jMenu1.add(jMenuItem4);
jMenu1.add(jMenuItem5);
jMenu2.add(jMenuItem6);
jMenu2.add(jMenuItem7);
jMenu2.add(jMenuItem8);
jPanel1.add(jLabel1);
jPanel1.add(txtFindId);
jPanel1.add(jButton1);
jPanel1.add(jLabel2);
jPanel1.add(txtFindName);
jPanel1.add(jButton2);
jPanel1.add(jButton3);
contentPane.add(jScrollPane1);
jScrollPane1.getViewport().add(table);
contentPane.add(jPanel2);
contentPane.add(jPanel1);
jPanel2.add(txtZlId);
jPanel2.add(jLabel8);
jPanel2.add(jLabel10);
jPanel2.add(jLabel12);
jPanel2.add(jLabel14);
jPanel2.add(jLabel16);
jPanel2.add(txtReturn);
jPanel2.add(txtJyDate, null);
jPanel2.add(txtContent);
jPanel2.add(txtStatus);
jPanel2.add(txtPrice);
jPanel2.add(txtName, null);
jPanel2.add(jLabel3, null);
jPanel2.add(jLabel6);
jPanel2.add(txtGrR);
jPanel2.add(jLabel4, null);
jPanel2.add(txtZcId);
jPanel2.add(txtDlId);
jPanel2.add(jLabel5);
jPanel2.add(jLabel7);
jPanel2.add(txtStyle);
jPanel2.add(txtGrDate);
jPanel2.add(jLabel9);
jPanel2.add(jLabel11);
jPanel2.add(jLabel13);
jPanel2.add(txtJyR);
jPanel2.add(txtGhDate);
jPanel2.add(jLabel15);
jMenu3.add(jMenuItem9);
jMenu3.add(jMenuItem10);
jMenu4.add(jMenuItem11);
setJMenuBar(jMenuBar1);
}
/**
* File | Exit action performed.
*
* @param actionEvent ActionEvent
*/
void jMenuFileExit_actionPerformed(ActionEvent actionEvent) {
ZcView zc = new ZcView();
zc.setTitle("添加資產信息");
zc.setSize(400, 400);
zc.btnDel.setEnabled(false);
zc.btnModify.setEnabled(false);
zc.setLocation(300, 100);
zc.setVisible(true);
}
public void jButton1_actionPerformed(ActionEvent e) {
con = new DbCon().getConnection();
if (table.getRowCount() > 0) {
for (int i = 0; table.getRowCount() > 0; i++) {
tm.removeRow(0);
}
}
try {
smt = con.createStatement();
rs = smt.executeQuery("select * from ASSET where assetid=" +
txtFindId.getText());
while (rs.next()) {
String id = String.valueOf(rs.getInt("assetid")).trim();
String name = rs.getString("asset_name").trim();
String DlId = String.valueOf(rs.getInt("cateid")).trim();
String ZlId = String.valueOf(rs.getInt("subcateid")).trim();
String style = rs.getString("model").trim();
String price = String.valueOf(rs.getFloat("price")).trim();
String d = rs.getString("purchase_date").trim();
d = d.substring(0, d.indexOf(" "));
String gdate = d;
String status = rs.getString("status").trim();
String grr = rs.getString("useby").trim();
String context = rs.getString("remarks").trim();
String[] info = {id, name, DlId, ZlId, style, price, gdate,
status, grr, context};
tm.addRow(info);
}
} catch (SQLException ex) {
}
}
public void jMenuItem1_actionPerformed(ActionEvent e) {
ZcView zc = new ZcView();
zc.setTitle("刪除資產信息");
zc.setSize(400, 400);
zc.btnAdd.setEnabled(false);
zc.btnModify.setEnabled(false);
zc.setLocation(300, 100);
zc.setVisible(true);
}
public void jMenuItem2_actionPerformed(ActionEvent e) {
ZcView zc = new ZcView();
zc.setTitle("修改資產信息");
zc.setSize(400, 400);
zc.btnAdd.setEnabled(false);
zc.btnDel.setEnabled(false);
zc.btnModify.setEnabled(true);
zc.setLocation(300, 100);
zc.setVisible(true);
}
public void jMenuItem3_actionPerformed(ActionEvent e) {
ZgView zg = new ZgView();
zg.setTitle("添加職工信息");
zg.setSize(400, 400);
zg.btnDel.setEnabled(false);
zg.btnModify.setEnabled(false);
zg.setLocation(300, 100);
zg.setVisible(true);
}
public void jMenuItem4_actionPerformed(ActionEvent e) {
ZgView zg = new ZgView();
zg.setTitle("刪除職工信息");
zg.setSize(400, 400);
zg.btnAdd.setEnabled(false);
zg.btnModify.setEnabled(false);
zg.setLocation(300, 100);
zg.setVisible(true);
}
public void jMenuItem5_actionPerformed(ActionEvent e) {
ZgView zg = new ZgView();
zg.setTitle("修改職工信息");
zg.setSize(400, 400);
zg.btnDel.setEnabled(false);
zg.btnAdd.setEnabled(false);
zg.setLocation(300, 100);
zg.setVisible(true);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -