库名：SuperMarket
商品表名：Merchandise
说明： 字段： 类型： 长度： 备注：
序号---------------------SequenceNumber int 4 标识列
商品编码-----------------MerchandiseNumber varchar 20 例：食品类别：SP000001
条型码-------------------TreatyCode varchar 20 例：tx321SP000001
类别编号-----------------SortNumber char 10 外键
商品名称-----------------MerchandiseName varchar 50
零售价（元）-------------RetailPrice money 8
商品规格-----------------MerchandiseSpec varchar 50 允许空
计量单位-----------------Units varchar 20
进货价-------------------PurchasePrice money 8
保质期（天）-------------CheckTerm numeric 9 允许空
备注---------------------Remark varchar 50 允许空
----------------------------------------------------------------------------------------------------------------------
商品表的子表
类别表名：Merchandise
说明： 字段： 类型： 长度： 备注：
序号---------------------SortID int 4 标识列
类别编号-----------------SortNumber char 10 例：食品类：SP0001
类别名-------------------SortName varchar 20
生鲜类：SX1001
食品类：SP1002
蔬果类：SG1003
电器类：DQ1004
日用类：RY1005
礼品类：LP1006
------------------------------------------------------------------------------------------------------------------------
用户表名：UserManger
说明： 字段： 类型： 长度： 备注：
用户名-------------------UserName varchar 20 主键
密码---------------------Password varchar 20
用户等级-----------------UserGrade varchar 20
Java 项目-java进销存管理系统（jsp+mssql）.zip （163个子文件） 
MainFrame.class 17KB Vendition_dialog.class 12KB JoinAndExceed.class 11KB Put_Out_Depot.class 10KB Select_Means.class 10KB Earning.class 10KB Stock_Dialog.class 9KB AddMerchandise.class 9KB Dialog_enroll.class 9KB PaymentList.class 8KB Insert_stock.class 7KB Select_card.class 6KB Put_outdepot.class 5KB Admin.class 4KB Adminstrator.class 4KB MainFrame_AboutBox.class 4KB UpdateData.class 3KB Guayuqwomen.class 3KB SelectEarning.class 2KB Settle_Dialog.class 2KB Dialog_enroll_MySQL.class 2KB PayFor.class 2KB Put_SQL.class 2KB Put_Out_Depot_SQL.class 1KB DelData.class 1KB Dialog_enroll_SQL.class 1KB GetTime.class 1KB MyApp.class 1KB DBAccess.class 1016B MyApp$1.class 985B Dialog_enroll$Dialog_enroll_jButton1_actionAdapter.class 900B Dialog_enroll$Dialog_enroll_jButton2_actionAdapter.class 900B Dialog_enroll$Dialog_enroll_jButton4_actionAdapter.class 900B Vendition_dialog$RemindTask.class 788B Dialog_enroll$RemindTask.class 781B Put_Out_Depot$RemindTask.class 781B JoinAndExceed$RemindTask.class 781B Stock_Dialog$RemindTask.class 775B PaymentList$RemindTask.class 769B Vendition_dialog_jButton1_actionAdapter.class 757B Vendition_dialog_jButton3_actionAdapter.class 757B Vendition_dialog_jButton2_actionAdapter.class 757B AddMerchandise_jButton2_actionAdapter.class 745B AddMerchandise_jButton4_actionAdapter.class 745B AddMerchandise_jButton1_actionAdapter.class 745B AddMerchandise_jButton3_actionAdapter.class 745B Put_Out_Depot_jButton3_actionAdapter.class 739B JoinAndExceed_jButton1_actionAdapter.class 739B Put_Out_Depot_jButton2_actionAdapter.class 739B JoinAndExceed_jButton5_actionAdapter.class 739B Put_Out_Depot_jButton1_actionAdapter.class 739B Dialog_enroll_jButton5_actionAdapter.class 739B JoinAndExceed_jButton2_actionAdapter.class 739B Put_Out_Depot_jButton4_actionAdapter.class 739B Dialog_enroll_jButton3_actionAdapter.class 739B JoinAndExceed_jButton4_actionAdapter.class 739B JoinAndExceed_jButton3_actionAdapter.class 739B PaymentList_jButton2_actionAdapter.class 737B PaymentList_jButton3_actionAdapter.class 737B Stock_Dialog_jButton5_actionAdapter.class 733B Stock_Dialog_jButton3_actionAdapter.class 733B Stock_Dialog_jButton4_actionAdapter.class 733B Stock_Dialog_jButton1_actionAdapter.class 733B Stock_Dialog_jButton2_actionAdapter.class 733B Adminstrator_jButton2_actionAdapter.class 733B Adminstrator_jButton1_actionAdapter.class 733B Select_card_jButton5_actionAdapter.class 727B PaymentList_jButton1_actionAdapter.class 727B PaymentList_jButton4_actionAdapter.class 727B Select_card_jButton2_actionAdapter.class 727B Vendition_dialog_jTextField6_focusAdapter.class 724B Vendition_dialog_jTextField1_focusAdapter.class 724B Vendition_dialog_jTextField2_keyAdapter.class 718B Vendition_dialog_jTextField5_keyAdapter.class 718B MainFrame_jTree1_treeSelectionAdapter.class 712B MainFrame_jMenuHelpAbout_ActionAdapter.class 708B JoinAndExceed_jTextField2_focusAdapter.class 706B Put_Out_Depot_jTextField2_focusAdapter.class 706B Earning_jButton1_actionAdapter.class 703B Stock_Dialog_jTextField4_focusAdapter.class 700B Stock_Dialog_jTextField1_focusAdapter.class 700B Admin_jButton1_actionAdapter.class 691B Admin_jButton2_actionAdapter.class 691B MainFrame_jMenuItem18_actionAdapter.class 689B MainFrame_jMenuItem23_actionAdapter.class 689B MainFrame_jMenuItem20_actionAdapter.class 689B MainFrame_jMenuItem15_actionAdapter.class 689B MainFrame_jMenuItem17_actionAdapter.class 689B MainFrame_jMenuItem16_actionAdapter.class 689B MainFrame_jMenuItem19_actionAdapter.class 689B MainFrame_jMenuItem21_actionAdapter.class 689B MainFrame_jMenuItem22_actionAdapter.class 689B MainFrame_jMenuItem25_actionAdapter.class 689B MainFrame_jMenuItem24_actionAdapter.class 689B MainFrame_jMenuItem10_actionAdapter.class 689B MainFrame_jMenuItem11_actionAdapter.class 689B MainFrame_jMenuItem1_actionAdapter.class 686B MainFrame_jMenuItem7_actionAdapter.class 686B MainFrame_jMenuItem9_actionAdapter.class 686B MainFrame_jMenuItem3_actionAdapter.class 686B共 163 条
- 1
- 2
资源评论
计算机徐师兄
- 粉丝: 20
- 资源: 1722
