Java语言课程设计-小型超市管理系统

JAVA语言课程设计报告题目：小型超市管理系统设计者：专业班级：学号：指导教师：2010 年12 月12 日计算机学院目录一、系统需求分析 .................................................................................................................................... - 1 -1.1系统名称： .................................................................................................................................. - 1 -1.2系统介绍： .................................................................................................................................. - 1 -1.3开发背景 ...................................................................................................................................... - 1 -1.4.系统面向的用户群体................................................................................................................... - 1 -1.5开发环境 ...................................................................................................................................... - 1 -二、系统总体设计 .................................................................................................................................... - 2 -2.1系统功能结构图........................................................................................................................... - 2 -三、系统详细设计 .................................................................................................................................... - 2 -3.1数据库实体E-R图设计 .............................................................................................................. - 2 -3.2数据库表的设计........................................................................................................................... - 4 -3.3物理设计文档............................................................................................................................... - 6 -3.4详细设计 .................................................................................................................................... - 10 -四、系统总结 .......................................................................................................................................... - 20 -五、系统设计心得体会........................................................................................................................... - 21 -六、参考文献 .......................................................................................................................................... - 21 -一、系统需求分析1.1系统名称：小型超市管理系统1.2系统介绍：界面设计简洁、友好、美观大方操作简单、快捷方便数据存储安全、可靠信息分类清晰、准确强大的查询功能、保证数据查询的灵活性提供销售排行，为管理员提供真实的数据信息提供灵活、方便的权限设置功能，使整个系统的管理分工明确对用户的输入的数据，系统进行严格的数据检验，尽可能排人为错误1.3开发背景随着现代科学技术的迅猛发展，计算机技术已经渗透到各个领域，成为各行业必不可少的工具，特别是Internet技术的推广和信息高速公路的建立，使IT产业在市场竞争中越发显示出其独特的优势，步入信息化时代，有巨大的数据信息等待加工处理和传输，这使得对数据库的进一步开发和利用显得尤为迫切。

作为国内市场的一些中小型超市，它们在信息化过程中的步伐要落后于大中型超市，而对于这些企业的资源管理，信息的存储和处理也显得迫切需要，要适应市场竞争，就需要有高效的处理方式和管理方法，因此加快超市的信息化进程是必不可少的。

我国的超市在20世纪90年代初期形成，现在已经成为我国零售业的一种重要形态，为国民经济的发展发挥了重要的作用。

随着经济的快速发展，超市的经营管理也变得愈加复杂，早期的售货员站柜台的形式早已不能满足现有销售业的发展，这样就迫切地需要引入新的管理技术。

1.4.系统面向的用户群体主要是中小型超市使用者，该消费群体具有以下特征：1超市日常管理人工化居多，工作效率较低；2超市日常交易额较小，货物流通较小，不愿花高价购进大型超市管理系统。

因此，该消费群体对产品的功能性需求并不高，只需满足前台销售系统、后台货物管理即可。

1.5开发环境Eclipse+mysql二、系统总体设计2.1系统功能结构图三、系统详细设计3.1数据库实体E-R图设计(1)图书信息实体E-R图(2)读者信息实体(3)图书借阅实体(4)多图之间的E-R图3.2数据库表的设计数据库名：limitedmarket(1)用户登录表（account）(2)用户信息表(manager)(3)商品信息表（commodity）(4)供应商表（provider）(5)销售表（sale）(6) 库存信息表(storage)(7)销售退货（returnsale）(8)入库退货（returnsale）3.3物理设计文档/*----------创建数据库----------*/本系统使用mysql数据库，首先我们在Navicat for MySQL的Host: localhost下创建数据库limitedmarket,选择数据库编码为utf8 -- UTF-8 Unicode。

或使用sql语句create database limitedmarket创建数据库。

/*----------创建基本表----------*//*创建account表*/DROP TABLE IF EXISTS `account`;CREATE TABLE `account` (`accountNumber` Integer NOT NULL auto_increment,`accountName` varchar(30) NOT NULL,`accountPassword` varchar(20) NOT NULL,`accountType` smallint(6) NOT NULL,`managerID` Integer default NULL,`accountState` smallint(6) NOT NULL,PRIMARY KEY (`accountNumber`),KEY `FK_manage` (`managerID`),CONSTRAINT `FK_manage` FOREIGN KEY (`managerID`) REFERENCES `manager` (`managerID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建manage表*/DROP TABLE IF EXISTS `manager`;CREATE TABLE `manager` (`managerID` Integer NOT NULL auto_increment,`managerName` varchar(20) NOT NULL,`managerMobilephone` varchar(15) ,`managerRegionNumber` varchar(4) ,`managerEMail` varchar(30) default NULL,`managerPhone` varchar(10) ,PRIMARY KEY (`managerID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建commodity表*/DROP TABLE IF EXISTS `commodity`;CREATE TABLE `commodity` (`commodityID` integer NOT NULL auto_increment,`providernumber` int(11) default NULL,`commodityname` varchar(45) NOT NULL,`inDate` datetime NOT NULL,`producedate` datetime NOT NULL,`inprice` float NOT NULL,`saleprice` float NOT NULL,`storagetime` int(11) NOT NULL,`downlimit` int(11) NOT NULL,`unit` varchar(8) default NULL,PRIMARY KEY (`commodityID`),KEY `FK_supply` (`providernumber`),CONSTRAINT `FK_supply` FOREIGN KEY (`providernumber`) REFERENCES `provider` (`providernumber`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建returncommodity*/DROP TABLE IF EXISTS `returncommodity`;CREATE TABLE `returncommodity` (`RCid` int unsigned NOT NULL auto_increment,`commodityname` varchar(45) NOT NULL,`commodityid` varchar(45) NOT NULL,`unit` varchar(45) NOT NULL,`price` float NOT NULL,`outdate` datetime NOT NULL,`provider` varchar(45) NOT NULL,`operator` varchar(45) NOT NULL,`number` int unsigned NOT NULL,PRIMARY KEY (`RCid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建sale表*/DROP TABLE IF EXISTS `sale`;CREATE TABLE `sale` (`commodityname` varchar(45) NOT NULL,`commodityid` int unsigned NOT NULL,`sellTime` datetime NOT NULL,`number` varchar(45) NOT NULL,`money` double NOT NULL,`operator` varchar(45) NOT NULL,`saleid` int NOT NULL auto_increment,PRIMARY KEY (`saleid`)) ENGINE=InnoDB DEFAULT CHARSET=gb2312 PACK_KEYS=1;/*创建returnsale表*/DROP TABLE IF EXISTS `returnsale`;CREATE TABLE `returnsale` (`Rsaleid` int unsigned NOT NULL auto_increment,`commodityid` int unsigned NOT NULL,`commodityname` varchar(45) NOT NULL,`number` int unsigned NOT NULL,`money` double NOT NULL,`returnTime` datetime NOT NULL,`operator` varchar(45) NOT NULL,PRIMARY KEY (`Rsaleid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建provider表*/DROP TABLE IF EXISTS `provider`;CREATE TABLE `provider` (`providernumber` int(11) NOT NULL auto_increment, `phone` varchar(20) NOT NULL,`provideraddress` varchar(60) NOT NULL,`providername` varchar(40) NOT NULL, PRIMARY KEY (`providernumber`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*创建stroge表*/DROP TABLE IF EXISTS `storage`;CREATE TABLE `storage` (`storageid` int unsigned NOT NULL auto_increment, `commodityname` varchar(45) NOT NULL,`commodityid` int unsigned NOT NULL,`unit` varchar(45) NOT NULL,`price` float NOT NULL,`indate` datetime NOT NULL,`provider` varchar(45) NOT NULL,`operators` varchar(45) NOT NULL,`number` int unsigned NOT NULL,PRIMARY KEY (`storageid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8/*创建storageinfo表*/DROP TABLE IF EXISTS `storageinfo`;CREATE TABLE `storageinfo` (`commoditynumber` int unsigned NOT NULL,`accountid` int unsigned NOT NULL,`amount` int unsigned NOT NULL,`storageid` int unsigned NOT NULL auto_increment, `money` double NOT NULL,PRIMARY KEY (`storageid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;3.4详细设计(1)数据库与Eclipse的连接package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Statement;/**** @author Administrator*/public class Connectdatabase {protected static String dbClassName = "com.mysql.jdbc.Driver";protected static String dburl="jdbc:mysql://127.0.0.1:3306/limitedmarket?user=root&password=123";static Connection con = null;static Statement stmt = null;p ublic static Connection getConnection() throws Exception{Class.forName(dbClassName);con = DriverManager.getConnection(dburl);return con;}public static Statement getStatement() throws Exception{Class.forName(dbClassName);con = DriverManager.getConnection(dburl);stmt = con.createStatement();return stmt;}}(2)主要代码stmt = con.createStatement();/*statement对象静态执行查询sql语句*/public Dao(){}public static ResultSet findForResultset(String sql){ResultSet rs = null;Statement smt;try {smt = Connectdatabase.getStatement();rs = smt.executeQuery(sql);System.out.print("sql语句已经执行！");} catch (Exception ex) {Logger.getLogger(Dao.class.getName()).log(Level.SEVERE, null, ex);}return rs;}/*statement对象静态执行插入、删除、更新sql语句*/public static int update(String sql){int result = 0;try {Statement smt = Connectdatabase.getStatement();result = smt.executeUpdate(sql);} catch (Exception ex) {Logger.getLogger(Dao.class.getName()).log(Level.SEVERE, null, ex);}return result;}/*指定参数的查询sql语句,动态*/public static ResultSet query(String querystr){ResultSet set = findForResultset(querystr);return set;}/*执行查询的sql语句*/public static int delete(String sql){return update(sql);}/*插入查询语句*/public static boolean insert(String sql) {boolean result = true;try {Statement stmt = Connectdatabase.getStatement();result = stmt.execute(sql);} catch (Exception e) {e.printStackTrace();}return result;}public static List findForList(String sql) {List<List> list = new ArrayList<List>();ResultSet rs = findForResultset(sql);try {ResultSetMetaData metaData = rs.getMetaData();int colCount = metaData.getColumnCount();while (rs.next()) {List<String> row = new ArrayList<String>();for (int i = 1; i <= colCount; i++) {String str = rs.getString(i);if (str != null && !str.isEmpty())str = str.trim();row.add(str);}list.add(row);}} catch (Exception e) {e.printStackTrace();}return list;}//用户登录方法public static Account getUser(String username,String password) {Account account = new Account();ResultSet rs = findForResultset("select * from account where accountName = '" +username+"'");try {if (rs.next()) {account.setAccountName(username);account.setAccountPassword(rs.getString("accountPassword").trim());if (account.getAccountPassword().equals(password)) {account.setAccountName(rs.getString("accountName").trim());account.setAccountState(Integer.parseInt(rs.getString("accountstate")));account.setAccountType(Integer.parseInt(rs.getString("accounttype")));account.setManagerId(Integer.parseInt(rs.getString("managerid")));account.setAccountNumber(Integer.parseInt(rs.getString("accountnumber")));} else {account.setAccountName("null");account.setAccountPassword("null");}}} catch (Exception e) {e.printStackTrace();}return account;}// 获取用户对象的方法p ublic static Account getUser(Item item) {String where = "AccountName='" + item.getName() + "'";// if (item.getId() != null)// where = "name='" + item.getId() + "'";ResultSet rs = findForResultset("select * from account where " + where);Account account = new Account();try {if (rs.next()) {account.setAccountName(rs.getString("AccountName").trim());account.setAccountPassword(rs.getString("AccountPassword").trim());account.setAccountState(Integer.parseInt(rs.getString("AccountState").trim()));account.setAccountType(Integer.parseInt(rs.getString("AccountType").trim()));}} catch (SQLException e) {e.printStackTrace();}return account;}/*通过存储过程添加商品*/public static boolean addcommodity(Commodity com){boolean flag = true;if(com==null){return true;}try{conn = Connectdatabase.getConnection();CallableStatement callstm = conn.prepareCall("{call insertcommodity(?,?,?,?,?,?,?,?,?)}");callstm.setInt(1, com.getProvidernumber());callstm.setString(2, com.getCommodityName());callstm.setFloat(3, com.getInPrice());callstm.setFloat(4, com.getSalePrice());callstm.setInt(5, com.getStorageTime());callstm.setInt(6, com.getDownlimit());callstm.setString(7, com.getUnit());callstm.setString(8, com.getInDate());callstm.setString(9, com.getProcudeDate());callstm.execute();}catch(Exception e){flag = true;}flag = false;return flag;}// 读取商品信息p ublic static Commodity getSpInfo(Item item) {String where = "commodityname='" + item.getName() + "'";if (item.getId() != null)where = "commodityID='" + item.getId() + "'";ResultSet rs = findForResultset("select * from commodity where "+ where);Commodity spInfo = new Commodity();try {if (rs.next()) {spInfo.setCommodityId(Integer.parseInt(rs.getString(1)));spInfo.setCommodityName(rs.getString(3));spInfo.setProvidernumber(Integer.parseInt(rs.getString(2)));spInfo.setInDate(rs.getString(4));spInfo.setProcudeDate(rs.getString(5));spInfo.setInPrice(Float.parseFloat(rs.getString(6)));spInfo.setSalePrice(Float.parseFloat(rs.getString(7)));spInfo.setStorageTime(Integer.parseInt(rs.getString(8)));spInfo.setDownlimit(Integer.parseInt(rs.getString(9)));spInfo.setUnit(rs.getString(10));}} catch (SQLException e) {e.printStackTrace();}return spInfo;}//修改商品信息// 获取所有商品信息p ublic static List getSpInfos() {List list = findForList("select * from commodity");return list;}p ublic static List getComInfo(int id) {List list = findForList("select * from commodity where CommodityID='"+ id + "'");return list;}/*添加供应商信息*/public static int updatecommodity(Commodity com){int flag = 1;try{conn = Connectdatabase.getConnection();CallableStatement st = conn.prepareCall("{call updatecommodity(?,?,?,?,?,?,?,?,?,?)}");st.setInt(1, com.getProvidernumber());st.setString(2, com.getCommodityName());st.setFloat(3, com.getInPrice());st.setFloat(4, com.getSalePrice());st.setInt(5, com.getStorageTime());st.setInt(6, com.getDownlimit());st.setString(7, com.getUnit());st.setString(8, com.getInDate());st.setString(9, com.getProcudeDate());st.setInt(10, com.getCommodityId());st.execute();}catch(Exception e){flag = 0;}return flag;}public static boolean addProvider(Provider pro){boolean flag = true;if(pro == null){return false;}return insert("insert into provider (providername, provideraddress, phone) values('"+ pro.getProviderName()+ "','"+ pro.getProviderAddress()+ "','"+ pro.getPhone() + "')");}// 读取所有供应商信息p ublic static List getGysInfos() {List list = findForList("select * from provider");return list;}// 读取指定供应商信息p ublic static Provider getGysInfo(Item item) {String where = "providername='" + item.getName() + "'";if (item.getId() != null)where = "providernumber='" + item.getId() + "'";Provider p = new Provider();ResultSet set = findForResultset("select * from provider where "+ where);try {if (set.next()) {p.setProviderNumber(Integer.parseInt(set.getString(1)));p.setProviderAddress(set.getString(3));p.setPhone(set.getString(2));p.setProviderName(set.getString(4));}} catch (SQLException e) {e.printStackTrace();}return p;}// 修改供应商信息的方法p ublic static int updateGys(Provider p) {return update("update provider set providername = '"+ p.getProviderName() + "', provideraddress='"+ p.getProviderAddress() + "',phone='" + p.getPhone()+ "'where providernumber ='" + p.getProviderNumber() + "'");}//将商品信息入库public static boolean RuKuInfo(StorageInfo s){try{conn = Connectdatabase.getConnection();CallableStatement csmt = conn.prepareCall("{call ruku(?,?,?,?,?,?,?,?)}");csmt.setString(1, s.getCommodityname());csmt.setInt(2, s.getCommodityid());csmt.setString(3, s.getUnit());csmt.setFloat(4, s.getPrice());csmt.setString(5, s.getIndate());csmt.setString(6, s.getProvider());csmt.setString(7, s.getOperator());csmt.setInt(8, s.getNumber());csmt.execute();}catch(Exception e){e.printStackTrace();}return false;}//库存信息public static boolean RuKu(Storage s) {@SuppressWarnings("unused")int total, num;boolean flag = true;try {conn = Connectdatabase.getConnection();CallableStatement csmt = conn.prepareCall("{call storageQuery(?)}");csmt.setInt(1, s.getCommoditynumber());ResultSet rs = csmt.executeQuery();if (rs.next()) {num = Integer.parseInt(rs.getString(3));num = num + s.getAmount();csmt = conn.prepareCall("{call storageupdate(?,?)}");csmt.setInt(1, num);csmt.setInt(2, s.getCommoditynumber());csmt.execute();flag = false;} else {csmt = conn.prepareCall("{call insertstorageinfo(?,?,?,?)}");csmt.setInt(2, s.getAccountid());csmt.setInt(1, s.getCommoditynumber());csmt.setInt(3, s.getAmount());csmt.setDouble(4, s.getMoney());csmt.execute();flag = false;}} catch (Exception e) {}return flag;}}四、系统总结总体来说，本次项目在规定期间顺利完成。