工厂销售管理系统源程序清单.doc

工厂销售管理系统源程序清单- 211 -2020年5月29日文档仅供参考工厂销售管理系统源程序清单课题名:工厂销售管理系统课题号:第15组小组组长:柳超小组成员:张玉进,高方,吴攀,李泉,何晶晶武汉科技大学电子技术学电子系058503班软件工程实践课题主控模块:org.chaolaoban.mainpackage org.chaolaoban.main;/* * author chaolaoban * * 创立标识:071213 * 修改标识:071214 */import java.awt.Color;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPasswordField;import javax.swing.JTextField;public class FsmsMs extends JFrame private static final long serialVersionUID = -2971856L;private JPasswordField PasswordField;private JTextField textField;/* * Launch the application * param args */public static void main(String args) try FsmsMs frame = new FsmsMs();frame.setVisible(true);frame.setSize(500, 375);frame.setResizable(false); catch (Exception e) e.printStackTrace();/* * Create the frame */public FsmsMs() super();getContentPane().setBackground(new Color(250, 235, 215);getContentPane().setLayout(null);setTitle(登陆工厂销售管理系统);setBounds(450, 200, 500, 375);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);final JLabel label = new JLabel();label.setFont(new Font(, Font.BOLD, 16);label.setBounds(138, 91, 58, 52);getContentPane().add(label);label.setText(用 户名);final JLabel label_1 = new JLabel();label_1.setFont(new Font(, Font.BOLD, 16);label_1.setBounds(138, 174, 58, 24);label_1.setText(密 码);getContentPane().add(label_1);textField = new JTextField();textField.setBounds(225, 107, 147, 24);getContentPane().add(textField);PasswordField = new JPasswordField();PasswordField.setBounds(225, 176, 147, 24);getContentPane().add(PasswordField);final JButton button = new JButton();button.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) String uname = textField.getText();String psw = new String(PasswordField.getPassword();int ifexit = 0;/if(uname = chaolaoban)if(uname.equals(chaolaoban)&psw.equals(008814)FsmsMain Fs = new FsmsMain();Fs.setVisible(true);Fs.setSize(500,375);cancel();else ifexit = JOptionPane.showConfirmDialog(null,输入的用户名或密码不正确,请重新输入!);if(ifexit = JOptionPane.YES_OPTION)return;else dispose();private void cancel() dispose() ;/ TODO 自动生成方法存根);button.setText(确 定);button.setBounds(122, 245, 99, 23);getContentPane().add(button);final JButton button_1 = new JButton();button_1.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) int ifdel = JOptionPane.showConfirmDialog(null, 真的要退出吗?);if(ifdel = JOptionPane.YES_OPTION)dispose();else return;);button_1.setText(退 出);button_1.setBounds(313, 245, 99, 23);getContentPane().add(button_1);final JLabel label_2 = new JLabel();label_2.setFont(new Font(, Font.BOLD, 22);label_2.setText(工厂销售管理系统);label_2.setBounds(157, 35, 195, 31);getContentPane().add(label_2);package org.chaolaoban.main;/* * author 超老板 * 创立标识:071209 * 修改标识:071210 * 修改标识:071214 * 修改标识:071217 */import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.BoxLayout;import javax.swing.JFrame;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import org.chaolaoban.contract.*;import org.chaolaoban.count.*;import org.chaolaoban.customer.*;import org.chaolaoban.product.*;import org.chaolaoban.search.*;/* * author chaolaoban * 工厂销售管理系统运行主界面 */public class FsmsMain extends JFrame implements ActionListenerprivate static final long serialVersionUID = 1043690L;/* * Launch the application * param args */建立一个菜单栏 final JMenuBar menuBar = new JMenuBar(); /建立合同管理菜单栏 final JMenu menucontract = new JMenu(); final JMenuItem itemAddContract = new JMenuItem(); final JMenuItem itemEditContract = new JMenuItem(); final JMenuItem itemDelContract = new JMenuItem(); /建立打印子菜单栏 final JMenu print = new JMenu(); final JMenuItem itemContractPrint = new JMenuItem(); final JMenuItem itemNumberPrint = new JMenuItem();/建立成品库管理菜单栏 final JMenu menuproduct = new JMenu(); final JMenuItem itemInProduct = new JMenuItem(); final JMenuItem itemOutProduct = new JMenuItem(); final JMenuItem itemInConMoney = new JMenuItem(); final JMenuItem itemEditProIndex = new JMenuItem(); final JMenuItem itemQuitProduct = new JMenuItem(); final JMenuItem itemEditProduct = new JMenuItem(); final JMenuItem itemSearchProIndex = new JMenuItem();/建立随机查询菜单栏 final JMenu menusearch = new JMenu(); final JMenuItem itemContractSearch = new JMenuItem(); final JMenuItem itemCustomerSearch = new JMenuItem(); final JMenuItem itemPaySearch = new JMenuItem(); final JMenuItem itemProductSearch = new JMenuItem(); final JMenuItem itemContExecuteSearch = new JMenuItem(); final JMenuItem itemDeliverySearch = new JMenuItem();/建立打印及统计报表菜单栏 final JMenu menucount = new JMenu(); final JMenuItem itemYearCount = new JMenuItem(); final JMenuItem itemProductCount = new JMenuItem();/建立客户管理菜单栏 final JMenu menucustomer = new JMenu(); final JMenuItem itemCustomerSearch_1 = new JMenuItem(); final JMenuItem itemCustomerPrint = new JMenuItem(); final JMenuItem itemOweSearch = new JMenuItem(); final JMenuItem itemLevelSearch = new JMenuItem(); /*public static void main(String args) try FsmsMain frame = new FsmsMain();frame.setVisible(true);frame.setResizable(false);frame.setSize(500, 375); catch (Exception e) e.printStackTrace(); */* * Create the frame */public FsmsMain() super();/enableEvents(AWTEvent.WINDOW_EVENT_MASK);setTitle(工厂销售管理系统);setBounds(450, 200, 500, 375);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);getContentPane().setLayout(new BoxLayout(getContentPane(), BoxLayout.X_AXIS);setJMenuBar(menuBar);menucontract.setText(合同管理);menuBar.add(menucontract);menucontract.add(itemAddContract);itemAddContract.setText(合同输入);itemEditContract.setText(合同修改);menucontract.add(itemEditContract);itemDelContract.setText(合同删除);menucontract.add(itemDelContract);print.setText(打印);menucontract.add(print);itemContractPrint.setText(合同执行情况清单);print.add(itemContractPrint);itemNumberPrint.setText(月需交货及汇总 );print.add(itemNumberPrint);menuproduct.setText(成品库管理);menuBar.add(menuproduct);itemInProduct.setText(入库);menuproduct.add(itemInProduct);itemOutProduct.setText(出库);menuproduct.add(itemOutProduct);itemInConMoney.setText(合同货款输入);menuproduct.add(itemInConMoney);itemEditProIndex.setText(修改库单);menuproduct.add(itemEditProIndex);itemQuitProduct.setText(退货处理);menuproduct.add(itemQuitProduct);itemEditProduct.setText(修改成品库信息);menuproduct.add(itemEditProduct);itemSearchProIndex.setText(查库单);menuproduct.add(itemSearchProIndex);menusearch.setText(随机查询);menuBar.add(menusearch);itemContractSearch.setText(查合同);menusearch.add(itemContractSearch);itemCustomerSearch.setText(查客户情况);menusearch.add(itemCustomerSearch);itemPaySearch.setText(查合同的付款情况);menusearch.add(itemPaySearch);itemProductSearch.setText(查成品库信息);menusearch.add(itemProductSearch);itemContExecuteSearch.setText(查合同执行情况);menusearch.add(itemContExecuteSearch);itemDeliverySearch.setText(查某月应交货情况);menusearch.add(itemDeliverySearch);menucount.setText(统计及打印报表);menuBar.add(menucount);itemYearCount.setText(按年月统计销售额);menucount.add(itemYearCount);itemProductCount.setText(按产品统计销售额);menucount.add(itemProductCount);menucustomer.setText(客户管理);menuBar.add(menucustomer);itemCustomerSearch_1.setText(查客户信息);menucustomer.add(itemCustomerSearch_1);itemCustomerPrint.setText(打印客户信息);menucustomer.add(itemCustomerPrint);itemOweSearch.setText(查阅欠款);menucustomer.add(itemOweSearch);itemLevelSearch.setText(查客户级别);menucustomer.add(itemLevelSearch);/添加事件侦听itemAddContract.addActionListener(this);itemContractPrint.addActionListener(this);itemDelContract.addActionListener(this);itemEditContract.addActionListener(this);itemNumberPrint.addActionListener(this);itemProductCount.addActionListener(this);itemYearCount.addActionListener(this);itemCustomerPrint.addActionListener(this);itemCustomerSearch_1.addActionListener(this);itemLevelSearch.addActionListener(this);itemOweSearch.addActionListener(this);itemEditProduct.addActionListener(this);itemEditProIndex.addActionListener(this);itemInConMoney.addActionListener(this);itemInProduct.addActionListener(this);itemOutProduct.addActionListener(this);itemQuitProduct.addActionListener(this);itemSearchProIndex.addActionListener(this);itemContExecuteSearch.addActionListener(this);itemContractSearch.addActionListener(this);itemCustomerSearch.addActionListener(this);itemDeliverySearch.addActionListener(this);itemPaySearch.addActionListener(this);itemProductSearch.addActionListener(this);public void actionPerformed(ActionEvent e) Object obj = e.getSource();if(obj=itemAddContract) /obj.getClass().isInstance(itemAddContract) AddContract act = new AddContract(); act.setVisible(true); else if(obj=itemContractPrint) /obj.getClass().isInstance(itemContractPrint) ContractPrint ctp = new ContractPrint(); ctp.setVisible(false); else if(obj = itemDelContract) /obj.getClass().isInstance(itemDelContract)DelContract adt = new DelContract();adt.setVisible(true);else if(obj=itemEditContract)EditContract ect =new EditContract();ect.setVisible(true);else if(obj=itemNumberPrint)NumberPrint np = new NumberPrint();np.setVisible(false);else if(obj=itemProductCount)ProductCount pc = new ProductCount();pc.setVisible(false);else if(obj=itemYearCount)YearCount yc = new YearCount();yc.setVisible(false);else if(obj=itemCustomerPrint)CustomerPrint cp = new CustomerPrint();cp.setVisible(false);else if(obj=itemCustomerSearch_1)CustomerSearch_1 sc_1 = new CustomerSearch_1();sc_1.setVisible(true);else if(obj=itemLevelSearch)LevelSearch np = new LevelSearch();np.setVisible(true);else if(obj=itemOweSearch)OweSearch os = new OweSearch();os.setVisible(true);else if(obj=itemEditProduct)EditProduct ep = new EditProduct();ep.setVisible(true);else if(obj=itemEditProIndex)EditProIndex epi = new EditProIndex();epi.setVisible(true);else if(obj=itemInConMoney)InConMoney icp = new InConMoney();icp.setVisible(true);else if(obj=itemInProduct)InProduct ip = new InProduct();ip.setVisible(true);else if(obj=itemOutProduct)OutProduct op = new OutProduct();op.setVisible(true);else if(obj=itemQuitProduct)QuitProduct qp = new QuitProduct();qp.setVisible(true);else if(obj=itemSearchProIndex)SearchProIndex np = new SearchProIndex();np.setVisible(true);else if(obj=itemContExecuteSearch)ContExecuteSearch np = new ContExecuteSearch();np.setVisible(true);else if(obj=itemContractSearch)ContractSearch cs = new ContractSearch();cs.setVisible(true);else if(obj=itemCustomerSearch)CustomerSearch cs = new CustomerSearch();cs.setVisible(true);else if(obj=itemDeliverySearch)DeliverySearch ds = new DeliverySearch();ds.setVisible(true);else if(obj=itemPaySearch)PaySearch ps = new PaySearch();ps.setVisible(true);else if(obj=itemProductSearch)ProductSearch ps = new ProductSearch();ps.setVisible(true);package org.chaolaoban.main;/* * author chaolaoban * 创立标识:071206 * 修改标识:071207 */import java.sql.*;public class DataBase String DBDRIVER = sun.jdbc.odbc.JdbcOdbcDriver;/定义数据库驱动程序sun.jdbc.odbc.JdbcOdbcDriver com.microsoft.jdbc.sqlserver.SQLServerDriver String DBURL = jdbc:odbc:fsmss; /定义数据库连接地址 jdbc:odbc:fsms jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=northwind private Connection conn = null; /定义数据库连接对象,属于java.sql中的接口 private Statement stmt; /定义statement对象,用于操作数据库 String sql; /定义一个字符串变量,用于保存sql语句 ResultSet rs = null; /定义结果集rspublic void Dababase() /定义一个构造函数/* * 打开数据库 */public void Openconn()throws ExceptiontryClass.forName(DBDRIVER); /加载驱动程序conn=DriverManager.getConnection(DBURL); /连接数据库catch(Exception e)System.out.println(数据库连接失败!);/* * 执行sql语句,返回结果集rs */public ResultSet executeQuery(String sql)stmt = null;rs=null;trystmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);rs=stmt.executeQuery(sql);catch(SQLException e)System.err.println(executeQuery:+e.getMessage();return rs;/* *执行sql语句 */public void executeUpdate(String sql)stmt=null;/rs=null;trystmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);stmt.executeUpdate(sql);mit();catch(SQLException e)System.err.println(executeUpdate:+e.getMessage(); public void closestmt() try stmt.close(); catch(SQLException e1)System.out.println(数据库关闭失败!); public void closeconn()tryconn.close();catch(SQLException e2)System.out.println(数据库关闭失败!);/* * 转换编码 */public static String toGBK(String str)try if(str=null)str = ;elsestr=new String(str.getBytes(ISO-