package pension;import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
import pension.hib.CtUser;
public class LoginAction extends Action {
public static SessionFactory sessionFactory;
static {
try {
sessionFactory = new Configuration().configure().
buildSessionFactory();
} catch (Exception e) {
e.printStackTrace();
}
} public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest servletRequest,
HttpServletResponse servletResponse) {
LoginForm loginForm = (LoginForm) actionForm;
String usrid = loginForm.getUserId();
String password = loginForm.getPassword();
Session session = sessionFactory.openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
Query query = session.createQuery("select a from CT_USER as a");
for (Iterator it = query.iterate(); it.hasNext(); ) {
CtUser ctuser = (CtUser) it.next();
System.out.println(ctuser.getUserId() + "<br>");
} tx.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
} System.out.println();
return (actionMapping.findForward(""));
}
}
配置为
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class
name="pension.hib.CtUser"
table="CT_USER"
>
<id
name="userId"
column="USER_ID"
>
<generator class="assigned" />
</id> <property
name="password"
column="PASSWORD"
length="10"
>
</property>
<property
name="createUser"
column="CREATE_USER"
length="20"
>
</property>
<property
name="createDate"
column="CREATE_DATE"
length="7"
>
</property>
<property
name="userName"
column="USER_NAME"
length="20"
>
</property>
<property
name="empNo"
column="EMP_NO"
length="15"
>
</property>
<property
name="beginDate"
column="BEGIN_DATE"
length="7"
>
</property>
<property
name="endDate"
column="END_DATE"
length="7"
>
</property>
<property
name="maintainUser"
column="MAINTAIN_USER"
length="20"
>
</property>
<property
name="maintainDate"
column="MAINTAIN_DATE"
length="7"
>
</property> <!-- Associations --> <!-- bi-directional one-to-many association to CtUserAccess
<set
name="ctUserAccesses"
lazy="true"
inverse="true"
cascade="none"
>
<meta attribute="field-description">
@hibernate.set
lazy="true"
inverse="true"
cascade="none" @hibernate.collection-key
column="USER_ID" @hibernate.collection-one-to-many
class="com.teammax.hib.pension.CtUserAccess"
</meta>
<key>
<column name="USER_ID" />
</key>
<one-to-many
class="com.teammax.hib.pension.CtUserAccess"
/>
</set>
-->
</class>
</hibernate-mapping>
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import org.hibernate.*;
import org.hibernate.cfg.*;
import java.util.*;
import pension.hib.CtUser;
public class LoginAction extends Action {
public static SessionFactory sessionFactory;
static {
try {
sessionFactory = new Configuration().configure().
buildSessionFactory();
} catch (Exception e) {
e.printStackTrace();
}
} public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest servletRequest,
HttpServletResponse servletResponse) {
LoginForm loginForm = (LoginForm) actionForm;
String usrid = loginForm.getUserId();
String password = loginForm.getPassword();
Session session = sessionFactory.openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
Query query = session.createQuery("select a from CT_USER as a");
for (Iterator it = query.iterate(); it.hasNext(); ) {
CtUser ctuser = (CtUser) it.next();
System.out.println(ctuser.getUserId() + "<br>");
} tx.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
} System.out.println();
return (actionMapping.findForward(""));
}
}
配置为
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class
name="pension.hib.CtUser"
table="CT_USER"
>
<id
name="userId"
column="USER_ID"
>
<generator class="assigned" />
</id> <property
name="password"
column="PASSWORD"
length="10"
>
</property>
<property
name="createUser"
column="CREATE_USER"
length="20"
>
</property>
<property
name="createDate"
column="CREATE_DATE"
length="7"
>
</property>
<property
name="userName"
column="USER_NAME"
length="20"
>
</property>
<property
name="empNo"
column="EMP_NO"
length="15"
>
</property>
<property
name="beginDate"
column="BEGIN_DATE"
length="7"
>
</property>
<property
name="endDate"
column="END_DATE"
length="7"
>
</property>
<property
name="maintainUser"
column="MAINTAIN_USER"
length="20"
>
</property>
<property
name="maintainDate"
column="MAINTAIN_DATE"
length="7"
>
</property> <!-- Associations --> <!-- bi-directional one-to-many association to CtUserAccess
<set
name="ctUserAccesses"
lazy="true"
inverse="true"
cascade="none"
>
<meta attribute="field-description">
@hibernate.set
lazy="true"
inverse="true"
cascade="none" @hibernate.collection-key
column="USER_ID" @hibernate.collection-one-to-many
class="com.teammax.hib.pension.CtUserAccess"
</meta>
<key>
<column name="USER_ID" />
</key>
<one-to-many
class="com.teammax.hib.pension.CtUserAccess"
/>
</set>
-->
</class>
</hibernate-mapping>
解决方案 »
- 求助:JAVA查询MYSQL语句有中文返回为空
- spring开发,主流使用注解还是xml配置
- JNDI中如何终止NamingEnumeration
- 关于hibernte 一对多映射 jutils测试时 弹出 invalid project specified对话框??
- 在jbuilder2006中编译运行jsf项目时
- 我公司想用java做一个即时通讯软件,请问有没有办法使客户端软件变小,就是不需要下载JVM?
- 关于jdbc数据库连接池的问题?急!
- spring管理hibernate的事务后异常怎莫捕获不到?
- struts問題﹐高分求救﹗
- 关于MySQL的问题,请大家帮忙解决。
- 一个关于Java连接FTP实现文件上传下载的问题
- 有人能帮我把这个小例子改成Struts形式
<generator class="assigned"/>
</id>