loginutil.java

本平台是以web2.0为基本的标准

package com.afuer.hib.dao.orgModel.Dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.afuer.hib.form.LinkControl;
import com.afuer.hib.form.UserAcl;

public class LoginUtil extends HibernateDaoSupport {

	public String getLoginnames(final String loginName) {
		return (String) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("select count(*) as b from UserInfo where loginname='"
										+ loginName + "'");
						Integer count = (Integer) query.uniqueResult();
						if (count.intValue() == 0) {
							return "<span class=\"reply\">账号不存在，可以注册！</span>";
						}
						return "<span class=\"warning\">账号已存在，请选择新帐号！</span>";
					}
				});
	}

	public Integer getAccounts(final String loginName, final String password) {
		return (Integer) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("select count(*) as b from UserInfo where"
										+ " loginname='"
										+ loginName
										+ "' and password='" + password + "'");
						Integer count = (Integer) query.uniqueResult();
						return count;
					}
				});
	}

	public String getHeadMenuString(List roles) {
		String temp = "";
		List list = new ArrayList();
		Iterator it = roles.iterator();

		// 获得linkid
		while (it.hasNext()) {
			final Integer roleid = (Integer) it.next();
			list.addAll((List) getHibernateTemplate().execute(
					new HibernateCallback() {
						public Object doInHibernate(Session session)
								throws SQLException {
							List tlist = new ArrayList();
							Connection con = session.connection();
							String sql2 = "select distinct * from linkcontrol where id in(select "
									+ "linkid from user_acl where roleid="
									+ roleid;

							PreparedStatement stmt = con.prepareStatement(sql2);

							ResultSet rs = stmt.executeQuery();
							while (rs.next()) {
								LinkControl lc = new LinkControl();
								lc.setId(new Integer(rs.getInt("id")));
								lc.setChildren(new Integer(rs
										.getInt("children")));
								lc.setImg(rs.getString("img"));
								lc.setIsline(rs.getString("isline"));
								lc.setLinkurl(rs.getString("linkurl"));
								lc.setName(rs.getString("name"));
								lc.setParentid(rs.getString("parentid"));
								lc.setPath(rs.getString("path"));
								lc.setSizex(new Integer(rs.getInt("sezex")));
								lc.setSizey(new Integer(rs.getInt("sizey")));
								tlist.add(tlist);
							}
							rs.close();
							stmt.close();
							con.close();
							return tlist;
						}
					}));

		}

		return temp;
	}
}