📄 rkguanli.java
字号:
package windows;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JComponent;
import javax.swing.JFileChooser;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.border.TitledBorder;
import javax.swing.event.InternalFrameAdapter;
import javax.swing.event.InternalFrameEvent;
import javax.swing.filechooser.FileFilter;
import sql.sql;
import model.TbUserlist;
import Login.Item;
import Login.Login;
public class RKGuanLi extends JInternalFrame {
private final JTextField In_ID = new JTextField();
private final JTextField Eqp_Name = new JTextField();
private final JTextField In_Num = new JTextField();
private final JTextField Eqp_Price = new JTextField();
private final JComboBox Eqp_Style = new JComboBox(new String[]{"CPU","主板","内存","显卡","硬盘","电源","光驱","机箱","键鼠","声卡"});
private final JTextField Eqp_Para=new JTextField();
private final JTextField In_Time = new JTextField();
private final JTextField In_Oper = new JTextField();
private final JTextField In_Per = new JTextField();
private final JLabel photoLabel = new JLabel("双击添加图片");
private final JTextField In_Remark = new JTextField();
private TbUserlist user = Login.getUser(); // 登录用户信息
private File file;
public RKGuanLi() throws SQLException {
super();
setMaximizable(true);
setIconifiable(true);
setClosable(true);
getContentPane().setLayout(new GridBagLayout());
setTitle("仓库管理之入库管理");
setBounds(20, 20,800,350);
try {
getMaxId();
} catch (SQLException e1) {
e1.printStackTrace();
}
setupComponet(new JLabel("入库编号："), 0, 0, 1, 1 , 0, false);
setupComponet(In_ID, 1, 0, 1, 1 , 80, true);
Date IDDate = new Date();
java.sql.Date date = new java.sql.Date(IDDate.getTime());
final String dateStr = date.toString().replace("-", "");
In_ID.setText("E_IN_"+dateStr+getMaxId());
In_ID.setFocusable(false);
setupComponet(new JLabel("入库时间："), 2,0, 1, 1 , 0, false);
setupComponet(In_Time,3, 0, 1, 1 , 1, true);
In_Time.setFocusable(false);
setupComponet(new JLabel("操作员："), 4,0, 1, 1 , 0, false);
setupComponet(In_Oper,5, 0, 1, 1 ,80, true);
In_Oper.setText(user.getName());
In_Oper.setFocusable(false);
setupComponet(new JLabel("设备名称："), 0,1, 1, 1 , 0, false);
setupComponet(Eqp_Name ,1, 1, 3, 1 , 80, true);
setupComponet(new JLabel("经手人："),4,1, 1, 1 , 0, false);
setupComponet(In_Per,5,1, 1, 1 , 100, true);
setupComponet(new JLabel("入库数量："), 0, 2, 1, 1 , 0, false);
setupComponet(In_Num ,1, 2, 1, 1 , 80, true);
In_Num.addKeyListener(new InputKeyListener());
setupComponet(new JLabel("设备单价："), 2,2, 1, 1 , 0, false);
setupComponet(Eqp_Price,3, 2, 1, 1 , 140, true);
Eqp_Price.addKeyListener(new InputKeyListener1());
setupComponet(new JLabel("设备类型："), 4,2, 1, 1 ,0, false);
setupComponet(Eqp_Style,5, 2, 1,1, 140, true);
Eqp_Style.setFocusable(false);
setupComponet(new JLabel("设备参数：") ,0,3, 1, 1, 0, false);
setupComponet(Eqp_Para, 1, 3, 4, 1, 80, true);
Eqp_Para.setPreferredSize(new Dimension(20, 100));
setupComponet(new JLabel("备注："), 0, 4, 1, 1 , 0, false);
setupComponet(In_Remark,1, 4, 4, 1 ,80, true);
photoLabel.setHorizontalAlignment(SwingConstants.CENTER);// 设置照片或文字居中显示
photoLabel.setBorder(new TitledBorder(null, "",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null));// 设置边框
photoLabel.setPreferredSize(new Dimension(20, 135));// 设置显示照片的大小
setupComponet(photoLabel,5, 3, 1, 5,1, true);
final JButton CZ= new JButton("重置");
CZ.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
Eqp_Name.setText(null);
In_Num.setText(null);
Eqp_Price.setText(null);
Eqp_Para.setText(null);
In_Per.setText(null);
photoLabel.setIcon(null);
photoLabel.setText("双击添加图片");
In_Remark.setText(null);
Eqp_Name.requestFocus();
}
});
JButton Exit =new JButton("退出");
Exit.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
dispose();
}
});
JPanel panel = new JPanel();
panel.add(CZ);
panel.add(Exit);
JButton RK =new JButton("入库");
setupComponet(RK, 2, 7, 1,8, 0, false);
setupComponet(panel, 3, 7, 1,8, 0, false);
RK.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
if (Eqp_Name.getText().equals(""))
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "设备名称为空，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
Eqp_Name.requestFocus();
}
else if(In_Per.getText().equals(""))
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "经手人为空，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
In_Per.requestFocus();
}
else if(In_Num.getText().equals(""))
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "入库数量为空，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
In_Num.requestFocus();
}
else if(Eqp_Price.getText().equals(""))
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "设备单价为空，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
Eqp_Price.requestFocus();
}
else{
try
{ int i= Integer.parseInt(In_Num.getText());
double d=Double.parseDouble(Eqp_Price.getText());
if(i==0)
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "入库数量不能为0，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
In_Num.setText("");
In_Num.requestFocus();
}
else if(d==0)
{
JOptionPane.showConfirmDialog(RKGuanLi.this, "设备单价不能为0，请重新填入", "E时代仓库信息管理系统入库管理提示",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
Eqp_Price.setText("");
Eqp_Price.requestFocus();
}
else{
if (file == null)
{
sql.insert("insert tb_In( [In_ID] , [Eqp_Name] , [In_Num] , [Eqp_Price] , [Eqp_Style] , [Eqp_Para] , [In_Time] , [In_Oper] , [In_Per] , [In_Remark]) values('" + In_ID.getText().trim() + "','"
+ Eqp_Name.getText().trim() + "','" + In_Num.getText().trim() + "','"
+ Eqp_Price.getText().trim() + "','" + Eqp_Style.getItemAt(Eqp_Style.getSelectedIndex()) + "','"
+ Eqp_Para.getText().trim() + "','" + In_Time.getText().trim() + "','"
+ In_Oper.getText().trim() + "','" + In_Per.getText().trim() + "','"+ In_Remark.getText().trim()+"')");
String sqlyuju = "select * from tb_Stor where ";
ResultSet set = sql.query(sqlyuju + "Eqp_Name='" + Eqp_Name.getText().trim() +"'");
if(!set.next()) //对库存表的操作
{
sql.insert("insert tb_Stor( [Eqp_Name] , [Stor_Num] ,[Eqp_Style] , [Eqp_Para]) values('"+ Eqp_Name.getText().trim()
+ "','" + In_Num.getText().trim() + "','" + Eqp_Style.getItemAt(Eqp_Style.getSelectedIndex()) + "','"
+ Eqp_Para.getText().trim() + "')");
}
else
{
int j=i+set.getInt(2);
sql.update("UPDATE tb_Stor SET [Stor_Num] = '"+ j + "'" + "where "+ "Eqp_Name='" + Eqp_Name.getText().trim() +"'");//
}
}
else
{//向数据库中存图片
java.sql.Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Storage");
java.sql.Statement stmt = conn.createStatement();
stmt.close();
PreparedStatement pstmt = null;
String sql1 = "";
InputStream photoStream = new FileInputStream(file);
sql1 = "INSERT INTO tb_In( [In_ID] , [Eqp_Name] , [In_Num] , [Eqp_Price] , [Eqp_Style] , [Eqp_Para] , [In_Time] , [In_Oper] , [In_Per] , [In_Remark],[Eqp_Pot]) VALUES (?,?,?,?,?,?,?,?,?,?,?)";
pstmt = ((java.sql.Connection) conn).prepareStatement(sql1);
pstmt.setString(1, In_ID.getText().trim());
pstmt.setString(2, Eqp_Name.getText().trim());
pstmt.setString(3, In_Num.getText().trim());
pstmt.setString(4, Eqp_Price.getText().trim());
pstmt.setString(5, (String) Eqp_Style.getItemAt(Eqp_Style.getSelectedIndex()));
pstmt.setString(6, Eqp_Para.getText().trim());
pstmt.setString(7, In_Time.getText().trim());
pstmt.setString(8, In_Oper.getText().trim());
pstmt.setString(9, In_Per.getText().trim());
pstmt.setString(10, In_Remark.getText().trim());
pstmt.setBinaryStream(11, photoStream, (int) file.length());
pstmt.executeUpdate();
pstmt.close();
conn.close();
String sqlyuju = "select * from tb_Stor where ";
ResultSet set = sql.query(sqlyuju + "Eqp_Name='" + Eqp_Name.getText().trim() +"'");
if(!set.next())
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Storage");
java.sql.Statement stmt1 = conn.createStatement();
stmt1.close();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -