1、PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULTTABLESPACE SYSTEM ; CREATE SEQUENCE MINVALUE 1 MAXVALUE 9999 INCREMENT BY 1 START WITH 121 CACHE 20 NO
2、ORDER NOCYCLE ;Insert into T_USER (ID,USERNAME,PASSWORD) values (Q_USER.nextval,222,);HibernateUtil.javaJava代码 package hibernate;import org.hibernate.HibernateException;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;/* Hibernate的工具类.* author A
3、migoXie*/public class HibernateUtil private static SessionFactory sessionFactory; /* 持有一个单态的Session实例. private static final ThreadLocal threadLocal = new ThreadLocal(); /* 持有一个单态的configuration实例. private static final Configuration cfg = new Configuration(); private static String CONFIG_FILE_LOCATION
4、 = hibernate/hibernate.cfg.xml static try sessionFactory = new Configuration().configure(CONFIG_FILE_LOCATION) .buildSessionFactory(); catch (Throwable ex) / Make sure you log the exception, as it might be swallowedSystem.err.println(Initial SessionFactory creation failed. + ex);throw new ExceptionI
5、nInitializerError(ex); public static SessionFactory getSessionFactory() return sessionFactory; /* 获得当前的Session实例.* return Session* throws HibernateException public static Session currentSession() throws HibernateException Session session = (Session) threadLocal.get();/if (session = null) if(session=
6、null|session.isOpen()=false)if (sessionFactory = null) try cfg.configure(CONFIG_FILE_LOCATION);sessionFactory = cfg.buildSessionFactory(); catch (Exception e) % Error Creating SessionFactory % + e.getMessage();session = sessionFactory.openSession();threadLocal.set(session);return session;User.javapu
7、blic class User private String id ; private String userName; private String password; public String getId() return id; public void setId(String id) this.id = id; public String getUserName() return userName; public void setUserName(String userName) this.userName = userName; public String getPassword(
8、) return password; public void setPassword(String password) this.password = password;hibernate.cfg.xmlXml代码 !DOCTYPE hibernate-configuration PUBLIC-/Hibernate/Hibernate Configuration DTD 3.0/ENhibernate-configuration - properties -property name=connection.urljdbc:oracle:thin:127.0.0.1:1521:JIMconnec
9、tion.usernamescottconnection.passwordtigerdialectorg.hibernate.dialect.OracleDialectconnection.driver_classoracle.jdbc.driver.OracleDrivershow_sqltrueformat_sqlfalsemapping resource=hibernate/user.hbm.xml/session-factory/hibernate-configurationuser.hbm.xmlxml version=1.0 encoding=UTF-8DOCTYPE hibern
10、ate-mapping PUBLIC-/Hibernate/Hibernate Mapping DTD 3.0/ENhibernate-mapping package=hibernateclass name=User table=id name=id column=ID type=stringgenerator class=assigned/iduserNamecolumn=USERNAMEtype= not-null=true /passwordPASSWORD/class/hibernate-mappingIuserDao.java接口package page;import hiberna
11、te.User;import java.util.List;public interface IuserDao public List displayUser(int offset,int max); public int count();UserDao.javaimport hibernate.HibernateUtil;import org.hibernate.Query;import org.hibernate.Transaction;public class UserDao implements IuserDao Override displayUser(int offset, int
12、 max) / TODO Auto-generated method stub/PagerModel pm = null;List list =null;String hsql = from User Session session = HibernateUtil.currentSession();Transaction ts = null; ts = session.beginTransaction();Query query = session.createQuery(hsql);query.setFirstResult(offset);query.setMaxResults(max);
13、list= query.list(); catch (HibernateException e) / TODO Auto-generated catch blocke.printStackTrace();if (ts != null) ts.rollback();finallysession.close();return list; public int count() int i = 0 ;Query query = session.createQuery(select count(*) from Useri = (Integer) query.uniqueResult();return i
14、;pageAction.javaimport com.opensymphony.xwork2.ActionSupport;public class PageAction extends ActionSupport int i=1;/中间变量private int k;/储存最大页面数private int pageNow=1; /页码数,初始为1private int pageSize = 5 ; /页面行数private int intRowCount = 0;/总行数private int intPageCount = 1;/总页数/private Admin admin;private
15、List Adminss;private User user; users;private int id;private int aid;public User getUser() return user;public void setUser(User user) this.user = user;public List getUsers() return users;public void setUsers(List users) this.users = users;public int getId() public void setId(int id) public int getAid() return aid;public void setAid(int aid) this.aid = aid;public int getPageNow() return pageNow;public void setPageNow(int pageNow) this.pageNow = pageNow;public int getPageSize()
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1