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

1、.PAGE ：.；工厂销售管理系统源程序清单课题名：工厂销售管理系统课题号：第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.e

2、vent.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 = -4634690259142971856L;priv

3、ate 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

4、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);lab

5、el.setBounds(, 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(, 174, 58, 24);label_1.setText(密 码);getContentPane().add(label_1);textField = new JTextField();textField.setBounds(225, 107, 147,

6、 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 = textFi

7、eld.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

8、(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 actionPerfor

9、med(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

10、);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;impo

11、rt 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 duct.*;import org.chaolaoban.search.*;/* * author chaolaoban * 工厂销售管理系统运转主界

12、面 */public class FsmsMain extends JFrame implements ActionListenerprivate static final long serialVersionUID = 104369173311173400L;/* * Launch the application * param args */建立一个菜单栏 final JMenuBar menuBar = new JMenuBar(); /建立合同管理菜单栏 final JMenu menucontract = new JMenu(); final JMenuItem itemAddCon

13、tract = 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 me

14、nuproduct = 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 itemEdi

15、tProduct = 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 JMenuIt

16、em 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()

17、;/建立客户管理菜单栏 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)

18、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);setDefa

19、ultCloseOperation(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.a

20、dd(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(menuprod

21、uct);itemInProduct.setText(入库);menuproduct.add(itemInProduct);itemOutProduct.setText(出库);menuproduct.add(itemOutProduct);itemInConMoney.setText(合同货款输入);menuproduct.add(itemInConMoney);itemEditProIndex.setText(修正库单);menuproduct.add(itemEditProIndex);itemQuitProduct.setText(退货处置);menuproduct.add(itemQ

22、uitProduct);itemEditProduct.setText(修正废品库信息);menuproduct.add(itemEditProduct);itemSearchProIndex.setText(查库单);menuproduct.add(itemSearchProIndex);menusearch.setText(随机查询);menuBar.add(menusearch);itemContractSearch.setText(查合同);menusearch.add(itemContractSearch);itemCustomerSearch.setText(查客户情况);menu

23、search.add(itemCustomerSearch);itemPaySearch.setText(查合同的付款情况);menusearch.add(itemPaySearch);itemProductSearch.setText(查废品库信息);menusearch.add(itemProductSearch);itemContExecuteSearch.setText(查合同执行情况);menusearch.add(itemContExecuteSearch);itemDeliverySearch.setText(查某月应交货情况);menusearch.add(itemDelive

24、rySearch);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(itemCu

25、stomerSearch_1);itemCustomerPrint.setText(打印客户信息);menucustomer.add(itemCustomerPrint);itemOweSearch.setText(查阅欠款);menucustomer.add(itemOweSearch);itemLevelSearch.setText(查客户级别);menucustomer.add(itemLevelSearch);/添加事件侦听itemAddContract.addActionListener(this);itemContractPrint.addActionListener(this);

26、itemDelContract.addActionListener(this);itemEditContract.addActionListener(this);itemNumberPrint.addActionListener(this);itemProductCount.addActionListener(this);itemYearCount.addActionListener(this);itemCustomerPrint.addActionListener(this);itemCustomerSearch_1.addActionListener(this);itemLevelSear

27、ch.addActionListener(this);itemOweSearch.addActionListener(this);itemEditProduct.addActionListener(this);itemEditProIndex.addActionListener(this);itemInConMoney.addActionListener(this);itemInProduct.addActionListener(this);itemOutProduct.addActionListener(this);itemQuitProduct.addActionListener(this

28、);itemSearchProIndex.addActionListener(this);itemContExecuteSearch.addActionListener(this);itemContractSearch.addActionListener(this);itemCustomerSearch.addActionListener(this);itemDeliverySearch.addActionListener(this);itemPaySearch.addActionListener(this);itemProductSearch.addActionListener(this);

29、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 Co

30、ntractPrint(); 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 =

31、 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

32、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

33、= 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=i

34、temOutProduct)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 = n

35、ew 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();d

36、s.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 Dat

37、aBase 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:sqlserverlocalhost:1433;DatabaseName=northwind private Connection conn = null; /定义数据库衔接对象,

38、属于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(Excep

39、tion 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.getMess

40、age();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);connmit();catch(SQLException e)System.err.println(executeUpdate:+e.getMessage(); public void closes

41、tmt() 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-8859-1),GBK); catch (Exce

42、ption e) System.out.println(e);return str;合同管理：Org.chaolaoban.contractpackage org.chaolaoban.contract;/* * author 超老板 * * 创建标识:071224 */import java.awt.Dimension;import java.awt.Toolkit;import java.awt.event.ActionEvent;/* * 合同管理模块 * 添加新的合同 * */public class AddContract extends Contract private stati

43、c final long serialVersionUID = -1079754123359683663L;ConBean cb = new ConBean();/* * Create the frame */public AddContract() super();setBounds(100, 100, 500, 375);/setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setTitle(添加合同);this.setResizable(false);contract_no.setEditable(false);contract_no.

44、setText(+cb.getCon_id();checkout_meth.setEditable(true);exchange_add.setEditable(true);transport_meth.setEditable(true);transport_fee.setEditable(true);need_name.setEditable(true);product_name.setEditable(true);number.setEditable(true);price.setEditable(true);delivery_data.setEditable(true); /设置运转时窗

45、口的位置Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();this.setLocation(screenSize.width - 400) / 2,(screenSize.height - 300) / 2 + 45);add.setText(添 加);clear.setText(清 空);/添加事件侦听add.addActionListener(this);clear.addActionListener(this);public void actionPerformed(ActionEvent e) / TO

46、DO 自动生成方法存根Object obj = e.getSource();if(obj = add)contract_no.setEnabled(false);checkout_meth.setEnabled(false);exchange_add.setEnabled(false);transport_meth.setEnabled(false);transport_fee.setEnabled(false);need_name.setEnabled(false);product_name.setEnabled(false);number.setEnabled(false);price.s

47、etEnabled(false);delivery_data.setEnabled(false);add.setEnabled(false);clear.setEnabled(false);cb.addCon(checkout_meth.getText(), exchange_add.getText(), transport_meth.getText(), transport_fee.getText(),need_name.getText(), product_name.getText(), number.getText(), price.getText(), delivery_data.ge

48、tText();this.dispose();AddContract ac = new AddContract();ac.setVisible(true);else if(obj = clear)setNull();contract_no.setText(+cb.getCon_id();package org.chaolaoban.contract;/* * author 超老板 * 创建标识:071223 */import java.sql.ResultSet;import javax.swing.JOptionPane;import org.chaolaoban.main.DataBase

49、; /有关合同数据库操作的类public class ConBean String sql;ResultSet rs = null;String contract_no;String checkout_meth;String exchange_add;String transport_meth;String transport_fee;String need_name;String product_name;String number;String price;String delivery_data;String colName;/列名String colValue;/列值String co

50、lValue2;/列值int contract_ID;/合同的新编号/添加合同public void addCon(String checkout_Meth,String exchange_Add,String transport_Meth,String transport_Fee,String need_Name,String product_Name,String numBer,String priCe,String delivery_Data)DataBase db = new DataBase();/this.contract_no = contract_no;this.checkou

51、t_meth = checkout_Meth;this.exchange_add = exchange_Add;this.transport_meth = transport_Meth;this.transport_fee = transport_Fee;this.need_name = need_Name;duct_name = product_Name;this.number = numBer;this.price = priCe;this.delivery_data = delivery_Data;if(need_name = null|need_name.equals(

52、)JOptionPane.showMessageDialog(null,请输入需方称号,错误,JOptionPane.ERROR_MESSAGE);return;else if(product_name = null|product_name.equals()JOptionPane.showMessageDialog(null,请输入产品称号,错误,JOptionPane.ERROR_MESSAGE);return;elsesql = insert into contract (Checkout_meth,Exchange_add,Transport_meth,Transport_fee,Ne

53、ed_name,Product_name,Numbe,Price,Delivery_data) values (+checkout_meth+,+exchange_add+,+transport_meth+,+transport_fee+,+need_name+,+product_name+,+number+,+price+,+delivery_data+);trydb.Openconn(); db.executeUpdate(sql);JOptionPane.showMessageDialog(null,胜利添加一条记录);catch(Exception e)System.out.print

54、ln(e);JOptionPane.showMessageDialog(null,添加失败,错误,JOptionPane.ERROR_MESSAGE);finallydb.closestmt();db.closeconn();/修正合同public void conModify(String contract_No,String checkout_Meth,String exchange_Add,String transport_Meth,String transport_Fee,String need_Name,String product_Name,String numBer,String

55、 priCe,String delivery_Data)DataBase db = new DataBase();this.contract_no = contract_No;this.checkout_meth = checkout_Meth;this.exchange_add = exchange_Add;this.transport_meth = transport_Meth;this.transport_fee = transport_Fee;this.need_name = need_Name;duct_name = product_Name;this.number

56、= numBer;this.price = priCe;this.delivery_data = delivery_Data;if(need_name = null|need_name.equals()JOptionPane.showMessageDialog(null,请输入需方称号,错误,JOptionPane.ERROR_MESSAGE);return;elsesql = update contract set Checkout_meth = +checkout_meth+,Exchange_add = +exchange_add+,Transport_meth = +transport

57、_meth+,Transport_fee = +transport_fee+,Need_name = +need_name+,Product_name = +product_name+,Numbe = +number+,Price = +price+,Delivery_data = +delivery_data+ where Contract_no = +Integer.parseInt(contract_no)+;trydb.Openconn();db.executeUpdate(sql);JOptionPane.showMessageDialog(null,胜利修正一条记录);catch(

58、Exception e)System.out.println(e);JOptionPane.showMessageDialog(null,修正失败,错误,JOptionPane.ERROR_MESSAGE);finallydb.closestmt();db.closeconn();/删除合同public void delCon(String contract_No)DataBase db = new DataBase();this.contract_no = contract_No; sql = delete from contract where Contract_no = +Integer

59、.parseInt(contract_no)+; try db.Openconn();db.executeUpdate(sql);JOptionPane.showMessageDialog(null,胜利删除一条记录); catch(Exception e) System.out.println(e); JOptionPane.showMessageDialog(null,删除失败,错误,JOptionPane.ERROR_MESSAGE); finally db.closestmt(); db.closeconn(); /根据合同号查询合同执行情况清单public String search

60、Con(String no)DataBase db = new DataBase();this.contract_no = no;String s = new String9;sql = select * from contract where Contract_no = +Integer.parseInt(contract_no)+;trydb.Openconn();rs = db.executeQuery(sql);if(rs.next()s0 = rs.getString(Checkout_meth);s1 = rs.getString(Exchange_add);s2 = rs.get