# HG changeset patch # User František Kučera # Date 1264437840 -3600 # Node ID 5d93bf1c8093403b6a4b2bb87c6d214a886399b3 # Parent 0deb8f6abcf56e0d5f57d03d0e6b76a983955a26 JSP SQL značky a schéma. diff -r 0deb8f6abcf5 -r 5d93bf1c8093 java/nekurak.net-web/web/WEB-INF/sun-web.xml --- a/java/nekurak.net-web/web/WEB-INF/sun-web.xml Sat Jan 16 02:43:45 2010 +0100 +++ b/java/nekurak.net-web/web/WEB-INF/sun-web.xml Mon Jan 25 17:44:00 2010 +0100 @@ -1,12 +1,12 @@ - /nekurak.net-web - - - - - Keep a copy of the generated servlet class' java code. - - + /nekurak.net-web + + + + + Keep a copy of the generated servlet class' java code. + + diff -r 0deb8f6abcf5 -r 5d93bf1c8093 java/nekurak.net-web/web/WEB-INF/web.xml --- a/java/nekurak.net-web/web/WEB-INF/web.xml Sat Jan 16 02:43:45 2010 +0100 +++ b/java/nekurak.net-web/web/WEB-INF/web.xml Mon Jan 25 17:44:00 2010 +0100 @@ -23,4 +23,10 @@ java.lang.NullPointerException /WEB-INF/chyby/nullPointer.jsp + + + jdbc/nekurak + javax.sql.DataSource + Container + diff -r 0deb8f6abcf5 -r 5d93bf1c8093 java/nekurak.net-web/web/sql-znacky.jsp --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/java/nekurak.net-web/web/sql-znacky.jsp Mon Jan 25 17:44:00 2010 +0100 @@ -0,0 +1,46 @@ + + + + + + + + SQL značky + + +

SQL značky

+ + + + + + +
SELECT * FROM podnik;
+ SELECT * FROM podnik; +
    + +
  • +
    +
+ + +
SELECT * FROM podnik WHERE nazev = ?;
+ + + +
    + +
  • +
    +
+ + + + + +
diff -r 0deb8f6abcf5 -r 5d93bf1c8093 sql/schéma.sql --- a/sql/schéma.sql Sat Jan 16 02:43:45 2010 +0100 +++ b/sql/schéma.sql Mon Jan 25 17:44:00 2010 +0100 @@ -2,7 +2,7 @@ -- PostgreSQL database dump -- --- Started on 2010-01-16 02:43:00 CET +-- Started on 2010-01-25 17:42:09 CET SET statement_timeout = 0; SET client_encoding = 'UTF8'; @@ -39,7 +39,7 @@ ALTER TABLE nekurak.podnik_seq OWNER TO nekurak; -- --- TOC entry 1847 (class 0 OID 0) +-- TOC entry 1848 (class 0 OID 0) -- Dependencies: 1568 -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak -- @@ -89,7 +89,43 @@ ADD CONSTRAINT podnik_pk PRIMARY KEY (id); --- Completed on 2010-01-16 02:43:01 CET +-- +-- TOC entry 1847 (class 0 OID 0) +-- Dependencies: 10 +-- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak +-- + +REVOKE ALL ON SCHEMA nekurak FROM PUBLIC; +REVOKE ALL ON SCHEMA nekurak FROM nekurak; +GRANT ALL ON SCHEMA nekurak TO nekurak; +GRANT USAGE ON SCHEMA nekurak TO nekurak_web; + + +-- +-- TOC entry 1849 (class 0 OID 0) +-- Dependencies: 1568 +-- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak +-- + +REVOKE ALL ON SEQUENCE podnik_seq FROM PUBLIC; +REVOKE ALL ON SEQUENCE podnik_seq FROM nekurak; +GRANT ALL ON SEQUENCE podnik_seq TO nekurak; +GRANT USAGE ON SEQUENCE podnik_seq TO nekurak_web; + + +-- +-- TOC entry 1850 (class 0 OID 0) +-- Dependencies: 1569 +-- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak +-- + +REVOKE ALL ON TABLE podnik FROM PUBLIC; +REVOKE ALL ON TABLE podnik FROM nekurak; +GRANT ALL ON TABLE podnik TO nekurak; +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik TO nekurak_web; + + +-- Completed on 2010-01-25 17:42:10 CET -- -- PostgreSQL database dump complete