使用的是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 回答
- 0 關注
- 20403 瀏覽
添加回答
舉報
0/150
提交
取消