分离valuelist的sql拼装

最新推荐文章于 2021-12-28 09:48:56 发布

chen_6879034

最新推荐文章于 2021-12-28 09:48:56 发布

阅读量264

点赞数

CC 4.0 BY-SA版权

分类专栏： j2EE开发群欢迎加入该群一起学习群号：172429747 文章标签：动态sql拼装

本文链接：https://blog.youkuaiyun.com/chen_6879034/article/details/84505185

j2EE开发群欢迎加入该群一起学习群号：172429747 专栏收录该内容

1 篇文章

订阅专栏

这几天用的sql的动态拼装，一下子就想到的valuelist，但是valuelist有好多前端的东西我们又用不到，所以想了想决定吧valuelist的动态拼装提出来。直接上传源码，不喜勿喷！

<bean id="hibernate4Adapter" class="net.mlw.vlh.adapter.hibernate4.Hibernate4Adapter">
//jap的
<property name="sessionFactory" ref="entityManagerFactory" />
//hibernate的
<property name="sessionFactoryBean" ref="sessionFactoryBean" />
</bean>

<bean id="columnMapRowMapper" class="org.springframework.jdbc.core.ColumnMapRowMapper" />
<bean id="sqlPagingSupport" class="net.mlw.vlh.adapter.jdbc.util.SqlPagingSupport" />

<bean id="jdbcAdapter" class="net.mlw.vlh.adapter.jdbc.JdbcAdapter" >
<property name="showSql" value="${hibernate.showSql}" />
<property name="dataSource" ref="dataSource" />
<property name="rowMapper" ref="columnMapRowMapper" />
<property name="sqlPagingSupport" ref="sqlPagingSupport" />
</bean>
//这个配置文件必须有
${hibernate.dialect}

  
  @Autowired
	public Hibernate4Adapter hibernate4Adapter;

	@Autowired
	private JdbcAdapter jdbcAdapter;

	@Test
	public void jdbc(){
		try {
			String sql = "select * from inspur_topic where 1=1 " +
					"/~name: and name = {name}~/" +
					"/~name: and name = '[name]'~/" +
					"/~sortColumn: order by [sortColumn] [sortDirection]~/";
			HashMap filters = new HashMap();
			filters.put("sortColumn", "id");
			filters.put("pagingNumberPer", "2");
			filters.put("sortDirection", "desc");
			filters.put("pagingPage", "1");
			filters.put("name", "新闻");
			net.mlw.vlh.ValueListInfo info = new net.mlw.vlh.ValueListInfo(filters);

			ValueList valueList = jdbcAdapter.getValueList(sql, info);
			System.err.println(valueList.getList().size());     
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

   	@Test
	public void hibernate(){
		try {
			String hql = "from topic where 1=1 " +
					"/~name: and name = {name}~/" +
					"/~name: and name = '[name]'~/" +
					"/~sortColumn: order by [sortColumn] [sortDirection]~/";
			HashMap filters = new HashMap();
			filters.put("sortColumn", "id");
			filters.put("pagingNumberPer", "2");
			filters.put("sortDirection", "desc");
			filters.put("pagingPage", "1");
			filters.put("name", "新闻");
			net.mlw.vlh.ValueListInfo info = new net.mlw.vlh.ValueListInfo(filters);

			ValueList valueList = hibernate4Adapter.getValueList(hql, info);
			System.err.println(valueList.getList().size());     
		} catch (Exception e) {
			e.printStackTrace();
		}
	}