mysql方言

• DB2的:

    
    
   < bean id="dataSource" 
     class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
     < property name="driverClassName" 
      value="com.ibm.db2.jcc.DB2Driver"> 
     < /property> 
     < property name="url" 
      value="jdbc:db2://localhost:50000/MyDB"> 
     < /property> 
     < property name="username" value="sp">< /property> 
     < property name="password" value="spspsp">< /property> 
  < /bean> 
   
  < bean id="sessionFactory" 
     class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
     < property name="dataSource"> 
      < ref bean="dataSource" /> 
     < /property> 
     < property name="hibernateProperties"> 
      < props> 
       < prop key="hibernate.dialect"> 
        org.hibernate.dialect.DB2Dialect  
       < /prop> 
       < prop key="hibernate.show_sql">true< /prop> 
      < /props> 
     < /property> 

  sql2005 的: SQL2000也差不多.

    
    
  < bean id="dataSource" 
     class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
     < property name="driverClassName" 
      value="net.sourceforge.jtds.jdbc.Driver"> 
     < /property> 
     < property name="url" 
      value="jdbc:jtds:sqlserver://192.168.1.64:1435"> 
     < /property> 
     < property name="username" value="sp">< /property> 
     < property name="password" value="sp">< /property> 
  < /bean> 
   
  < bean id="sessionFactory" 
     class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
     < property name="dataSource"> 
      < ref bean="dataSource" /> 
     < /property> 
     < property name="hibernateProperties"> 
      < props> 
       < prop key="hibernate.dialect"> 
        org.hibernate.dialect.SQLServerDialect  
       < /prop> 
       < prop key="hibernate.show_sql">true< /prop> 
      < /props> 
     < /property> 
   

  MySQL: 5和6的差不多的.

    
    
  < bean id="dataSource" 
     class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
     < property name="driverClassName" 
      value="com.mysql.jdbc.Driver"> 
     < /property> 
     < property name="url" 
      value="jdbc:mysql://localhost:3306/DBNAME?useUnicode=true&characterEncoding=gbk"> 
     < /property> 
     < property name="username" value="root">< /property> 
     < property name="password" value="">< /property> 
  < /bean> 
   
  < bean id="sessionFactory" 
     class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
     < property name="dataSource"> 
      < ref bean="dataSource" /> 
     < /property> 
     < property name="hibernateProperties"> 
      < props> 
       < prop key="hibernate.dialect"> 
        org.hibernate.dialect.MySQLDialect  
       < /prop> 
       < prop key="hibernate.show_sql">true< /prop> 
      < /props>