Live Writer Test

最新推荐文章于 2016-11-07 21:44:00 发布

转载最新推荐文章于 2016-11-07 21:44:00 发布 · 91 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/anyhow/p/3849471.html

本文介绍了如何使用LiveWriter工具撰写CNblog文章，并通过Java代码实现用户信息的分页查询。包括使用Hibernate的session工厂进行数据库操作，执行SQL查询获取用户信息，并对查询结果进行分页展示。

测试下LiveWriter写CNblog：

1、Source code plug-in:

@Override
	public List getAll(String orgid,String start, String limit, String query1) {
		Query query = null;
		Session session = sessionFactory.openSession();
		try {
	        String sql = "select a.userid,a.username,a.gender,"
	        		+ "(select rolename from Role where roleid=(select roleid from TUser_Role where userid=a.userid)) as rolename, "
	        		+ "(select orgname from Organization where orgid=a.orgid) as orgname,"
	        		+ "(select departmentname from Department where departid=a.departid) as deparname,"
	        		+ "a.tel from TUser a where orgid='"+orgid+"'";
	        session.beginTransaction();
	        query = session.createQuery(sql);
	        query.setFirstResult(Integer.valueOf(start));
	        query.setMaxResults(Integer.valueOf(limit));
	        return query.list();
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		} finally {
			session.close();
		}
	}

2、插入代码：

@Override
    public List getAll(String orgid,String start, String limit, String query1) {
        Query query = null;
        Session session = sessionFactory.openSession();
        try {
            String sql = "select a.userid,a.username,a.gender,"
                    + "(select rolename from Role where roleid=(select roleid from TUser_Role where userid=a.userid)) as rolename, "
                    + "(select orgname from Organization where orgid=a.orgid) as orgname,"
                    + "(select departmentname from Department where departid=a.departid) as deparname,"
                    + "a.tel from TUser a where orgid='"+orgid+"'";
            session.beginTransaction();
            query = session.createQuery(sql);
            query.setFirstResult(Integer.valueOf(start));
            query.setMaxResults(Integer.valueOf(limit));
            return query.list();
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        } finally {
            session.close();
        }
    }