hi,everyone
Hibernate version:
hibernate 3.1+struts1.27+myeclipse
Mapping documents:
Administrator.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<!-- Created Tue May 16 03:20:14 GMT 2006 -->
<hibernate-mapping>
<class name="com.kevin.form.Administrator" table="Administrator">
<id name="adminid" column="AdminID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="adminname" column="AdminName" type="java.lang.String" not-null="true" />
<property name="adminpassword" column="AdminPassword" type="java.lang.String" not-null="true" />
<property name="admindictionaryid" column="AdminDictionaryID" type="java.lang.String" not-null="true" />
<property name="adminquestion" column="AdminQuestion" type="java.lang.String" not-null="true" />
<property name="adminanswer" column="AdminAnswer" type="java.lang.String" not-null="true" />
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<hibernate-configuration>
<session-factory>
<!-- properties -->
<property name="connection.username">gyf</property>
<property name="connection.url">jdbc:jtds:sqlserver://localhost:1433;database=ICShop</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="connection.password">85356156</property>
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<!-- mapping files -->
<mapping resource="com/kevin/form/Administrator.hbm.xml"/>
</session-factory>
</hibernate-configuration>
po -> Administrator.java
/*
* Created Tue May 16 03:20:15 GMT 2006 by MyEclipse Hibernate Tool.
*/
package com.kevin.form;
import java.io.Serializable;
/**
* A class that represents a row in the 'Administrator' table.
* This class may be customized as it is never re-generated
* after being created.
*/
public class Administrator implements Serializable
{
/** The cached hash code value for this instance. Settting to 0 triggers re-calculation. */
private int hashValue = 0;
private Long adminid;
private String adminname;
private String adminpassword;
private String admindictionaryid;
private String adminquestion;
private String adminanswer;
/**
* Simple constructor of Administrator instances.
*/
public Administrator()
{
}
public Administrator(String adminname,String adminpassword) {
this.adminname=adminname;
this.adminpassword=adminpassword;
}
/**
* Return the simple primary key value that identifies this object.
* @return java.lang.Long
*/
public Long getAdminid()
{
return adminid;
}
/**
* Set the simple primary key value that identifies this object.
* @param adminid
*/
public void setAdminid(Long adminid)
{
this.hashValue = 0;
this.adminid = adminid;
}
/**
* Return the value of the AdminName column.
* @return java.lang.String
*/
public String getAdminname()
{
return this.adminname;
}
/**
* Set the value of the AdminName column.
* @param adminname
*/
public void setAdminname(String adminname)
{
this.adminname = adminname;
}
/**
* Return the value of the AdminPassword column.
* @return java.lang.String
*/
public String getAdminpassword()
{
return this.adminpassword;
}
/**
* Set the value of the AdminPassword column.
* @param adminpassword
*/
public void setAdminpassword(String adminpassword)
{
this.adminpassword = adminpassword;
}
/**
* Return the value of the AdminDictionaryID column.
* @return java.lang.String
*/
public String getAdmindictionaryid()
{
return this.admindictionaryid;
}
/**
* Set the value of the AdminDictionaryID column.
* @param admindictionaryid
*/
public void setAdmindictionaryid(String admindictionaryid)
{
this.admindictionaryid = admindictionaryid;
}
/**
* Return the value of the AdminQuestion column.
* @return java.lang.String
*/
public String getAdminquestion()
{
return this.adminquestion;
}
/**
* Set the value of the AdminQuestion column.
* @param adminquestion
*/
public void setAdminquestion(String adminquestion)
{
this.adminquestion = adminquestion;
}
/**
* Return the value of the AdminAnswer column.
* @return java.lang.String
*/
public String getAdminanswer()
{
return this.adminanswer;
}
/**
* Set the value of the AdminAnswer column.
* @param adminanswer
*/
public void setAdminanswer(String adminanswer)
{
this.adminanswer = adminanswer;
}
/**
* Implementation of the equals comparison on the basis of equality of the primary key values.
* @param rhs
* @return boolean
*/
public boolean equals(Object rhs)
{
if (rhs == null)
return false;
if (! (rhs instanceof Administrator))
return false;
Administrator that = (Administrator) rhs;
if (this.getAdminid() != null && that.getAdminid() != null)
{
if (! this.getAdminid().equals(that.getAdminid()))
{
return false;
}
}
return true;
}
/**
* Implementation of the hashCode method conforming to the Bloch pattern with
* the exception of array properties (these are very unlikely primary key types).
* @return int
*/
public int hashCode()
{
if (this.hashValue == 0)
{
int result = 17;
int adminidValue = this.getAdminid() == null ? 0 : this.getAdminid().hashCode();
result = result * 37 + adminidValue;
this.hashValue = result;
}
return this.hashValue;
}
}
formbean->AdminLoginForm.java
//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.4/xslt/JavaClass.xsl
package com.kevin.form;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.validator.ValidatorForm;
/**
* MyEclipse Struts
* Creation date: 05-16-2006
*
* XDoclet definition:
* @struts:form name="adminLoginForm"
*/
public class AdminLoginForm extends ValidatorForm {
// --------------------------------------------------------- Instance Variables
/** adminPassword property */
private String adminPassword;
/** adminName property */
private String adminName;
// --------------------------------------------------------- Methods
/**
* Method validate
* @param mapping
* @param request
* @return ActionErrors
*/
public ActionErrors validator(
ActionMapping mapping,
HttpServletRequest request) {
throw new UnsupportedOperationException(
"Generated method 'validate(...)' not implemented.");
}
/**
* Method reset
* @param mapping
* @param request
*/
public void reset(ActionMapping mapping, HttpServletRequest request) {
this.adminName=null;
this.adminPassword=null;
}
/**
* Returns the adminPassword.
* @return String
*/
public String getAdminPassword() {
return adminPassword;
}
/**
* Set the adminPassword.
* @param adminPassword The adminPassword to set
*/
public void setAdminPassword(String adminPassword) {
this.adminPassword = adminPassword;
}
/**
* Returns the adminName.
* @return String
*/
public String getAdminName() {
return adminName;
}
/**
* Set the adminName.
* @param adminName The adminName to set
*/
public void setAdminName(String adminName) {
this.adminName = adminName;
}
}
action -> AdminLoginAction.java
//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.4/xslt/JavaClass.xsl
package com.kevin.action;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.kevin.form.*;
import com.kevin.struts.HibernateUtil;
/**
* MyEclipse Struts
* Creation date: 05-16-2006
*
* XDoclet definition:
* @struts:action path="/adminLoginAction" name="adminLoginForm" input="/Login.jsp" scope="request" validate="true"
*/
public class AdminLoginAction extends Action {
// --------------------------------------------------------- Instance Variables
// --------------------------------------------------------- Methods
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)throws HibernateException{
String adminName=request.getParameter("adminName");
String adminPassword=request.getParameter("adminPassword");
System.out.println(adminName);
System.out.println(adminPassword);
//AdminLoginForm loginForm=new AdminLoginForm();
Administrator admin=new Administrator();
Session session=HibernateUtil.getSession();
Transaction tx=session.beginTransaction();
try{
Query query=session.createQuery("from Administrator admin where admin.adminname='"+adminName+"'and admin.adminpassword='"+adminPassword+"'");
System.out.println("query is :"+adminName);
//System.out.println("loginForm:"+loginForm.getAdminName());
//System.out.println("Admin.getAdmin:"+admin.getAdminname());
query.setString("adminname",adminName);
query.setString("adminpassword",adminPassword);
List list=query.list();
System.out.println("query.list().getadmin"+query.list().get(1));
for (ListIterator iterator=list.listIterator(); iterator.hasNext(); )
{
admin = (Administrator) iterator.next();
};
}catch (Exception e) {
System.out.println(e.getMessage());
}
tx.commit();
HibernateUtil.closeSession();
if(!(admin.getAdminname().equals("")))
return(mapping.findForward("success"));
else
return(mapping.findForward("error"));
}
}
Debug level Hibernate log excerpt:
log4j messages:
Parameter adminname does not exist as a named parameter in [from Administrator admin where admin.adminname='admin'and admin.adminpassword='admin']
Login
FAQ
Search
