Guest User

Untitled

a guest
Jan 21st, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. class Test {
  2. private int Id;
  3. private String Name;
  4. private String Remark;
  5. }
  6.  
  7. CREATE TABLE sqls (
  8. `name` VARCHAR,
  9. `select` CLOB,
  10. `insert` CLOB
  11. `update` CLOB
  12. `delete` CLOB
  13. );
  14. INSERT INTO sqls (
  15. `name`, `select`, `insert`, `update`, `delete`
  16. ) VALUES (
  17. "TEST",
  18. "SELECT id, name, remark FROM mytable",
  19. "INSERT INTO mytable (id, name, remark) VALUES (:id, :name, :remark)",
  20. "UPDATE mytable SET name = :name, remark = :remark WHERE id = :id",
  21. "DELETE FROM mytable WHERE id = :id"
  22. );
Add Comment
Please, Sign In to add comment