springmvc链接数据库

⑴ springmvc连接数据库时报错，求解决方法

<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
是driverClassName，不是driver

⑵ SpringMVC 连接 Oracle数据库 增删改查

缺少了spring-web-3.2.6.jar包

⑶ 请教在Spring MVC中，如何实现启动时从数据库读取信息

读db数据的对象，只要被Spring加载了，都会读到ApplicationContext(应用环境)中，

然后任何控制器Controller可以实现ApplicationContextAware(打理应用环境)接口，可以自动加载ApplicationContext，也就可以在控制器的方法中操作其中任一数据对象。

比如某个spring-beans.xml中写上

<bean id="myService" class="com.mypackage.MyDatabaseService" />

然后在控制器中

java">@Controller
{
;
@(ApplicationContextac){
service=(MyDatabaseService)ac.getBean("myService");
}
}

这样就自动加载了

⑷ spring mvc 鎬庝箞閰嶇疆澶氫釜搴

銆銆鍦烘櫙鎻忚堪锛氭湁澶氫釜鏁版嵁搴擄紝姣忎釜鏁版嵁搴撳彲鑳藉垎甯冨湪涓嶅悓鐨刴ysql instance涓婇潰锛屾湁澶氫釜瀛樺偍杩囩▼锛屾瘡涓瀛樺偍杩囩▼鍙鑳藉垎甯冨湪涓嶅悓鐨勬暟鎹搴撲腑锛岄渶瑕佹湁涓や釜閰嶇疆鏂囦欢銆

銆銆1. mysql 鏁版嵁搴撴槧灏勶細
銆銆A.driverClassName=com.mysql.jdbc.Driver
A.url=jdbc:mysql://172.20.7.51:3308/blog
A.username=trappuser
A.password=Opera1!

B.driverClassName=com.mysql.jdbc.Driver
B.url=jdbc:mysql://localhost:3306/wedding
B.username=root
B.password=opera
銆銆涓婇潰瀹氫箟鐨凙銆丅涓轰袱涓猰ysql instance鐨勭缉鍐欍
銆銆2. 瀛樺偍杩囩▼涓巑ysql instance鐨勬槧灏勫叧绯伙細
銆銆SP_Get_User=A
GetStocks=B

銆銆瀹氫箟涓や釜妯℃嫙瀛樺偍杩囩▼锛岀涓涓鏁版嵁搴撯淪P_Get_User鈥滄槸鍦ㄦ暟鎹搴揂涓嬮潰锛岀鑴婄楁暎浜屼釜鏁版嵁搴撯滸etStocks鈥滄槸鍦ㄦ暟鎹搴揃涓嬮潰銆
3. 寤虹珛鑷瀹氫箟鐨剆essionFactory
銆銆3.1 xml閰嶇疆鐨刣atasource鍙妔essionFactory濡備笅锛
銆銆<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="dataSource">
<property name="driverClassName" value="${database.driverClassName}"/>
<property name="url" value="${database.url}"/>
<property name="username" value="${database.username}"/>
<property name="password" value="${database.password}"/>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>妯辨皬
<鏃忓唽property name="packagesToScan" value="com.xx.assetcommander">
</property>

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>

</property>
</bean>
銆銆姝ゅ勬垜浠瀹氫箟鐨剆essionFactory鐨勭被鍨嬩负LocalSessionFactoryBean锛屽畠鏄涓涓宸ュ巶瀵硅薄锛屼笌鎴戜滑鍐嶉渶瑕佺殑 SessionFactory涓嶆槸涓鍥炰簨锛屾垜浠闇瑕佺殑sessionfactory鏄痮rg.hibernate.SessionFactory锛岃繖涓瀵硅薄鍙浠ヨ绗涓涓猻essionFactory鐨刧etObject()鏂规硶鐢熸垚銆

銆銆3.2 鐢变簬鎴戜滑杩炴帴鐨勬槸澶氫釜mysql instance锛 涓嶆柟渚垮湪xml涓閰嶇疆澶氫釜datasource鍜屽氫釜sessionFactory锛屾晠鍙浠ラ氳繃绾痡ava鐨勫舰寮忓紑鍙戯紝鍙浠ヤ娇鐢╩ap鏉ュ瓨鍌ㄥ瓨鍌ㄨ繃绋嬩笌mysql database鐨勫叧绯伙紝灏嗗瓨鍌ㄨ繃绋嬬殑鍚嶅瓧鍜屾暟鎹搴撳缓璁鍏崇郴锛岃繖鏍烽氳繃瀛樺偍杩囩▼鐨勫悕绉板氨鑳藉緱鍒版暟鎹搴撶殑缂╁啓鍚嶏紝閫氳繃鏁版嵁搴撶殑缂╁啓鍚嶈兘澶熸壘鍒板瑰簲鐨刴ysql instance锛屼娇鐢ㄧ函java寮鍙戠殑杩囩▼绫讳技浜巟ml閰嶇疆锛屽備笅锛
銆銆ds.setDriverClassName(getDriver());
ds.setUrl(getUrl());
ds.setUsername(getUsername());
ds.setPassword(getPassword());
LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
sessionFactory.setDataSource(ds);
sessionFactory.setPackagesToScan("com.xx.assetcommander");
Properties params = new Properties();
params.setProperty("hibernate.dialect",
"org.hibernate.dialect.MySQLDialect");
params.setProperty("hibernate.show_sql", "true");
sessionFactory.setHibernateProperties(params);

銆銆褰撴垜浠鑾峰緱鍙浠ヤ娇鐢ㄧ殑LocalSessionFactoryBean鏃跺欙紝鍦ㄨ皟鐢╣etObject()鑾峰緱SessionFactory涔嬪墠锛屽繀椤昏佽皟鐢╝fterPropertiesSet()鏂规硶锛屽惁鍒欏緱鍒扮殑sessionFactory涓虹┖銆
銆銆public Session getDsBySp(String spName) throws IOException {
//get the corresponding mysql database shortname by sp name
String dbName = getDbForSP(str);
//get the corresponding mysql instance connection by mysql database shortname
LocalSessionFactoryBean fB = getDsByDb(dbName);
// don't forget this line or null will be returned when you call getObject() method.
fB.afterPropertiesSet();
return fB.getObject().openSession();
}

銆銆娉锛氬湪tomcat鍚鍔ㄦ椂锛屽傛灉娌℃湁閰嶇疆浠讳綍datasource锛屼細鍑虹幇濡備笅閿欒锛
銆銆org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type [javax.persistence.EntityManagerFactory] is defined
鏁呴渶瑕侀厤缃榛樿ょ殑datasource.
杩欑嶆柟寮忛渶瑕佸仛鍒颁笉鍚岀殑鏁版嵁搴搃nstance鐩存帴涓氬姟鐨勫畬鍏ㄧ嫭绔嬶紝涓嶅彲浠ュ嚭鐜拌法鏁版嵁搴撶殑琛╦oin锛屽惁鍒欏勭悊闅惧害浼氬炲姞銆
杩樻湁灏辨槸瀵逛簬澶氭暟鎹搴撶洿鎺ョ殑浜嬪姟绠＄悊濡備綍鍘诲勭悊锛

⑸ spring涓涓轰粈涔堟槸閫氳繃杩炴帴鑾峰彇鎿嶄綔鏁版嵁搴撶殑瀵硅薄(springmvc杩炴帴鏁版嵁搴)

浣犵殑搴旇ユ槸Spring鑾峰緱鏁版嵁搴撹繛鎺ュ硅薄鐨勭被銆

(SpringFramework5.0.4.RELEASEAPI)

鍦↗ava鏁版嵁搴撴搷浣滅殑妗嗘灦涓棰傞晣锛屼笉璁烘槸Spring锛孲truts锛屾垨鑰呬綘鑷宸卞啓鐨勮繛鎺ユ帶鍒朵篃涓嶇′綘鏄鍚﹂泦鎴愯繛鎺ユ睜锛屾瘮濡傝碈3P0銆

涓鑸鏉ヨ达紝閮芥槸鍏堣佽幏寰楁暟鎹搴撹倖浜鐨勯摼鎺ャ傝傛ū瀹

鍦ㄨ繖閲屼綘鐨勮繛鎺ュ湪Connection閲岄潰銆

鑾峰緱杩炴帴鍚庢墠鑳藉规暟鎹搴撹繘琛屾搷浣溿