"基于 JAVA 的 B/S 仓库管理系统设计与实现"

版权申诉
0 下载量 128 浏览量 更新于2024-02-25 收藏 1.34MB PDF 举报
The storage management system designed and implemented in this project is based on the B/S architecture using JAVA technology. The system aims to provide efficient and secure warehouse operations management by incorporating modules for inventory management, warehouse location information management, and inbound and outbound management. The development tools utilized include JAVA, JSP, JavaScript, and HTML languages, with Tomcat server technology employed and SQL Server 2000 selected as the backend database. This warehouse management system offers a simple yet effective solution for businesses to streamline their warehouse operations. It facilitates processes such as product registration, inbound and outbound handling, and inventory management, ensuring that warehouses are well-organized and contribute to the overall health and growth of the enterprise. The system's user-friendly interface and functionalities make it easy for users to perform these tasks, ultimately enhancing the efficiency and security of warehouse management. Overall, this project successfully demonstrates the advantages of utilizing JAVA technology and the B/S architecture in developing a warehouse management system. By implementing this system, businesses can enhance their warehouse operations, improve productivity, and create a conducive environment for sustainable growth. The key features of the system, including JSP, JAVA, SQL Server 2000 database, and B/S architecture, make it a valuable asset for businesses seeking to optimize their warehouse management processes.

SELECT bs.sample_id, bs.item_id, bs.report_id, bs.order_no, bs.order_id, bs.order_business_type, bs.commission_date, bs.customer_name, bs.applicant, bs.phone, bs.receive_user_name, bs.contract_no, bs.special_requirements, bs.report_org_name, bs.report_org_address, bs.sample_name, bs.standard_instrument_name, bs.complete_day, bs.sample_remark AS remark, bs.standard_instrument_id, bs.sample_no, bs.factory_number, bs.item_name, /*bs.item_quantity,*/ bs.inspection_type, bs.mandatory_flag, bs.test_quantity, bs.sample_state, bs.current_site, bs.plan_complete_date, bs.affix, bs.ranges, bs.grade, bs.factory, bs.calibrat_point, bs.apply_dept, bs.specification, bs.final_fee, bs.service_type, CASE WHEN bs.actual_complete_date IS NOT NULL THEN DATEDIFF( bs.plan_complete_date, bs.actual_complete_date ) ELSE datediff( bs.plan_complete_date, now()) END AS surplus_days, bs.report_no, bs.is_report_back, bs.back_reason AS report_back_reason, bs.is_just_certificate, bs.report_state, bs.temper, bs.humidity, bs.test_result, bs.test_date, bs.next_test_date, bs.test_cycle, bs.test_address, bs.generate_time, bs.point_report_id, bs.is_merge, bs.circulation_flag, bs.item_proposal_fee AS proposal_fee, bs.change_price_reason, bs.test_user_name, bs.group_id, bs.group_name, bs.charging_num, bs.other_fee, bs.receivable_fee, bs.affix_quantity, bs.test_org, bs.out_org_order_no, bs.out_org_sample_no, bs.business_user_name, bs.pdf_path, bs.settlement_state, bs.result_describe, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 根据bs.commission_date 进行排序最近的排上面 bs.commission_date

2023-07-15 上传