第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

請教ssm框架不能獲取JDBC連接的問題Could not get JDBC Connection

請教ssm框架不能獲取JDBC連接的問題Could not get JDBC Connection

迷失代碼林 2017-08-26 11:55:08
使用的是JDK1.7+tomcat7開發(fā)的ssm項目,地址欄輸入login和register可以正確進入登錄和注冊頁面不報錯。在注冊頁面正確輸入完用戶名后由ajax提交到UserController進行驗證://注冊驗證 @RequestMapping(value="/checkRegister",method=RequestMethod.POST) ????public?void?checkRegister(HttpServletRequest?request, HttpServletResponse?response,Users?user,Model?model){ try?{ ????????System.out.println("已進入到注冊檢測模塊!"); ????????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(); ????????????????????} }不過控制臺并沒有輸出“已進入注冊檢測模塊!”這句話,而是直接報以下錯誤!### 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數據源配置如下:<!--?JNDI獲取數據源(使用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>數據庫驅動包為:mysql-connector-java-5.1.7-bin.jar之前項目中還有5.1.0和5.1.26版本的mysql驅動,與現狀錯誤是一樣的。driverClass這個類沒問題的,在jar包可以找得到。我找來找去也發(fā)現不了是哪的問題,請求各位大神幫忙指點?。?!
查看完整描述

1 回答

?
執(zhí)著小哥

TA貢獻1條經驗 獲得超1個贊

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

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

查看完整回答
1 反對 回復 2017-09-04
  • 1 回答
  • 0 關注
  • 20403 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

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

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號