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

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

课题名：工厂销售管理系统

课题号：第15组

小组组长：柳超

小组成员：张玉进，高方，吴攀，李泉，何晶晶

武汉科技大学电子技术学电子系058503班软件工程实践课题

主控模块：org.chaolaoban.main
package 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 = -4634690259142971856L;
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 ActionListener{
private static final long serialVersionUID = 104369173311173400L;
/**
* 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; //定义结果集rs

public void Dababase(){ //定义一个构造函数
}
/**
* 打开数据库
*/
public void Openconn()throws Exception{
try{
Class.forName(DBDRIVER); //加载驱动程序
conn=DriverManager.getConnection(DBURL); //连接数据库
}
catch(Exception e){
System.out.println("数据库连接失败!!!");
}
}
/**
* 执行sql语句,返回结果集rs
*/
public ResultSet executeQuery(String sql){
stmt = null;
rs=null;
try{
stmt=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;
try{
stmt=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(){
try{
conn.close();
}
catch(SQLException e2){
System.out.println("数据库关闭失败!!");
}
}
/**
* 转换编码
*/
public static String toGBK(String str){
try {
if(str==null)
str = "";
else
str=new String(str.getBytes("ISO-8859-1"),"GBK");
}
catch (Exceptio