session.createSQLQuery(sql1--sql语句);和session.createDySQLQuery("sqlmap路径名",map);区别

最新推荐文章于 2021-03-30 13:42:44 发布

qq_33203743

最新推荐文章于 2021-03-30 13:42:44 发布

阅读量373

点赞数

分类专栏： servernet 文章标签： sql server

本文链接：https://blog.csdn.net/qq_33203743/article/details/52514684

版权

servernet 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

String sql1=”SELECT bucm_leader_id AS id, name, position, position_detail AS detail, relation_id AS headPortrait, creation_date AS date, concat(‘Images/’, relation_id) AS server_name FROM bucm_leader WHERE bucm_leader_id = :id”;
SQLQuery query1 = session.createSQLQuery(sql1);
new QueryParameterImpl().initParameter(query1, map);//将组装好的map传入
List rs1 = query1.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
String data = new Gson().toJson(rs1);
out.print(data);
session.createSQLQuery(sql1);和 session.createDySQLQuery区别，如果是单独一条sql语句则用 session.createSQLQuery(sql1)，如果是写好的复杂sqlmap则用 session.createDySQLQuery

SQLQuery query1 = session.createDySQLQuery(“SelectAboutMuseum.selectCurrentLeaders”,map);
new QueryParameterImpl().initParameter(query1 , map);
List rs2 = query1.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
String data = new Gson().toJson(rs2);
out.print(data);

qq_33203743

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
session.createSQLQuery(sql1--sql语句);和session.createDySQLQuery("sqlmap路径名",map);区别

String sql1=”SELECT bucm_leader_id AS id, name, position, position_detail AS detail, relation_id AS headPortrait, creation_date AS date, concat(‘Images/’, relation_id) AS server_name FROM bucm_leader W
复制链接

扫一扫