JAVA下的SQL_System的建立

CREATE VIEW chanpin_company_view
AS
SELECT company.manager,chanpin.leibie
FROM company,chanpin
WHERE company.id = chanpin.qiyeid
GROUP BY company.manage,chanpin.leibie