当前位置： 首页 > news >正文

达梦8-达梦数据的示例用户和表

news 来源：原创 2025/6/18 7:21:04

1、示例库说明：

创建达梦数据的示例用户和表，导入测试数据。

在完成达梦数据库的安装之后，在/opt/dmdbms/samples/instance_script目录下有用于创建示例用户的SQL文件。samples目录前的路径根据实际安装情况进行修改，本文将达梦数据库软件安装到了/opt/dmdbms目录下。

 在/opt/dmdbms/samples/instance_script目录下有两个示例库bookshop和dmhr。 

示例库 BOOKSHOP 模拟武汉代理图书的某销售公司，该公司欲建立在线购物平台来拓展其代理产品的销售渠道，该在线购物平台支持网上产品信息浏览、订购等服务(仅限同城内销售及送货)。该销售公司的雇员、部门信息、业务方案等是所有实例的基础。

示例库DMHR模拟武汉达梦数据库有限公司人力资源管理系统，该示例库创建一个模式DMHR和一个表空间DMHR，在DMHR模式下创建REGION、CITY、LOCATION、DEPARTMENT、JOB、EMPLOYEE、JOB_HISTORY等7张表，并插入数据。

在相应的示例库目录内有对应的执行sql脚本，可以直接在disql内按顺序运行即可创建和插入数据。但在这之前需要了解当前数据库的字符集。

SELECT '字符集',CASE SF_GET_UNICODE_FLAG() WHEN '0' THEN 'GBK18030' WHEN '1' then 'UTF-8' when '2' then 'EUC-KR' end

根据数据库的字符集进入相应的目录。执行相应的脚本。

进入disql交互界面，执行脚本。使用[start]命令。

使用绝对路径

start /opt/dmdbms/samples/instance_script/bookshop/UTF-8/1-CREATESCHEMA.sql

如果不想输出信息，执行一下命令：

--不显示执行的SQL
set echo off
--不显示执行脚本影响的行数
set feedback off
--不每个 SQL 语句花费的执行时间
set timing off 
--不显示标题
set heading off
--不显示行号
set lineshow off

2、示例库脚本-bookshop

该示例库包含脚本：

1-CREATESCHEMA.sql
2-CREATETABLE.sql
3-INSERTSQL.sql

2.1-CREATESCHEMA.sql

--创建表空间
CREATE TABLESPACE BOOKSHOP DATAFILE 'BOOKSHOP.DBF' size 150;
/--创建模式
CREATE SCHEMA RESOURCES;
/
CREATE SCHEMA PERSON;
/
CREATE SCHEMA SALES;
/
CREATE SCHEMA PRODUCTION;
/
CREATE SCHEMA PURCHASING;
/
CREATE SCHEMA OTHER;
/

2.2-CREATETABLE.sql

--创建表
--CREATE PERSON.ADDRESS
create table PERSON.ADDRESS
(ADDRESSID INT IDENTITY(1,1) PRIMARY KEY,ADDRESS1 VARCHAR(60) NOT NULL,ADDRESS2 VARCHAR(60),CITY VARCHAR(30) NOT NULL,POSTALCODE VARCHAR(15) NOT NULL
) STORAGE (on BOOKSHOP);--CREATE PERSON.ADDRESS_TYPE
create table PERSON.ADDRESS_TYPE
(ADDRESS_TYPEID INT IDENTITY(1,1) PRIMARY KEY,NAME VARCHAR(50) NOT NULL
) STORAGE (on BOOKSHOP);--CREATE PERSON.PERSON
CREATE TABLE PERSON.PERSON
(PERSONID  INT IDENTITY(1,1) CLUSTER PRIMARY KEY,SEX CHAR(1) NOT NULL,NAME VARCHAR(50) NOT NULL,EMAIL VARCHAR(50),PHONE VARCHAR(25)
) STORAGE (on BOOKSHOP);--create PERSON.PERSON_TYPE
create table PERSON.PERSON_TYPE
(PERSON_TYPEID INT IDENTITY(1,1) PRIMARY KEY,NAME VARCHAR(256) NOT NULL
) STORAGE (on BOOKSHOP);--create RESOURCES.DEPARTMENT
create table RESOURCES.DEPARTMENT
(DEPARTMENTID INT IDENTITY(1,1) PRIMARY KEY,NAME VARCHAR(50) NOT NULL
) STORAGE (on BOOKSHOP);--create RESOURCES.EMPLOYEE
create table RESOURCES.EMPLOYEE
(EMPLOYEEID INT IDENTITY(1,1) PRIMARY KEY ,NATIONALNO VARCHAR(18) NOT NULL,PERSONID INT NOT NULL REFERENCES PERSON.PERSON(PERSONID),LOGINID VARCHAR(256) NOT NULL,TITLE VARCHAR(50) NOT NULL,MANAGERID INT,BIRTHDATE DATE NOT NULL,MARITALSTATUS CHAR(1) NOT NULL,PHOTO IMAGE,HAIRDATE DATE NOT NULL,SALARY DEC(19,4) NOT NULL
) STORAGE (on BOOKSHOP);--create RESOURCES.EMPLOYEE_ADDRESS
create table RESOURCES.EMPLOYEE_ADDRESS
(ADDRESSID INT NOT NULL REFERENCES PERSON.ADDRESS(ADDRESSID),EMPLOYEEID INT NOT NULL REFERENCES RESOURCES.EMPLOYEE(EMPLOYEEID)
) STORAGE (on BOOKSHOP);--create RESOURCES.EMPLOYEE_DEPARTMENT
create table RESOURCES.EMPLOYEE_DEPARTMENT
(EMPLOYEEID INT NOT NULL REFERENCES RESOURCES.EMPLOYEE(EMPLOYEEID),DEPARTMENTID INT NOT NULL REFERENCES RESOURCES.DEPARTMENT(DEPARTMENTID),STARTDATE DATE NOT NULL,ENDDATE DATE
) STORAGE (on BOOKSHOP);--create SALES.CUSTOMER
create table SALES.CUSTOMER
(CUSTOMERID INT IDENTITY(1,1) PRIMARY KEY,PERSONID INT NOT NULL REFERENCES PERSON.PERSON(PERSONID)
) STORAGE (on BOOKSHOP);--create SALES.CUSTOMER_ADDRESS
create table SALES.CUSTOMER_ADDRESS
(CUSTOMERID INT REFERENCES SALES.CUSTOMER(CUSTOMERID),ADDRESSID INT REFERENCES PERSON.ADDRESS(ADDRESSID),ADDRESS_TYPEID INT NOT NULL REFERENCES PERSON.ADDRESS_TYPE(ADDRESS_TYPEID),primary key (CUSTOMERID,ADDRESSID)
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT_CATEGORY
create table PRODUCTION.PRODUCT_CATEGORY
(PRODUCT_CATEGORYID INT IDENTITY(1,1) PRIMARY KEY,NAME VARCHAR(50) NOT NULL
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT_SUBCATEGORY
create table PRODUCTION.PRODUCT_SUBCATEGORY
(PRODUCT_SUBCATEGORYID INT IDENTITY(1,1) PRIMARY KEY,PRODUCT_CATEGORYID INT NOT NULL ,NAME VARCHAR(50) NOT NULL
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT
create table PRODUCTION.PRODUCT
(PRODUCTID INT IDENTITY(1,1) PRIMARY KEY,NAME VARCHAR(100) NOT NULL,AUTHOR VARCHAR(25) NOT NULL,PUBLISHER VARCHAR(50) NOT NULL,PUBLISHTIME DATE NOT NULL,PRODUCT_SUBCATEGORYID INT NOT NULL REFERENCES PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_SUBCATEGORYID),PRODUCTNO VARCHAR(25) NOT NULL,SATETYSTOCKLEVEL SMALLINT NOT NULL,ORIGINALPRICE DEC(19,4) NOT NULL,NOWPRICE DEC(19,4) NOT NULL,DISCOUNT DECIMAL(2,1) NOT NULL,DESCRIPTION TEXT,PHOTO IMAGE,TYPE VARCHAR(5),PAPERTOTAL INT,WORDTOTAL INT,SELLSTARTTIME DATE NOT NULL,SELLENDTIME DATE,UNIQUE(PRODUCTNO)
) STORAGE (on BOOKSHOP);--create PRODUCTION.LOCATION
create table PRODUCTION.LOCATION
(LOCATIONID INT IDENTITY(1,1) PRIMARY KEY,PRODUCT_SUBCATEGORYID INT NOT NULL REFERENCES PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_SUBCATEGORYID),NAME VARCHAR(50) NOT NULL
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT_INVENTORY
create table PRODUCTION.PRODUCT_INVENTORY
(PRODUCTID INT NOT NULL REFERENCES PRODUCTION.PRODUCT(PRODUCTID),LOCATIONID INT NOT NULL REFERENCES PRODUCTION.LOCATION(LOCATIONID),QUANTITY INT NOT NULL
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT_REVIEW
create table PRODUCTION.PRODUCT_REVIEW
(PRODUCT_REVIEWID INT IDENTITY(1,1) PRIMARY KEY, PRODUCTID INT NOT NULL REFERENCES PRODUCTION.PRODUCT(PRODUCTID),NAME VARCHAR(50) NOT NULL,REVIEWDATE DATE NOT NULL,EMAIL VARCHAR(50) NOT NULL,RATING INT NOT NULL CHECK(RATING IN(1,2,3,4,5)),COMMENTS TEXT
) STORAGE (on BOOKSHOP);--create PURCHASING.VENDOR
create table PURCHASING.VENDOR
(VENDORID INT IDENTITY(1,1) PRIMARY KEY,ACCOUNTNO VARCHAR(15) NOT NULL,NAME VARCHAR(50) NOT NULL,ACTIVEFLAG BIT NOT NULL,WEBURL VARCHAR(1024),CREDIT INT NOT NULL CHECK(CREDIT IN(1,2,3,4,5))
) STORAGE (on BOOKSHOP);--create PURCHASING.VENDOR_ADDRESS
create table PURCHASING.VENDOR_ADDRESS
(VENDORID INT NOT NULL REFERENCES PURCHASING.VENDOR(VENDORID),ADDRESSID INT NOT NULL REFERENCES PERSON.ADDRESS(ADDRESSID),ADDRESS_TYPEID INT NOT NULL REFERENCES PERSON.ADDRESS_TYPE(ADDRESS_TYPEID),primary key (VENDORID,ADDRESSID)
) STORAGE (on BOOKSHOP);--create PURCHASING.VENDOR_PERSON
create table PURCHASING.VENDOR_PERSON
(VENDORID INT NOT NULL REFERENCES PURCHASING.VENDOR(VENDORID), PERSONID INT NOT NULL REFERENCES PERSON.PERSON(PERSONID),PERSON_TYPEID INT NOT NULL REFERENCES PERSON.PERSON_TYPE(PERSON_TYPEID),primary key (VENDORID,PERSONID)
) STORAGE (on BOOKSHOP);--create PRODUCTION.PRODUCT_VENDOR
create table PRODUCTION.PRODUCT_VENDOR
(PRODUCTID INT REFERENCES PRODUCTION.PRODUCT(PRODUCTID),VENDORID INT REFERENCES PURCHASING.VENDOR(VENDORID),STANDARDPRICE DEC(19,4) NOT NULL,LASTPRICE DEC(19,4),LASTDATE DATE,MINQTY INT NOT NULL,MAXQTY INT NOT NULL,ONORDERQTY INT,PRIMARY KEY(PRODUCTID,VENDORID)
) STORAGE (on BOOKSHOP);--create SALES.SALESPERSON
create table SALES.SALESPERSON
(SALESPERSONID INT IDENTITY(1,1) PRIMARY KEY,EMPLOYEEID INT NOT NULL REFERENCES RESOURCES.EMPLOYEE(EMPLOYEEID),SALESTHISYEAR DEC(19,4) NOT NULL,SALESLASTYEAR DEC(19,4) NOT NULL
) STORAGE (on BOOKSHOP);--create PURCHASING.PURCHASEORDER_HEADER
create table PURCHASING.PURCHASEORDER_HEADER
(PURCHASEORDERID INT IDENTITY(1,1) PRIMARY KEY,ORDERDATE DATE NOT NULL,STATUS TINYINT NOT NULL CHECK(STATUS IN(0,1,2,3)),EMPLOYEEID INT NOT NULL REFERENCES RESOURCES.EMPLOYEE(EMPLOYEEID),VENDORID INT NOT NULL REFERENCES PURCHASING.VENDOR(VENDORID),SHIPMETHOD VARCHAR(50) NOT NULL,SUBTOTAL DEC(19,4) NOT NULL,TAX DEC(19,4) NOT NULL,FREIGHT DEC(19,4) NOT NULL,TOTAL DEC(19,4) NOT NULL
) STORAGE (on BOOKSHOP);--create PURCHASING.PURCHASEORDER_DETAIL
create table PURCHASING.PURCHASEORDER_DETAIL
(PURCHASEORDERID INT NOT NULL REFERENCES PURCHASING.PURCHASEORDER_HEADER(PURCHASEORDERID),PURCHASEORDER_DETAILID INT NOT NULL,DUEDATE DATE NOT NULL,PRODUCTID INT NOT NULL REFERENCES PRODUCTION.PRODUCT(PRODUCTID),ORDERQTY INT NOT NULL,PRICE DEC(19,4) NOT NULL,SUBTOTAL DEC(19,4) NOT NULL,RECEIVEDQTY INT NOT NULL,REJECTEDQTY INT NOT NULL,STOCKEDQTY INT NOT NULL,PRIMARY KEY(PURCHASEORDERID,PURCHASEORDER_DETAILID)
) STORAGE (on BOOKSHOP);--create SALES.SALESORDER_HEADER
create table SALES.SALESORDER_HEADER
(SALESORDERID INT IDENTITY(1,1) PRIMARY KEY,ORDERDATE DATE NOT NULL,DUEDATE DATE NOT NULL,STATUS TINYINT NOT NULL CHECK(STATUS IN(0,1,2,3,4,5)),ONLINEORDERFLAG BIT NOT NULL,CUSTOMERID INT NOT NULL REFERENCES SALES.CUSTOMER(CUSTOMERID),SALESPERSONID INT NOT NULL REFERENCES SALES.SALESPERSON(SALESPERSONID),ADDRESSID INT NOT NULL REFERENCES PERSON.ADDRESS(ADDRESSID),SHIPMETHOD BIT NOT NULL,SUBTOTAL DEC(19,4) NOT NULL,FREIGHT DEC(19,4) NOT NULL,TOTAL DEC(19,4) NOT NULL,COMMENTS TEXT
) STORAGE (on BOOKSHOP);--create SALES.SALESORDER_DETAIL
create table SALES.SALESORDER_DETAIL
(SALESORDERID INT NOT NULL REFERENCES SALES.SALESORDER_HEADER(SALESORDERID),SALESORDER_DETAILID INT NOT NULL,CARRIERNO VARCHAR(25) NOT NULL,PRODUCTID INT NOT NULL REFERENCES PRODUCTION.PRODUCT(PRODUCTID),ORDERQTY INT NOT NULL,LINETOTAL DEC(19,4) NOT NULL,PRIMARY KEY(SALESORDERID,SALESORDER_DETAILID)
) STORAGE (on BOOKSHOP);--create OTHER.DEPARTMENT
CREATE TABLE OTHER.DEPARTMENT 
(high_dep VARCHAR(50),dep_name VARCHAR(50)
) STORAGE (on BOOKSHOP);--create OTHER.EMPSALARY
CREATE TABLE OTHER.EMPSALARY
(ename char(10), empno numeric(4), sal numeric(4)
) STORAGE (on BOOKSHOP);--create OTHER.ACCOUNT
CREATE TABLE OTHER.ACCOUNT
("ACCOUNT_ID" INTEGER NOT NULL,"BAL" DEC(10,2),PRIMARY KEY("ACCOUNT_ID")
) STORAGE (on BOOKSHOP);--create OTHER.ACTIONS
CREATE TABLE OTHER.ACTIONS
("ACCOUNT_ID" INTEGER NOT NULL,"OPER_TYPE" CHAR(1),"NEW_VALUE" DEC(10,2),"STATUS" VARCHAR(50),PRIMARY KEY("ACCOUNT_ID")
) STORAGE (on BOOKSHOP);--create OTHER.READER 
CREATE TABLE OTHER.READER 
(READER_ID	INT PRIMARY KEY,NAME		VARCHAR(30),AGE		SMALLINT,GENDER		CHAR,MAJOR		VARCHAR(30)
) STORAGE (on BOOKSHOP);--create OTHER.READERAUDIT 
CREATE TABLE OTHER.READERAUDIT 
(change_type	CHAR NOT NULL,changed_by	VARCHAR(8) NOT NULL,op_timestamp	DATE NOT NULL,old_reader_id	INT,old_name	VARCHAR(30),old_age		SMALLINT,old_gender	CHAR,old_major	VARCHAR(30),new_reader_id	INT,new_name	VARCHAR(30),new_age		SMALLINT,new_gender	CHAR,new_major	VARCHAR(30)
) STORAGE (on BOOKSHOP);--create OTHER.DEPTTAB 
CREATE TABLE OTHER.DEPTTAB 
(     Deptno  INT PRIMARY KEY,Dname  VARCHAR(15),Loc  VARCHAR(25)
) STORAGE (on BOOKSHOP);--create OTHER.EMPTAB 
CREATE TABLE OTHER.EMPTAB 
(Empno  INT PRIMARY KEY,Ename  VARCHAR(15) NOT NULL,Job  VARCHAR(10),Sal  FLOAT,Deptno  INT
) STORAGE (on BOOKSHOP);--create OTHER.SALGRADE 
CREATE TABLE OTHER.SALGRADE
(Losal		   FLOAT,	Hisal		   FLOAT,	Job_classification VARCHAR(10)
) STORAGE (on BOOKSHOP);--create OTHER.COMPANYHOLIDAYS 
CREATE TABLE OTHER.COMPANYHOLIDAYS
(Holiday  DATE
) STORAGE (on BOOKSHOP);

2.3-INSERTSQL.sql 

--INSERT ADDRESS
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区369号金地太阳城56-1-202','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区369号金地太阳城57-2-302','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('青山区青翠苑1号','','武汉市青山区','430080');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('武昌区武船新村115号','','武汉市武昌区','430063');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('汉阳大道熊家湾15号','','武汉市汉阳区','430050');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区保利花园50-1-304','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区保利花园51-1-702','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区关山春晓51-1-702','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('江汉区发展大道561号','','武汉市江汉区','430023');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('江汉区发展大道555号','','武汉市江汉区','430023');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('武昌区武船新村1号','','武汉市武昌区','430063');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('江汉区发展大道423号','','武汉市江汉区','430023');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区关山春晓55-1-202','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区关山春晓10-1-202','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区关山春晓11-1-202','','武汉市洪山区','430073');
INSERT INTO PERSON.ADDRESS(ADDRESS1,ADDRESS2,CITY,POSTALCODE) VALUES('洪山区光谷软件园C1_501','','武汉市洪山区','430073');--INSERT ADDRESS_TYPE
INSERT INTO PERSON.ADDRESS_TYPE(NAME) VALUES('发货地址');
INSERT INTO PERSON.ADDRESS_TYPE(NAME) VALUES('送货地址');
INSERT INTO PERSON.ADDRESS_TYPE(NAME) VALUES('家庭地址');
INSERT INTO PERSON.ADDRESS_TYPE(NAME) VALUES('公司地址');--INSERT DEPARTMENT
INSERT INTO RESOURCES.DEPARTMENT(NAME) VALUES('采购部门');
INSERT INTO RESOURCES.DEPARTMENT(NAME) VALUES('销售部门');
INSERT INTO RESOURCES.DEPARTMENT(NAME) VALUES('人力资源');
INSERT INTO RESOURCES.DEPARTMENT(NAME) VALUES('行政部门');
INSERT INTO RESOURCES.DEPARTMENT(NAME) VALUES('广告部');--INSERT PERSON
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','李丽','lily@sina.com','02788548562');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('M','王刚','','02787584562');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('M','李勇','','02782585462');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','郭艳','','02787785462');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','孙丽','','13055173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('M','黄非','','13355173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','王菲','','13255173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('M','张平','','13455173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('M','张红','','13555173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','刘佳','','13955173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','王南','','15955173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','李飞','','15954173012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','张大海','','15955673012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','王宇轩','','15955175012');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','桑泽恩','','15955173024');
INSERT INTO PERSON.PERSON(SEX,NAME,EMAIL,PHONE) VALUES('F','刘青','','15955173055');
INSERT INTO PERSON.PERSON(SEX,NAME,PHONE) VALUES('F','杨凤兰','02785584662');--INSERT PERSON_TYPE
INSERT INTO PERSON.PERSON_TYPE(NAME) VALUES('采购经理');
INSERT INTO PERSON.PERSON_TYPE(NAME) VALUES('采购代表');
INSERT INTO PERSON.PERSON_TYPE(NAME) VALUES('销售经理');
INSERT INTO PERSON.PERSON_TYPE(NAME) VALUES('销售代表');--INSERT CUSTOMER
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='刘青';
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='桑泽恩';
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='王宇轩';
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='张大海';
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='李飞';
INSERT INTO SALES.CUSTOMER(PERSONID) SELECT PERSONID FROM PERSON.PERSON WHERE NAME='王南';--INSERT  CUSTOMER_ADDRESS
INSERT INTO SALES.CUSTOMER_ADDRESS(CUSTOMERID,ADDRESSID,ADDRESS_TYPEID)
SELECT CUSTOMERID,11,2 FROM SALES.CUSTOMER;
INSERT INTO SALES.CUSTOMER_ADDRESS(CUSTOMERID,ADDRESSID,ADDRESS_TYPEID)
SELECT CUSTOMERID,12,3 FROM SALES.CUSTOMER;--INSERT EMPLOYEE
INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921197908051523',1,'L1','总经理','','1979-08-05','S','','2002-05-02',40000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198008051523',2,'L2','销售经理',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='总经理'),'1980-08-05','S','','2002-05-02', 26000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198408051523',3,'L3','采购经理',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='总经理'),'1981-08-05','S','','2002-05-02',23000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198208051523',4,'L4','销售代表',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='销售经理'),'1982-08-05','S','','2002-05-02',15000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198308051523',5,'L5','销售代表',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='销售经理'),'1983-08-05','S','','2002-05-02',16000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198408051523',6,'L6','采购代表',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='采购经理'),'1984-08-05','S','','2005-05-02',12000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921197708051523',7,'L7','人力资源部经理',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='总经理'),'1977-08-05','M','','2002-05-02',25000);INSERT INTO RESOURCES.EMPLOYEE(NATIONALNO,PERSONID,LOGINID,TITLE,MANAGERID,BIRTHDATE,MARITALSTATUS,PHOTO,HAIRDATE,SALARY)
VALUES('420921198008071523',8,'L8','系统管理员',(SELECT EMPLOYEEID FROM RESOURCES.EMPLOYEE WHERE TITLE='人力资源部经理'),'1980-08-07','S','','2004-05-02',20000);--INSERT IMPLOYEE_DEPARTMENT 
INSERT INTO RESOURCES.EMPLOYEE_DEPARTMENT(EMPLOYEEID,DEPARTMENTID,STARTDATE,ENDDATE)
SELECT EMPLOYEEID,'2','2005-02-01',null FROM RESOURCES.EMPLOYEE WHERE RESOURCES.EMPLOYEE.TITLE='销售代表' OR RESOURCES.EMPLOYEE.TITLE='销售经理';
INSERT INTO RESOURCES.EMPLOYEE_DEPARTMENT(EMPLOYEEID,DEPARTMENTID,STARTDATE,ENDDATE)
SELECT EMPLOYEEID,'1','2005-02-01',null FROM RESOURCES.EMPLOYEE WHERE RESOURCES.EMPLOYEE.TITLE='采购代表' OR RESOURCES.EMPLOYEE.TITLE='采购经理';
INSERT INTO RESOURCES.EMPLOYEE_DEPARTMENT(EMPLOYEEID,DEPARTMENTID,STARTDATE,ENDDATE)
SELECT EMPLOYEEID,'3','2005-02-01',null FROM RESOURCES.EMPLOYEE WHERE RESOURCES.EMPLOYEE.TITLE='系统管理员';
INSERT INTO RESOURCES.EMPLOYEE_DEPARTMENT(EMPLOYEEID,DEPARTMENTID,STARTDATE,ENDDATE)
SELECT EMPLOYEEID,'4','2001-02-01',null FROM RESOURCES.EMPLOYEE WHERE RESOURCES.EMPLOYEE.TITLE='总经理';--INSERT EMPLOYEE_ADDRESS
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(1,1);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(2,2);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(3,3);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(4,4);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(5,5);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(6,6);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(7,7);
INSERT INTO RESOURCES.EMPLOYEE_ADDRESS(EMPLOYEEID,ADDRESSID) VALUES(8,8);--INSERT SALES.SALESPERSON
INSERT INTO SALES.SALESPERSON(EMPLOYEEID,SALESTHISYEAR,SALESLASTYEAR)
SELECT EMPLOYEEID,8,10 FROM RESOURCES.EMPLOYEE WHERE TITLE='销售代表';--INSERT VENDOR
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','上海画报出版社','1','','2');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','长江文艺出版社','1','','2');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','北京十月文艺出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','人民邮电出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','清华大学出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','中华书局','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','广州出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','上海出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','21世纪出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','外语教学与研究出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','机械工业出版社','1','','1');
INSERT INTO PURCHASING.VENDOR(ACCOUNTNO,NAME,ACTIVEFLAG,WEBURL,CREDIT)
VALUES('00','文学出版社','1','','1');--INSERT VENDOR_ADDRESS
INSERT INTO PURCHASING.VENDOR_ADDRESS(VENDORID,ADDRESSID,ADDRESS_TYPEID)
SELECT VENDORID,9,1 FROM PURCHASING.VENDOR;
INSERT INTO PURCHASING.VENDOR_ADDRESS(VENDORID,ADDRESSID,ADDRESS_TYPEID)
SELECT VENDORID,10,4 FROM PURCHASING.VENDOR;--INSERT VENDOR_PERSON
INSERT INTO PURCHASING.VENDOR_PERSON(VENDORID,PERSONID,PERSON_TYPEID)
SELECT VENDORID,9,4 FROM PURCHASING.VENDOR;--INSERT PRODUCT_CATEGORRY
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('小说');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('文学');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('计算机');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('英语');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('管理');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('少儿');
INSERT INTO PRODUCTION.PRODUCT_CATEGORY(NAME) VALUES('金融');--INSERT PRODUCT_SUBCATEGORY
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'世界名著');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'武侠');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'科幻');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'四大名著');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'军事');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='小说'),'社会');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME) VALUES(10,'历史');INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'文集');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'纪实文学');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'文学理论');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'中国古诗词');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'中国现当代诗');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'戏剧');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='文学'),'民间文学');INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'计算机理论');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'计算机体系结构');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'操作系统');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'程序设计');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'数据库');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'软件工程');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'信息安全');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='计算机'),'多媒体');INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语词汇');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语语法');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语听力');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语口语');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语阅读');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='英语'),'英语写作');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'行政管理');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'项目管理');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'质量管理与控制');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'商业道德');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'经营管理');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='管理'),'财务管理');INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'幼儿启蒙');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'益智游戏');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'童话');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'卡通');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'励志');
INSERT INTO PRODUCTION.PRODUCT_SUBCATEGORY(PRODUCT_CATEGORYID,NAME)
VALUES((SELECT PRODUCT_CATEGORYID FROM PRODUCTION.PRODUCT_CATEGORY WHERE NAME='少儿'),'少儿英语');--INSERT PRODUCT
INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('红楼梦','曹雪芹,高鹗','中华书局','2005-4-1','9787101046120',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='四大名著'),'10','19','15.2','8.0','曹雪芹，是中国文学史上最伟大也是最复杂的作家，《红楼梦》也是中国文学史上最伟大而又最复杂的作品。《红楼梦》写的是封建贵族的青年贾宝玉、林黛王、薛宝钗之间的恋爱和婚姻悲剧，而且以此为中心，写出了当时具有代表性的贾、王、史、薛四大家族的兴衰，其中又以贾府为中心，揭露了封建社会后期的种种黑暗和罪恶，及其不可克服的内在矛盾，对腐朽的封建统治阶级和行将崩溃的封建制度作了有力的批判，使读者预感到它必然要走向覆灭的命运。本书是一部具有高度思想性和高度艺术性的伟大作品，从本书反映的思想倾向来看，作者具有初步的民主主义思想，他对现实社会包括宫廷及官场的黑暗，封建贵族阶级及其家庭的腐朽，封建的科举制度、婚姻制度、奴婢制度、等级制度，以及与此相适应的社会统治思想即孔孟之道和程朱理学、社会道德观念等等，都进行了深刻的批判并且提出了朦胧的带有初步民主主义性质的理想和主张。这些理想和主张正是当时正在滋长的资本主义经济萌芽因素的曲折反映。','','16','943','933000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('水浒传','施耐庵，罗贯中','中华书局','2005-4-1','9787101046137',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='四大名著'),'10','19','14.3','7.5','《水浒传》是宋江起义故事在民间长期流传基础上产生出来的，吸收了民间文学的营养。《水浒传》是我国人民最喜爱的古典长篇白话小说之一。它产生于明代，是在宋、元以来有关水浒的故事、话本、戏曲的基础上，由作者加工整理、创作而成的。全书以宋江领导的农民起义为主要题材，艺术地再现了中国古代人民反抗压迫、英勇斗争的悲壮画卷。作品充分暴露了封建统治阶级的腐朽和残暴，揭露了当时尖锐对立的社会矛盾和“官逼民反”的残酷现实，成功地塑造了鲁智深、李逵、武松、林冲、阮小七等一批英雄人物。小说故事情节曲折，语言生动，人物性格鲜明，具有高度的艺术成就。但作品歌颂、美化宋江，鼓吹“忠义”和“替天行道”，表现出严重的思想局限。','','16','922','912000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('老人与海','海明威','上海出版社','2006-8-1','9787532740093',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='世界名著'),'10','10','6.1','6.1','海明威(1899一1961)，美国著名作家、诺贝尔文学奖获得者。《老人与海》是他最具代表性的作品之一。','','16','98','67000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('射雕英雄传（全四册）','金庸 ','广州出版社','2005-12-1','9787807310822',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='武侠'),'10','32','21.7','6.8','自幼家破人亡的郭靖，随母流落蒙古大漠，这傻头傻脑但有情有义的小伙子倒也逝有福气，他不但习得了江南六怪的绝艺、全真教马钰的内功、洪七公的隆龙十八掌、双手互博之术、九阴真经等盖世武功，还让古灵精怪的小美女黄蓉这辈子跟定了他。这部原名『大漠英雄传』的小说是金庸小说中最广为普罗大众接受、传颂的一部，其中出了许多有名又奇特的人物，东邪西毒南帝北丐中神通，还有武功灵光、脑袋不灵光的老顽童周伯通，他们有特立独行的性格、作为和人生观，让人叹为观止。书中对历史多有着墨，中原武林及蒙古大漠的生活情形随着人物的生长环境变迁而有不同的叙述，异族统治之下的小老百姓心情写来丝丝入扣，本书对情的感觉是很含蓄的，尤其是郭靖与拖雷、华筝无猜的童年之谊，他与江南六怪的师生之谊等等，还有全真七子中长春子丘处机的侠义行为及其与郭杨二人风雪中的一段情谊，也有很豪气的叙述。神算子瑛姑及一灯大师和周伯通的一场孽恋，是最出乎人意料的一段，成人世界的恋情可比小儿女的青涩恋燕还复杂多了。郭靖以扭胜巧的人生经历和「为国为民，侠之大者」的儒侠风范，也是书中最大要旨。距离这本书完成的时间已有四十年了，书中的单纯诚朴的人物性格还深深的留在读者心中，本书故事也多改编成电影、电视剧等，受欢迎程度可见一斑。','','16','','1153000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('鲁迅文集（小说、散文、杂文）全两册','鲁迅','','2006-9-1','9787509000724',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='文集'),'10','39.8','20','5.0','','','16','684','680000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('长征','王树增 ','人民文学出版社','2006-9-1','9787020057986',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='纪实文学'),'10','53','37.7','6.4','','','16','683','670000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('数据结构（C语言版）（附光盘）','严蔚敏，吴伟民','清华大学出版社','2007-3-1','9787302147510',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='计算机理论'),'10','30','25.5','8.5','《数据结构》（C语言版）是为“数据结构”课程编写的教材，也可作为学习数据结构及其算法的C程序设计的参数教材。 本书的前半部分从抽象数据类型的角度讨论各种基本类型的数据结构及其应用','','8','334','493000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('工作中无小事','陈满麒','机械工业出版社','2006-1-1','9787111182252',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='行政管理'),'10','16.8','11.4','6.8','本书立足于当今企业中常见的轻视小事，做事浮躁等现象，从人性的弱点这一独特角度，挖掘出员工轻视小事的根本原因，具有深厚的人文关怀，极易引起员工的共鸣。它有助于员工端正心态，摒弃做事贪大的浮躁心理，把小事做好做到位，从而提高整个企业的工作质量。当重视小事成为员工的一种习惯，当责任感成为一种生活态度，他们将会与胜任、优秀、成功同行，责任、忠诚、敬业也将不再是一句空洞的企业宣传口号。本书是一本提升企业竞争力、建设企业文化的指导手册，一本员工素质培训的完美读本，一本所有公务员、公司职员的必读书。','','8','152','70000','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('突破英文基础词汇','刘毅','外语教学与研究出版社','2003-8-1','9787560035024',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语词汇'),'10','15.9','11.1','7.0','本书所列单词共计1300个，加上各词的衍生词、同义词及反义词，则实际收录约3000词，均为平时最常用、最容易接触到的单词。详细列出各词的国际音标、词性说明及中文解释，省却查字典的麻烦。每一课分为五个部分，以便于分段记忆。在课前有预备测验，每一部分之后有习题，课后有效果检测，可借助于重复测验来加深对单词的印象，并学习如何活用单词。','','8','350','','2006-03-20','');INSERT INTO PRODUCTION.PRODUCT(NAME,AUTHOR,PUBLISHER,PUBLISHTIME,PRODUCTNO,PRODUCT_SUBCATEGORYID,SATETYSTOCKLEVEL,ORIGINALPRICE,NOWPRICE,DISCOUNT,DESCRIPTION,PHOTO,TYPE,PAPERTOTAL,WORDTOTAL,SELLSTARTTIME,SELLENDTIME)
VALUES('噼里啪啦丛书(全7册)','（日）佐佐木洋子','21世纪出版社','1901-01-01','9787539125992',(SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='幼儿启蒙'),'10','58','42','6.1','噼里啪啦系列丛书包括：我要拉巴巴》《我去刷牙》《我要洗澡》《你好》《草莓点心》《车来了》《我喜欢游泳》共7册。 这是日本画家佐佐木洋子编绘的，分别描绘孩子在刷牙、洗澡、游玩、吃点心等各种时候所碰到的问题，以风趣的方式教会他们人生的最初的知识。书中的图形不仅夸张诱人，而且采用了一些局部折叠的方式，在书页中可以不时翻开一些折叠面，让人看到图画内部的东西，这是很符合低幼儿童的阅读心理的。','','8','','','2006-03-20','');--INSERT LOCATION
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='世界名著'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='武侠'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='科幻'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='军事'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='社会'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='文集'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='纪实文学'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='文学理论'),'库存1-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='中国古诗词'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='中国现当代诗'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='戏剧'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='民间文学'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='计算机理论'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='计算机体系结构'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='操作系统'),'库存1-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='程序设计'),'库存1-货架3');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='数据库'),'库存1-货架3');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='软件工程'),'库存1-货架3');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='信息安全'),'库存1-货架3');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='多媒体'),'库存1-货架3');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语词汇'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语语法'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语听力'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语口语'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语阅读'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='英语写作'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='行政管理'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='项目管理'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='质量管理与控制'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='商业道德'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='经营管理'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='财务管理'),'库存1-货架4');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='幼儿启蒙'),'库存2-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='益智游戏'),'库存2-货架1');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='童话'),'库存2-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='卡通'),'库存2-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='励志'),'库存2-货架2');
INSERT INTO PRODUCTION.LOCATION(PRODUCT_SUBCATEGORYID,NAME)
VALUES((SELECT PRODUCT_SUBCATEGORYID FROM PRODUCTION.PRODUCT_SUBCATEGORY WHERE NAME='少儿英语'),'库存2-货架2');--INSERT PRODUCT_INVENTORY
INSERT INTO PRODUCTION.PRODUCT_INVENTORY(PRODUCTID,LOCATIONID,QUANTITY) 
SELECT T1.PRODUCTID,T2.LOCATIONID,100 FROM PRODUCTION.PRODUCT T1,PRODUCTION.LOCATION T2 
WHERE T1.PRODUCT_SUBCATEGORYID=T2.PRODUCT_SUBCATEGORYID;--INSERT PRODUCT_REVIEW
INSERT INTO PRODUCTION.PRODUCT_REVIEW(PRODUCTID,NAME,REVIEWDATE,EMAIL,RATING,COMMENTS)
SELECT PRODUCTID,'刘青','2007-05-06','zhangping@sina.com','1','送货快' from PRODUCTION.PRODUCT;
INSERT INTO PRODUCTION.PRODUCT_REVIEW(PRODUCTID,NAME,REVIEWDATE,EMAIL,RATING,COMMENTS)
SELECT PRODUCTID,'桑泽恩','2007-05-06','zhangping@sina.com','1','服务态度好' from PRODUCTION.PRODUCT;--INSERT PRODUCT_VENDOR
INSERT INTO PRODUCTION.PRODUCT_VENDOR(PRODUCTID,VENDORID,STANDARDPRICE,LASTPRICE,LASTDATE,MINQTY,MAXQTY,ONORDERQTY)
SELECT PRODUCTID,VENDORID,25,'','','10','100','' FROM PRODUCTION.PRODUCT,PURCHASING.VENDOR WHERE PRODUCTION.PRODUCT.PUBLISHER=PURCHASING.VENDOR.NAME;--INSER SALESORDER_HEADER
INSERT INTO SALES.SALESORDER_HEADER(ORDERDATE,DUEDATE,STATUS,ONLINEORDERFLAG,CUSTOMERID,SALESPERSONID,ADDRESSID,SHIPMETHOD,SUBTOTAL,FREIGHT,TOTAL,COMMENTS)
VALUES ('2007-05-06','2007-5-07',2,1,1,2,3,0,36.9,0,36.9,'上午送到');
INSERT INTO SALES.SALESORDER_HEADER(ORDERDATE,DUEDATE,STATUS,ONLINEORDERFLAG,CUSTOMERID,SALESPERSONID,ADDRESSID,SHIPMETHOD,SUBTOTAL,FREIGHT,TOTAL,COMMENTS)
VALUES ('2007-05-07','2007-5-07',1,1,1,1,1,0,36.9,0,36.9,'上午送到');-- INSERT SALESORDER_DETAIL
INSERT INTO SALES.SALESORDER_DETAIL(SALESORDERID,SALESORDER_DETAILID,CARRIERNO,PRODUCTID,ORDERQTY,LINETOTAL)
SELECT SALESORDERID,'1','2007052',1,1,15.2 FROM SALES.SALESORDER_HEADER;
INSERT INTO SALES.SALESORDER_DETAIL(SALESORDERID,SALESORDER_DETAILID,CARRIERNO,PRODUCTID,ORDERQTY,LINETOTAL)
SELECT SALESORDERID,'2','2007053',3,1,21.7 FROM SALES.SALESORDER_HEADER;UPDATE SALES.SALESPERSON SET SALESLASTYEAR = 20.0000 WHERE SALESPERSONID = 2;INSERT INTO PURCHASING.PURCHASEORDER_HEADER(ORDERDATE,STATUS,EMPLOYEEID,VENDORID,SHIPMETHOD,SUBTOTAL,TAX,FREIGHT,TOTAL)
VALUES('2006-7-21',1,6,5,'快递',5000.00,600.00,800.00,6400.00);INSERT INTO OTHER.DEPARTMENT VALUES(NULL, '总公司');
INSERT INTO OTHER.DEPARTMENT VALUES('总公司', '服务部');
INSERT INTO OTHER.DEPARTMENT VALUES('总公司', '采购部');
INSERT INTO OTHER.DEPARTMENT VALUES('总公司', '财务部');
INSERT INTO OTHER.DEPARTMENT VALUES('服务部', '网络服务部');
INSERT INTO OTHER.DEPARTMENT VALUES('服务部', '读者服务部');
INSERT INTO OTHER.DEPARTMENT VALUES('服务部', '企业服务部');
INSERT INTO OTHER.DEPARTMENT VALUES('读者服务部', '书籍借阅服务部');
INSERT INTO OTHER.DEPARTMENT VALUES('读者服务部', '书籍阅览服务部');INSERT INTO OTHER.EMPSALARY VALUES ('KING',7839,5000);
INSERT INTO OTHER.EMPSALARY VALUES ('SCOTT',7788,3000);
INSERT INTO OTHER.EMPSALARY VALUES ('FORD',7902,3000);
INSERT INTO OTHER.EMPSALARY VALUES ('JONES',7566,2975);
INSERT INTO OTHER.EMPSALARY VALUES ('BLAKE',7698,2850);
INSERT INTO OTHER.EMPSALARY VALUES ('CLARK',7782,2450);
INSERT INTO OTHER.EMPSALARY VALUES ('ALLEN',7499,1600);
INSERT INTO OTHER.EMPSALARY VALUES ('TURNER',7844,1500);
INSERT INTO OTHER.EMPSALARY VALUES ('MILLER',7934,1300);
INSERT INTO OTHER.EMPSALARY VALUES ('WARD',7521,1250);
INSERT INTO OTHER.EMPSALARY VALUES ('MARTIN',7654,1250);
INSERT INTO OTHER.EMPSALARY VALUES ('ADAMS',7876,1100);
INSERT INTO OTHER.EMPSALARY VALUES ('JAMES',7900,950);
INSERT INTO OTHER.EMPSALARY VALUES ('SMITH',7369,800);INSERT INTO OTHER.ACCOUNT VALUES(1,1000);
INSERT INTO OTHER.ACCOUNT VALUES(2,2000);
INSERT INTO OTHER.ACCOUNT VALUES(3,1500);
INSERT INTO OTHER.ACCOUNT VALUES(4,6500);
INSERT INTO OTHER.ACCOUNT VALUES(5,500);INSERT INTO OTHER.ACTIONS VALUES(3,'U',599,NULL);
INSERT INTO OTHER.ACTIONS VALUES(6,'I',20099,NULL);
INSERT INTO OTHER.ACTIONS VALUES(5,'D',NULL,NULL);
INSERT INTO OTHER.ACTIONS VALUES(7,'U',1599,NULL);
INSERT INTO OTHER.ACTIONS VALUES(1,'I',399,NULL);
INSERT INTO OTHER.ACTIONS VALUES(9,'D',NULL,NULL);
INSERT INTO OTHER.ACTIONS VALUES(10,'X',NULL,NULL);INSERT INTO OTHER.READER VALUES(10, 'Bill', 19, 'M', 'Computer');
INSERT INTO OTHER.READER VALUES(11, 'Susan', 18, 'F', 'History');
INSERT INTO OTHER.READER VALUES(12, 'John', 19, 'M', 'Computer');

手册中的示例说明 | 达梦技术文档为方便读者阅读并尽快学会使用 DM 系统，本手册在介绍利用 DM 建立、维护数据库以及对数据库进行的各种操作中，使用了示例库 BOOKSHOP。本章将对该示例库进行说明。 2.1 示例库说明 示例库 BOOKSHOP 模拟武汉代理图书的某销售公司，该公司欲建立在线购物平台来拓展其代理产品的销售渠道，该在线购物平台支持网上产品信息浏览、订购等服务(仅限同城内销售及送货)。该销售公司的雇员、部门信息icon-default.png?t=O83Ahttps://eco.dameng.com/document/dm/zh-cn/pm/example-description#

示例库DMHR创建方式与 BOOKSHOP一致。

-END- 

相关文章：

达梦8-达梦数据的示例用户和表

1、示例库说明： 创建达梦数据的示例用户和表，导入测试数据。 在完成达梦数据库的安装之后，在/opt/dmdbms/samples/instance_script目录下有用于创建示例用户的SQL文件。samples目录前的路径根据实际安装情况进行修改，本文将达梦…...

编程日记 2025/6/3 1:32:06

day08-别名-重定向-去重排序等

1.重复用touch命令创建同一份文件，会修改文件的时间戳。 alias命令： 别名 查看已有别名：alias [rootoldboy ~]# alias alias cpcp -i alias egrepegrep --colorauto alias fgrepfgrep --colorauto alias grepgrep --colorauto alias l.ls…...

编程日记 2025/6/1 10:35:24

如何在 .NET Core 中轻松实现异步编程并提升性能

目录 初识异步编程 与多线程关系 异步编程操作 初识异步编程 异步编程：是指在执行某些任务时程序可以在等待某个操作完成的过程中继续执行其他任务，而不是阻塞当前线程，这在处理I/O密集型操作(如文件读取、数据库查询、网络请求等)时尤为重…...

编程日记 2025/6/1 21:36:10

makefile文件

简介： 自动化编译：只需要一个make命令，整个工程自动编译 提高编译效率：再次编译时，只编译修改的文件（查看时间戳，根据修改文件的时间判断文件是否被修改） 基本语法： …...

编程日记 2025/5/31 17:51:59

MybatisPlus使用LambdaQueryWrapper更新时 int默认值问题

问题&#xff1a; User user new User();user.setBalance(1000);QueryWrapper<User> queryWrapper new QueryWrapper<>();queryWrapper.eq("username","Jack");userMapper.update(user, queryWrapper);通过用户名&#xff0c;更新金额&…...

编程日记 2025/6/4 1:23:32

泷羽sec学习打卡-brupsuite7搭建IP炮台

声明 学习视频来自B站UP主 泷羽sec,如涉及侵权马上删除文章 笔记的只是方便各位师傅学习知识,以下网站只涉及学习内容,其他的都 与本人无关,切莫逾越法律红线,否则后果自负 关于brupsuite的那些事儿-Brup-IP炮台搭建 搭建炮台服务端安装zmap1、更新系统和安装基础依赖&#xff…...

编程日记 2025/6/3 6:42:01

WPF系列一：窗口设置无边框

WindowStyle 设置&#xff1a;WindowStyle"None"&#xff0c;窗口无法拖拽&#xff0c;但可纵向和横向拉伸 <Window x:Class"WPFDemo.MainWindow.MainWindow"xmlns"http://schemas.microsoft.com/winfx/2006/xaml/presentation"xmlns:x&quo…...

编程日记 2025/6/4 16:19:20

《C++与 Armadillo：线性代数助力人工智能算法简化之路》

在人工智能领域&#xff0c;线性代数运算可谓是构建各类模型与算法的基石。从神经网络中的矩阵乘法、向量运算&#xff0c;到数据处理中的特征分解、奇异值分解等&#xff0c;无一不依赖高效且精准的线性代数计算。而 C作为一种强大且高效的编程语言&#xff0c;在人工智能开发…...

编程日记 2025/6/1 17:17:14

【新界面】基于卷积神经网络的垃圾分类（Matlab）

基于CNN的垃圾识别与分类GUI【新界面】 有需要可直接联系我&#xff0c;基本都在在线&#xff0c;能秒回&#xff01;可加我看演示视频&#xff0c;不懂可以远程教学 1.此项目设计包括两份完整的源代码&#xff0c;有GUI界面的代码和无GUI界面系统的代码。 &#xff08;以下部…...

编程日记 2025/6/4 16:00:28

阿尔茨海默症数据集,使用yolo，voc，coco格式对2013张原始图片进行标注，可识别轻微，中等和正常的症状

阿尔茨海默症数据集,使用yolo&#xff0c;voc&#xff0c;coco格式对2013张原始图片进行标注&#xff0c;可识别轻微&#xff0c;中等&#xff0c;严重和正常的症状 数据集分割 训练组100&#xff05; 2013图片 有效集&#xff05; 0图片 测试集&#xf…...

编程日记 2025/6/1 21:36:05

评估二分类模型性能之AUC-ROC 曲线

AUC-ROC 曲线 是评估二分类模型性能的重要工具。它结合了 受试者工作特性曲线 (Receiver Operating Characteristic, ROC) 和 曲线下面积 (Area Under the Curve, AUC)&#xff0c;全面衡量分类器在不同阈值下的表现。 概念解释 1. ROC 曲线 ROC 曲线展示了分类器在不同阈值下…...

编程日记 2025/6/4 8:40:07

睡岗和玩手机数据集，4653张原始图，支持YOLO，VOC XML，COCO JSON格式的标注

睡岗和玩手机数据集&#xff0c;4653张原始图&#xff0c;支持YOLO&#xff0c;VOC XML&#xff0c;COCO JSON格式的标注 数据集分割 训练组70&#xff05; 3257图片 有效集20&#xff05; 931图片 测试集10&#xff05; 465图片 预处理 没有采用任何预处…...

编程日记 2025/6/4 11:47:42

景联文科技：精准语音标注，驱动语音技术新发展

在人工智能迅速发展的今天&#xff0c;语音技术的应用已经渗透到我们生活的方方面面。从智能音箱、语音助手到自动语音识别系统&#xff0c;高质量的语音数据是这些应用成功的关键。景联文科技作为领先的AI数据服务提供商&#xff0c;专注于为客户提供高精度、高效的语音标注服…...

编程日记 2025/6/3 4:29:58

Linux 查看目录命令 ls 详细介绍

Linux 和 Unix 系统中 ls 命令是用于列出目录内容。用户可以查看指定目录下的文件和子目录&#xff0c;还可以获取有关这些文件和子目录的详细信息。 基本语法&#xff1a; ls [选项] [目录]如果不指定目录&#xff0c;ls 将列出当前工作目录下的内容。 01、-a 或 --all ls…...

编程日记 2025/6/1 21:35:58

Flux Tools 结构简析

Flux Tools 结构简析 BFL 这次一共发布了 Canny、Depth、Redux、Fill 四个 Tools 模型系列&#xff0c;分别对应我们熟悉的 ControlNets、Image Variation&#xff08;IP Adapter&#xff09;和 Inpainting 三种图片条件控制方法。虽然实现功能是相同的&#xff0c;但是其具体…...

编程日记 2025/6/3 10:05:18

从零开始：PHP基础教程系列-第13篇：构建简单的Web应用

从零开始&#xff1a;PHP基础教程系列 第13篇&#xff1a;构建简单的Web应用 在本篇文章中&#xff0c;我们将学习如何使用PHP构建一个简单的Web应用。这个应用将实现用户注册和登录功能&#xff0c;并使用PDO与MySQL数据库进行交互。我们将逐步实现这个应用的基本功能。 一…...

编程日记 2025/6/1 21:35:56

文件夹属性变0字节：全面解析与恢复指南

一、文件夹属性变0字节现象概述 在日常使用电脑的过程中&#xff0c;我们可能会遇到文件夹属性突然变为0字节的情况。这意味着文件夹中的文件列表或元数据被某种方式清空或损坏&#xff0c;导致系统无法正确读取文件夹的内容。当您尝试打开此类文件夹时&#xff0c;通常会收到…...

编程日记 2025/6/2 22:18:33

PDFMathTranslate 一个基于AI优秀的PDF论文翻译工具

PDFMathTranslate 是一个设想中的工具&#xff0c;旨在翻译PDF文档中的数学内容。以下是这个工具的主要特点和使用方法&#xff1a; 功能特点 数学公式识别&#xff1a;利用先进的OCR&#xff08;光学字符识别&#xff09;技术&#xff0c;精准识别PDF文档中的数学公式和文本…...

编程日记 2025/6/4 13:06:21

35. Three.js案例-创建带阴影的球体与平面

35. Three.js案例-创建带阴影的球体与平面 实现效果 知识点 WebGLRenderer WebGLRenderer 是Three.js中用于渲染场景的主要类之一&#xff0c;它负责将场景中的对象渲染到画布上。 构造器 new THREE.WebGLRenderer(parameters : Object) 参数类型描述parametersObject可选…...

编程日记 2025/6/4 16:15:14

【Linux】深入理解进程信号机制：信号的产生、捕获与阻塞

&#x1f3ac; 个人主页&#xff1a;谁在夜里看海. &#x1f4d6; 个人专栏&#xff1a;《C系列》《Linux系列》《算法系列》 ⛰️ 时间不语&#xff0c;却回答了所有问题 目录 &#x1f4da;前言 &#x1f4da;一、信号的本质 &#x1f4d6;1.异步通信 &#x1f4d6;2.信…...

编程日记 2025/6/3 13:11:44

Vue3.0使用JavaScript脚本实现Vue Router路由：页面跳转、获取URL参数

Vue 使用 Vue Router 路由系列文章： 《Vue使用Vue Router路由：开发单页应用》 《Vue使用Vue Router路由：通过URL传递与获取参数》 《Vue3.0使用JavaScript脚本实现Vue Router路由：页面跳转、获取URL参数》 1、路由基础 在单页 Web 应用中，整个项目只有一个 HTML 文件，不…...

编程日记 2025/6/4 7:15:23

2025山东科技大学考研专业课复习资料一览

[冲刺]2025年山东科技大学020200应用经济学《814经济学之西方经济学[宏观部分]》考研学霸狂刷870题[简答论述计算题]1小时前[强化]2025年山东科技大学085600材料与化工《817物理化学》考研强化检测5套卷22小时前[冲刺]2025年山东科技大学030100法学《704综合一[法理学、国际法学…...

编程日记 2025/6/4 4:14:33

lambda 表达式 闭包写法

lambda 表达式 1.用于 匿名委托函数表达 2.用于linq 查询表达 匿名方法表达 &#xff08;参数&#xff09;》{ 逻辑} 比如 &#xff08;x,y&#xff09;>{return xy;} 如果一个参数可不带&#xff08;&#xff09;&#xff0c;如果逻辑简单可以不{} 比如 x>x 如果没有参…...

编程日记 2025/6/1 12:42:28

什么是正则化？Regularization: The Stabilizer of Machine Learning Models（中英双语）

正则化&#xff1a;机器学习模型的稳定器 1. 什么是正则化&#xff1f; 正则化&#xff08;Regularization&#xff09;是一种在机器学习模型训练中&#xff0c;通过约束模型复杂性以防止过拟合的技术。 它的核心目标是让模型不仅在训练集上表现良好&#xff0c;还能在测试集上…...

编程日记 2025/6/3 14:22:57

【西门子PLC.博途】——面向对象编程及输入输出映射FC块

当我们做面向对象编程的时候&#xff0c;需要用到输入输出的映射。这样建立的变量就能够被复用&#xff0c;从而最大化利用了我们建立的udt对象。 下面就来讲讲映射是什么。 从本质上来说&#xff0c;映射就是拿实际物理对象对应程序虚拟对象&#xff0c;假设程序对象是I0.0&…...

编程日记 2025/6/2 4:32:20

CS61a.1 textbook1.2 编程要素

1.structure and interpretation of computer programs Python 内置了对各种常见编程活动的支持&#xff0c; 例如&#xff0c;操作文本、显示图形以及通过 互联网。Python 代码行 >>> from urllib.request import urlopen是一个 import 语句&#xff0c;用于加载用…...

编程日记 2025/6/2 17:43:37

计算机毕业设计Django+Tensorflow音乐推荐系统 音乐可视化 卷积神经网络CNN LSTM音乐情感分析 机器学习 深度学习 Flask

温馨提示&#xff1a;文末有 CSDN 平台官方提供的学长联系方式的名片&#xff01; 温馨提示&#xff1a;文末有 CSDN 平台官方提供的学长联系方式的名片&#xff01; 温馨提示&#xff1a;文末有 CSDN 平台官方提供的学长联系方式的名片&#xff01; 作者简介&#xff1a;Java领…...

编程日记 2025/6/3 17:20:14

使用国内镜像网站在线下载安装Qt（解决官网慢的问题）——Qt

国内镜像网站 中国科学技术大学&#xff1a;http://mirrors.ustc.edu.cn/qtproject/清华大学&#xff1a;https://mirrors.tuna.tsinghua.edu.cn/qt/北京理工大学&#xff1a;http://mirror.bit.edu.cn/qtproject/ 南京大学&#xff1a;https://mirror.nju.edu.cn/qt腾讯镜像&…...

编程日记 2025/6/3 5:03:11

乳腺癌多模态诊断解释框架：CNN + 可解释 AI 可视化

乳腺癌多模态诊断解释框架&#xff1a;CNN 可解释 AI 可视化 论文大纲理解1. 确认目标2. 分析过程&#xff08;目标-手段分析&#xff09;3. 实现步骤4. 效果展示 结构分析1. 层级结构分析叠加形态&#xff08;从基础到高级&#xff09;构成形态&#xff08;部分到整体&#x…...

编程日记 2025/6/1 0:58:13

MySQL篇之对MySQL进行参数优化，提高MySQL性能

1. MySQL参数优化说明 MySQL 参数调优是提高数据库性能的重要手段之一。通过调整 MySQL 的配置参数&#xff0c;可以优化查询速度、提升并发处理能力、减少资源消耗等。 MySQL 的性能优化涉及到多个方面&#xff0c;包括内存管理、磁盘 I/O、查询优化、连接管理、复制配置等。…...

编程日记 2025/6/3 5:38:54

Scratch节日 | 快乐圣诞节——用编程传递节日祝福！ ✨

今天为大家推荐一款充满节日气氛的Scratch项目——《快乐圣诞节》&#xff01;这款圣诞主题动画贺卡项目不仅让小朋友们学习编程知识&#xff0c;还提供了一种用创意传递祝福的方式。通过编程打造星星闪烁的圣诞树&#xff0c;播放经典圣诞音乐&#xff0c;制作一张属于自己的节…...

编程日记 2025/6/3 21:06:19

android studio更改应用图片，和应用名字。

更改应用图标&#xff0c;和名字 先打开AndroidManifest.xml文件。 更改图片文件名字&#xff08; 右键-->构建-->重命名&#xff08;R&#xff09;&#xff09;...

编程日记 2025/5/19 13:43:25

PHP8.4下webman直接使用topthink/think-orm

环境信息 操作系统win11php 8.4.1webman-framework ^1.6.8MySQL 8.4.3topthink/think-orm ^3.0 说明 PHP8.3以下版本 直接使用webman提供的webman/think-orm更方便。 PHP 环境换为 8.4 使用webman/think-orm 报了个错&#xff1b;所以换topthink/think-orm&#xff0c;根据文…...

编程日记 2025/6/3 20:40:45

uniapp 微信小程序 功能入口

单行单独展示 效果图 html <view class"shopchoose flex jsb ac" click"routerTo(要跳转的页面)"><view class"flex ac"><image src"/static/dyd.png" mode"aspectFit" class"shopchooseimg"&g…...

编程日记 2025/6/4 17:18:48

Halcon 机器视觉案例 之 连接件测量

第一篇 机器视觉案例 之 连接件测量 文章目录 第一篇 机器视觉案例 之 连接件测量1.案例要求2.实现思路2.1 读取单张图片并创建图像模板2.2 画出圆和直线2.3 创建测量模型2.4 循环读取多张图片并查找图像中连接件位置2.5 根据偏移量补偿使得测量模型移动至指定位置 3.实现效果4…...

编程日记 2025/6/2 9:11:40

druid与pgsql结合踩坑记

最近项目里面突然出现一个怪问题&#xff0c;数据库是pgsql&#xff0c;jdbc连接池是alibaba开源的druid&#xff0c;idea里面直接启动没问题&#xff0c;打完包放在centos上和windows上cmd窗口都能直接用java -jar命令启动&#xff0c;但是放到国产信创系统上就是报错&#xf…...

编程日记 2025/5/31 20:49:21

Windows环境 (Ubuntu 24.04.1 LTS ) 国内镜像，用apt-get命令安装RabbitMQ，java代码样例

一、环境 Windows11 WSL(Ubuntu 24.04.1) 二、思路 1 用Windows中的Ubuntu安装RabbitMQ&#xff0c;贴近Linux的线上环境&#xff1b; 2 RabbitMQ用erlang语言编写的&#xff0c;先安装erlang的运行环境&#xff1b; 2 用Linux的apt-get命令安装&#xff0c;解决软件依赖…...

编程日记 2025/5/26 23:40:09

RabbitMQ的核心组件有哪些？

大家好&#xff0c;我是锋哥。今天分享关于【RabbitMQ的核心组件有哪些&#xff1f;】面试题。希望对大家有帮助&#xff1b; RabbitMQ的核心组件有哪些&#xff1f; 1000道 互联网大厂Java工程师 精选面试题-Java资源分享网 RabbitMQ是一个开源的消息代理&#xff08;Messag…...

编程日记 2025/6/4 5:09:18

mysql免安装版配置教程

一、将压缩包解压至你想要放置的文件夹中&#xff0c;注意&#xff1a;绝对路径中要避免出现中文 二、在解压目录下新建my.ini文件&#xff0c;已经有的就直接覆盖 my.ini文件内容 [mysqld] # 设置3306端口 port3306 # 设置mysql的安装目录 basedirD:\\tools\\mysql-8.1.0-win…...

编程日记 2025/6/3 5:31:03

ubuntu+ros新手笔记（三）：21讲没讲到的MoveIt2

1 安装MoveIt2 安装参照在ROS2中&#xff0c;通过MoveIt2控制Gazebo中的自定义机械手 安装 MoveIt2可以选择自己编译源码安装&#xff0c;或者直接从二进制安装。 个人建议直接二进制安装&#xff0c;可以省很多事。 sudo apt install ros-humble-moveitmoveit-setup-assistan…...

编程日记 2025/6/2 14:07:09

Charles简单压力测试

01、接口请求次数&#xff0c;并发量&#xff0c;请求延迟时间均可配置 选中需要进行测试的接口&#xff0c;鼠标右键选中【repeat advance】 02、设置并发参数 下面的图中&#xff0c;选择了1个接口&#xff0c;每次迭代中1个接口同时请求&#xff0c;迭代1000次&#xff08…...

编程日记 2025/6/1 12:42:13

决策树的生成与剪枝

决策树的生成与剪枝 决策树的生成生成决策树的过程决策树的生成算法 决策树的剪枝决策树的损失函数决策树的剪枝算法 代码 决策树的生成 生成决策树的过程 为了方便分析描述&#xff0c;我们对上节课中的训练样本进行编号&#xff0c;每个样本加一个ID值&#xff0c;如图所示…...

编程日记 2025/6/3 8:49:19

对象克隆与单例模式的实现

一、引言 在 C 编程中&#xff0c;对象克隆和单例模式是两个非常重要的概念。对象克隆可以帮助我们快速创建具有相同状态的对象副本&#xff0c;而单例模式则可以确保一个类只有一个实例&#xff0c;并提供全局访问点。本文将详细介绍 C 中如何实现对象的克隆以及单例模式。 …...

编程日记 2025/6/1 12:42:12

在 Linux 系统中，让 apt 使用 HTTP 代理

在 Linux 系统中&#xff0c;要让 apt 使用 HTTP 代理&#xff0c;有几种方法可以实现&#xff1a; ### 1. 临时设置代理 你可以通过设置环境变量来临时为 apt 命令设置代理。这种方法不需要修改任何配置文件&#xff0c;只需在命令行中设置环境变量即可。例如&#xff1a; …...

编程日记 2025/6/1 12:42:10

中国气象局：2024年第二批“气象数据要素×”典型案例（附下载）

11月25日&#xff0c;中国气象局通报2024年第二批“气象数据要素”典型案例。此次遴选充分结合首届“数据要素”大赛获奖案例&#xff0c;旨在进一步号召各级气象部门充分学习借鉴先进经验和做法&#xff0c;持续推动高价值气象数据产品开发利用&#xff0c;挖掘气象数据要素应…...

编程日记 2025/6/3 19:14:25

Android绘图Path基于LinearGradient线性渐变，Kotlin（1）

Android绘图Path基于LinearGradient线性渐变&#xff0c;Kotlin&#xff08;1&#xff09; import android.content.Context import android.graphics.Canvas import android.graphics.Color import android.graphics.LinearGradient import android.graphics.Paint import and…...

编程日记 2025/6/4 9:45:50

基础入门-APP应用微信小程序原生态开发H5+Vue技术WEB封装打包反编译抓包点

知识点&#xff1a; 1、基础入门-APP应用-开发架构安全问题 2、基础入门-小程序应用-开发架构安全问题 通用&#xff1a; 1、反编译-得到源码-源码提取资产&#xff08;泄漏的配置信息&#xff09;-安全测试 2、抓包-资产-安全测试 一、演示案例-移动App-开发架构-原生&H…...

编程日记 2025/6/4 9:45:45

vue+ts提交数据时不提交（剔除）某项数据

关键代码 // 假设这是原始要提交的数据数组 const dataArray [{areaConfId: ,areaName: ,cityInfo: [],provinceList: [],cityList: []} ];// 使用map方法遍历数组中的每个对象&#xff0c;通过解构赋值和对象展开运算符去除cityInfo字段 const newDataArray dataArray.map…...

编程日记 2025/6/4 9:45:41

乐凡信息智能安全管控方案：助力油气田行业安全管控多方位升级

我国油田地域广阔&#xff0c;分布着大量各种油井&#xff0c;油井开采设备的连续稳定运行是保证石油开采的首要条件。然而&#xff0c;由于油田多位于特殊地理环境中&#xff0c;因而实现油井之间的通信首要问题就是要克服地理环境所带来的限制&#xff0c;传统通信系统的建设…...

编程日记 2025/6/4 14:29:09

Jenkins搭建并与Harbor集成上传镜像

Jenkins介绍 Jenkins 是一个开源的自动化服务器&#xff0c;广泛用于持续集成&#xff08;CI&#xff09;和持续交付&#xff08;CD&#xff09;的实践中。它帮助开发人员自动化构建、测试和部署过程&#xff0c;从而提高开发效率、代码质量和项目交付速度。通过丰富的插件支持…...

编程日记 2025/6/4 11:02:56