基于springboot开发的国际物流管理系统，阿里巴巴Java编程笔试题
2021/9/10 17:06:57
本文主要是介绍基于springboot开发的国际物流管理系统，阿里巴巴Java编程笔试题，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
– Records of customerbillclear
– Table structure for customerinfo
DROP TABLE IF EXISTS customerinfo;
CREATE TABLE customerinfo (
customer_code varchar(50) NOT NULL,
address varchar(50) DEFAULT NULL,
customer varchar(50) DEFAULT NULL,
customer_type varchar(50) DEFAULT NULL,
email varchar(50) DEFAULT NULL,
enterprise_property varchar(50) DEFAULT NULL,
enterprise_size varchar(50) DEFAULT NULL,
fax varchar(50) DEFAULT NULL,
linkman varchar(50) DEFAULT NULL,
linkman_mobile varchar(50) DEFAULT NULL,
phone varchar(50) DEFAULT NULL,
post_code varchar(50) DEFAULT NULL,
PRIMARY KEY (customer_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of customerinfo
– Table structure for customerreceiptinfo
DROP TABLE IF EXISTS customerreceiptinfo;
CREATE TABLE customerreceiptinfo (
id int(11) NOT NULL AUTO_INCREMENT,
carry_bill_event_id int(11) NOT NULL,
check_goods_record varchar(50) DEFAULT NULL,
customer varchar(50) DEFAULT NULL,
goods_bill_code varchar(50) DEFAULT NULL,
receive_goods_date date DEFAULT NULL,
receive_goods_person varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of customerreceiptinfo
– Table structure for driveramount
DROP TABLE IF EXISTS driveramount;
CREATE TABLE driveramount (
driver_code varchar(50) NOT NULL,
add_carriage_total double NOT NULL,
carry_fee_total double NOT NULL,
total double NOT NULL,
PRIMARY KEY (driver_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driveramount
– Table structure for driverclear
DROP TABLE IF EXISTS driverclear;
CREATE TABLE driverclear (
back_bill_code varchar(50) NOT NULL,
add_carriage double DEFAULT NULL,
balance double DEFAULT NULL,
balance_time date DEFAULT NULL,
balance_type varchar(50) DEFAULT NULL,
bind_insurance double DEFAULT NULL,
carry_fee double DEFAULT NULL,
dispatch_service_fee double DEFAULT NULL,
driver_code varchar(50) DEFAULT NULL,
insurance double DEFAULT NULL,
need_payment double DEFAULT NULL,
payed_money double DEFAULT NULL,
prepay_money double DEFAULT NULL,
PRIMARY KEY (back_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driverclear
– Table structure for driverinfo
DROP TABLE IF EXISTS driverinfo;
CREATE TABLE driverinfo (
id varchar(50) NOT NULL,
address varchar(50) DEFAULT NULL,
allow_carry_volume double DEFAULT NULL,
allow_carry_weight double DEFAULT NULL,
birthday date DEFAULT NULL,
biz_licence varchar(50) DEFAULT NULL,
car_dept varchar(50) DEFAULT NULL,
car_dept_tel varchar(50) DEFAULT NULL,
car_frame_no varchar(50) DEFAULT NULL,
car_length varchar(50) DEFAULT NULL,
car_no varchar(50) DEFAULT NULL,
car_type varchar(50) DEFAULT NULL,
car_width varchar(50) DEFAULT NULL,
company_car bit(1) NOT NULL,
drive_licence varchar(50) DEFAULT NULL,
driver_name varchar(50) DEFAULT NULL,
engine_no varchar(50) DEFAULT NULL,
gender varchar(50) DEFAULT NULL,
goods_height varchar(50) DEFAULT NULL,
id_card varchar(50) DEFAULT NULL,
insurance_card varchar(50) DEFAULT NULL,
phone varchar(50) DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
run_licence varchar(50) DEFAULT NULL,
state varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of driverinfo
– Table structure for employee
DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
employee_code varchar(50) NOT NULL,
birthday date DEFAULT NULL,
department varchar(50) DEFAULT NULL,
employee_name varchar(50) DEFAULT NULL,
gender varchar(50) DEFAULT NULL,
position varchar(50) DEFAULT NULL,
PRIMARY KEY (employee_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employee
– Table structure for employeeuser
DROP TABLE IF EXISTS employeeuser;
CREATE TABLE employeeuser (
id int(11) NOT NULL AUTO_INCREMENT,
employee_id int(11) NOT NULL,
user_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employeeuser
– Table structure for employeewage
DROP TABLE IF EXISTS employeewage;
CREATE TABLE employeewage (
id int(11) NOT NULL AUTO_INCREMENT,
allowance double NOT NULL,
basic_wage double NOT NULL,
date date DEFAULT NULL,
employee varchar(50) DEFAULT NULL,
employee_code varchar(50) NOT NULL,
station_wage double NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of employeewage
– Table structure for extraclear
DROP TABLE IF EXISTS extraclear;
CREATE TABLE extraclear (
id int(11) NOT NULL AUTO_INCREMENT,
balance_date date DEFAULT NULL,
balance_money double DEFAULT NULL,
balance_type varchar(50) DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
subject_name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of extraclear
– Table structure for extraincome
DROP TABLE IF EXISTS extraincome;
CREATE TABLE extraincome (
id int(11) NOT NULL AUTO_INCREMENT,
income_month varchar(255) DEFAULT NULL,
money double NOT NULL,
name varchar(50) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of extraincome
– Table structure for financefee
DROP TABLE IF EXISTS financefee;
CREATE TABLE financefee (
id int(11) NOT NULL AUTO_INCREMENT,
fee double NOT NULL,
payout_month varchar(255) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of financefee
– Table structure for functionwithgroup
DROP TABLE IF EXISTS functionwithgroup;
CREATE TABLE functionwithgroup (
id int(11) NOT NULL AUTO_INCREMENT,
function_id int(11) NOT NULL,
group_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of functionwithgroup
INSERT INTO functionwithgroup VALUES (‘1’, ‘1’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘2’, ‘2’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘3’, ‘3’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘4’, ‘4’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘5’, ‘5’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘6’, ‘6’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘7’, ‘7’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘8’, ‘8’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘9’, ‘9’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘10’, ‘10’, ‘1’);
INSERT INTO functionwithgroup VALUES (‘11’, ‘11’, ‘1’);
– Table structure for function_
DROP TABLE IF EXISTS function_;
CREATE TABLE function_ (
id int(11) NOT NULL AUTO_INCREMENT,
page_function varchar(50) DEFAULT NULL,
page_name varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
– Records of function_
INSERT INTO function_ VALUES (‘1’, null, ‘票据管理’);
INSERT INTO function_ VALUES (‘2’, null, ‘接货管理’);
INSERT INTO function_ VALUES (‘3’, null, ‘配车管理’);
INSERT INTO function_ VALUES (‘4’, null, ‘到货管理’);
INSERT INTO function_ VALUES (‘5’, null, ‘中转管理’);
INSERT INTO function_ VALUES (‘6’, null, ‘结算管理’);
INSERT INTO function_ VALUES (‘7’, null, ‘客户服务’);
INSERT INTO function_ VALUES (‘8’, null, ‘监控分析’);
INSERT INTO function_ VALUES (‘9’, null, ‘成本核算’);
INSERT INTO function_ VALUES (‘10’, null, ‘应用管理’);
INSERT INTO function_ VALUES (‘11’, null, ‘系统管理’);
– Table structure for goodsbill
DROP TABLE IF EXISTS goodsbill;
CREATE TABLE goodsbill (
goods_bill_code varchar(50) NOT NULL,
accept_procedure_rate varchar(50) DEFAULT NULL,
accept_station varchar(100) DEFAULT NULL,
carriage double DEFAULT NULL,
carry_goods_fee double DEFAULT NULL,
employee_code varchar(50) DEFAULT NULL,
fact_deal_date date DEFAULT NULL,
fetch_goods_mode varchar(50) DEFAULT NULL,
help_accept_payment double DEFAULT NULL,
if_audit bit(1) DEFAULT NULL,
if_settle_accounts bit(1) DEFAULT NULL,
insurance double DEFAULT NULL,
money_of_change_pay double DEFAULT NULL,
pay_kickback double DEFAULT NULL,
pay_mode varchar(50) DEFAULT NULL,
predelivery_date date DEFAULT NULL,
receive_goods_addr varchar(50) DEFAULT NULL,
receive_goods_customer varchar(50) DEFAULT NULL,
receive_goods_customer_addr varchar(50) DEFAULT NULL,
receive_goods_customer_code varchar(50) DEFAULT NULL,
receive_goods_customer_tel varchar(50) DEFAULT NULL,
reduce_fund double DEFAULT NULL,
remark varchar(50) DEFAULT NULL,
send_goods_addr varchar(50) DEFAULT NULL,
send_goods_customer varchar(50) DEFAULT NULL,
send_goods_customer_addr varchar(50) DEFAULT NULL,
send_goods_customer_no varchar(50) DEFAULT NULL,
send_goods_customer_tel varchar(50) DEFAULT NULL,
send_goods_date date DEFAULT NULL,
transfer_fee double DEFAULT NULL,
transfer_station varchar(50) DEFAULT NULL,
validity bit(1) DEFAULT NULL,
write_bill_person varchar(50) DEFAULT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (goods_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsbill
– Table structure for goodsbillevent
DROP TABLE IF EXISTS goodsbillevent;
CREATE TABLE goodsbillevent (
goods_bill_id varchar(50) NOT NULL,
event_name varchar(50) NOT NULL,
occur_time datetime(6) DEFAULT NULL,
remark varchar(50) NOT NULL,
PRIMARY KEY (goods_bill_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsbillevent
– Table structure for goodsreceiptinfo
DROP TABLE IF EXISTS goodsreceiptinfo;
CREATE TABLE goodsreceiptinfo (
id int(11) NOT NULL AUTO_INCREMENT,
check_goods_record varchar(50) DEFAULT NULL,
driver_name varchar(50) DEFAULT NULL,
goods_revert_code varchar(50) DEFAULT NULL,
rceive_goods_date date DEFAULT NULL,
receive_goods_person varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of goodsreceiptinfo
– Table structure for incomemonthlytemp
DROP TABLE IF EXISTS incomemonthlytemp;
CREATE TABLE incomemonthlytemp (
id int(11) NOT NULL AUTO_INCREMENT,
biz_fee double NOT NULL,
biz_income double NOT NULL,
car_carriage double NOT NULL,
carriage_money double NOT NULL,
convey_wage double NOT NULL,
finance_fee double NOT NULL,
house_rent double NOT NULL,
income double NOT NULL,
insurance_money double NOT NULL,
manage_fee double NOT NULL,
month varchar(255) DEFAULT NULL,
office_fee double NOT NULL,
other double NOT NULL,
payout double NOT NULL,
phone_fee double NOT NULL,
profit double NOT NULL,
unbiz_income double NOT NULL,
wage double NOT NULL,
water_elec_fee double NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
– Records of incomemonthlytemp
INSERT INTO incomemonthlytemp VALUES (‘1’, ‘500’, ‘0’, ‘500’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘2018-11’, ‘0’, ‘0’, ‘500’, ‘0’, ‘-500’, ‘0’, ‘0’, ‘0’);
– Table structure for lineoverall
DROP TABLE IF EXISTS lineoverall;
CREATE TABLE lineoverall (
id int(11) NOT NULL AUTO_INCREMENT,
all_carriage_total double NOT NULL,
deal_goods_station varchar(50) DEFAULT NULL,
insurance_total double NOT NULL,
load_station varchar(50) DEFAULT NULL,
times int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of lineoverall
– Table structure for managefee
DROP TABLE IF EXISTS managefee;
CREATE TABLE managefee (
id int(11) NOT NULL AUTO_INCREMENT,
house_rent double NOT NULL,
office_fee double NOT NULL,
other_payout double NOT NULL,
payout_month varchar(255) DEFAULT NULL,
phone_fee double NOT NULL,
water_elec_fee double NOT NULL,
write_date date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of managefee
– Table structure for proxyfeeclear
DROP TABLE IF EXISTS proxyfeeclear;
CREATE TABLE proxyfeeclear (
goods_bill_code varchar(50) NOT NULL,
account_receivable double DEFAULT NULL,
balance_date date DEFAULT NULL,
commision_rate float DEFAULT NULL,
commision_receivable double DEFAULT NULL,
customer_code varchar(50) DEFAULT NULL,
fact_receive_fund double DEFAULT NULL,
goods_pay_change double DEFAULT NULL,
received_commision double DEFAULT NULL,
PRIMARY KEY (goods_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of proxyfeeclear
– Table structure for region
DROP TABLE IF EXISTS region;
CREATE TABLE region (
id int(11) NOT NULL AUTO_INCREMENT,
city varchar(50) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
– Records of region
最后
光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的增加文章的篇幅，减少文章的可读性
**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](
)**
Java面试宝典2021版
最常见Java面试题解析（2021最新版）
2021企业Java面试题精选
本文已被CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】收录，自学编程路线及系列技术文章等资源持续更新中…
ay_change` double DEFAULT NULL,
received_commision double DEFAULT NULL,
PRIMARY KEY (goods_bill_code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of proxyfeeclear
– Table structure for region
DROP TABLE IF EXISTS region;
CREATE TABLE region (
id int(11) NOT NULL AUTO_INCREMENT,
city varchar(50) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
– Records of region
最后
光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的增加文章的篇幅，减少文章的可读性
**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](
)**
Java面试宝典2021版
[外链图片转存中…(img-jY2CIwIA-1631260714405)]
[外链图片转存中…(img-TA1kwJM1-1631260714407)]
最常见Java面试题解析（2021最新版）
[外链图片转存中…(img-SdZsHYis-1631260714409)]
[外链图片转存中…(img-hoAbXPBv-1631260714410)]
2021企业Java面试题精选
[外链图片转存中…(img-wKvf88p0-1631260714411)]
[外链图片转存中…(img-FAcChw3G-1631260714413)]
本文已被CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+真实项目实战+最新讲解视频】收录，自学编程路线及系列技术文章等资源持续更新中…
这篇关于基于springboot开发的国际物流管理系统，阿里巴巴Java编程笔试题的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-06-26结对编程到底难不难？答案在这里
- 2024-06-19《2023版Java工程师》课程升级公告
- 2024-06-15matplotlib作图不显示3D图，怎么办？
- 2024-06-1503-Loki 日志监控
- 2024-06-1504-让LLM理解知识 -Prompt
- 2024-06-05做软件测试需要懂代码吗？
- 2024-06-0514-ShardingSphere的分布式主键实现
- 2024-06-03为什么以及如何要进行架构设计权衡？
- 2024-05-31全网首发第二弹！软考2024年5月《软件设计师》真题+解析+答案！（11-20题）
- 2024-05-31全网首发！软考2024年5月《软件设计师》真题+解析+答案！（21-30题）
