WooYun.org

package com.qunar.affiliate.actions;
import com.qunar.affiliate.controller.UserController;
import com.qunar.affiliate.model.User;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
public class LogonAction extends Action
{
  static final String logon_user = "affiliate_user";
  public ActionForward execute(ActionMapping arg0, ActionForm arg1, HttpServletRequest arg2, HttpServletResponse arg3)
    throws Exception
  {
    DynaActionForm aform = (DynaActionForm)arg1;
    UserController uc = new UserController();
    User user = uc.validateUser(aform.getString("name"), aform.getString("password"));
    if (user != null)
    {
      arg2.getSession().setAttribute("affiliate_user", user);
      return arg0.findForward("success");
    }
    return arg0.findForward("failed");
  }
}

package com.qunar.affiliate.controller;
import com.qunar.affiliate.model.User;
import com.qunar.affiliate.util.Encrypt;
import com.qunar.affiliate.util.HibernateUtil;
import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;
import org.hibernate.criterion.Example;
public class UserController
{
  static Logger logger = Logger.getLogger(UserController.class);
  public static void main(String[] args)
  {
    UserController controller = new UserController();
    if (args[0].equals("store")) {
      controller.createAndStoreUser("jingyi.zhang", "密码隐藏");
    }
    else if (args[0].equals("list"))
    {
      User localUser = controller.validateUser("qiang.zhou", "密码隐藏");
    }
  }
  public User createAndStoreUser(String name, String password)
  {
    Session session = null;
    try {
      session = HibernateUtil.getSessionFactory().openSession();
      session.beginTransaction();
      User user = new User();
      user.setName(name);
      user.setHashed_password(Encrypt.change("SHA", password));
      session.save(user);
      session.getTransaction().commit();
      User localUser1 = user;
      return localUser1;
    }
    finally {
      if (session != null) try { session.close(); } catch (Throwable t) { logger.error("UserController close session failed!", t); } 
    }
    throw localObject;
  }
  public User validateUser(String name, String password) {
    Session session = null;
    try {
      session = HibernateUtil.getSessionFactory().openSession();
      session.beginTransaction();
      User user = new User();
      user.setName(name);
      user.setHashed_password(Encrypt.change("SHA", password));
      User vu = (User)session.createCriteria(User.class).add(Example.create(user)).uniqueResult();
      session.getTransaction().commit();
      User localUser1 = vu;
      return localUser1;
    }
    finally {
      if (session != null) try { session.close(); } catch (Throwable t) { logger.error("UserController close session failed!", t); } 
    }
    throw localObject;
  }
}

session = HibernateUtil.getSessionFactory().openSession();

<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://l-aff2.隐藏.隐藏.qunar.com/affiliate?characterEncoding=utf-8</property>
<property name="connection.username">affiliate_new</property>
<property name="connection.password">密码隐藏</property>
<!-- JDBC connection pool (use the built-in) -->
<!--<property name="connection.pool_size">10</property>-->
<!--  hibernate c3p0  -->
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.max_size">10</property>
<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">100</property><property name="hibernate.c3p0.idle_test_period">3000</property><property name="hibernate.c3p0.acquire_increment">2</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache  -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<!--<property name="hbm2ddl.auto">create</property>-->
<mapping resource="com/qunar/affiliate/model/user.hbm.xml"/>
</session-factory>
</hibernate-configuration>