yxhxj2006

Hibernate实现有两种配置，xml配置与注释配置

摘要: hibernate实现有两种配置，xml配置与注释配置。（1）：xml配置：hibernate.cfg.xml （放到src目录下）和实体配置类:xxx.hbm.xml（与实体为同一目录中） <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC &nbs... 阅读全文

posted @ 2012-06-30 10:00 奋斗成就男人阅读(49834) | 评论 (4) | 编辑收藏

hibernate查询方法对比

HQL查询

HQL是hibernate自己的一套查询语言，于SQL语法不同，具有跨数据库的优点。示例代码：

[java]
static void query(String name){
Session s=null;
try{
   s=HibernateUtil.getSession();

   //from后面是对象，不是表名
   String hql="from Admin as admin where admin.aname=:name";//使用命名参数，推荐使用，易读。
   Query query=s.createQuery(hql);
   query.setString("name", name);

   List<Admin> list=query.list();

   for(Admin admin:list){
    System.out.println(admin.getAname());
   }
}finally{
   if(s!=null)
   s.close();
}
}
适用情况：常用方法，比较传统，类似jdbc。缺点：新的查询语言，适用面有限，仅适用于Hibernate框架。

对象化查询Criteria方法：

[java]
static void cri(String name,String password){
Session s=null;
try{
   s=HibernateUtil.getSession();

   Criteria c=s.createCriteria(Admin.class);
   c.add(Restrictions.eq("aname",name));//eq是等于，gt是大于，lt是小于,or是或
   c.add(Restrictions.eq("apassword", password));

   List<Admin> list=c.list();
   for(Admin admin:list){
    System.out.println(admin.getAname());
   }
}finally{
   if(s!=null)
   s.close();
}
}
适用情况：面向对象操作，革新了以前的数据库操作方式，易读。缺点：适用面较HQL有限。

动态分离查询DetachedCriteria

[java]
static List dc(DetachedCriteria dc) {

Session s = HibernateUtil.getSession();
Criteria c = dc.getExecutableCriteria(s);
List rs = c.list();
s.close();
return rs;
}

[java]
DetachedCriteria dc = DetachedCriteria.forClass(User.class);
int id = 1;
if (id != 0)
dc.add(Restrictions.eq("id", id));
Date age = new Date();
if (age != null)
dc.add(Restrictions.le("birthday", age));
List users = dc(dc);
System.out.println("离线查询返回结果：" + users);

适用情况：面向对象操作，分离业务与底层，不需要字段属性摄入到Dao实现层。缺点：适用面较HQL有限。

例子查询

[java]
static List example(User user) {
Session s = HibernateUtil.getSession();
List<User> users = s.createCriteria(User.class).add(
Example.create(user)).list();
// List<User>
// users2=s.createCriteria(User.class).add((Example.create(user)).ignoreCase())
// .createCriteria("child").add((Example.create(user))).list();
return users;
}
适用情况：面向对象操作。缺点：适用面较HQL有限，不推荐。

sql查询

[java]
static List sql() {

Session s = HibernateUtil.getSession();
Query q = s.createSQLQuery("select * from user").addEntity(User.class);
List<User> rs = q.list();
s.close();
return rs;
}
适用情况：不熟悉HQL的朋友，又不打算转数据库平台的朋友，万能方法缺点：破坏跨平台，不易维护，不面向对象。

命名查询

[java]
static List namedQuery(int id) {
Session s = HibernateUtil.getSession();
Query q = s.getNamedQuery("getUserById");
q.setInteger("id", id);
return q.list();
}

[html]
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="com.sy.vo.User" table="user" catalog="news">



    </class>
    
    <query name="getUserById">
     <![CDATA[from User where id=:id]]>
    </query>
    
</hibernate-mapping>

posted @ 2012-06-29 13:34 奋斗成就男人阅读(902) | 评论 (0) | 编辑收藏

Spring配置文件总结

首先来看一个标准的Spring配置文件 applicationContext.xml

<bean id="dataSource"
  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <property name="url">
   <value>
    jdbc:mysql://localhost/ssh?characterEncoding=utf-8
   </value>
  </property>
  <property name="username">
   <value>root</value>
  </property>
  <property name="password">
   <value>123</value>
  </property>
</bean>

<bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <property name="mappingResources">
   <list>
    <value>com/ssh/pojo/User.hbm.xml</value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.show_sql">true</prop>
   </props>
  </property>
</bean>


<bean id="transactionManager"
  class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
</bean>


<bean id="hibernateTemplate"
  class="org.springframework.orm.hibernate3.HibernateTemplate">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
</bean>

<bean id="userDao"
class="com.ssh.dao.impl.UserDaoImpl">
<property name="hibernateTemplate" ref="hibernateTemplate"></property>
</bean>

<bean id="userService"
class="com.ssh.service.impl.UserServiceImpl">
<property name="userDao" ref="userDao"></property>
</bean>

<bean id="UserAction"
  class="com.ssh.action.UserAction" scope="prototype">
  <property name="userService" ref="userService"></property>
</bean>
  
<bean id="User" class="com.ssh.pojo.User" scope="prototype"/>
</beans>

//////////////////////////////////////////////// 下面是详解： ////////////////////////////////////////////////////////////////////////

1.基本配置：
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                    ">

<context:component-scan base-package="com.persia">

</context:component-scan>

<context:annotation-config>

</context:annotation-config>

<bean id="personServiceAnno" class="com.persia.PersonServiceAnnotation"></bean>
<bean id="personDaoBeanAnno" class="com.persia.PersonDaoBean"></bean>
<bean id="personDaoBeanAnno2" class="com.persia.PersonDaoBean"></bean>

<bean id="personServiceAutoInject" class="com.persia.PersonServiceAutoInject" autowire="byName"></bean>

<bean id="personDao" class="com.persia.PersonDaoBean"></bean>
<bean id="personService4" class="com.persia.PersonServiceBean">
<property name="personDao" ref="personDao"></property>
</bean>

<bean id="personService5" class="com.persia.PersonServiceBean">
<property name="personDao">
     <bean class="com.persia.PersonDaoBean"></bean>
</property>
<property name="name" value="persia"></property>
<property name="age" value="21"></property>

<property name="sets">
    
     <set>
       <value>第一个</value>
       <value>第二个</value>
       <value>第三个</value>
     </set>
</property>

<property name="lists">
    
    <list>
        <value>第一个l</value>
       <value>第二个l</value>
       <value>第三个l</value>
    </list>

</property>

<property name="properties">
    <props>
      <prop key="key1">value1</prop>
      <prop key="key2">value2</prop>
      <prop key="key3">value3</prop>
    </props>
</property>

<property name="map">
   <map>
      <entry key="key1" value="value-1"></entry>
      <entry key="key2" value="value-2"></entry>
      <entry key="key3" value="value-3"></entry>
   </map>
</property>
</bean>

</beans>2.开启AOP：
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                     http://www.springframework.org/schema/aop
                    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                   ">

<aop:aspectj-autoproxy></aop:aspectj-autoproxy>

<aop:config>
<aop:aspect id="myaop" ref="aspectBean">
<aop:pointcut id="mycut" expression="execution(* com.persia.service.impl.PersonServiceImpl.*(..))"/>
<aop:pointcut id="argcut" expression="execution(* com.persia.service.impl.PersonServiceImpl.*(..)) and args(name)"/>
<aop:before pointcut-ref="mycut" method="doAccessCheck" />
<aop:after-returning pointcut-ref="mycut" method="doAfterReturning"/>
<aop:after-throwing pointcut-ref="mycut" method="doThrowing"/>
<aop:after pointcut-ref="argcut" method="doAfter" arg-names="name"/>
<aop:around pointcut-ref="mycut" method="arround"/>
</aop:aspect>

</aop:config>

</beans>3.开启事务和注解：
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                    http://www.springframework.org/schema/aop
                    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                   ">

<aop:aspectj-autoproxy></aop:aspectj-autoproxy>


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"/>
    <property name="username" value="root"/>
    <property name="password" value=""/>
     
     <property name="initialSize" value="1"/>
     
     <property name="maxActive" value="500"/>
     
     <property name="maxIdle" value="2"/>
     
     <property name="minIdle" value="1"/>
</bean>


<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
</bean>

    <bean id="personService" class="com.persia.service.impl.PersonServiceImpl">
    <property name="ds" ref="dataSource"></property>
</bean>


<tx:annotation-driven transaction-manager="txManager"/>

</beans>XML版本：

<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                    http://www.springframework.org/schema/aop
                    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                   ">

<aop:aspectj-autoproxy></aop:aspectj-autoproxy>


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"/>
    <property name="username" value="root"/>
    <property name="password" value=""/>
     
     <property name="initialSize" value="1"/>
     
     <property name="maxActive" value="500"/>
     
     <property name="maxIdle" value="2"/>
     
     <property name="minIdle" value="1"/>
</bean>


<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
</bean>

   <bean id="personService" class="com.persia.service.impl.PersonServiceImpl">
    <property name="ds" ref="dataSource"></property>
</bean>

    
<aop:config>
    
    <aop:pointcut id="transactionPointcut" expression="execution(* com.persia.service..*.*(..))"/>
    <aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointcut"/>
</aop:config>

<tx:advice id="txAdvice" transaction-manager="txManager">
      <tx:attributes>
      
        <tx:method name="get*" read-only="true" propagation="NOT_SUPPORTED"/>
      
        <tx:method name="*"/>
      </tx:attributes>
</tx:advice>


</beans>4.SSH:
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                    http://www.springframework.org/schema/aop
                    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                   ">

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"/>
    <property name="username" value="root"/>
    <property name="password" value=""/>
     
     <property name="initialSize" value="1"/>
     
     <property name="maxActive" value="500"/>
     
     <property name="maxIdle" value="2"/>
     
     <property name="minIdle" value="1"/>
</bean>


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource"><ref bean="dataSource" /></property>
<property name="mappingResources">
      <list>
        <value>com/persia/model/Person.hbm.xml</value>
      </list>
   </property>

     
        
        
             
             
             
<property name="hibernateProperties">
      <value>
          hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
          hibernate.hbm2ddl.auto=update
          hibernate.show_sql=false
          hibernate.format_sql=false
          hibernate.cache.use_second_level_cache=true
                hibernate.cache.use_query_cache=false
             hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
      </value>
      </property>
</bean>

<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>

<tx:annotation-driven transaction-manager="txManager"/>

<context:annotation-config></context:annotation-config>

<bean id="personService" class="com.persia.service.impl.PersonServiceImpl"></bean>

<bean name="/person/list" class="com.persia.struts.PersonListAction">




</bean>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"/>
    <property name="username" value="root"/>
    <property name="password" value=""/>
     
     <property name="initialSize" value="1"/>
     
     <property name="maxActive" value="500"/>
     
     <property name="maxIdle" value="2"/>
     
     <property name="minIdle" value="1"/>
</bean>


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource"><ref bean="dataSource" /></property>
<property name="mappingResources">
      <list>
        <value>com/persia/model/Person.hbm.xml</value>
      </list>
   </property>

     
        
        
             
             
             
<property name="hibernateProperties">
      <value>
          hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
          hibernate.hbm2ddl.auto=update
          hibernate.show_sql=false
          hibernate.format_sql=false
          hibernate.cache.use_second_level_cache=true
                hibernate.cache.use_query_cache=false
             hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
      </value>
      </property>
</bean>

<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>

<tx:annotation-driven transaction-manager="txManager"/>

<context:annotation-config></context:annotation-config>

<bean id="personService" class="com.persia.service.impl.PersonServiceImpl"></bean>

<bean id="personList" class="com.persia.struts2.action.PersonListAction"></bean>
</beans>6.SSJ:
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context-2.5.xsd
                    http://www.springframework.org/schema/aop
                    http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                   ">

<context:annotation-config></context:annotation-config>

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
<property name="persistenceUnitName" value="SpringJPAPU"/>
</bean>

<bean id="txManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>

<tx:annotation-driven transaction-manager="txManager"/>

<bean id="personService" class="com.persia.service.impl.PersonServiceImpl"></bean>

<bean name="/person/list" class="com.persia.struts.PersonListAction"/>
<bean name="/person/manage" class="com.persia.struts.PersonManageAction"/>
</beans>

posted @ 2012-06-28 11:14 奋斗成就男人阅读(154) | 评论 (0) | 编辑收藏

web.xml 中的listener、 filter、servlet 加载顺序及其详解 .

摘要: 在项目中总会遇到一些关于加载的优先级问题，近期也同样遇到过类似的，所以自己查找资料总结了下，下面有些是转载其他人的，毕竟人家写的不错，自己也就不重复造轮子了，只是略加点了自己的修饰。首先可以肯定的是，加载顺序与它们在 web.xml 文件中的先后顺序无关。即不会因为 filter 写在 listener 的前... 阅读全文

posted @ 2012-06-27 16:37 奋斗成就男人阅读(200) | 评论 (0) | 编辑收藏

HttpClient 学习整理

摘要: HttpClient 是我最近想研究的东西，以前想过的一些应用没能有很好的实现，发现这个开源项目之后就有点眉目了，令人头痛的cookie问题还是有办法解决滴。在网上整理了一些东西，写得很好，寄放在这里。HTTP 协议可能是现在 Internet 上使用得最多、最重要的协议了，越来越多的 Java 应用程序需要直接通过 HTTP 协议来访问网络资源。虽然在 JDK 的 java.net 包中已经提供... 阅读全文

posted @ 2012-06-19 18:25 奋斗成就男人阅读(220) | 评论 (0) | 编辑收藏

java后台用post方式提交参数

public static void main(String[] args) {
  URL url = null;
  HttpURLConnection httpurlconnection = null;
  try {
   url = new URL("http://www.ip138.com/ips.asp");
   httpurlconnection = (HttpURLConnection) url.openConnection();
   httpurlconnection.setDoInput(true);
   httpurlconnection.setDoOutput(true);

   httpurlconnection.setRequestMethod("POST");
   httpurlconnection.setRequestProperty("Content-Type",
     "application/x-www-form-urlencoded");

String username = "ip=192.168.0.1";
httpurlconnection.getOutputStream().write(username.getBytes());

   httpurlconnection.getOutputStream().flush();
   httpurlconnection.getOutputStream().close();
   int code = httpurlconnection.getResponseCode();
   System.out.println("code    " + code);

if (code == 200) {

    String cookie = httpurlconnection.getHeaderField("Set-Cookie ");
    System.out.println(cookie);
    // httpurlconnection.setRequestProperty( "Cookie", cookie);

    DataInputStream in = new DataInputStream(httpurlconnection
      .getInputStream());
    int len = in.available();
    byte[] by = new byte[len];
    in.readFully(by);
    String rev = new String(by);
    System.out.println(rev);
    in.close();
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   if (httpurlconnection != null) {
    httpurlconnection.disconnect();
   }
  }
}

posted @ 2012-06-19 18:20 奋斗成就男人阅读(3284) | 评论 (1) | 编辑收藏

导航

留言簿(7)

随笔分类

文章分类

随笔档案

阅读排行榜

评论排行榜

常用链接

统计

最新评论

Hibernate实现有两种配置，xml配置与注释配置

hibernate查询方法对比

Spring配置文件总结

web.xml 中的listener、 filter、servlet 加载顺序及其详解 .

HttpClient 学习整理

java后台用post方式提交参数