求一个连接sql2005+s2sh的小项目,只要有登录或注册功能就OK了,
我现在写的都是用mysql的,但换上了sql2005就不能用了,配置我也配好了,sqljdbc.jar也导了。application.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">
<!-- 配置注释 start -->
<context:annotation-config />
<context:component-scan base-package="com.my" />
<!-- 配置注释 end -->
<!-- 直接配置数据库
<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/spring" />
<property name="username" value="root" />
<property name="password" value="123" />
</bean>
--> <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url" value="jdbc:sqlserver://localhost:1433; DatabaseName=storage" />
<property name="username" value="sa" />
<property name="password" value="123" />
</bean>
<!-- 读取外部.properties文件并配置数据库 start-->
<!--
<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<value>classpath:jdbc.properties</value>
</property>
</bean> <bean id="dataSource" destroy-method="close"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
-->
<!-- 读取外部.properties文件并配置数据库 end-->
<!-- 配置sessionFactory start -->
<bean id="sf"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="annotatedClasses">
<list>
<value>com.my.storage.model.MyAdmin</value>
<!--<value>com.my.storage.model.MyProduct</value>
<value>com.my.storage.model.MyProductAccessory</value>
<value>com.my.storage.model.MyProductBrand</value>
<value>com.my.storage.model.MyProductProvider</value>
<value>com.my.storage.model.MyProductProviderType</value>
<value>com.my.storage.model.MyProductSuit</value>
<value>com.my.storage.model.MyProductType</value>
<value>com.my.storage.model.MyState</value>
--></list>
</property>
<!-- 配置自动读实体
<property name="packagesToScan">
<list>
<value>com.my..model</value>
</list>
</property>
-->
<!-- 配置数据库方言与显示不显示sql语句 start -->
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
<!-- org.hibernate.dialect.MySQLDialect -->
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<!-- 配置数据库方言与显示不显示sql语句 end -->
</bean>
<!-- 配置sessionFactory end -->
<!-- 配置hibernateTemplate start -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory" ref="sf"></property>
</bean>
<!-- 配置hibernateTemplate end -->
<!-- 配置spring管理者 start -->
<bean id="txManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sf" />
</bean>
<!-- 配置spring管理者 end -->
<!-- 配置声明式aop start -->
<aop:config>
<aop:pointcut id="bussinessService"
expression="execution(public * com.my.storage.service.*.*(..))" />
<aop:advisor pointcut-ref="bussinessService"
advice-ref="txAdvice" />
</aop:config>
<!-- 配置声明式aop end -->
<!-- 配置spring建议者 start -->
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="existByNameAndPasswod" read-only="true" />
<!--
<tx:method name="add*" propagation="REQUIRED"/>
-->
</tx:attributes>
</tx:advice>
<!-- 配置spring建议者 end -->
</beans> 求一个完整的sql2005+s2sh小项目!
我现在写的都是用mysql的,但换上了sql2005就不能用了,配置我也配好了,sqljdbc.jar也导了。application.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">
<!-- 配置注释 start -->
<context:annotation-config />
<context:component-scan base-package="com.my" />
<!-- 配置注释 end -->
<!-- 直接配置数据库
<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/spring" />
<property name="username" value="root" />
<property name="password" value="123" />
</bean>
--> <bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url" value="jdbc:sqlserver://localhost:1433; DatabaseName=storage" />
<property name="username" value="sa" />
<property name="password" value="123" />
</bean>
<!-- 读取外部.properties文件并配置数据库 start-->
<!--
<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<value>classpath:jdbc.properties</value>
</property>
</bean> <bean id="dataSource" destroy-method="close"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
-->
<!-- 读取外部.properties文件并配置数据库 end-->
<!-- 配置sessionFactory start -->
<bean id="sf"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="annotatedClasses">
<list>
<value>com.my.storage.model.MyAdmin</value>
<!--<value>com.my.storage.model.MyProduct</value>
<value>com.my.storage.model.MyProductAccessory</value>
<value>com.my.storage.model.MyProductBrand</value>
<value>com.my.storage.model.MyProductProvider</value>
<value>com.my.storage.model.MyProductProviderType</value>
<value>com.my.storage.model.MyProductSuit</value>
<value>com.my.storage.model.MyProductType</value>
<value>com.my.storage.model.MyState</value>
--></list>
</property>
<!-- 配置自动读实体
<property name="packagesToScan">
<list>
<value>com.my..model</value>
</list>
</property>
-->
<!-- 配置数据库方言与显示不显示sql语句 start -->
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
<!-- org.hibernate.dialect.MySQLDialect -->
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<!-- 配置数据库方言与显示不显示sql语句 end -->
</bean>
<!-- 配置sessionFactory end -->
<!-- 配置hibernateTemplate start -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory" ref="sf"></property>
</bean>
<!-- 配置hibernateTemplate end -->
<!-- 配置spring管理者 start -->
<bean id="txManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="sf" />
</bean>
<!-- 配置spring管理者 end -->
<!-- 配置声明式aop start -->
<aop:config>
<aop:pointcut id="bussinessService"
expression="execution(public * com.my.storage.service.*.*(..))" />
<aop:advisor pointcut-ref="bussinessService"
advice-ref="txAdvice" />
</aop:config>
<!-- 配置声明式aop end -->
<!-- 配置spring建议者 start -->
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="existByNameAndPasswod" read-only="true" />
<!--
<tx:method name="add*" propagation="REQUIRED"/>
-->
</tx:attributes>
</tx:advice>
<!-- 配置spring建议者 end -->
</beans> 求一个完整的sql2005+s2sh小项目!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货