hibernate基础操作

获取年度最大的序号

public int findMaxSerial(String year){
		Map<String,Object> params = new HashMap();  
        StringBuffer sb=new StringBuffer();  
        sb.append("select max(sub.serial) from DaPicsubject sub where sub.year='"+year+"'");
        Query query = getSession().createQuery(sb.toString());  
        Object ret = query.uniqueResult();
        int count =-1;
        if(ret!=null){
        	count = ((Integer)ret).intValue();
        }
        return count;  
	}	

日期范围搜索

Date st = DateCenter.getDate(startdate);
Date end = DateCenter.getDate(enddate);
sb.append(" and (");
	sb.append("	(t.receivedate  >=:st");
	sb.append(" and t.receivedate  <=:end)");
	sb.append(" or (t.builddate  >=:st");			
	sb.append(" and t.builddate  <=:end)");
sb.append(")");
params.put("st", st); 
params.put("end", end);

输出日志至log4j

hibernate输出log4j日志（可用）

# Direct log messages to a log file
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=C:\\yihaomen.log
log4j.appender.file.MaxFileSize=1MB
log4j.appender.file.MaxBackupIndex=1
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
 
# Direct log messages to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
 
# Root logger option
log4j.rootLogger=INFO, file, stdout
 
 
 
 log4j.logger.org.hibernate=info   
#log4j.logger.org.hibernate=debug   
  
### log HQL query parser activity   
#log4j.logger.org.hibernate.hql.ast.AST=debug   
  
### log just the SQL   
log4j.logger.org.hibernate.SQL=info   
  
### log JDBC bind parameters ###   
log4j.logger.org.hibernate.type=info   
#log4j.logger.org.hibernate.type=debug   
  
### log schema export/update ###   
log4j.logger.org.hibernate.tool.hbm2ddl=info 
  
### log HQL parse trees   
log4j.logger.org.hibernate.hql=info   
  
### log cache activity ###   
#log4j.logger.org.hibernate.cache=debug   
  
### log transaction activity   
#log4j.logger.org.hibernate.transaction=debug   
  
### log JDBC resource acquisition   
#log4j.logger.org.hibernate.jdbc=debug   
  
### enable the following line if you want to track down connection ###   
### leakages when using DriverManagerConnectionProvider ###   
#log4j.loggennection.DriverManagerConnectionProvider=trace