Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Test {
- private int Id;
- private String Name;
- private String Remark;
- }
- CREATE TABLE sqls (
- `name` VARCHAR,
- `select` CLOB,
- `insert` CLOB
- `update` CLOB
- `delete` CLOB
- );
- INSERT INTO sqls (
- `name`, `select`, `insert`, `update`, `delete`
- ) VALUES (
- "TEST",
- "SELECT id, name, remark FROM mytable",
- "INSERT INTO mytable (id, name, remark) VALUES (:id, :name, :remark)",
- "UPDATE mytable SET name = :name, remark = :remark WHERE id = :id",
- "DELETE FROM mytable WHERE id = :id"
- );
Add Comment
Please, Sign In to add comment