Package com.blogger.tcuri.appserver.db

Examples of com.blogger.tcuri.appserver.db.SqlBuilder

17
18
19
20
21
22
23
24
25
26
27
    public Resolution execute(ActionContext context) throws Exception {

        String content = context.param("content");

        if (Utils.isNotBlank(content)) {
            SqlBuilder sql = new SqlBuilder(
                    "insert into messages (content) values (?)", content);
            DbUtils.execute(sql);
        }

        return CrudLogic.read();
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
    public Resolution execute(ActionContext context) throws Exception {

        String id = context.param("id");

        if (Utils.isNotBlank(id)) {
            SqlBuilder sql = new SqlBuilder(
                    "delete from messages where id=?", id);
            DbUtils.execute(sql);
        }

        return CrudLogic.read();
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
        String id = context.param("id");
        String content = context.param("content");

        if (Utils.isNotBlank(id) && Utils.isNotBlank(content)) {
            SqlBuilder sql = new SqlBuilder(
                    "update messages set content=? where id=?", content, id);
            DbUtils.execute(sql);
        }

        return CrudLogic.read();
View Full Code Here
11
12
13
14
15
16
17
18
19
20
21
import com.blogger.tcuri.appserver.resolution.Resolution;

public class CrudLogic {

    public static Resolution read() throws SQLException {
        SqlBuilder sql = new SqlBuilder(
                "select id,content,formatdatetime(updatetime, 'yyyy-MM-dd HH:mm:ss') as updatetime from messages order by id desc");

        List<Map<String, Object>> messageList = DbUtils.selectList(sql,
                MapHandler.INSTANCE);
View Full Code Here
TOP

Related Classes of com.blogger.tcuri.appserver.db.SqlBuilder

  • app.action.crud.CreateAction
  • app.action.crud.DeleteAction
  • app.action.crud.UpdateAction
  • app.logic.CrudLogic
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.