最近中文字幕高清中文字幕无,亚洲欧美高清一区二区三区,一本色道无码道dvd在线观看 ,一个人看的www免费高清中文字幕

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問題,去搜搜看,總會(huì)有你想問的

請(qǐng)教ssm框架不能獲取JDBC連接的問題Could not get JDBC Connection

請(qǐng)教ssm框架不能獲取JDBC連接的問題Could not get JDBC Connection

迷失代碼林 2017-08-26 11:55:08
使用的是JDK1.7+tomcat7開發(fā)的ssm項(xiàng)目,地址欄輸入login和register可以正確進(jìn)入登錄和注冊(cè)頁面不報(bào)錯(cuò)。在注冊(cè)頁面正確輸入完用戶名后由ajax提交到UserController進(jìn)行驗(yàn)證://注冊(cè)驗(yàn)證 @RequestMapping(value="/checkRegister",method=RequestMethod.POST) ????public?void?checkRegister(HttpServletRequest?request, HttpServletResponse?response,Users?user,Model?model){ try?{ ????????System.out.println("已進(jìn)入到注冊(cè)檢測(cè)模塊!"); ????????String?cardId?=?request.getParameter("cardId"); ????????cardId=usersService.getUserByCardId(cardId).getCardId(); ????????PrintWriter?out; ????????out?=?response.getWriter(); ????????out.write(JSONArray.fromObject(cardId).toString()); ????}?catch?(IOException?e)?{ ????????????????e.printStackTrace(); ????????????????????} }不過控制臺(tái)并沒有輸出“已進(jìn)入注冊(cè)檢測(cè)模塊!”這句話,而是直接報(bào)以下錯(cuò)誤!### Error querying database. ?Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${driverClass}'### The error may exist in dao/UsersMapper.xml### The error may involve dao.UsersMapper.getUserByCardId### The error occurred while executing a query### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${driverClass}'] with root causejava.lang.ClassNotFoundException: ${driverClass}然后配置文件是在源文件夾中,源碼是:driverClass=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/mysql user=root password=As3014DBCP數(shù)據(jù)源配置如下:<!--?JNDI獲取數(shù)據(jù)源(使用dbcp連接池)?--> <bean?id="dataSource"?class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"?scope="singleton"> <property?name="driverClassName"?value="${driverClass}"?/> <property?name="url"?value="${url}"?/> <property?name="username"?value="${user}"?/> <property?name="password"?value="${password}"?/> </bean>UserMapper類的代碼為:public?interface?UsersMapper{ @MapKey("id") public?Map<Integer,Users>?usersList(); public?Users?getUserByCardId(String?cardId); public?Users?getUserByName(String?name); public?Integer?insertUsers(Users?user); public?Integer?deleteUsers(Users?user); public?Integer?updateUsers(Users?user); }UserMapper.xml代碼為:<?xml?version="1.0"?encoding="UTF-8"?> <!DOCTYPE?mapper?PUBLIC?"-//mybatis.org//DTD?Mapper?3.0//EN"???? "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper?namespace="dao.UsersMapper"> <!--?查詢用戶--> <select?id="usersList"?resultType="users"?parameterType="users"> select?*?from?users </select> <select?id="getUserByName"?resultType="users"?parameterType="users"> select?*?from?Users?where?name=#{name} </select> <select?id="getUserByCardId"?resultType="users"?parameterType="users"> select?*?from?Users?where?cardId=#{cardId} </select> <select?id="insertUsers"?parameterType="users"> insert?into?Users(cardId,name,gender,createTime,password,status)?values( #{cardId},#{name},#{gender},#{createTime},#{password},#{status} ) </select> <select?id="updateUsers"?parameterType="users"> update?users?set?name=#{name},gender=#{gender},createTime=#{createTime},password=#{password},status=#{status}? where?cardId=#{cardId} </select> <select?id="deleteUsers"?parameterType="users"> delete?from?users?where?cardId=#{cardId} </select> </mapper>數(shù)據(jù)庫驅(qū)動(dòng)包為:mysql-connector-java-5.1.7-bin.jar之前項(xiàng)目中還有5.1.0和5.1.26版本的mysql驅(qū)動(dòng),與現(xiàn)狀錯(cuò)誤是一樣的。driverClass這個(gè)類沒問題的,在jar包可以找得到。我找來找去也發(fā)現(xiàn)不了是哪的問題,請(qǐng)求各位大神幫忙指點(diǎn)!??!
查看完整描述

1 回答

?
執(zhí)著小哥

TA貢獻(xiàn)1條經(jīng)驗(yàn) 獲得超1個(gè)贊

driverClass=com.mysql.jdbc.Driver改為driver=com.mysql.jdbc.Driver

<property?name="driverClassName"?value="${driverClass}"?/>改為<property?name="driverClassName"?value="${driver}"?/>

查看完整回答
1 反對(duì) 回復(fù) 2017-09-04
  • 1 回答
  • 0 關(guān)注
  • 20439 瀏覽
慕課專欄
更多

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)