📄 lendview.java~9~
字号:
package zcgl;
import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JButton;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.awt.HeadlessException;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class LendView extends JFrame {
Connection con=null;
Statement smt=null;
ResultSet rs=null;
JPanel jPanel1 = new JPanel();
JLabel jLabel1 = new JLabel();
JTextField txtZcId = new JTextField();
JLabel jLabel2 = new JLabel();
JTextField txtZcName = new JTextField();
JLabel jLabel3 = new JLabel();
JTextField txtStyle = new JTextField();
JLabel jLabel4 = new JLabel();
JTextField txtPrice = new JTextField();
JLabel jLabel5 = new JLabel();
JComboBox cmbLender = new JComboBox();
JLabel jLabel6 = new JLabel();
JTextField txtLendDate = new JTextField();
JLabel jLabel7 = new JLabel();
JTextField txtGhDate = new JTextField();
JLabel jLabel8 = new JLabel();
JComboBox cmbLend = new JComboBox();
JLabel jLabel9 = new JLabel();
JTextField txtOpator = new JTextField();
JLabel jLabel10 = new JLabel();
JTextField txtContext = new JTextField();
JButton btnBorrow = new JButton();
JButton btnReturn = new JButton();
JButton jButton1 = new JButton();
public LendView() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
getContentPane().setLayout(null);
jPanel1.setBorder(BorderFactory.createEtchedBorder());
jPanel1.setBounds(new Rectangle(40, 11, 345, 200));
jPanel1.setLayout(null);
jLabel2.setText("资产名称");
jLabel2.setBounds(new Rectangle(172, 20, 49, 15));
txtZcName.setBounds(new Rectangle(224, 18, 98, 21));
txtZcId.setBounds(new Rectangle(60, 17, 101, 21));
jLabel3.setText("样 式");
jLabel3.setBounds(new Rectangle(11, 53, 42, 15));
txtStyle.setBounds(new Rectangle(61, 51, 101, 21));
jLabel4.setText("价 格");
jLabel4.setBounds(new Rectangle(174, 53, 42, 15));
txtPrice.setBounds(new Rectangle(225, 51, 95, 21));
jLabel5.setText("借用人编号");
jLabel5.setBounds(new Rectangle(10, 83, 70, 23));
cmbLender.setBounds(new Rectangle(74, 84, 88, 23));
jLabel6.setText("借用日期");
jLabel6.setBounds(new Rectangle(174, 87, 50, 15));
txtLendDate.setBounds(new Rectangle(226, 85, 94, 21));
jLabel7.setText("归还日期");
jLabel7.setBounds(new Rectangle(10, 122, 55, 15));
txtGhDate.setBounds(new Rectangle(61, 121, 101, 21));
jLabel8.setText("是否归还");
jLabel8.setBounds(new Rectangle(174, 125, 49, 15));
cmbLend.setBounds(new Rectangle(226, 120, 94, 23));
jLabel9.setText("操作人");
jLabel9.setBounds(new Rectangle(16, 165, 42, 13));
txtOpator.setBounds(new Rectangle(61, 160, 101, 21));
jLabel10.setText("备 注");
jLabel10.setBounds(new Rectangle(176, 164, 48, 15));
txtContext.setBounds(new Rectangle(224, 162, 97, 21));
btnBorrow.setBounds(new Rectangle(35, 238, 83, 25));
btnBorrow.setText("借用");
btnBorrow.addActionListener(new LendView_btnBorrow_actionAdapter(this));
btnReturn.setBounds(new Rectangle(149, 238, 83, 25));
btnReturn.setText("归还");
btnReturn.addActionListener(new LendView_btnReturn_actionAdapter(this));
jButton1.setBounds(new Rectangle(259, 240, 83, 25));
jButton1.setText("查询");
jButton1.addActionListener(new LendView_jButton1_actionAdapter(this));
jPanel1.add(jLabel1);
jPanel1.add(txtZcId);
jPanel1.add(txtZcName);
jPanel1.add(jLabel2);
jPanel1.add(jLabel3);
jPanel1.add(txtStyle);
jPanel1.add(jLabel4);
jPanel1.add(txtPrice);
jPanel1.add(jLabel5);
jPanel1.add(cmbLender);
jPanel1.add(jLabel6);
jPanel1.add(txtLendDate);
jPanel1.add(jLabel7);
jPanel1.add(txtGhDate);
jPanel1.add(jLabel8);
jPanel1.add(cmbLend);
jPanel1.add(jLabel9);
jPanel1.add(txtOpator);
jPanel1.add(jLabel10);
jPanel1.add(txtContext);
this.getContentPane().add(jButton1);
this.getContentPane().add(btnReturn);
this.getContentPane().add(btnBorrow);
this.getContentPane().add(jPanel1, null);
jLabel1.setText("资产编号");
jLabel1.setBounds(new Rectangle(9, 20, 52, 15));
cmbLend.addItem("是");
cmbLend.addItem("否");
con=new DBConn().getConnection();
smt=con.createStatement();
rs=smt.executeQuery("select empno from EMPLOYEE");
while (rs.next())
{
cmbLender.addItem(rs.getInt(1));
}
}
public void btnBorrow_actionPerformed(ActionEvent e) throws
HeadlessException, ClassNotFoundException {
ZcBean bean=new ZcBean();
bean.setZcDlId(Integer.parseInt(txtZcId.getText()));
if(bean.isUse()){
JOptionPane.showMessageDialog(this, "此资产已被借出！");
return;
}
bean.setZcName(txtZcName.getText());
bean.setZcStyle(txtStyle.getText());
bean.setLendDate(txtLendDate.getText());
bean.setZcPrice(Float.parseFloat(txtPrice.getText()));
bean.setReturnDate(txtGhDate.getText());
bean.setLender(Integer.parseInt(cmbLender.getSelectedItem().toString()));
if (cmbLend.getSelectedIndex() == 0) {
bean.setZcStatus("1");
} else {
bean.setZcStatus("0");
}
bean.setZcGrR(txtOpator.getText());
bean.setZcContext(txtContext.getText());
if (bean.lend()) {
JOptionPane.showMessageDialog(this, "操作成功！");
} else {
JOptionPane.showMessageDialog(this, "操作失败！");
}
}
public void btnReturn_actionPerformed(ActionEvent e) throws
HeadlessException, ClassNotFoundException {
ZcBean bean = new ZcBean();
bean.setZcId(Integer.parseInt(txtZcId.getText()));
if(!bean.isUse()){
JOptionPane.showMessageDialog(this, "此资产没有被借出，不需要归还！");
return;
}
if( bean.returns())
JOptionPane.showMessageDialog(this, "操作成功！");
else
JOptionPane.showMessageDialog(this, "操作失败！");
}
public void jButton1_actionPerformed(ActionEvent e) throws
ClassNotFoundException {
ResultSet rs=null;
rs= new DBConn().execute("select A.*,L.* from ASSET as A left outer join LEND as L on A.assetid=L.assetid where A.assetid="+txtZcId.getText());
try {
if (rs.next()) {
txtZcName.setText(rs.getString("asset_name").trim());
txtStyle.setText(rs.getString("model").trim());
txtPrice.setText(String.valueOf(rs.getFloat("price")));
txtLendDate.setText(rs.getDate("usedate").toString());
txtGhDate.setText(rs.getDate("retdate").toString());
txtOpator.setText(rs.getString("lender"));
txtContext.setText(rs.getString("remarks").trim());
}
} catch (SQLException ex) {
}catch(NullPointerException ex){
txtLendDate.setText("");
txtGhDate.setText("");
txtOpator.setText("");
txtContext.setText("");
}
}
}
class LendView_jButton1_actionAdapter implements ActionListener {
private LendView adaptee;
LendView_jButton1_actionAdapter(LendView adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
try
{
adaptee.jButton1_actionPerformed(e);
}
catch(Exception ex){
}
}
}
class LendView_btnReturn_actionAdapter implements ActionListener {
private LendView adaptee;
LendView_btnReturn_actionAdapter(LendView adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btnReturn_actionPerformed(e);
}
}
class LendView_btnBorrow_actionAdapter implements ActionListener {
private LendView adaptee;
LendView_btnBorrow_actionAdapter(LendView adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.btnBorrow_actionPerformed(e);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -