使用的是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 回答
- 0 關(guān)注
- 20439 瀏覽
添加回答
舉報(bào)
0/150
提交
取消